$Id$
faq.txt
(c) ggw@openisp.net 2002

Why do these errors appear in the radius.log file?
--------------------------------------------------
"Error: MYSQL cannot select db mysqlradacct"
You need to use mysql as root and (example may vary. See local.h):
mysql> GRANT ALL ON mysqlradacct.* TO mysqlradius@localhost IDENTIFIED BY
'wsxedc'
Restart radiusd just in case...

"Error: Accounting: /var/log/radutmp: Permission denied"
you need to:
#touch /var/log/radutmp
#chown openisp /var/log/radutmp
Restart radiusd just in case...


Why is the pid file not working?
--------------------------------
Check all your tConfiguration settings.
You may need a non documented tConfiguration entry like so:
cLabel: cRadiusdArgs-localhost
cValue: -D -y -i 192.168.0.224 -p 1645 -l /usr/local/openisp/logs
Note that it should be the same as cRadiusdArgs.
The -<tServer.cLabel> part is needed for remotely managed radius servers, but
the documentation is not explicit.
Example webadmin URL to table above:
http://192.168.0.224:9123/cgi-bin/mysqlRadius.cgi?function=tConfiguration

Check to make sure you start the correct version of the Cistron radiusd.
Make sure you start it with (example rc.local and crontab operation)

>cat /etc/rc.d/rc.local
...
/cgi-bin/mysqlRadius.cgi Start localhost
...
(Note that ln -s /usr/local/openisp/cgi-bin /cgi-bin was performed on the 
server above for ease of use...)

~openisp should also be set correctly

chown -R openisp ~openisp should be performed also.

>crontab -l
...
#
#OpenISP job queue processing. By ggw@openisp.net
#
#mysqlRadius
* * * * * /cgi-bin/mysqlRadius.cgi ProcessExtJobQueue localhost >> /usr/local/openisp/logs/mysqlRadiusExt.log 2>&1 ; /bin/sleep 1 ; /cgi-bin/mysqlRadius.cgi ProcessJobQueue localhost >> /usr/local/openisp/logs/mysqlRadius.log 2>&1
...
Note the debug helpful "logfiles" created.


Why is the radiusd logfile not working?
---------------------------------------
If you don't include: -l /usr/local/openisp/logs
in your tConfiguration.cValue a bug in Cistron 1.6.6 will create log file 
with the wrong permissions.


Why is the mysqlRadius-Cistron-1.6.6 radiusd not starting?
----------------------------------------------------------
Check radius.log and read the end.
Check for /etc/raddb/sqlserver file and check it's contents.


Why is accounting not taking place?
-----------------------------------
read logfile and set /etc/raddb/clients correctly
mkdir /var/log/radacct
radtest does not send acct packets!

make sure your system HD partitions have enough space for huge /var/log/sql.log file (this file can be turned off by easy hacking of mysqlRadius Cistron)