Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Iftakhul Anwar
HI All, I just recompile my freeadius with specific directory library.I use command : ./configure --with-mysql-lib-dir=/usr/lib/mysql --with-ldap-lib-dir=/usr/lib/ldap Now ldap and mysql running well :D Thanks all On Fri, Mar 8, 2013 at 3:41 PM, Alan Buxey wrote: > As Fajar says, some dist

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Alan Buxey
As Fajar says, some distros split up the functions into separate packages (so you don't need to install loads of things just to have a basic server) use your package manager to find/install the sub packages alan -- This smartphone uses free WiFi around the world with eduroam, now that's what I

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Fajar A. Nugraha
If you install using packages, it's usually contained on separate packages. For example: http://packages.ubuntu.com/search?suite=quantal&keywords=freeradius i.e. freeradius-mysql, freeradius-ldap. -- Fajar On Fri, Mar 8, 2013 at 7:02 PM, Iftakhul Anwar wrote: > I've installed mysql-server on

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Muhammad Nadeem
Ok man.. set LD_LIBRARY_PATH to your mysql drivers,, like for oracle it will be SET PATH=LD_LIBRARY_PATH=$ORACLE_HOME/lib On Fri, Mar 8, 2013 at 1:02 PM, Iftakhul Anwar wrote: > I've installed mysql-server on my system even before i installed > freeradius server. > > Any another tips to solve t

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Iftakhul Anwar
I've installed mysql-server on my system even before i installed freeradius server. Any another tips to solve this ? On Fri, Mar 8, 2013 at 2:59 PM, Muhammad Nadeem wrote: > Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: > rlm_sql_mysql.so: cannot open shared object file:

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Muhammad Nadeem
Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory >>It seems that your mysql drivers have not been installed successfully, thanks to freeradius, it has the option to install mysql server along free radi

Freeradius with either LDAP or Mysql Error lib not found

2013-03-07 Thread Iftakhul Anwar
Hi All I just try to config freeradius using either Mysql or LDAP. But i get same error like bellow : [errror Mysq] Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Fri Mar 8 13:44:46 2013 : Error

Re: error message connection to MySQL. (Error Message :rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0)

2010-04-28 Thread John Dennis
You very helpfully deleted all the interesting information from the debug log (please always post the full log). But you can do this yourself. Take a look at sql initialization section and see what it's saying about initializing the sql driver, in this case it should be rlm_sql_mysql, that shou

error message connection to MySQL. (Error Message :rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0)

2010-04-28 Thread bslee (HKBU)
Hi, I try to authenticate freeradius 2.1.8 using mysql5.0.26. Information of my system: 1. OS is SuSE Linux SLES10 SP2. 2. I have installed following RPM for FreeRadius 2.1.8: #rpm -qa |grep freeradius freeradius-server-utils-2.1.8-1.1 freeradius-client-libs-1.1.6-4.1 freeradius-server-2.1.8-1

freeradius doesn't start at boot-time : mysql error

2008-02-07 Thread mailinglists
erver [EMAIL PROTECTED]:radius Wed Feb 6 16:17:49 2008 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.1.1' (113)' Wed Feb 6 16:17:49 2008 : Error: rlm_sql (sql): Failed to connect DB handle #0 Wed Feb 6 16:17:49 2008 : Info: rlm_sql (sql):

Re: Mysql error

2008-01-15 Thread Pablo Lucchetti
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

Re: Mysql error

2008-01-14 Thread Marinko Tarlac
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.

Re: Mysql error

2008-01-14 Thread Pablo Lucchetti
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

Re: Mysql error

2008-01-14 Thread Marinko Tarlac
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

Re: Mysql error

2008-01-14 Thread Pablo Lucchetti
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 wit

Re: Mysql error

2008-01-14 Thread A . L . M . Buxey
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 versi

Mysql error

2008-01-14 Thread Pablo Lucchetti
an 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

Re: Mysql error

2007-12-24 Thread liran tal
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] > >

Re: Mysql error

2007-12-24 Thread Pablo Lucchetti
Freeradius, MySql & Daloradius! ;) liran tal wrote: 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 install

Re: Mysql error

2007-12-24 Thread liran tal
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, 2

Re: Mysql error

2007-12-24 Thread Pablo Lucchetti
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 <[EMAIL PROTECTED] > wrote: Hi Liran! Dist: Debian etch xen version (upgraded) kernel: 2.6.16-xe

Re: Mysql error

2007-12-24 Thread liran tal
Hey Pablo, On Dec 24, 2007 2:27 PM, Pablo Lucchetti <[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 insta

Re: Mysql error

2007-12-24 Thread Pablo Lucchetti
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]

Re: Mysql error

2007-12-24 Thread liran tal
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 fil

Re: Mysql error

2007-12-24 Thread Pablo Lucchetti
ysql-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 >

Re: Mysql error

2007-12-24 Thread Pablo Lucchetti
CTED] <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

Re: Mysql error

2007-12-24 Thread ikpirhu last
rhu 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 er

Re: Mysql error

2007-12-24 Thread Pablo Lucchetti
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 t

Re: Mysql error

2007-12-24 Thread Pablo Lucchetti
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

Re: Mysql error

2007-12-24 Thread tnt
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-ser

Re: Mysql error

2007-12-24 Thread ikpirhu last
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]>

Re: Mysql error

2007-12-23 Thread Pablo Lucchetti
m_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

Re: Mysql error

2007-12-23 Thread Norbert Wegener
or #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): sta

