Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th March 2013, 18:42
kendel kendel is offline
HowtoForge Supporter
 
Join Date: Aug 2010
Posts: 132
Thanks: 4
Thanked 1 Time in 1 Post
Default Ubuntu Updated MySQL Failed to Connect

I saved a few updates for a while, and finally updated. But now nothing is able to connect to mysql. I created a database using ispconfig and noticed that it did not get created in mysql. Then I started checking around and noticed that MySQL server listening address was set back to default, so I commented it out. but none of my databases connect, not even root but all password check out and webmin still has access.
__________________
If you are looking for examples of an ISPConfig 3 Multiserver Setup, Visit my website Here!!!
Reply With Quote
Sponsored Links
  #2  
Old 26th March 2013, 00:15
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,482
Thanks: 835
Thanked 5,524 Times in 4,345 Posts
Default

Any errors in mysql logs?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 26th March 2013, 08:06
kendel kendel is offline
HowtoForge Supporter
 
Join Date: Aug 2010
Posts: 132
Thanks: 4
Thanked 1 Time in 1 Post
Default

Trying to connect I get: Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Then: mysql.log

Code:
130325 10:21:57 [Note] Plugin 'FEDERATED' is disabled.
130325 10:21:57 InnoDB: The InnoDB memory heap is disabled
130325 10:21:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 10:21:57 InnoDB: Compressed tables use zlib 1.2.3.4
130325 10:21:57 InnoDB: Initializing buffer pool, size = 128.0M
130325 10:21:57 InnoDB: Completed initialization of buffer pool
130325 10:21:58 InnoDB: highest supported file format is Barracuda.
130325 10:21:58  InnoDB: Waiting for the background threads to start
130325 10:21:59 InnoDB: 1.1.8 started; log sequence number 34782103
130325 10:21:59  InnoDB: Starting shutdown...
130325 10:21:59  InnoDB: Shutdown completed; log sequence number 34782103
130325 10:21:59 [Note] Plugin 'FEDERATED' is disabled.
130325 10:21:59 InnoDB: The InnoDB memory heap is disabled
130325 10:21:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 10:21:59 InnoDB: Compressed tables use zlib 1.2.3.4
130325 10:21:59 InnoDB: Initializing buffer pool, size = 128.0M
130325 10:21:59 InnoDB: Completed initialization of buffer pool
130325 10:21:59 InnoDB: highest supported file format is Barracuda.
130325 10:22:00  InnoDB: Waiting for the background threads to start
130325 10:22:01 InnoDB: 1.1.8 started; log sequence number 34782103
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at lin$
130325 10:22:01 [ERROR] Aborting

130325 10:22:01  InnoDB: Starting shutdown...
130325 10:22:01  InnoDB: Shutdown completed; log sequence number 34782103
130325 10:22:01 [Note] /usr/sbin/mysqld: Shutdown complete

130325 10:22:01 [Note] Plugin 'FEDERATED' is disabled.
130325 10:22:01 InnoDB: The InnoDB memory heap is disabled
130325 10:22:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 10:22:01 InnoDB: Compressed tables use zlib 1.2.3.4
130325 10:22:01 InnoDB: Initializing buffer pool, size = 128.0M
130325 10:22:01 InnoDB: Completed initialization of buffer pool
130325 10:22:01 InnoDB: highest supported file format is Barracuda.
130325 10:22:01  InnoDB: Waiting for the background threads to start
130325 10:22:02 InnoDB: 1.1.8 started; log sequence number 34782103
130325 10:22:02  InnoDB: Starting shutdown...
130325 10:22:03  InnoDB: Shutdown completed; log sequence number 34782103
130325 10:22:03 [Note] Plugin 'FEDERATED' is disabled.
130325 10:22:03 InnoDB: The InnoDB memory heap is disabled
130325 10:22:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 10:22:03 InnoDB: Compressed tables use zlib 1.2.3.4
130325 10:22:03 InnoDB: Initializing buffer pool, size = 128.0M
130325 10:22:03 InnoDB: Completed initialization of buffer pool
130325 10:22:03 InnoDB: highest supported file format is Barracuda.
130325 10:22:03  InnoDB: Waiting for the background threads to start
130325 10:22:04 InnoDB: 1.1.8 started; log sequence number 34782103
ERROR: 1050  Table 'plugin' already exists
130325 10:22:04 [ERROR] Aborting

130325 10:22:04  InnoDB: Starting shutdown...
130325 10:22:05  InnoDB: Shutdown completed; log sequence number 34782103
130325 10:22:05 [Note] /usr/sbin/mysqld: Shutdown complete

