<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">Hello,<br><br>I just setup 2.2.0 from freebsd ports. In the testing environment it looks okey except this error:<br>rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN<br>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1<br>
rlm_sql_mysql: Starting connect to MySQL server for #1<br>
rlm_sql (sql): Connected new DB handle, #1<br><br>It appears on every second authorization attempt. Ping to mysql server runs fine, another db's works without any clue.<br>Google didnt give me any answers about this problem.<br><br>rad_recv: Access-Request packet from host 127.0.0.1 port 27983, id=47, length=50<br> User-Name = "2-40"<br> User-Password = "PjTKX2Ln"<br> Framed-Protocol = PPP<br># Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group authorize {...}<br>++[preprocess] returns ok<br>++[chap] returns noop<br>++[mschap] returns noop<br>++[digest] returns noop<br>[suffix] No '@' in User-Name = "2-40", looking up realm NULL<br>[suffix] No such realm "NULL"<br>++[suffix] returns noop<br>[eap] No EAP-Message, not doing EAP<br>++[eap] returns noop<br>[sql] expand: %{User-Name} -> 2-40<br>[sql] sql_set_user escaped user --> '2-40'<br>rlm_sql (sql): Reserving sql socket id: 2<br>[sql]
expand: SELECT id, username, attribute, value, op FROM
radcheck WHERE username = '%{SQL-User-Name}' ORDER
BY id -> SELECT id, username, attribu<br>rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #2<br>rlm_sql_mysql: Starting connect to MySQL server for #2<br>rlm_sql (sql): Connected new DB handle, #2<br>[sql] User found in radcheck table<br>[sql]
expand: SELECT id, username, attribute, value, op FROM
radreply WHERE username = '%{SQL-User-Name}' ORDER
BY id -> SELECT id, username, attribu<br>[sql] expand: SELECT
groupname FROM radusergroup WHERE username =
'%{SQL-User-Name}' ORDER BY priority -> SELECT
groupname FROM radusergrou<br>[sql] expand: SELECT id,
groupname, attribute, Value, op FROM
radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER
BY id -> SELECT id, grou<br>[sql] User found in group Plaza20<br>[sql]
expand: SELECT id, groupname, attribute, value,
op FROM radgroupreply WHERE groupname =
'%{Sql-Group}' ORDER BY id -> SELECT id, grou<br>rlm_sql (sql): Released sql socket id: 2<br>++[sql] returns ok<br>++[expiration] returns noop<br>++[logintime] returns noop<br>[pap] WARNING: Auth-Type already set. Not setting to PAP<br>++[pap] returns noop<br>Found Auth-Type = PAP<br># Executing group from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group PAP {...}<br>[pap] login attempt with password "PjTKX2Ln"<br>[pap] Using CRYPT password "PCA82A.D836/k"<br>[pap] User authenticated successfully<br>++[pap] returns ok<br>Login OK: [2-40/PjTKX2Ln] (from client localhost port 0)<br># Executing section post-auth from file /usr/local/etc/raddb/sites-enabled/default<br>+- entering group post-auth {...}<br>[sql] expand: %{User-Name} -> 2-40<br>[sql] sql_set_user escaped user --> '2-40'<br>[sql] expand: %{User-Password} -> PjTKX2Ln<br>[sql]
expand: INSERT INTO radpostauth
(username, pass, reply, authdate) VALUES
( '%{User-Name}', <br>rlm_sql (sql) in
sql_postauth: query is INSERT INTO radpostauth
(username, pass, reply, authdate) VALUES ( <br>rlm_sql (sql): Reserving sql socket id: 1<br>rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #1<br>rlm_sql_mysql: Starting connect to MySQL server for #1<br>rlm_sql (sql): Connected new DB handle, #1<br>rlm_sql (sql): Released sql socket id: 1<br>++[sql] returns ok<br>++[exec] returns noop<br>Sending Access-Accept of id 47 to 127.0.0.1 port 27983<br>Finished request 1.<br>Going to the next request<br>Waking up in 4.9 seconds.<br>Cleaning up request 1 ID 47 with timestamp +51<br>Ready to process requests.<br><br><br>Thanks.<br></div></div></body></html>