View previous topic :: View next topic |
Author |
Message |
gregpilot Member
Joined: 20 Sep 2012 Posts: 28
|
Posted: Tue Jun 11, 2013 6:01 pm Post subject: MySQL connection refused error following power interruption |
|
|
After a power interruption I am having a hard time accessing the MySQL database. It successfully completed its crash recovery routine and the avantfax module is working correctly. I can't get any sort of php web applications to connect to it. (Joomla and collabtive) When I go through the settings on those applications, I receive a "Connection Refused" error. I'd appreciate any ideas on how I might get this back up and running.
Thanks!
Greg
SMS64 v 2.0.2
MySQL Log file for the entire day when this occurred:
Quote: |
130610 20:42:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130610 20:42:06 [Note] Plugin 'FEDERATED' is disabled.
130610 20:42:06 InnoDB: The InnoDB memory heap is disabled
130610 20:42:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130610 20:42:06 InnoDB: Compressed tables use zlib 1.2.6
130610 20:42:06 InnoDB: Using Linux native AIO
130610 20:42:06 InnoDB: Initializing buffer pool, size = 128.0M
130610 20:42:06 InnoDB: Completed initialization of buffer pool
130610 20:42:06 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130610 20:42:06 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...
InnoDB: Last MySQL binlog file position 0 57948280, file name ./mysql-bin.000029
130610 20:42:08 InnoDB: Waiting for the background threads to start
130610 20:42:09 InnoDB: 1.1.8 started; log sequence number 103945448
130610 20:42:09 [Note] Recovering after a crash using mysql-bin
130610 20:42:09 [Note] Starting crash recovery...
130610 20:42:09 [Note] Crash recovery finished.
130610 20:42:10 [Note] Event Scheduler: Loaded 0 events
130610 20:42:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.28-log' socket: '/var/run/mysql/mysql.sock' port: 0 MySQL Community Server
(GPL)
|
|
|
Back to top |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 11, 2013 6:09 pm Post subject: |
|
|
Are you trying to connect though the machine itself (127.0.0.1) or over network?
Network is closed be default, you need to comment skip-networking in /etc/my.cnf
Can you login through bash and are the users there?
You can look with phpmyadmin too...
gerasimos_h _________________ Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
Back to top |
|
gregpilot Member
Joined: 20 Sep 2012 Posts: 28
|
Posted: Tue Jun 11, 2013 6:24 pm Post subject: |
|
|
Skip networking is commented out and there are users present in phpmyadmin. |
|
Back to top |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 11, 2013 6:29 pm Post subject: |
|
|
Try to connect through bash and login as a mysql user, which is set to joomla...
You can try to recreate privileges if aren't correct...
We need to know if it's a network access only issue...
gerasimos_h _________________ Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
Back to top |
|
gregpilot Member
Joined: 20 Sep 2012 Posts: 28
|
Posted: Tue Jun 11, 2013 7:10 pm Post subject: |
|
|
It's got to be a network access issue. When I change the host to "localhost" and the permissions on the sql user to "localhost" and it works. |
|
Back to top |
|
gerasimos_h Site Admin
Joined: 09 Aug 2007 Posts: 1757 Location: Greece
|
Posted: Tue Jun 11, 2013 7:17 pm Post subject: |
|
|
So problem is solved?
You can try to add users with the hostname like
Code: | grant all on database.* to user@[youhostname] identified by 'pass'; |
gerasimos_h _________________ Superb! Mini Server Project Manager
http://sms.it-ccs.com
Last edited by gerasimos_h on Tue Jun 11, 2013 8:11 pm; edited 1 time in total |
|
Back to top |
|
gregpilot Member
Joined: 20 Sep 2012 Posts: 28
|
Posted: Tue Jun 11, 2013 7:41 pm Post subject: |
|
|
Yes, for what I need it to do. I had all of my connections set to the static IP address of the server even thought they reside on the same machine. By changing the host to "localhost" it seems to work. Might play around with the network access at a later date. I think a UPS solution will be my first priority.
Thanks again for your help. |
|
Back to top |
|
|