130325 10:22:05 [Note] Plugin 'FEDERATED' is disabled.
130325 10:22:05 InnoDB: The InnoDB memory heap is disabled
130325 10:22:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 10:22:05 InnoDB: Compressed tables use zlib 1.2.3.4
130325 10:22:05 InnoDB: Initializing buffer pool, size = 128.0M
130325 10:22:05 InnoDB: Completed initialization of buffer pool
130325 10:22:05 InnoDB: highest supported file format is Barracuda.
130325 10:22:05  InnoDB: Waiting for the background threads to start
130325 10:22:06 InnoDB: 1.1.8 started; log sequence number 34782103
130325 10:22:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130325 10:22:06 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
130325 10:22:06 [Note] Server socket created on IP: '127.0.0.1'.
130325 10:22:06 [Note] Event Scheduler: Loaded 0 events
130325 10:22:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
130325 10:37:42 [Note] /usr/sbin/mysqld: Normal shutdown

130325 10:37:42 [Note] Event Scheduler: Purging the queue. 0 events
130325 10:37:42  InnoDB: Starting shutdown...
130325 10:37:43  InnoDB: Shutdown completed; log sequence number 34782103
130325 10:37:43 [Note] /usr/sbin/mysqld: Shutdown complete

130325 10:38:14 [Note] Plugin 'FEDERATED' is disabled.
130325 10:38:14 InnoDB: The InnoDB memory heap is disabled
130325 10:38:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 10:38:14 InnoDB: Compressed tables use zlib 1.2.3.4
130325 10:38:14 InnoDB: Initializing buffer pool, size = 128.0M
130325 10:38:14 InnoDB: Completed initialization of buffer pool
130325 10:38:14 InnoDB: highest supported file format is Barracuda.
130325 10:38:15  InnoDB: Waiting for the background threads to start
130325 10:38:16 InnoDB: 1.1.8 started; log sequence number 34782103
130325 10:38:16 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130325 10:38:16 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
130325 10:38:16 [Note] Server socket created on IP: '127.0.0.1'.
130325 10:38:16 [Note] Event Scheduler: Loaded 0 events
130325 10:38:16 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
130325 10:54:15 [Note] /usr/sbin/mysqld: Normal shutdown

130325 10:54:15 [Note] Event Scheduler: Purging the queue. 0 events
130325 10:54:15  InnoDB: Starting shutdown...
130325 10:54:17  InnoDB: Shutdown completed; log sequence number 34782103
130325 10:54:17 [Note] /usr/sbin/mysqld: Shutdown complete

130325 10:54:19 [Note] Plugin 'FEDERATED' is disabled.
130325 10:54:19 InnoDB: The InnoDB memory heap is disabled
130325 10:54:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 10:54:19 InnoDB: Compressed tables use zlib 1.2.3.4
130325 10:54:19 InnoDB: Initializing buffer pool, size = 128.0M
130325 10:54:19 InnoDB: Completed initialization of buffer pool
130325 10:54:19 InnoDB: highest supported file format is Barracuda.
130325 10:54:20  InnoDB: Waiting for the background threads to start
130325 10:54:21 InnoDB: 1.1.8 started; log sequence number 34782103
130325 10:54:21 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130325 10:54:21 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
130325 10:54:21 [Note] Server socket created on IP: '127.0.0.1'.
130325 10:54:21 [Note] Event Scheduler: Loaded 0 events
130325 10:54:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
130325 11:44:50 [Note] /usr/sbin/mysqld: Normal shutdown

130325 11:44:50 [Note] Event Scheduler: Purging the queue. 0 events
130325 11:44:50  InnoDB: Starting shutdown...
130325 11:44:51  InnoDB: Shutdown completed; log sequence number 34782103
130325 11:44:51 [Note] /usr/sbin/mysqld: Shutdown complete

130325 11:45:19 [Note] Plugin 'FEDERATED' is disabled.
130325 11:45:19 InnoDB: The InnoDB memory heap is disabled
130325 11:45:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 11:45:19 InnoDB: Compressed tables use zlib 1.2.3.4
130325 11:45:19 InnoDB: Initializing buffer pool, size = 128.0M
130325 11:45:19 InnoDB: Completed initialization of buffer pool
130325 11:45:19 InnoDB: highest supported file format is Barracuda.
130325 11:45:20  InnoDB: Waiting for the background threads to start
130325 11:45:21 InnoDB: 1.1.8 started; log sequence number 34782103
130325 11:45:21 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130325 11:45:21 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
130325 11:45:21 [Note] Server socket created on IP: '127.0.0.1'.
130325 11:45:21 [Note] Event Scheduler: Loaded 0 events
130325 11:45:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
130325 12:07:09 [Note] /usr/sbin/mysqld: Normal shutdown

130325 12:07:09 [Note] Event Scheduler: Purging the queue. 0 events
130325 12:07:11 [Warning] /usr/sbin/mysqld: Forcing close of thread 164  user: 'ispconfig'

130325 12:07:11  InnoDB: Starting shutdown...
130325 12:07:12  InnoDB: Shutdown completed; log sequence number 34782103
130325 12:07:12 [Note] /usr/sbin/mysqld: Shutdown complete

130325 12:07:14 [Note] Plugin 'FEDERATED' is disabled.
130325 12:07:14 InnoDB: The InnoDB memory heap is disabled
130325 12:07:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 12:07:14 InnoDB: Compressed tables use zlib 1.2.3.4
130325 12:07:14 InnoDB: Initializing buffer pool, size = 128.0M
130325 12:07:14 InnoDB: Completed initialization of buffer pool
130325 12:07:14 InnoDB: highest supported file format is Barracuda.
130325 12:07:14  InnoDB: Waiting for the background threads to start
130325 12:07:15 InnoDB: 1.1.8 started; log sequence number 34782103
130325 12:07:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130325 12:07:15 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130325 12:07:15 [Note] Server socket created on IP: '0.0.0.0'.
130325 12:07:15 [Note] Event Scheduler: Loaded 0 events
130325 12:07:15 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
130325 12:08:55 [Warning] IP address '192.168.10.1' could not be resolved: Name or service not known
130325 12:12:03 [Note] /usr/sbin/mysqld: Normal shutdown

130325 12:12:03 [Note] Event Scheduler: Purging the queue. 0 events
130325 12:12:05 [Warning] /usr/sbin/mysqld: Forcing close of thread 126  user: 'ispconfig'

130325 12:12:05  InnoDB: Starting shutdown...
130325 12:12:06  InnoDB: Shutdown completed; log sequence number 34782103
130325 12:12:06 [Note] /usr/sbin/mysqld: Shutdown complete

130325 12:12:06 [Note] Plugin 'FEDERATED' is disabled.
130325 12:12:06 InnoDB: The InnoDB memory heap is disabled
130325 12:12:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 12:12:06 InnoDB: Compressed tables use zlib 1.2.3.4
130325 12:12:06 InnoDB: Initializing buffer pool, size = 128.0M
130325 12:12:06 InnoDB: Completed initialization of buffer pool
130325 12:12:06 InnoDB: highest supported file format is Barracuda.
130325 12:12:07  InnoDB: Waiting for the background threads to start
130325 12:12:08 InnoDB: 1.1.8 started; log sequence number 34782103
130325 12:12:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130325 12:12:08 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130325 12:12:08 [Note] Server socket created on IP: '0.0.0.0'.
130325 12:12:08 [Note] Event Scheduler: Loaded 0 events
130325 12:12:08 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
130325 12:16:15 [Warning] IP address '192.168.10.1' could not be resolved: Name or service not known
130325 13:46:34 [Note] /usr/sbin/mysqld: Normal shutdown

130325 13:46:34 [Note] Event Scheduler: Purging the queue. 0 events
130325 13:46:34  InnoDB: Starting shutdown...
130325 13:46:36  InnoDB: Shutdown completed; log sequence number 34782103
130325 13:46:36 [Note] /usr/sbin/mysqld: Shutdown complete

130325 13:46:38 [Note] Plugin 'FEDERATED' is disabled.
130325 13:46:38 InnoDB: The InnoDB memory heap is disabled
130325 13:46:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130325 13:46:38 InnoDB: Compressed tables use zlib 1.2.3.4
130325 13:46:38 InnoDB: Initializing buffer pool, size = 128.0M
130325 13:46:38 InnoDB: Completed initialization of buffer pool
130325 13:46:38 InnoDB: highest supported file format is Barracuda.
130325 13:46:38  InnoDB: Waiting for the background threads to start
130325 13:46:39 InnoDB: 1.1.8 started; log sequence number 34782103
130325 13:46:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130325 13:46:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130325 13:46:39 [Note] Server socket created on IP: '0.0.0.0'.
130325 13:46:39 [Note] Event Scheduler: Loaded 0 events
130325 13:46:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
130325 14:06:15 [Warning] IP address '192.168.10.1' could not be resolved: Name or service not known
130325 23:03:07 [Warning] IP address '61.160.223.112' could not be resolved: Name or service not known
grep:
Code:
root@db:~# grep mysql /var/log/syslog
Mar 25 10:21:57 db mysqld_safe[24045]:
Mar 25 10:21:57 db mysqld_safe[24045]: PLEASE REMEMBER TO SET A PASSWORD FOR THE                                                                                                                                                              MySQL root USER !
Mar 25 10:21:57 db mysqld_safe[24045]: To do so, start the server, then issue th                                                                                                                                                             e following commands:
Mar 25 10:21:57 db mysqld_safe[24045]:
Mar 25 10:21:57 db mysqld_safe[24045]: /usr/bin/mysqladmin -u root password 'new                                                                                                                                                             -password'
Mar 25 10:21:57 db mysqld_safe[24045]: /usr/bin/mysqladmin -u root -h db.lampxse                                                                                                                                                             rver.com password 'new-password'
Mar 25 10:21:57 db mysqld_safe[24045]:
Mar 25 10:21:57 db mysqld_safe[24045]: Alternatively you can run:
Mar 25 10:21:57 db mysqld_safe[24045]: /usr/bin/mysql_secure_installation
Mar 25 10:21:57 db mysqld_safe[24045]:
Mar 25 10:21:57 db mysqld_safe[24045]: which will also give you the option of re                                                                                                                                                             moving the test
Mar 25 10:21:57 db mysqld_safe[24045]: databases and anonymous user created by d                                                                                                                                                             efault.  This is
Mar 25 10:21:57 db mysqld_safe[24045]: strongly recommended for production serve                                                                                                                                                             rs.
Mar 25 10:21:57 db mysqld_safe[24045]:
Mar 25 10:21:57 db mysqld_safe[24045]: See the manual for more instructions.
Mar 25 10:21:57 db mysqld_safe[24045]:
Mar 25 10:21:57 db mysqld_safe[24045]: Please report any problems with the /usr/                                                                                                                                                             scripts/mysqlbug script!
Mar 25 10:21:57 db mysqld_safe[24045]:
Mar 25 10:22:07 db /etc/mysql/debian-start[24262]: Upgrading MySQL tables if nec                                                                                                                                                             essary.
Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: /usr/bin/mysql_upgrade: the '                                                                                                                                                             --basedir' option is always ignored
Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: Looking for 'mysql' as: /usr/                                                                                                                                                             bin/mysql
Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: Looking for 'mysqlcheck' as:                                                                                                                                                              /usr/bin/mysqlcheck
Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: This installation of MySQL is                                                                                                                                                              already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 25 10:22:07 db /etc/mysql/debian-start[24277]: Checking for insecure root ac                                                                                                                                                             counts.
Mar 25 10:22:07 db /etc/mysql/debian-start[24282]: Triggering myisam-recover for                                                                                                                                                              all MyISAM tables
Mar 25 10:38:17 db /etc/mysql/debian-start[1047]: Upgrading MySQL tables if nece                                                                                                                                                             ssary.
Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: /usr/bin/mysql_upgrade: the '-                                                                                                                                                             -basedir' option is always ignored
Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: Looking for 'mysql' as: /usr/b                                                                                                                                                             in/mysql
Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: Looking for 'mysqlcheck' as: /                                                                                                                                                             usr/bin/mysqlcheck
Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: This installation of MySQL is                                                                                                                                                              already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 25 10:38:17 db /etc/mysql/debian-start[1061]: Checking for insecure root acc                                                                                                                                                             ounts.
Mar 25 10:38:17 db /etc/mysql/debian-start[1066]: Triggering myisam-recover for                                                                                                                                                              all MyISAM tables
Mar 25 10:54:21 db /etc/mysql/debian-start[1860]: Upgrading MySQL tables if nece                                                                                                                                                             ssary.
Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: /usr/bin/mysql_upgrade: the '-                                                                                                                                                             -basedir' option is always ignored
Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: Looking for 'mysql' as: /usr/b                                                                                                                                                             in/mysql
Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: Looking for 'mysqlcheck' as: /                                                                                                                                                             usr/bin/mysqlcheck
Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: This installation of MySQL is                                                                                                                                                              already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 25 10:54:21 db /etc/mysql/debian-start[1874]: Checking for insecure root acc                                                                                                                                                             ounts.
Mar 25 10:54:21 db /etc/mysql/debian-start[1879]: Triggering myisam-recover for                                                                                                                                                              all MyISAM tables
Mar 25 11:45:21 db /etc/mysql/debian-start[1038]: Upgrading MySQL tables if nece                                                                                                                                                             ssary.
Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: /usr/bin/mysql_upgrade: the '-                                                                                                                                                             -basedir' option is always ignored
Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: Looking for 'mysql' as: /usr/b                                                                                                                                                             in/mysql
Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: Looking for 'mysqlcheck' as: /                                                                                                                                                             usr/bin/mysqlcheck
Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: This installation of MySQL is                                                                                                                                                              already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 25 11:45:21 db /etc/mysql/debian-start[1052]: Checking for insecure root acc                                                                                                                                                             ounts.
Mar 25 11:45:21 db /etc/mysql/debian-start[1057]: Triggering myisam-recover for                                                                                                                                                              all MyISAM tables
Mar 25 12:07:16 db /etc/mysql/debian-start[2060]: Upgrading MySQL tables if nece                                                                                                                                                             ssary.
Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: /usr/bin/mysql_upgrade: the '-                                                                                                                                                             -basedir' option is always ignored
Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: Looking for 'mysql' as: /usr/b                                                                                                                                                             in/mysql
Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: Looking for 'mysqlcheck' as: /                                                                                                                                                             usr/bin/mysqlcheck
Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: This installation of MySQL is                                                                                                                                                              already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 25 12:07:16 db /etc/mysql/debian-start[2074]: Checking for insecure root acc                                                                                                                                                             ounts.
Mar 25 12:07:16 db /etc/mysql/debian-start[2079]: Triggering myisam-recover for                                                                                                                                                              all MyISAM tables
Mar 25 12:12:08 db /etc/mysql/debian-start[2662]: Upgrading MySQL tables if nece                                                                                                                                                             ssary.
Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: /usr/bin/mysql_upgrade: the '-                                                                                                                                                             -basedir' option is always ignored
Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: Looking for 'mysql' as: /usr/b                                                                                                                                                             in/mysql
Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: Looking for 'mysqlcheck' as: /                                                                                                                                                             usr/bin/mysqlcheck
Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: This installation of MySQL is                                                                                                                                                              already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 25 12:12:08 db /etc/mysql/debian-start[2676]: Checking for insecure root acc                                                                                                                                                             ounts.
Mar 25 12:12:08 db /etc/mysql/debian-start[2681]: Triggering myisam-recover for                                                                                                                                                              all MyISAM tables
Mar 25 13:46:40 db /etc/mysql/debian-start[6376]: Upgrading MySQL tables if nece                                                                                                                                                             ssary.
Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: /usr/bin/mysql_upgrade: the '-                                                                                                                                                             -basedir' option is always ignored
Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: Looking for 'mysql' as: /usr/b                                                                                                                                                             in/mysql
Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: Looking for 'mysqlcheck' as: /                                                                                                                                                             usr/bin/mysqlcheck
Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: This installation of MySQL is                                                                                                                                                              already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 25 13:46:40 db /etc/mysql/debian-start[6390]: Checking for insecure root acc                                                                                                                                                             ounts.
Mar 25 13:46:40 db /etc/mysql/debian-start[6395]: Triggering myisam-recover for                                                                                                                                                              all MyISAM tables
__________________
If you are looking for examples of an ISPConfig 3 Multiserver Setup, Visit my website Here!!!

