Re: Mysql error
I added column im radacct and all it's Ok, thanks for your help. Pablo Marinko Tarlac wrote: Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2790 (20080114) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mysql error
Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: radius:/usr/local/var/log/radius# tail radius.log -f Mon Jan 14 16:01:37 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Any help please? Thanks in advance, Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I'm using freeradius 2.0.0 on Debian Etch, I think the problem is case sensitivity as you mentioned because in schema.sql is un lower case and in dialup.conf also. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2790 (20080114) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
in lower case really? Marinko Tarlac wrote: Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. [EMAIL PROTECTED] wrote: Hi, Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^ here is the call as part of an UPDATE check case sensitivity alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2790 (20080114) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
1.1.7 [EMAIL PROTECTED] wrote: What freeradius version are you using? Ivan Kalik Kalik Informatika ISP Dana 24/12/2007, ikpirhu last [EMAIL PROTECTED] piše: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, Pablo Lucchetti [EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED] :radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I've las version of Mysql-server and mysql-client. Regards, Pablo ikpirhu last wrote: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Yes I'll do that. Thanks, Pablo ikpirhu last wrote: its not a freeradius Kalik. im 100% sure thats a mysql problem. at the url http://dev.mysql.com/doc/refman/5.0/en/old-client.html http://dev.mysql.com/doc/refman/5.0/en/old-client.html they said that maybe is a library ( dll , so ) problem. maybe you have both of them installed ( mysql4 and 5 ) if its not an production system i suggest to uninstall and reinstall (not upgrade) the mysql server and clients. As always , remember to backup your entire databases. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I've las version of Mysql-server and mysql-client. Regards, Pablo ikpirhu last wrote: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory 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. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Any help? Pablo ikpirhu last wrote: its not a freeradius Kalik. im 100% sure thats a mysql problem. at the url http://dev.mysql.com/doc/refman/5.0/en/old-client.html http://dev.mysql.com/doc/refman/5.0/en/old-client.html they said that maybe is a library ( dll , so ) problem. maybe you have both of them installed ( mysql4 and 5 ) if its not an production system i suggest to uninstall and reinstall (not upgrade) the mysql server and clients. As always , remember to backup your entire databases. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I've las version of Mysql-server and mysql-client. Regards, Pablo ikpirhu last wrote: i remember that Mysql error 'Client does not support authentication was an error of the mysql-client with mysql-server being incompactible with each other i had to upgrade both of them to be error free. try it and tell me. On 24/12/2007, *Pablo Lucchetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Yes I've. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] piše: Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2744 (20071223) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list
Re: Mysql error
Hi Liran! Dist: Debian etch xen version (upgraded) kernel: 2.6.16-xen #1 Freeradius: 1.1.7 Mysql-server and client: 5.0 Libmysqlclient: libmysqlclient15-dev libmysqlclient15off Regards, Pablo liran tal wrote: Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory 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. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Seems like a big mess. Let's begin from the start - what distribution is this? what version of it? Can you paste the versions of the installed mysql packages (libraries, client, and server) please. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
Freeradius, MySql Daloradius! ;) liran tal wrote: Hey Pablo, On Dec 24, 2007 2:59 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Great Liran! Now is working fine Thanks a lot. Sure Pablo, enjoy the holidays and you're new freeradius+mysql installation :-) Regards, Liran Tal. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:27 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Liran! Dist: Debian etch xen version (upgraded) kernel: 2.6.16-xen #1 Freeradius: 1.1.7 Mysql-server and client: 5.0 Libmysqlclient: libmysqlclient15-dev libmysqlclient15off I'm assuming you installed freeradius from source, right? If so, re-compile it as you have mentioned that you upgrade the packages. Regards, Liran. liran tal wrote: Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I did uninstall and install Mysql-server and client, and now I've this error wiht libraries: radius:/usr/local/etc/raddb# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: libmysqlclient_r.so.12: cannot open shared object file: No such file or directory 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. radiusd.conf[117] Unknown module sql. radiusd.conf[114] Failed to parse authorize section. Seems like a big mess. Let's begin from the start - what distribution is this? what version of it? Can you paste the versions of the installed mysql packages (libraries, client, and server) please. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2745 (20071224) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mysql error
Hi, I've an error with mysql, I think is php mysql client. I did upgrade to php5 but the erros remains the same. Mysql is Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id acct_unique: key = User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port Module: Instantiated acct_unique (acct_unique) Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. Any help? Thanks in advance Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Problem with authentication
Hi, I've a Freeradius on a Debian Etch with Mysql but when I'm triying to test with NTRadPing always got the same error. The user already exists in database rad_recv: Access-Request packet from host 192.168.1.109:4027, id=2, length=49 User-Name = test-user User-Password = test-pass rlm_sql (sql): Reserving sql socket id: 4 rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 Sending Access-Reject of id 2 to 192.168.1.109 port 4027 Any help please? Thanks in advance, Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with authentication
mysql SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'test-user' ORDER BY id; ++---+---+---++ | id | UserName | Attribute | Value | op | ++---+---+---++ | 1 | test-user | user-password | test-pass | == | ++---+---+---++ 1 row in set (0.00 sec) It seems to be OK, but looking into sql.conf MySQL listen on localhost only and NTRadping is running on my pc, that's right? Thanks a lot. Pablo CoMeC wrote: Hey, I am not sure, no specialist, but try to make this query in your mysql: SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'test-user' ORDER BY id Make sure, that your mysql server/login/password/database are correct. Take a look how is you password handled... clear-text or what? Maybe that will help you, Best regards, CoMeC On Thu, 13 Dec 2007 16:33:07 -0300, Pablo Lucchetti [EMAIL PROTECTED] wrote: Hi, I've a Freeradius on a Debian Etch with Mysql but when I'm triying to test with NTRadPing always got the same error. The user already exists in database rad_recv: Access-Request packet from host 192.168.1.109:4027, id=2, length=49 User-Name = test-user User-Password = test-pass rlm_sql (sql): Reserving sql socket id: 4 rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 Sending Access-Reject of id 2 to 192.168.1.109 port 4027 Any help please? Thanks in advance, Pablo - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ Información de NOD32, revisión 2721 (20071213) __ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with authentication
gessuttia:~# freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file. Support for this will go away soon.
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
Module: Instantiated acct_unique (acct_unique)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.
sql.conf
sql {
driver = rlm_sql_mysql
server = 127.0.0.1
login = dbuser
password = dbpass
radius_db = radius
acct_table1 = radacct
acct_table2 = radacct
postauth_table = radpostauth
authcheck_table = radcheck
authreply_table = radreply
groupcheck_table = radgroupcheck
groupreply_table = radgroupreply
usergroup_table = usergroup
deletestalesessions = yes
sqltrace = no
sqltracefile = ${logdir}/sqltrace.sql
num_sql_socks = 5
connect_failure_retry_delay = 60
}
radreoply table
mysql select * from radreply;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | Framed-IP-Address | = | 192.168.1.109 |
| 2 | test-user | Framed-IP-Address | = | 0.0.0.0 |
++---+---++---+
2 rows in set (0.00 sec)
[EMAIL PROTECTED] wrote:
Send radiusd -X output. Have you done something to sql.conf apart from
database connection details?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
Hi,
I've a Freeradius on a Debian Etch with Mysql but when I'm triying to
test with NTRadPing always got the same error.
The user already exists in database
rad_recv: Access-Request packet from host 192.168.1.109:4027, id=2,
length=49
User-Name = test-user
User-Password = test-pass
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
Sending Access-Reject of id 2 to 192.168.1.109 port 4027
Any help please?
Thanks in advance,
Pablo
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
__ Información de NOD32, revisión 2721 (20071213) __
Este mensaje ha sido analizado con NOD32 antivirus system
http://www.nod32.com
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with authentication
rad_recv: Access-Request packet from host 192.168.1.109:1601, id=6,
length=49
User-Name = test-user
User-Password = test-pass
rad_lowerpair: User-Name now 'test-user'
rad_lowerpair: User-Password now 'test-pass'
rad_rmspace_pair: User-Name now 'test-user'
rad_rmspace_pair: User-Password now 'test-pass'
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module chap returns noop for request 0
modcall[authorize]: module mschap returns noop for request 0
radius_xlat: ''
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module sql returns fail for request 0
modcall: leaving group authorize (returns fail) for request 0
There was no response configured: rejecting request 0
Server rejecting request 0.
Sending Access-Reject of id 6 to 192.168.1.109 port 1601
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 6 with timestamp 47619d3f
Nothing to do. Sleeping until we see a request.
[EMAIL PROTECTED] wrote:
OK. Capital X == radiusd -X. And send from the point the request is
received - you can skip the server startup.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
gessuttia:~# freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file. Support for this will go away soon.
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
Module: Instantiated acct_unique (acct_unique)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.
sql.conf
sql {
driver = rlm_sql_mysql
server = 127.0.0.1
login = dbuser
password = dbpass
radius_db = radius
acct_table1 = radacct
acct_table2 = radacct
postauth_table = radpostauth
authcheck_table = radcheck
authreply_table = radreply
groupcheck_table = radgroupcheck
groupreply_table = radgroupreply
usergroup_table = usergroup
deletestalesessions = yes
sqltrace = no
sqltracefile = ${logdir}/sqltrace.sql
num_sql_socks = 5
connect_failure_retry_delay = 60
}
radreoply table
mysql select * from radreply;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | Framed-IP-Address | = | 192.168.1.109 |
| 2 | test-user | Framed-IP-Address | = | 0.0.0.0 |
++---+---++---+
2 rows in set (0.00 sec)
[EMAIL PROTECTED] wrote:
Send radiusd -X output. Have you done something to sql.conf apart from
database connection details?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
Hi,
I've a Freeradius on a Debian Etch with Mysql but when I'm triying to
test with NTRadPing always got the same error.
The user already exists in database
rad_recv: Access-Request packet from host 192.168.1.109:4027, id=2,
length=49
User-Name = test-user
User-Password = test-pass
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
Sending Access-Reject of id 2 to 192.168.1.109 port 4027
Any help please?
Thanks in advance,
Pablo
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/usershtml
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
__ Información de NOD32, revisión 2721
Re: Problem with authentication
I tuned On sqltrace but nothing occurs :(
mysql select * from radreply;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | Framed-IP-Address | = | 192.168.1.109 |
| 2 | test-user | Framed-IP-Address | = | 0.0.0.0 |
++---+---++---+
2 rows in set (0.00 sec)
mysql select * from radcheck;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | user-password | == | test-pass |
++---+---++---+
1 row in set (0.00 sec)
[EMAIL PROTECTED] wrote:
Switch on sqltrace in sql.conf and see what happened with the queries.
You do have a password for this user in radcheck table? You have posted
just radreply table.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
rad_recv: Access-Request packet from host 192.168.1.109:1601, id=6,
length=49
User-Name = test-user
User-Password = test-pass
rad_lowerpair: User-Name now 'test-user'
rad_lowerpair: User-Password now 'test-pass'
rad_rmspace_pair: User-Name now 'test-user'
rad_rmspace_pair: User-Password now 'test-pass'
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module chap returns noop for request 0
modcall[authorize]: module mschap returns noop for request 0
radius_xlat: ''
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module sql returns fail for request 0
modcall: leaving group authorize (returns fail) for request 0
There was no response configured: rejecting request 0
Server rejecting request 0.
Sending Access-Reject of id 6 to 192.168.1.109 port 1601
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 6 with timestamp 47619d3f
Nothing to do. Sleeping until we see a request.
[EMAIL PROTECTED] wrote:
OK. Capital X == radiusd -X. And send from the point the request is
received - you can skip the server startup.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
gessuttia:~# freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file. Support for this will go away soon.
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
Module: Instantiated acct_unique (acct_unique)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.
sql.conf
sql {
driver = rlm_sql_mysql
server = 127.0.0.1
login = dbuser
password = dbpass
radius_db = radius
acct_table1 = radacct
acct_table2 = radacct
postauth_table = radpostauth
authcheck_table = radcheck
authreply_table = radreply
groupcheck_table = radgroupcheck
groupreply_table = radgroupreply
usergroup_table = usergroup
deletestalesessions = yes
sqltrace = no
sqltracefile = ${logdir}/sqltrace.sql
num_sql_socks = 5
connect_failure_retry_delay = 60
}
radreoply table
mysql select * from radreply;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | Framed-IP-Address | = | 192.168.1.109 |
| 2 | test-user | Framed-IP-Address | = | 0.0.0.0
Re: Problem with authentication
gessuttia:/etc/freeradius# vim sql.conf
sql {
driver = rlm_sql_mysql
server = 127.0.0.1
login = dbuser
password = dbpass
radius_db = radius
acct_table1 = radacct
acct_table2 = radacct
postauth_table = radpostauth
authcheck_table = radcheck
authreply_table = radreply
groupcheck_table = radgroupcheck
groupreply_table = radgroupreply
usergroup_table = usergroup
deletestalesessions = yes
sqltrace = yes
sqltracefile = ${logdir}/sqltrace.sql
num_sql_socks = 5
connect_failure_retry_delay = 60
}
~
[EMAIL PROTECTED] wrote:
sqltrace = yes?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
I tuned On sqltrace but nothing occurs :(
mysql select * from radreply;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | Framed-IP-Address | = | 192.168.1.109 |
| 2 | test-user | Framed-IP-Address | = | 0.0.0.0 |
++---+---++---+
2 rows in set (0.00 sec)
mysql select * from radcheck;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | user-password | == | test-pass |
++---+---++---+
1 row in set (0.00 sec)
[EMAIL PROTECTED] wrote:
Switch on sqltrace in sql.conf and see what happened with the queries.
You do have a password for this user in radcheck table? You have posted
just radreply table.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
rad_recv: Access-Request packet from host 192.168.1.109:1601, id=6,
length=49
User-Name = test-user
User-Password = test-pass
rad_lowerpair: User-Name now 'test-user'
rad_lowerpair: User-Password now 'test-pass'
rad_rmspace_pair: User-Name now 'test-user'
rad_rmspace_pair: User-Password now 'test-pass'
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module chap returns noop for request 0
modcall[authorize]: module mschap returns noop for request 0
radius_xlat: ''
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module sql returns fail for request 0
modcall: leaving group authorize (returns fail) for request 0
There was no response configured: rejecting request 0
Server rejecting request 0.
Sending Access-Reject of id 6 to 192.168.1.109 port 1601
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 6 with timestamp 47619d3f
Nothing to do. Sleeping until we see a request.
[EMAIL PROTECTED] wrote:
OK. Capital X == radiusd -X. And send from the point the request is
received - you can skip the server startup.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
gessuttia:~# freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file. Support for this will go away soon.
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
Module: Instantiated acct_unique (acct_unique)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.
sql.conf
sql {
driver = rlm_sql_mysql
server = 127.0.0.1
login = dbuser
password = dbpass
radius_db = radius
acct_table1 = radacct
Re: Problem with authentication
That's all Ivan.
[EMAIL PROTECTED] wrote:
Is that the whole sql.conf? Where are the queries?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
gessuttia:/etc/freeradius# vim sql.conf
sql {
driver = rlm_sql_mysql
server = 127.0.0.1
login = dbuser
password = dbpass
radius_db = radius
acct_table1 = radacct
acct_table2 = radacct
postauth_table = radpostauth
authcheck_table = radcheck
authreply_table = radreply
groupcheck_table = radgroupcheck
groupreply_table = radgroupreply
usergroup_table = usergroup
deletestalesessions = yes
sqltrace = yes
sqltracefile = ${logdir}/sqltrace.sql
num_sql_socks = 5
connect_failure_retry_delay = 60
}
~
[EMAIL PROTECTED] wrote:
sqltrace = yes?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
I tuned On sqltrace but nothing occurs :(
mysql select * from radreply;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | Framed-IP-Address | = | 192.168.1.109 |
| 2 | test-user | Framed-IP-Address | = | 0.0.0.0 |
++---+---++---+
2 rows in set (0.00 sec)
mysql select * from radcheck;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | user-password | == | test-pass |
++---+---++---+
1 row in set (0.00 sec)
[EMAIL PROTECTED] wrote:
Switch on sqltrace in sql.conf and see what happened with the queries.
You do have a password for this user in radcheck table? You have posted
just radreply table.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
rad_recv: Access-Request packet from host 192.168.1.109:1601, id=6,
length=49
User-Name = test-user
User-Password = test-pass
rad_lowerpair: User-Name now 'test-user'
rad_lowerpair: User-Password now 'test-pass'
rad_rmspace_pair: User-Name now 'test-user'
rad_rmspace_pair: User-Password now 'test-pass'
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module chap returns noop for request 0
modcall[authorize]: module mschap returns noop for request 0
radius_xlat: ''
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module sql returns fail for request 0
modcall: leaving group authorize (returns fail) for request 0
There was no response configured: rejecting request 0
Server rejecting request 0.
Sending Access-Reject of id 6 to 192.168.1.109 port 1601
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 6 with timestamp 47619d3f
Nothing to do. Sleeping until we see a request.
[EMAIL PROTECTED] wrote:
OK. Capital X == radiusd -X. And send from the point the request is
received - you can skip the server startup.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
gessuttia:~# freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file. Support for this will go away soon.
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
Module: Instantiated acct_unique (acct_unique)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Ready
Re: Problem with authentication
Thanks a lot Ivan! Now is working fine.
Cheers,
Pablo
[EMAIL PROTECTED] wrote:
No. This is how default sql.conf looks like:
http://www.freeradius.org/radiusd/raddb/sql.conf
You have deleted all that makes this module function.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
That's all Ivan.
[EMAIL PROTECTED] wrote:
Is that the whole sql.conf? Where are the queries?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
gessuttia:/etc/freeradius# vim sql.conf
sql {
driver = rlm_sql_mysql
server = 127.0.0.1
login = dbuser
password = dbpass
radius_db = radius
acct_table1 = radacct
acct_table2 = radacct
postauth_table = radpostauth
authcheck_table = radcheck
authreply_table = radreply
groupcheck_table = radgroupcheck
groupreply_table = radgroupreply
usergroup_table = usergroup
deletestalesessions = yes
sqltrace = yes
sqltracefile = ${logdir}/sqltrace.sql
num_sql_socks = 5
connect_failure_retry_delay = 60
}
~
[EMAIL PROTECTED] wrote:
sqltrace = yes?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
I tuned On sqltrace but nothing occurs :(
mysql select * from radreply;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | Framed-IP-Address | = | 192.168.1.109 |
| 2 | test-user | Framed-IP-Address | = | 0.0.0.0 |
++---+---++---+
2 rows in set (0.00 sec)
mysql select * from radcheck;
++---+---++---+
| id | UserName | Attribute | op | Value |
++---+---++---+
| 1 | test-user | user-password | == | test-pass |
++---+---++---+
1 row in set (0.00 sec)
[EMAIL PROTECTED] wrote:
Switch on sqltrace in sql.conf and see what happened with the queries.
You do have a password for this user in radcheck table? You have posted
just radreply table.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
rad_recv: Access-Request packet from host 192.168.1.109:1601, id=6,
length=49
User-Name = test-user
User-Password = test-pass
rad_lowerpair: User-Name now 'test-user'
rad_lowerpair: User-Password now 'test-pass'
rad_rmspace_pair: User-Name now 'test-user'
rad_rmspace_pair: User-Password now 'test-pass'
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module chap returns noop for request 0
modcall[authorize]: module mschap returns noop for request 0
radius_xlat: ''
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module sql returns fail for request 0
modcall: leaving group authorize (returns fail) for request 0
There was no response configured: rejecting request 0
Server rejecting request 0.
Sending Access-Reject of id 6 to 192.168.1.109 port 1601
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 6 with timestamp 47619d3f
Nothing to do. Sleeping until we see a request.
[EMAIL PROTECTED] wrote:
OK. Capital X == radiusd -X. And send from the point the request is
received - you can skip the server startup.
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, Pablo Lucchetti [EMAIL PROTECTED] piše:
gessuttia:~# freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file. Support for this will go away soon.
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: Starting connect to MySQL server for #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: Starting connect to MySQL server for #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: Starting connect to MySQL server for #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect
