Author Topic: Reinstalled CWP and now mysql doesn't work  (Read 8393 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Reinstalled CWP and now mysql doesn't work
« on: August 13, 2016, 11:25:05 PM »
I have reinstalled the CWP, copy the files, created the database, and import the another database to the new datebases, but now they don't work.

Why?

I have this log:

Code: [Select]
160813 01:19:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160813  1:19:09  InnoDB: Initializing buffer pool, size = 8.0M
160813  1:19:09  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160813  1:19:09  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
160813  1:19:09  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
160813  1:19:09  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
160813  1:19:09  InnoDB: Started; log sequence number 0 0
160813  1:19:09 [Note] Event Scheduler: Loaded 0 events
160813  1:19:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160813  1:19:10 [Note] /usr/libexec/mysqld: Normal shutdown

160813  1:19:10 [Note] Event Scheduler: Purging the queue. 0 events
160813  1:19:10  InnoDB: Starting shutdown...
160813  1:19:15  InnoDB: Shutdown completed; log sequence number 0 44233
160813  1:19:15 [Note] /usr/libexec/mysqld: Shutdown complete

160813 01:19:15 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160813 01:19:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160813  1:19:15  InnoDB: Initializing buffer pool, size = 8.0M
160813  1:19:15  InnoDB: Completed initialization of buffer pool
160813  1:19:15  InnoDB: Started; log sequence number 0 44233
160813  1:19:16 [Note] Event Scheduler: Loaded 0 events
160813  1:19:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160813  1:42:11 [Note] /usr/libexec/mysqld: Normal shutdown

160813  1:42:11 [Note] Event Scheduler: Purging the queue. 0 events
160813  1:42:11  InnoDB: Starting shutdown...
160813  1:42:13  InnoDB: Shutdown completed; log sequence number 0 103628
160813  1:42:13 [Note] /usr/libexec/mysqld: Shutdown complete

160813 01:42:13 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160813 01:42:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160813  1:42:30  InnoDB: Initializing buffer pool, size = 8.0M
160813  1:42:30  InnoDB: Completed initialization of buffer pool
160813  1:42:30  InnoDB: Started; log sequence number 0 103628
160813  1:42:30 [Note] Event Scheduler: Loaded 0 events
160813  1:42:30 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160813  7:33:09 [Note] /usr/libexec/mysqld: Normal shutdown

160813  7:33:09 [Note] Event Scheduler: Purging the queue. 0 events
160813  7:33:09  InnoDB: Starting shutdown...
160813  7:33:12  InnoDB: Shutdown completed; log sequence number 0 72426297
160813  7:33:12 [Note] /usr/libexec/mysqld: Shutdown complete

160813 07:33:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160813 07:33:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160813  7:33:12  InnoDB: Initializing buffer pool, size = 64.0M
160813  7:33:12  InnoDB: Completed initialization of buffer pool
160813  7:33:12  InnoDB: Started; log sequence number 0 72426297
160813  7:33:12 [Note] Event Scheduler: Loaded 0 events
160813  7:33:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
160813  7:36:32 [Note] /usr/libexec/mysqld: Normal shutdown

160813  7:36:32 [Note] Event Scheduler: Purging the queue. 0 events
160813  7:36:32  InnoDB: Starting shutdown...
160813  7:36:34  InnoDB: Shutdown completed; log sequence number 0 72426297
160813  7:36:34 [Note] /usr/libexec/mysqld: Shutdown complete

160813 07:36:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160813 07:37:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160813  7:37:10  InnoDB: Initializing buffer pool, size = 64.0M
160813  7:37:10  InnoDB: Completed initialization of buffer pool
160813  7:37:10  InnoDB: Started; log sequence number 0 72426297
160813  7:37:10 [Note] Event Scheduler: Loaded 0 events
160813  7:37:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Offline
*
Re: Reinstalled CWP and now mysql doesn't work
« Reply #1 on: August 14, 2016, 11:12:56 PM »
RESOLVED !!

The problem was the permission of the folders.
I have fixed it with this: http://forum.centos-webpanel.com/php/suphp-500-internal-server-error/

Regards.