Last edited by kendel; 26th March 2013 at 10:42.
Reply With Quote
  #4  
Old 28th March 2013, 07:04
kendel kendel is offline
HowtoForge Supporter
 
Join Date: Aug 2010
Posts: 132
Thanks: 4
Thanked 1 Time in 1 Post
Default

SOLVED. Warning be careful of new Ubuntu updates.
__________________
If you are looking for examples of an ISPConfig 3 Multiserver Setup, Visit my website Here!!!

Last edited by kendel; 28th March 2013 at 07:52.
Reply With Quote
  #5  
Old 21st April 2013, 20:39
kendel kendel is offline
HowtoForge Supporter
 
Join Date: Aug 2010
Posts: 132
Thanks: 4
Thanked 1 Time in 1 Post
 
Default

After a long while it seems this problem is still around. I keep having to FLUSH each time which seems to be a temp fix. Not sure what happened, there was an update and since then its been like this. Databases are not being created.
__________________
If you are looking for examples of an ISPConfig 3 Multiserver Setup, Visit my website Here!!!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't connect to local MySQL server through socket ababneh Server Operation 2 21st March 2013 08:37
Turn off unnecessary services drivespace General 2 18th July 2011 23:32
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 23:16
Failed during pvmove, howto: set up software raid 1 on running LVM system sbh77 HOWTO-Related Questions 2 8th October 2010 01:11
Debian Lenny apt-get update failed to fetch qriz Installation/Configuration 3 31st October 2009 23:19


All times are GMT +2. The time now is 14:40.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.