Добрый день!
Буквально вчера все было нормально, сегодня пишет ошибку Error displaying the error page: Application Instantiation Error: Could not connect to MySQL.
Используется msql 5.5
Содержимое профиля:
[main]
start=30
allow=1
autowait=0
emformat=txt
maxmemcache=64
cgiprocess=6
pginitencode=UTF8
pginitlocale=Russian_Russia.1251
ip=127.0.0.1
http_log=1
mysql_log=0
postgresql_log=0
mongodb_log=0
dns_log=0
memcache_log=0
redis_log=0
debugmail=0
mysqlcharset=utf8_general_ci
phpdriver="PHP-5.3"
httpdriver="Apache-2.2"
mysql_driver="MySQL-5.5"
pg_driver=none
mongo_driver=none
memcachedriver=none
redisdriver=none
dnsdriver=none
httpcharset=notset
logreadsize=256
showversion=0
astart=0
crdisk=1
crpath=0
crdomain=0
showfvr=0
showprogs=1
hdomains=0
balloon=1
favorite=0
showswitch=1
debugmode=0
stext=1
sbrowser=0
email=0
vdisk=W
selfhosts=0
webdir="domains"
browser=""
textred="%realprogdir%\progs\_Office\Notepad2\Notepad2.exe"
filebrowser=""
sfilebrowser=0
fzone=none
maxrequests=0
folders=""
[ports]
mysqlport=3306
postgresqlport=5432
mongodbport=27017
httpport=80
httpsport=443
httpbackport=8080
ftpport=21
sftpport=990
phpport=9000
redisport=6379
memcacheport=11211
[ftp]
ftp=0
ftpcommandtimeout=600
ftpconnecttimeout=60
[sendmail]
smtp_server=""
smtp_port=""
auth_username=""
auth_password=""
smtp_ssl=0
pop3_server=""
pop3_username=""
pop3_password=""
force_sender=""
Параметры системы: Win 7х32, avast антивирус, под админом работаю, Firefox браузер
Логи: Основной:
2015-03-25 13:00:32 --------------------------------------------
2015-03-25 13:00:32 Начало процедуры запуска сервера
2015-03-25 13:00:33 Обновление Hosts файла
2015-03-25 13:00:33 Обновление конфигурации MySQL-5.5
2015-03-25 13:00:34 Обновление конфигурации Sendmail
2015-03-25 13:00:34 Обновление конфигурации PHP-5.3
2015-03-25 13:00:34 Обновление конфигурации PHPMyAdmin
2015-03-25 13:00:34 Обновление конфигурации Apache-2.2
2015-03-25 13:00:34 Запуск MySQL-5.5
2015-03-25 13:00:34 Запуск Apache-2.2
2015-03-25 13:00:34 Проверка состояния сервера
2015-03-25 13:00:42 Cервер успешно запущен за 10,594 секунд!
Apache запросы:
www: 127.0.0.1 [25/Mar/2015:13:00:52 +0500] "GET / HTTP/1.1" 200 93 "-" "Mozilla/5.0 (Windows NT 6.1; rv:36.0) Gecko/20100101 Firefox/36.0"
www: 127.0.0.1 [25/Mar/2015:13:04:57 +0500] "GET / HTTP/1.1" 200 93 "-" "Mozilla/5.0 (Windows NT 6.1; rv:36.0) Gecko/20100101 Firefox/36.0"
www: 127.0.0.1 [25/Mar/2015:13:06:19 +0500] "GET /administrator/ HTTP/1.1" 200 93 "-" "Mozilla/5.0 (Windows NT 6.1; rv:36.0) Gecko/20100101 Firefox/36.0"
www: 127.0.0.1 [25/Mar/2015:13:14:04 +0500] "GET / HTTP/1.1" 200 93 "-" "Mozilla/5.0 (Windows NT 6.1; rv:36.0) Gecko/20100101 Firefox/36.0"]
Apache отладка:
[Wed Mar 25 13:00:40 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:40 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:40 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:40 2015] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 25 13:00:42 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:42 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:42 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:42 2015] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 25 13:00:47 2015] [notice] Apache/2.2.29 (Win32) mod_ssl/2.2.29 OpenSSL/0.9.8zc configured -- resuming normal operations
[Wed Mar 25 13:00:47 2015] [notice] Server built: Sep 10 2014 11:58:36
[Wed Mar 25 13:00:47 2015] [notice] Parent: Created child process 2392
[Wed Mar 25 13:00:48 2015] [notice] Disabled use of AcceptEx() WinSock2 API
[Wed Mar 25 13:00:49 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:49 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:49 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:49 2015] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 25 13:00:51 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:51 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:51 2015] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!?
[Wed Mar 25 13:00:51 2015] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
[Wed Mar 25 13:00:52 2015] [notice] Child 2392: Child process is running
[Wed Mar 25 13:00:52 2015] [notice] Child 2392: Acquired the start mutex.
[Wed Mar 25 13:00:52 2015] [notice] Child 2392: Starting 32 worker threads.
[Wed Mar 25 13:00:52 2015] [notice] Child 2392: Listening on port 443.
[Wed Mar 25 13:00:52 2015] [notice] Child 2392: Listening on port 80.
PHP отладка:
пусто
Mysql отладка:
150325 13:00:35 [Note] Plugin 'FEDERATED' is disabled.
150325 13:00:35 InnoDB: The InnoDB memory heap is disabled
150325 13:00:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150325 13:00:35 InnoDB: Compressed tables use zlib 1.2.3
150325 13:00:35 InnoDB: Initializing buffer pool, size = 20.0M
150325 13:00:35 InnoDB: Completed initialization of buffer pool
150325 13:00:35 InnoDB: highest supported file format is Barracuda.
150325 13:00:40 InnoDB: Waiting for the background threads to start
150325 13:00:41 InnoDB: 5.5.41 started; log sequence number 29891375
150325 13:00:41 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150325 13:00:41 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150325 13:00:41 [Note] Server socket created on IP: '127.0.0.1'.
150325 13:00:42 [ERROR] mysql.user has no `Event_priv` column at position 29
150325 13:00:42 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
150325 13:00:42 [Note] c:\openserver\modules\database\MySQL-5.5\bin\mysqld.exe: ready for connections.
Version: '5.5.41-log' socket: '' port: 3306 MySQL Community Server (GPL)
150325 13:04:34 [Note] Plugin 'FEDERATED' is disabled.
150325 13:04:34 InnoDB: The InnoDB memory heap is disabled
150325 13:04:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150325 13:04:34 InnoDB: Compressed tables use zlib 1.2.3
150325 13:04:34 InnoDB: Initializing buffer pool, size = 20.0M
150325 13:04:34 InnoDB: Completed initialization of buffer pool
150325 13:04:34 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
150325 13:04:44 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
150325 13:04:54 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
Почта:
пусто
Доп.инфо: стояла джумла ver. 3.3.3, сверху шаблон qickstart, вчера, пока все работало, ставила внешний форум phpBB ver. 3.1.3, так же ставились компонент на джумлу для интеграции форума и сайта (чтобы два раза не регаться на форуме и сайте), JFusion ver. 2.1.0. Так же в PhpMyAdmin, в базе mysql, в таблице User были добавлены три строчки, что бы совершать обмен юзверями между форумом и сайтом: 1) имя - user_pass_convert тип - VARCHAR длина значения 255 сравнение utf8_bin, 2) имя - user_occ тип - VARCHAR длина значения 255 сравнение utf8_bin, 3) имя - user_interests тип - TEXT сравнение utf8_general_ci.
Бэкапов, на мою голову, я не делала. Скрин приложеный, изменения в базе.