Re: rlm_sql_mysql problem
The driver should be installed into /usr/local/lib with the filename rlm_sql.la first check if the file exists there, and then check configure log, in the directory where U compiled the module, probably U are missing a library or any other required file, and that's why U couldn't compile the driver Pozdrawiam Przemek Bozek 33-25-564 - Original Message - From: Andrés de Barros [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 3:52 PM Subject: rlm_sql_mysql problem dear all, i got message from my radius (freeradius-0.9.1) like this : rlm_sql (sql): Could not link driver rlm_sql_mysql: 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[14]: sql: Module instantiation failed. any suggest for this case ? Thanks, Andrés - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql problem
RedHat 8.0 work ok, thanks Andrés de Barros - Original Message - From: Sérgio José Ferreira [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:08 PM Subject: RES: rlm_sql_mysql problem Check if you have all of the mysql's libraries on your system and if they are on the correct place. What's your system ( Linux / FreeBSD ) ?? Sergio Jose Ferreira WGO Internet Brazil -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nome de Przemek Bozek Enviada em: segunda-feira, 22 de dezembro de 2003 13:03 Para: [EMAIL PROTECTED] Assunto: Re: rlm_sql_mysql problem The driver should be installed into /usr/local/lib with the filename rlm_sql.la first check if the file exists there, and then check configure log, in the directory where U compiled the module, probably U are missing a library or any other required file, and that's why U couldn't compile the driver Pozdrawiam Przemek Bozek 33-25-564 - Original Message - From: Andrés de Barros [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 3:52 PM Subject: rlm_sql_mysql problem dear all, i got message from my radius (freeradius-0.9.1) like this : rlm_sql (sql): Could not link driver rlm_sql_mysql: 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[14]: sql: Module instantiation failed. any suggest for this case ? Thanks, Andrés - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql
Because there are no file named rlm_sql_mysql under RADIUSPATH/lib then under sql.conf i tried to change the driver into rlm_sql instead of rlm_sql_mysql and the result is: sql: simul_verify_query = SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0 rlm_sql (sql): Driver rlm_sql (module SQL) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect SQL #0 Segmentation fault [EMAIL PROTECTED]:/usr/local/radiusd/etc/raddb# Need help, thanks .. Regards, Rio Martin. On Tuesday 09 September 2003 18:47, Ulrich Walcher wrote: I guess you'll have to add the configure options for mysql like: sql: simul_verify_query = SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0 rlm_sql (sql): Could not link driver rlm_sql_mysql: 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[14]: sql: Module instantiation failed. -- I wonder why still not worked ? Of course FAQ given the right instruction right ? I ve tried google, answer to related problem is just the same as written in FAQ. Do i missed something ? Regards, Rio Martin. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql
Rio Martin [EMAIL PROTECTED] wrote: Because there are no file named rlm_sql_mysql under RADIUSPATH/lib then under sql.conf i tried to change the driver into rlm_sql instead of rlm_sql_mysql Huh? Why the heck would you expect that to work? Did you think about trying to build rlm_sql_mysq? and the result is: It doesn't work. So the answer is don't do that Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql
On Monday 15 September 2003 20:52, Alan DeKok wrote: Rio Martin [EMAIL PROTECTED] wrote: Because there are no file named rlm_sql_mysql under RADIUSPATH/lib then under sql.conf i tried to change the driver into rlm_sql instead of rlm_sql_mysql Huh? Why the heck would you expect that to work? Did you think about trying to build rlm_sql_mysq? That would be the step i missed (: and the result is: It doesn't work. So the answer is don't do that Thanks for the rough hint .. Regards, Rio Martin. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql
I guess you'll have to add the configure options for mysql like: --with-mysql-dir=/path/to/mysql --with-mysql-lib-dir=/path/to/mysql/lib --with-mysql-include-dir=/path/to/mysql/include I might be wrong but at least it's a hint... Am Die, 2003-09-09 um 12.25 schrieb Rio Martin: Dear folks, I am having the same problem as described at Freeradius FAQ. I tried the solution just as the FAQ mentioned, First i tried with: ./configure --disable-shared make make install But it didnt succeed. I tried second way: i add /usr/local/radiusd/lib into /etc/ld.so.conf -- [EMAIL PROTECTED]:/usr/local/radiusd/lib# cat /etc/ld.so.conf /usr/local/lib /usr/X11R6/lib /usr/i386-slackware-linux/lib /opt/kde/lib /usr/local/radiusd/lib [EMAIL PROTECTED]:/usr/local/radiusd/lib# ldconfig [EMAIL PROTECTED]:/usr/local/radiusd/lib# /usr/local/radiusd/sbin/radiusd -X . . sql: simul_verify_query = SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0 rlm_sql (sql): Could not link driver rlm_sql_mysql: 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[14]: sql: Module instantiation failed. -- I wonder why still not worked ? Of course FAQ given the right instruction right ? I ve tried google, answer to related problem is just the same as written in FAQ. Do i missed something ? Regards, Rio Martin. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql operator patch
Hi, Look in src/modules/rlm_sql/sql.c function: sql_userparse it is the mode/row[4]. The schema update is in the latest CVS. bash On Wed, 9 Jan 2002, Steve Sobol wrote: OK, this is getting aggravating. I built the 1/9 nightly snapshot off the ftp site (id's itself as FR 0.5) and... nothing. Searched through the source for rlm_sql and rlm_sql_mysql for any mention of the word operator - not found. Same with the latest source off CVS. I hope this is just a result of me being stupid. (It's happened before. :) Maybe I missed something. Does someone have a tarball with working operator code? Please? :) -- JustThe.net LLC - Steve Web Dude Sobol, CTO ICQ: 56972932/WebDude216 website: http://JustThe.net email: [EMAIL PROTECTED] phone: 216.619.2NET postal: 5686 Davis Drive, Mentor On The Lake, OH 44060-2752 DalNet: ZX-2 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql operator patch
At 11:17 PM 1/9/2002 -0500, Steve Sobol wrote: OK, this is getting aggravating. I built the 1/9 nightly snapshot off the ftp site (id's itself as FR 0.5) and... nothing. Searched through the source for rlm_sql and rlm_sql_mysql for any mention of the word operator - not found. Same with the latest source off CVS. It's not the code the changed, but the table schema: src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql Note that the *check tables have added 'op char(2)' to the table definition. You'll need to update you tables to add this column, and then set that to ':='. -Chris -- \\\|||/// \ Chris Parker-Manager, Development Engineering \ ~ ~ / \ WX *is* Wireless!\ [EMAIL PROTECTED] | @ @ |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Without C we would have 'obol', 'basi', and 'pasal' - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql operator patch
At 08:52 AM 1/10/02 -0600, you wrote: It's not the code the changed, but the table schema: OK. Well, I did find the new schema, and created a new database using that schema. I pointed sql.conf at the new database and got the same results I'd been getting. Note that the *check tables have added 'op char(2)' to the table definition. You'll need to update you tables to add this column, and then set that to ':='. Noted, and yes, I did set the op column to := for the records containing the Auth-Type attribute. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql operator patch
At 10:01 AM 1/10/2002 -0500, Steve Sobol wrote: At 08:52 AM 1/10/02 -0600, you wrote: It's not the code the changed, but the table schema: OK. Well, I did find the new schema, and created a new database using that schema. I pointed sql.conf at the new database and got the same results I'd been getting. Also, the queries in sql conf are updated as well as the table schema. You'll need to make sure the queries are retrieving the 'op' value in the auth query. -Chris -- \\\|||/// \ Chris Parker-Manager, Development Engineering \ ~ ~ / \ WX *is* Wireless!\ [EMAIL PROTECTED] | @ @ |\ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\-- \ Without C we would have 'obol', 'basi', and 'pasal' - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html