From: Ryan Milton <rmilton@mvsusa.com>
Date: Tuesday, January 7, 2014 at 3:16 PM
To: "freeradius-users@lists.freeradius.org" <freeradius-users@lists.freeradius.org>
Subject: restarting? database, radius

Hi,

I am using FreeRADIUS 2.1 on a FreeBSD 8.2

In the process of inserting lines into tables on the master server, one server, the one in question wasn’t replicating properly. I attempted to stop radius

- /usr/local/etc/rc.d/radiusd stop  and restart MySQL - /usr/local/etc/rc.d/mysql-server restart

But that did not work.

when I ran a tail command on the radius.log file, I got these errors:
Tue Jan 7 20:18:00 2014 : Error: Failed to load clients from SQL.
Tue Jan 7 20:18:00 2014 : Info: rlm_sql (sql): Closing sqlsocket 4
Tue Jan 7 20:18:00 2014 : Info: rlm_sql (sql): Closing sqlsocket 3
Tue Jan 7 20:18:00 2014 : Info: rlm_sql (sql): Closing sqlsocket 2
Tue Jan 7 20:18:00 2014 : Info: rlm_sql (sql): Closing sqlsocket 1
Tue Jan 7 20:18:00 2014 : Info: rlm_sql (sql): Closing sqlsocket 0
Tue Jan 7 20:18:00 2014 : Error: /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
Tue Jan 7 20:18:00 2014 : Error: /usr/local/etc/raddb/sites-enabled/default[177]: Failed to load module "sql".
Tue Jan 7 20:18:00 2014 : Error: /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section.
Tue Jan 7 20:18:00 2014 : Error: Failed to load virtual server <default>

The error log show the following (I don’t understand it):

/var/db/mysql/serv03XXX.net.err 

140107 20:20:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/data
^G/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140107 20:20:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140107 20:20:22 InnoDB: The InnoDB memory heap is disabled
140107 20:20:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140107 20:20:22 InnoDB: Compressed tables use zlib 1.2.3
140107 20:20:22 InnoDB: Initializing buffer pool, size = 128.0M
140107 20:20:22 InnoDB: Completed initialization of buffer pool
140107 20:20:22 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
140107 20:20:22 mysqld_safe mysqld from pid file /usr/local/data/serv03.ams5.bganglobalnet.net.pid ended
140107 20:23:33 mysqld_safe Starting mysqld daemon with databases from /usr/local/data
^G/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140107 20:23:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140107 20:23:33 InnoDB: The InnoDB memory heap is disabled
140107 20:23:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140107 20:23:33 InnoDB: Compressed tables use zlib 1.2.3

Now, I’m getting this beloved error when I attempt to go back into the MySQL db:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I am completely new at this, but I hesitate to do anything drastic to the server since I don’t fully understand it.

Thanks in advance for any assistance,

Ryan