From: Ryan Milton <rmilton@mvsusa.com<mailto:rmilton@mvsusa.com>> Date: Tuesday, January 7, 2014 at 3:16 PM To: "freeradius-users@lists.freeradius.org<mailto:freeradius-users@lists.freeradius.org>" <freeradius-users@lists.freeradius.org<mailto: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