Changing Plesk database provider

[shima]

I installed plesk with MSSQL as a database provider, now I want to change the provider to MySql, I don't receive any error but plesk is still using MSSQL.
What should I do ?

 

[Bender]

Use Plesk reconfigurator to change database engine:
Start -> Programs -> Swsoft -> Plesk -> Plesk reconfigurator

 

[shima]

Hi,
I used plesk reconfiguration,but Plesk still uses MSSQL as Database provider, although I don't receive any error during Changing Database provider from MSSQL to MySQL.

 

[sergius]

Originally posted by shima
Hi,
I used plesk reconfiguration,but Plesk still uses MSSQL as Database provider, although I don't receive any error during Changing Database provider from MSSQL to MySQL.

Could you please find error messages in Event Viewer and put it here?

 

[shima]

Hi,
First of all, I explain what I've entered in Plesk reconfigurator

I want to switch from MSSql to MySql.
Server type : MySql Port 8306
administrator login : admin
Password : Plesk admin Password

Create DB:
Database : psa
database username : psa
password : password
password : passsword

And there is no error in event viewer.

 

[sergius]

Why do you suppose Plesk still uses MSSQL ?

 

[JackL]

Follow steps below:
1. In services.mmc set PleskSQLServer to automatic
2. In %plesk_dir%\mysql\data\my.ini
add entry
skip-grant-table
and save my.ini
3. Start PleskSQLServer
4. cmd
cd %plesk_dir%\mysql\bin
mysql -P8306
--------------
below is mysql cli
--------------
use mysql
update user set password=password('plesk-admin-password') where user="admin"
quite
----------------------
4. Remove entry skip-grant-table from my.ini
5. Restart (start)PleskSQLServer
6. Open Plesk REconfigurator and start database switching
Note, that new admin user must be something like admin1 and password used must be the same as for admin
7. STart switching

John S.G.

 

[sergius]

Please download updated modules reconfigurator.exe and psaobsolete.dll and put it to %plesk_bin%.
Next try to run switching again. If error will occur then please put text here.

 

[shima]

Hi,
Before downloading updated modules of reconfigurator.exe, I want to explain the situation:

1- I followed what JackL wrote and at end I just received these two lines in Even viewer ( As always) :
================================
Event Type: Information
Event Source: MySQL
C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

Event Type: Information
Event Source: MySQL
C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete
================================

2-I checked the status of 'Plesk SQL Server' servic in services.mmc, at the end of the "DB switching" , the service will be disabled. ( Even when I set it Automatic!)

3- In services.mmc and for 'Plesk SQL Server' Service, I checked dependencies,in "The following system components depend on this service:" section, there was nothing!, although I thought there must be 'Plesk management Service'

Any Idea?
--Shima

 

[shima]

Hi,
Downloading updated modules reconfigurator.exe and psaobsolete.dll didn't solve the problem. Event viewer :
================================
Event Type: Information
Event Source: MySQL
C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

Event Type: Information
Event Source: MySQL
C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete
================================
Is there any command line (instruction) for changing DB provider? I prefere to change db provider manually instead of using reconfigurator.exe.

 

[sergius]

Originally posted by shima
Hi,
Downloading updated modules reconfigurator.exe and psaobsolete.dll didn't solve the problem. Event viewer :
================================
Event Type: Information
Event Source: MySQL
C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

Event Type: Information
Event Source: MySQL
C:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete
================================
Is there any command line (instruction) for changing DB provider? I prefere to change db provider manually instead of using reconfigurator.exe.

What error message Reconfigurator shown? Not in Event log but in message box.

 

[shima]

Hi
The result :
Swsoft found that the permissions on the admin user in MySQL wasn't setup correctly. They fixed this and changed the DB to MySQL.

The question is : does it is really related to the Plesk 8.2 default setting problem?

 

[rackset]

Please clarify how to fix this issue? We have the same problem, want to change engine from JET to MySQL.

 

[shall]

http://download1.parallels.com/Plesk/Autoupdate/plesk_8.3.0.1_update080228.13.htm

8.2 and 8.3 both had broken db migration functionality. Upgrade to 8.3.0.1 - it works fine there.