Freeradius 0.5 with mysql...

[Houcheng]

Dear all Freeradius users:       I've installed freeradius 0.5 and mysql database on my linux, and both run well. Now I try to log the accounting information into mysql database, so I modify the "sql.conf" and change the driver to "rlm_sql_mysql".       When I start the radiusd, it fails with the following error message:   root@bmw>/usr/local/sbin/radiusd -x Starting - reading configuration files ... Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Module: Loaded SQL rlm_sql: Could not link driver rlm_sql_mysql: file not found rlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[4]: sql: Module instantiation failed. root@bmw>       I can assure that the rlm_sql_mysql.a and rlm_sql_mysql.la is installed into the modules lib directory, and mysql lib is installed at /usr/lib/mysql. Is there anything I miss ?                                              Thanks in advance!                                            Lin Houcheng