accounting with postgres

[Salvin Kumar]

After installing freeradius4.8 I installed postgresql 7.3.3 and  I am interested in the accounting part which I want to be done into a database.The details are there in the detail file.   I made the appropriate changes to the radiusd.conf and postgresql.conf files. And now when I run the daemon radiusd -x I get the following error message: su-2.05b# radiusd -x Starting - reading configuration files ... Module: Loaded System Module: Instantiated unix (unix) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_postgresql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path  of your system's ld. radiusd.conf[8]: sql: Module instantiation failed.   The libraries are there in /usr/local/lib.  I have also tried, export LD_LIBRARY_PATH=/usr/local/lib   Then I created ld.so.conf file in the /etc directory and this is how it looks:   # Begin /etc/ld.so.conf /lib /usr/lib /usr/X11R6/lib /usr/local/lib   # End /etc/ld.so.conf   and the I ran ldconfig