I have successfully implemented accounting to syslog, but I would like to use MySQL to handle accounting. I have read that # DEFS+=-DSQL_ACC must be uncommented for database logging to work, but I installed from RPM, how can I set up database accounting in this situation?
By the way, I have ser-0.8.12-0.i386.rpm and ser-mysql-0.8.12-0.i386.rpm installed on my system.
Thank you for your time.
__________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/
jerk face wrote:
I have successfully implemented accounting to syslog, but I would like to use MySQL to handle accounting. I have read that # DEFS+=-DSQL_ACC must be uncommented for database logging to work, but I installed from RPM, how can I set up database accounting in this situation?
Its explained in the acc moduls README:
--- You need to enable it by recompiling the module with properly set defines. Uncomment the SQL_ACC and RAD_ACC lines in modules/acc/Makefile. To compile SQL support, you need to have mysqlclient package on your system. To compile RADIUS support, you need to have radiusclient installed on your system (http://www.mcs-cityline.net/~lf/radius/). The radius client needs to be configured properly. To do so, use the template at etc/radiusclient.conf and make sure that module's radius_config parameter points to its location. In particular, accounting secret must match that one configured in server. Uses along with FreeRadius (http://www.freeradius.org/) and Radiator (http://www.open.com.au/radiator/) servers have been reported to us.
Both mysql and radius libraries must be dynamically linkable. You need to configure your OS so that SER, when started, will find them. Typically, you do so by manipulating LD_LIBRARY_PATH environment variable or condiguring ld.so. ---
further info is available in on the ser wiki pages.
-- Arnd
--- Arnd Vehling av@nethead.de wrote:
jerk face wrote:
I have successfully implemented accounting to
syslog,
but I would like to use MySQL to handle
accounting. I
have read that # DEFS+=-DSQL_ACC must be
uncommented
for database logging to work, but I installed from RPM, how can I set up database accounting in this situation?
Its explained in the acc moduls README:
You need to enable it by recompiling the module with properly set defines. Uncomment the SQL_ACC and RAD_ACC lines in modules/acc/Makefile. To compile SQL support, you need to have mysqlclient package on your system. To compile RADIUS support, you need to have radiusclient installed on your system (http://www.mcs-cityline.net/~lf/radius/). The radius client needs to be configured properly. To do so, use the template at etc/radiusclient.conf and make sure that module's radius_config parameter points to its location. In particular, accounting secret must match that one configured in server. Uses along with FreeRadius (http://www.freeradius.org/) and Radiator (http://www.open.com.au/radiator/) servers have been reported to us.
Both mysql and radius libraries must be dynamically linkable. You need to configure your OS so that SER, when started, will find them. Typically, you do so by manipulating LD_LIBRARY_PATH environment variable or condiguring ld.so.
further info is available in on the ser wiki pages.
-- Arnd
I installed from RPM, so how would I edit anything and recompile?
__________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/
On Friday 09 January 2004 20:35, jerk face wrote:
--- Arnd Vehling av@nethead.de wrote:
jerk face wrote:
I have successfully implemented accounting to
syslog,
but I would like to use MySQL to handle
accounting. I
have read that # DEFS+=-DSQL_ACC must be
uncommented
for database logging to work, but I installed from RPM, how can I set up database accounting in this situation?
Its explained in the acc moduls README:
[...]
further info is available in on the ser wiki pages.
-- Arnd
I installed from RPM, so how would I edit anything and recompile?
You can try to compile the acc module from a source tarball and replace the acc module from your rpm with that new compiled module. But we do NOT recommend this way, because of possible strange errors which are hard to debug. The better and much more cleaner solution is to remove your rpm installation, and recompile and install from a fresh tarball. (Naturally you can backup and re-use the config of your current installation.)
Regards Nils
-
Arnd Vehling -
jerk face -
Nils Ohlmeier