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
Re: Mysql error
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
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
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
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
I didn't try lowercase but XAscendSessionSvrKey - varchar(10) works fine :) Pablo Lucchetti wrote: 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 - 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
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 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] 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] 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 - 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
Re: Mysql error
Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti [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
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
Hey Pablo, On Dec 24, 2007 2:59 PM, Pablo Lucchetti [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] 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] 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 - 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
Re: Mysql error
Cool! Let me know how daloRADIUS goes with FreeRADIUS 1.1.7. Regards, Liran. On Dec 24, 2007 8:06 PM, Pablo Lucchetti [EMAIL PROTECTED] wrote: 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql error
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
Re: Mysql error
Maybe this helps: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Norbert Wegener Pablo Lucchetti wrote: 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
Re: Mysql Error Message and Postgresql Question
Ugur GUNCER wrote:
Hi
Im my radius server gives Mysql check_error : 1054 received message after
user authorization procc.
What is it mean
My usergroup table is empty !!!
modcall: entering group authorize
modcall[authorize]: module preprocess returns ok
radius_xlat: 'dark'
rlm_sql (sql): sql_set_user escaped user -- 'dark'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'dark' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = 'dark' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
rlm_sql (sql): Released sql socket id: 4
And my second question is
im exporting detail to mysql
But i want to export detail to postgresql
At same time with mysql
i edit my
Radius.conf . Like this
# Include another file that has the SQL-related configuration.
# This is another file solely because it tends to be big.
#
# The following configuration file is for use with MySQL.
#
# For Postgresql, use: ${confdir}/postgresql.conf
# For MS-SQL, use: ${confdir}/mssql.conf
#
$INCLUDE ${confdir}/sql.conf
The line above should be commented out or removed.
$INCLUDE /usr/local/radiusd/etc/raddb/postgresql.conf
# Write a 'utmp' style log file, of which users are currently
# logged in, and where they've logged in from.
#
And postgresql.conf like this
# Connect info
server = localhost
login = puser
password = ppass
# Database table configuration
radius_db = pdata_db
But in postgres radacct table is empty
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
