radius 0.9.3 / mysql 4.0.16: no logging

2003-12-15 Thread James Green
Good morning all, We have a server with a really old copy of FreeRADIUS logging accounting data to mysql 3.xx. We are now in the process of upgrading to the latest stable of mysql 4 and freeradius. We've built the system on a separate machine and it works during testing, except it doesn't log

Re: radius 0.9.3 / mysql 4.0.16: no logging

2003-12-15 Thread ZORBADELOS KONSTANTINOS
At Mon, 15 Dec 2003 10:25:36 +, James Green wrote: Use radiusd -X and see what happens with the requests. You should see the sql queries that the server tries to execute. Good morning all, We have a server with a really old copy of FreeRADIUS logging accounting data to mysql 3.xx. We

Re: radius 0.9.3 / mysql 4.0.16: no logging

2003-12-15 Thread James Green
ZORBADELOS KONSTANTINOS wrote: At Mon, 15 Dec 2003 10:25:36 +, James Green wrote: Use radiusd -X and see what happens with the requests. You should see the sql queries that the server tries to execute. Zorbadelos, This has been done. That is how I know it connects to the database, but

Re: radius 0.9.3 / mysql 4.0.16: no logging

2003-12-15 Thread ZORBADELOS KONSTANTINOS
At Mon, 15 Dec 2003 12:57:24 +, James Green wrote: ZORBADELOS KONSTANTINOS wrote: You said you used radiusd -x and not radiusd -X (case is important). Please send the output you receive from radiusd -X. See the rlm_sql and radius_xlat messages. Perhaps something is wrong with the

Re: radius 0.9.3 / mysql 4.0.16: no logging

2003-12-15 Thread James Green
ZORBADELOS KONSTANTINOS wrote: At Mon, 15 Dec 2003 12:57:24 +, James Green wrote: ZORBADELOS KONSTANTINOS wrote: You said you used radiusd -x and not radiusd -X (case is important). Please send the output you receive from radiusd -X. See the rlm_sql and radius_xlat messages. Perhaps

Re: radius 0.9.3 / mysql 4.0.16: no logging

2003-12-15 Thread Nick Davis
modcall[authorize]: module preprocess returns ok for request 3 radius_xlat: '/var/log/radiusd/radacct/81.20.32.130/auth-detail-20031215' rlm_detail: /var/log/radiusd/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/radiusd/radacct/81.20.32.130/auth-detail-20031215

Re: radius 0.9.3 / mysql 4.0.16: no logging

2003-12-15 Thread James Green
Nick Davis wrote: James, All of your accounting data is being written to the details files. You must not have put sql in the accounting section of radius.conf. You mean this?: accounting { # # Ensure that we have a semi-unique identifier for every # request, and many