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 root@localhost:/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 root@localhost: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
Have you configured sql server connection details in sql.conf? Ivan Kalik Kalik Informatika ISP Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar> 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 root@localhost:/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 root@localhost: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
Yes I've. tnt@kalik.co.yu wrote:
Have you configured sql server connection details in sql.conf?
Ivan Kalik Kalik Informatika ISP
Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar> 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 root@localhost:/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 root@localhost: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
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 <pablo@lnx.org.ar> wrote:
Yes I've.
tnt@kalik.co.yu wrote:
Have you configured sql server connection details in sql.conf?
Ivan Kalik Kalik Informatika ISP
Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar> 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 root@localhost:/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 root@localhost :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
What freeradius version are you using? Ivan Kalik Kalik Informatika ISP Dana 24/12/2007, "ikpirhu last" <meshkruaj@gmail.com> 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 <pablo@lnx.org.ar> wrote:
Yes I've.
tnt@kalik.co.yu wrote:
Have you configured sql server connection details in sql.conf?
Ivan Kalik Kalik Informatika ISP
Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar> 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 root@localhost:/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 root@localhost :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
1.1.7 tnt@kalik.co.yu wrote:
What freeradius version are you using?
Ivan Kalik Kalik Informatika ISP
Dana 24/12/2007, "ikpirhu last" <meshkruaj@gmail.com> 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 <pablo@lnx.org.ar> wrote:
Yes I've.
tnt@kalik.co.yu wrote:
Have you configured sql server connection details in sql.conf?
Ivan Kalik Kalik Informatika ISP
Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar> 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 root@localhost:/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 root@localhost :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
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* <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> wrote:
Yes I've.
tnt@kalik.co.yu <mailto:tnt@kalik.co.yu> wrote: > Have you configured sql server connection details in sql.conf? > > Ivan Kalik > Kalik Informatika ISP > > > Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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 root@localhost:/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 root@localhost: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
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 <pablo@lnx.org.ar> 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* <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> wrote:
Yes I've.
tnt@kalik.co.yu <mailto:tnt@kalik.co.yu> wrote: > Have you configured sql server connection details in sql.conf? > > Ivan Kalik > Kalik Informatika ISP > > > Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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 root@localhost:/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 root@localhost: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
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* <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > 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* <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto: pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> wrote: > > Yes I've. > > tnt@kalik.co.yu <mailto:tnt@kalik.co.yu> <mailto: tnt@kalik.co.yu <mailto:tnt@kalik.co.yu>> wrote: > > Have you configured sql server connection details in sql.conf? > > > > Ivan Kalik > > Kalik Informatika ISP > > > > > > Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> 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 root@localhost:/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 > root@localhost: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
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* <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > 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* <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto: pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> wrote: > > Yes I've. > > tnt@kalik.co.yu <mailto:tnt@kalik.co.yu> <mailto: tnt@kalik.co.yu <mailto:tnt@kalik.co.yu>> wrote: > > Have you configured sql server connection details in sql.conf? > > > > Ivan Kalik > > Kalik Informatika ISP > > > > > > Dana 22/12/2007, "Pablo Lucchetti" <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> 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 root@localhost:/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 > root@localhost: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
Hey Pablo, On Dec 24, 2007 2:10 PM, Pablo Lucchetti <pablo@lnx.org.ar> 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.
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 <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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
Hey Pablo, On Dec 24, 2007 2:27 PM, Pablo Lucchetti <pablo@lnx.org.ar> 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 <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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
Great Liran! Now is working fine Thanks a lot. Regards and Merry Christmas! Pablo liran tal wrote:
Hey Pablo,
On Dec 24, 2007 2:27 PM, Pablo Lucchetti <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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 <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> 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
Hey Pablo, On Dec 24, 2007 2:59 PM, Pablo Lucchetti <pablo@lnx.org.ar> 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 <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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 <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> 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
Freeradius, MySql & Daloradius! ;) liran tal wrote:
Hey Pablo,
On Dec 24, 2007 2:59 PM, Pablo Lucchetti <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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 <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> 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 < pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> > > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>>> 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
Cool! Let me know how daloRADIUS goes with FreeRADIUS 1.1.7. Regards, Liran. On Dec 24, 2007 8:06 PM, Pablo Lucchetti <pablo@lnx.org.ar> wrote:
Freeradius, MySql & Daloradius! ;)
liran tal wrote:
Hey Pablo,
On Dec 24, 2007 2:59 PM, Pablo Lucchetti <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> 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 <pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>> 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 < pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>> > > <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar> <mailto:pablo@lnx.org.ar <mailto:pablo@lnx.org.ar>>>> 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
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 root@localhost:/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 root@localhost: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
participants (5)
-
ikpirhu last -
liran tal -
Norbert Wegener -
Pablo Lucchetti -
tnt@kalik.co.yu