[main] start=10 allow=1 emformat=txt maxmemcache=64 cgiprocess=6 pginitencode=UTF8 pginitlocale=Russian_Russia.1251 ip=192.168.0.1 mysqlrootpass= postgresqlpass= dbdriver=MySQL-5.1.67 mysqlcharset=utf8_general_ci phpdriver=PHP-5.4.11 httpdriver=Apache-2.2.23 httpcharset=windows-1251 logreadsize=512 showversion=1 astart=1 crdisk=1 crpath=0 crdomain=0 showfvr=0 showprogs=1 hdomains=0 balloon=1 favorite=0 showswitch=1 debugmode=1 stext=0 sbrowser=0 mysql=1 email=0 vdisk=W webdir="domains" browser="" textred="" filebrowser="" sfilebrowser=0 upurl=http://open-server.ru/update/ durl=http://open-server.ru/download.html folders="public_html www\htdocs www http htdocs docs web httpdocs public html site" [ports] mysqlport=3306 postgresqlport=5432 httpport=80 httpsport=443 httpbackport=8080 ftpport=21 phpport=9000 memcacheport=11211 [ftp] ftp=1 ftpcommandtimeout=600 ftpconnecttimeout=60 [sendmail] smtp_server= smtp_port= auth_username= auth_password= smtp_ssl=0 pop3_server= pop3_username= pop3_password= force_sender=Основной лог
2013-03-01 01:36:58 -------------------------------------------- 2013-03-01 01:36:58 Начало процедуры запуска сервера 2013-03-01 01:36:58 Обновление Hosts файла 2013-03-01 01:36:58 Обновление конфигурации MySQL-5.1.67 2013-03-01 01:36:58 Обновление конфигурации Sendmail 2013-03-01 01:36:58 Обновление конфигурации PHP-5.4.11 2013-03-01 01:36:58 Обновление конфигурации FTP сервера 2013-03-01 01:36:58 Обновление конфигурации PHPMyAdmin 2013-03-01 01:36:58 Обновление конфигурации MemcacheAdmin 2013-03-01 01:36:58 Обновление конфигурации Apache-2.2.23 2013-03-01 01:36:58 Запуск MySQL-5.1.67 2013-03-01 01:36:58 Запуск FTP сервера 2013-03-01 01:36:58 Запуск Apache-2.2.23 2013-03-01 01:36:58 Проверка состояния сервера 2013-03-01 01:37:53 Не удалось запустить Memcached Server 2013-03-01 01:37:53 Сбой запуска! 2013-03-01 01:37:53 -------------------------------------------- 2013-03-01 01:37:53 Начало процедуры остановки сервера 2013-03-01 01:37:53 Остановка системных модулей 2013-03-01 01:38:11 Отключение виртуального диска 2013-03-01 01:38:11 Веб-сервер успешно остановлен!БД запросы
E:\OpenServer\OpenServer\modules\database\MySQL-5.1.67\bin\mysqld.exe, Version: 5.1.67-community-log (MySQL Community Server (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command ArgumentБД отладка
130301 1:36:58 [Note] Plugin 'FEDERATED' is disabled. 130301 1:36:58 InnoDB: Initializing buffer pool, size = 10.0M 130301 1:36:58 InnoDB: Completed initialization of buffer pool 130301 1:36:58 InnoDB: Started; log sequence number 0 122474 Can't start server: Bind on TCP/IP port: No such file or directory 130301 1:36:58 [ERROR] Do you already have another mysqld server running on port: 3306 ? 130301 1:36:58 [ERROR] Aborting 130301 1:36:58 InnoDB: Starting shutdown... 130301 1:37:04 InnoDB: Shutdown completed; log sequence number 0 122474 130301 1:37:04 [Note] E:\OpenServer\OpenServer\modules\database\MySQL-5.1.67\bin\mysqld.exe: Shutdown completeFTP сервер
FileZilla Server version 0.9.41 beta started Initializing Server. Creating listen socket on port 21... Failed to bind the listen socket on port 21 to the following IPs: 192.168.0.1 Server not online.Работаю под WinXP.
[main] start=10 allow=1 emformat=txt maxmemcache=64 cgiprocess=6 pginitencode=UTF8 pginitlocale=Russian_Russia.1251 ip=127.0.0.1 mysqlrootpass= postgresqlpass= dbdriver=MySQL-5.1.67 mysqlcharset=utf8_general_ci phpdriver=PHP-5.2.17 httpdriver=Apache-2.2.23 httpcharset=notset logreadsize=512 showversion=1 astart=1 crdisk=1 crpath=0 crdomain=0 showfvr=0 showprogs=1 hdomains=0 balloon=1 favorite=0 showswitch=1 debugmode=1 stext=1 sbrowser=1 mysql=1 email=0 vdisk=W webdir="domains" browser="%realprogdir%\progs\_Internet\IronPortable\IronPortable.exe" textred="%realprogdir%\progs\_Office\Notepad++Portable\Notepad++Portable.exe" filebrowser="%realprogdir%\progs\_System\Explorer++Portable\Explorer++Portable.exe" sfilebrowser=1 upurl=http://open-server.ru/update/ durl=http://open-server.ru/download.html folders="public_html www\htdocs www http htdocs docs web httpdocs public html site" [ports] mysqlport=3306 postgresqlport=5432 httpport=80 httpsport=443 httpbackport=8080 ftpport=21 phpport=9000 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=Содержимое файла main.log:
2013-03-03 17:48:26 -------------------------------------------- 2013-03-03 17:48:26 Начало процедуры запуска сервера 2013-03-03 17:48:26 Обновление Hosts файла 2013-03-03 17:48:26 Обновление конфигурации MySQL-5.1.67 2013-03-03 17:48:26 Обновление конфигурации Sendmail 2013-03-03 17:48:26 Обновление конфигурации PHP-5.2.17 2013-03-03 17:48:26 Обновление конфигурации PHPMyAdmin 2013-03-03 17:48:26 Обновление конфигурации MemcacheAdmin 2013-03-03 17:48:26 Обновление конфигурации Apache-2.2.23 2013-03-03 17:48:26 Запуск MySQL-5.1.67 2013-03-03 17:48:26 Запуск Apache-2.2.23 2013-03-03 17:48:26 Проверка состояния сервера 2013-03-03 17:48:42 Не удалось запустить MySQL-5.1.67 2013-03-03 17:48:42 Сбой запуска! 2013-03-03 17:48:42 -------------------------------------------- 2013-03-03 17:48:42 Начало процедуры остановки сервера 2013-03-03 17:48:42 Остановка системных модулей 2013-03-03 17:48:59 Отключение виртуального диска 2013-03-03 17:48:59 Веб-сервер успешно остановлен!НТТР отладка:
[Sun Mar 03 17:48:27 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:27 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:27 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:27 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:27 2013] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366) [Sun Mar 03 17:48:27 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:27 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:27 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:27 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:27 2013] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366) [Sun Mar 03 17:48:31 2013] [notice] Apache/2.2.23 (Win32) mod_ssl/2.2.23 OpenSSL/0.9.8x configured -- resuming normal operations [Sun Mar 03 17:48:31 2013] [notice] Server built: Aug 24 2012 11:45:16 [Sun Mar 03 17:48:31 2013] [notice] Parent: Created child process 4376 [Sun Mar 03 17:48:31 2013] [notice] Disabled use of AcceptEx() WinSock2 API [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:31 2013] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366) [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Mar 03 17:48:31 2013] [warn] RSA server certificate CommonName (CN) `openserver' does NOT match server name!? [Sun Mar 03 17:48:31 2013] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366) [Sun Mar 03 17:48:35 2013] [notice] Child 4376: Child process is running [Sun Mar 03 17:48:35 2013] [notice] Child 4376: Acquired the start mutex. [Sun Mar 03 17:48:35 2013] [notice] Child 4376: Starting 32 worker threads. [Sun Mar 03 17:48:35 2013] [notice] Child 4376: Listening on port 443. [Sun Mar 03 17:48:35 2013] [notice] Child 4376: Listening on port 80.БД запросы:
C:\server\OpenServer\modules\database\MySQL-5.1.67\bin\mysqld.exe, Version: 5.1.67-community-log (MySQL Community Server (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument 130303 17:48:29 1 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:30 2 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:34 3 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:35 4 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:36 5 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:37 6 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:38 7 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:39 8 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:40 9 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:41 10 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 130303 17:48:42 11 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO) 12 Connect Access denied for user 'root'@'127.0.0.1' (using password: NO)БД отладка:
130303 17:48:26 [Note] Plugin 'FEDERATED' is disabled. 130303 17:48:26 InnoDB: Initializing buffer pool, size = 10.0M 130303 17:48:26 InnoDB: Completed initialization of buffer pool InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 130303 17:48:26 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 130303 17:48:26 InnoDB: Started; log sequence number 0 46229 130303 17:48:26 [Note] Event Scheduler: Loaded 0 events 130303 17:48:26 [Note] C:\server\OpenServer\modules\database\MySQL-5.1.67\bin\mysqld.exe: ready for connections. Version: '5.1.67-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
"Открываем справку > Работа с программой > Работа с MySQL > Изменение паролей"povstance писал(а):Решение проблемы какое, не понял. Подробнее можно?
Что теперь делать?При изменении пароля root пользователя MySQL или PostgreSQL сервера необходимо также указать этот пароль в файле конфигурации профиля(ей), параметры mysqlrootpass и postgresqlpass соответственно, после чего перезапустить программу (не сервер).
