Mayor error

[JhonJ]

Hello


After made a update of my license key update the fallow error shows up:

ERROR: PleskMainDBException
No connection could be made because the target machine actively refused it.


0: common_func.php3:619
reconnect()
1: common_func.php3:582
db_connect()
2: auth.php3:146
ERROR: PleskMainDBException
No connection could be made because the target machine actively refused it.


0: common_func.php3:619
reconnect()
1: common_func.php3:582
db_connect()
2: auth.php3:146

my webs ites are on but no the Panel when I try log in mysql or psa i cannot connect.

please help

 

[JhonJ]

at the Windows Log I get this:

- Provider

[ Name] MySQL

- EventID 100

[ Qualifiers] 49152

Level 4

Task 0

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2011-08-30T03:10:19.000000000Z

EventRecordID 140168

Channel Application

Computer server

C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

 

[IgorG]

Looks like something wrong with MySQL server. Try to start it manually and check configuration file \Plesk\MySQL\Data\my.ini

 

[JhonJ]

I have try so far until now made very kind of repair possible everything just no works, it seems the PSA and mysql password has change or something else like that happens.

I have the psa dump do I can restore it? if I can the mysql would do it too?

thanks you

 

[JhonJ]

Igor do you can provide me please a my.ini default 10.3 plesk file? mine is impossible to open

 

[JhonJ]

Finally I open it. it seems were an error on permissions I did fixed it but still the Panel don't run.

this is my my.ini
[client]
port=8306
[PleskSQLServer]
port=8306
basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL
datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
default-character-set=latin1
default-storage-engine=INNODB
query_cache_size=128M
table_cache=768
tmp_table_size=524288000
max_heap_table_size=524288000
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data

 

[JhonJ]

well i did check it and I found few things wrong in there so I changed it to:


[client]
port=8306
[PleskSQLServer]
port=8306
basedir=C:\\Program Files\\Parallels\\Plesk\\MySQL
datadir=C:\\Program Files\\Parallels\\Plesk\\MySQL\\Data
default-character-set=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\Program Files\\Parallels\\Plesk\\MySQL\\Data

 

[JhonJ]

I am working right now on:


110823 22:28:06 InnoDB: Started; log sequence number 0 3430897
C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
Version: '4.1.22-community-nt' socket: '' port: 8306 MySQL Community Edition (GPL)
110824 18:13:10 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

110824 18:13:14 InnoDB: Starting shutdown...
110824 18:13:20 InnoDB: Shutdown completed; log sequence number 0 10399264
110824 18:13:21 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

110824 18:15:40 InnoDB: Started; log sequence number 0 10399264
C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
Version: '4.1.22-community-nt' socket: '' port: 8306 MySQL Community Edition (GPL)
110824 16:32:49 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

110824 16:32:51 [Warning] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 3 user: 'admin'

110824 18:32:51 InnoDB: Starting shutdown...
110824 18:32:54 InnoDB: Shutdown completed; log sequence number 0 10925319
110824 16:32:54 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

110824 18:35:09 InnoDB: Started; log sequence number 0 10925319
C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: ready for connections.
Version: '4.1.22-community-nt' socket: '' port: 8306 MySQL Community Edition (GPL)
110829 20:59:26 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Normal shutdown

110829 20:59:28 InnoDB: Starting shutdown...
110829 20:59:30 InnoDB: Shutdown completed; log sequence number 0 13204844
110829 20:59:30 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

InnoDB: Unrecognized value O_DIRECT for innodb_flush_method
110829 21:01:15 [ERROR] Can't init databases
110829 21:01:15 [ERROR] Aborting

110829 21:01:15 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

InnoDB: Unrecognized value O_DIRECT for innodb_flush_method
110829 22:10:19 [ERROR] Can't init databases
110829 22:10:19 [ERROR] Aborting

110829 22:10:19 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

InnoDB: Unrecognized value O_DIRECT for innodb_flush_method
110829 22:55:13 [ERROR] Can't init databases
110829 22:55:13 [ERROR] Aborting

110829 22:55:13 [Note] C:\Program Files (x86)\Parallels\Plesk\MySQL\bin\mysqld-nt.exe: Shutdown complete

 

[JhonJ]

please Igot do you can let me knwo how to apply this KB http://kb.odin.com/6586 on windows?

 

[JhonJ]

Last Update:

Can't find messagefile 'C:\Program Files\Parallels\Plesk\MySQL\share\english\errmsg.sys'

there is any KB about this error please?

 

[IgorG]

Seems you have seriously corrupted MySQL server. Did you try to full MySQL server reinstallation? Contact Support Team if it not help.

 

[JhonJ]

Igor I have 2 server one on public and another internal (Panel) please there is any documentation how to made a server installation for plesk?

Thank you

 

[IgorG]

Installation Guide
And you can find all Plesk documentation here - http://www.parallels.com/products/plesk/documentation/

 

[JhonJ]

I havent need that information dude, I needed information about how Plesk interact with the database but nvm.

thanks for nothing.