Re: Mysql error

2007-12-23 Thread tnt
;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 s

Mysql error

2007-12-22 Thread Pablo Lucchetti
(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 '

Error: rlm_sql_mysql: MYSQL Error

2006-07-07 Thread jayesh
database. Now I kept the SIPp at rate of 45 calls per second, but after say 10 to 15 minutes the radius server dies. This is the message I could see in the log:   rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0   Error: rlm_sql_mysql: MYSQL Error: Cannot get resultFri Jul

MYSQL error 1312

2006-06-12 Thread vignesh
Hello all I am trying to use MySQL 5.0.19 Stored Procedure with Free Radius 1.1. This is my Procedure DELIMITER $$ DROP PROCEDURE IF EXISTS `radius`.`auth`$$ CREATE PROCEDURE `auth`(user1 varchar(100)) BEGIN SELECT id, UserName, Attribute, Value, op FROM radius.radcheck WHERE Username =user1 ORD

RE: Freeradius+mysql+error

2005-06-01 Thread Rupak
Thank you I just finished it successfully. Actually the problem was with the sql server.Now I am defining the attribute " Max-All-Session" in seconds. That means I am defining time limitations. [Prepaid].But what I want is that I will make a user and it can surf unlimited.But the total time shoul

RE: Freeradius+mysql+error

2005-06-01 Thread Abdul Lateef
Hello, Check your sql configuration in sql.conf in the following area # Connect info server = "yousqlip" login = "user" password = "pws" Abdul Lateef Kapilvastu Lumbini __ Discover Yahoo! Find restaurants, movies, tra

Re: Freeradius+mysql+error

2005-06-01 Thread Chris Knipe
On Wed, Jun 01, 2005 at 07:07:02AM +0545, [EMAIL PROTECTED] wrote: > radius.But when i start radius in debugging mode then i find the following > errors.What can be the error. > rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL > PROTECTED]:radius > rlm_sq

Freeradius+mysql+error

2005-06-01 Thread rupak
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 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' rlm_sql (s

RE: Freeradius+mysql error

2005-05-31 Thread Rupak
I checked bu there is no "mysqld.sock" in /var/run/mysqld. May be because my sql is not started. Because it gives back an error telling that " mysqld dead but subsys locked Rupak Rupak wrote: >Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the >file and found that the valu

Re: Freeradius+mysql error

2005-05-31 Thread Sebastian Wild
Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = "root" Password = "password".But I don't know how to configure mysql.Does any one hav

Re: Freeradius+mysql error

2005-05-31 Thread Sebastian Wild
Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = "root" Password = "password".But I don't know how to configure mysql.Does any one hav

Re: Freeradius+mysql error

2005-05-31 Thread Kamran Bukhari
U dont have to change anything to my.cnf as when u install the new rpm, the cnf file will be automatically adjusted. After succesful installation, run the mysql client. After the successful running, do some changes to sql.conf in raddb as u wish. for tutorial , try mysql website as they got good ma

RE: Freeradius+mysql error

2005-05-31 Thread Rupak
Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = "root" Password = "password".But I don't know how to configure mysql.Does any one have a link to a go

Re: Freeradius+mysql error

2005-05-31 Thread A . L . M . Buxey
Hi, > Thank you for the reply I think I have compiled free radius with mysql > support because I had installed it --with-experimental-modules.Now if I > start the sql server by giving the command "mysql -u root -p rootpass radius > < db_mysql.sql" then it returns me with the following error > > E

RE: Freeradius+mysql error

2005-05-31 Thread Rupak
Well I have installed the following things of my sql.The things are the following. rpm -q mysql--it is installed rpm -q mysql-server--it is installed rpm -q mysql-devel---it is installed. These packages were installed from redhat9.But when I start the service Service mysqld start/status it says

Re: Freeradius+mysql error

2005-05-31 Thread Kamran Bukhari
Try installing the Mysql rpm separately and then check wether ur MySQL is running correctly or not. Try this tweak,hope it will clear the mess. On 6/1/05, Rupak <[EMAIL PROTECTED]> wrote: > > Thank you for the reply I think I have compiled free radius with mysql > support because I had installed

RE: Freeradius+mysql error

2005-05-31 Thread Rupak
Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command "mysql -u root -p rootpass radius < db_mysql.sql" then it returns me with the following error Error 2002: can't

Re: Freeradius+mysql error

2005-05-30 Thread Kamran Bukhari
Hello Download MYSQL with all its libraries e.g. i got MySQL 4.11. You are missing with libraries, thats y this message is prompting U. after downloading the libraries, Use following command rpm -Uvh --nodeps MySQL-server-... .rpm (use ur server version at ...) rpm -Uvh MySQL-share.rpm (use t

Re: Freeradius+mysql error

2005-05-30 Thread Chris Knipe
On Mon, May 30, 2005 at 04:23:24PM -0700, Rupak wrote: > rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found > rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the > search path of your system's ld. > radiusd.conf[14]: sql: Module instantiation failed. Compile f

Freeradius+mysql error

2005-05-30 Thread Rupak
  I configured freeradius it was working well.Now I wanted to make it work with my sql.My distro is redhat9 and I am using the version mysql-3.23.54a-11.rpm.Free radius was working and authenticating user.But after configuring the files to make it work with sql it is not working well.It ga

Re: Mysql Error Message and Postgresql Question

2004-03-22 Thread Guy Fraser
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 (sq

Mysql Error Message and Postgresql Question

2004-03-19 Thread Ugur GUNCER
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 es