Re: FreeRadius with MySQL
"Leandro Sant'ana" <[EMAIL PROTECTED]> wrote: > I commented that's lines in file /etc/raddb/users ... > #DEFAULT Auth-Type =3D System > #Fall-Through =3D 1 > > To force Auth-Type in databases No. Uncommenting that line means you forced it to NOT use System authentication. But you didn't tell it what OTHER authentication method to use, so the server failed. > modcall: group authorize returns ok for request 0 > auth: No authenticate method (Auth-Type) configuration found for the > request: Rejecting the user Did you try setting an Auth-Type somewhere? What part of the error message is unclear? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius with MySQL
Please read the FAQ before posting again. Turn off your Graphic and html. Leandro Sant'ana wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRadius with MySQL
Leandro, See to it you included sql in authorization and accounting. Another helpful information ... http://www.frontios.com/freeradius.html = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRadius with MySQL
Title: Untitled Document Hi! Don't know why but when i try to authentication an user using database don't work. I commented that's lines in file /etc/raddb/users # First setup all accounts to be checked against the UNIX /etc/passwd.# (Unless a password was already given earlier in this file).##DEFAULT Auth-Type = System# Fall-Through = 1 To force Auth-Type in databases and give this error: rad_recv: Access-Request packet from host 192.168.0.60:32799, id=228, length=61 User-Name = "aferreira" User-Password = "stag" NAS-IP-Address = 255.255.255.255 NAS-Port = 0modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0radius_xlat: '/var/log/radius/radacct/192.168.0.60/auth-detail-20031210'rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/radius/radacct/192.168.0.60/auth-detail-20031210 modcall[authorize]: module "auth_log" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 modcall[authorize]: module "eap" returns noop for request 0 rlm_realm: No '@' in User-Name = "aferreira", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 0 modcall[authorize]: module "files" returns notfound for request 0 modcall[authorize]: module "mschap" returns noop for request 0modcall: group authorize returns ok for request 0auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the userauth: Failed to validate the user.Delaying request 0 for 1 seconds Anybody know what de happend? Leandro Sant'anaMeu Provedor Tecnologias e Informática Ltda.Rua Camerino, 128 Grs. 302Centro - Rio de Janeiro - RJ - CEP 20080-010Tel.: 55 21 25181011 (PABX/FAX)Telefone Móvel - Celular: 55 21 8844-2645 <>
Re: Cisco Aironet MAC Auth to FreeRadius with mysql backend
Hi David. Did you manage to make it work? On Thu, 18 Sep 2003 11:05:36 -0700 "David Chait" <[EMAIL PROTECTED]> wrote: > Greetings, > I have managed to get this most of the way configured on my own, however > the lack of docs has lead to me a dead end. I cannot seem to get the Aironet > to do an Auth request, only an Accounting request. Cisco isn't much help > unfortunately so I will post my config below as well as the debug responses, > hopefully someone can find my mistake. Ideally I would like to create a DB > of allowable MAC addresses via mysql and have the AP's refference that, > denying all requests not on that list. > > Thanks, > David > > [EMAIL PROTECTED] sbin]# ./radiusd -X > Starting - reading configuration files ... > reread_config: reading radiusd.conf > Config: including file: /usr/local/etc/raddb/proxy.conf > Config: including file: /usr/local/etc/raddb/clients.conf > Config: including file: /usr/local/etc/raddb/snmp.conf > Config: including file: /usr/local/etc/raddb/sql.conf > main: prefix = "/usr/local" > main: localstatedir = "/usr/local/var" > main: logdir = "/usr/local/var/log/radius" > main: libdir = "/usr/local/lib" > main: radacctdir = "/usr/local/var/log/radius/radacct" > main: hostname_lookups = no > main: max_request_time = 30 > main: cleanup_delay = 5 > main: max_requests = 1024 > main: delete_blocked_requests = 0 > main: port = 0 > main: allow_core_dumps = no > main: log_stripped_names = no > main: log_file = "/usr/local/var/log/radius/radius.log" > main: log_auth = no > main: log_auth_badpass = no > main: log_auth_goodpass = no > main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" > main: user = "(null)" > main: group = "(null)" > main: usercollide = no > main: lower_user = "no" > main: lower_pass = "no" > main: nospace_user = "no" > main: nospace_pass = "no" > main: checkrad = "/usr/local/sbin/checkrad" > main: proxy_requests = yes > proxy: retry_delay = 5 > proxy: retry_count = 3 > proxy: synchronous = no > proxy: default_fallback = yes > proxy: dead_time = 120 > proxy: post_proxy_authorize = yes > proxy: wake_all_if_all_dead = no > security: max_attributes = 200 > security: reject_delay = 1 > security: status_server = no > main: debug_level = 0 > read_config_files: reading dictionary > read_config_files: reading naslist > Using deprecated naslist file. Support for this will go away soon. > read_config_files: reading clients > Using deprecated clients file. Support for this will go away soon. > read_config_files: reading realms > Using deprecated realms file. Support for this will go away soon. > radiusd: entering modules setup > Module: Library search path is /usr/local/lib > Module: Loaded expr > Module: Instantiated expr (expr) > Module: Loaded PAP > pap: encryption_scheme = "crypt" > Module: Instantiated pap (pap) > Module: Loaded CHAP > Module: Instantiated chap (chap) > Module: Loaded MS-CHAP > mschap: use_mppe = yes > mschap: require_encryption = no > mschap: require_strong = no > mschap: passwd = "(null)" > mschap: authtype = "MS-CHAP" > Module: Instantiated mschap (mschap) > Module: Loaded eap > eap: default_eap_type = "md5" > eap: timer_expire = 60 > rlm_eap: Loaded and initialized the type md5 > rlm_eap: Loaded and initialized the type leap > Module: Instantiated eap (eap) > Module: Loaded preprocess > preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups" > preprocess: hints = "/usr/local/etc/raddb/hints" > preprocess: with_ascend_hack = no > preprocess: ascend_channels_per_line = 23 > preprocess: with_ntdomain_hack = no > preprocess: with_specialix_jetstream_hack = no > preprocess: with_cisco_vsa_hack = no > Module: Instantiated preprocess (preprocess) > Module: Loaded realm > realm: format = "suffix" > realm: delimiter = "@" > Module: Instantiated realm (suffix) > Module: Loaded SQL > sql: driver = "rlm_sql_mysql" > sql: server = "localhost" > sql: port = "" > sql: login = "root" > sql: password = "" > sql: radius_db = "radius" > sql: acct_table = "radacct" > sql: acct_table2 = "radacct" > sql: authcheck_table = "radcheck" > sql: authreply_table = "radreply" > sql: groupcheck_table = "radgroupcheck" > sql: groupreply_table = "radgroupreply" > sql: usergroup_table = "usergroup" > sql: nas_table = "nas" > sql: dict_table = "dictionary" > sql: sqltrace = no > sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql" > sql: deletestalesessions = yes > sql: num_sql_socks = 5 > sql: sql_user_name = "%{User-Name}" > sql: default_user_profile = "" > sql: query_on_not_found = no > sql: authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM > radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id" > sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM > radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id" > sql: authorize_group_check_query = "SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute
Cisco Aironet MAC Auth to FreeRadius with mysql backend
Greetings, I have managed to get this most of the way configured on my own, however the lack of docs has lead to me a dead end. I cannot seem to get the Aironet to do an Auth request, only an Accounting request. Cisco isn't much help unfortunately so I will post my config below as well as the debug responses, hopefully someone can find my mistake. Ideally I would like to create a DB of allowable MAC addresses via mysql and have the AP's refference that, denying all requests not on that list. Thanks, David [EMAIL PROTECTED] sbin]# ./radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = "/usr/local" main: localstatedir = "/usr/local/var" main: logdir = "/usr/local/var/log/radius" main: libdir = "/usr/local/lib" main: radacctdir = "/usr/local/var/log/radius/radacct" main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/usr/local/var/log/radius/radius.log" main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" main: user = "(null)" main: group = "(null)" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/local/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = yes proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients Using deprecated clients file. Support for this will go away soon. read_config_files: reading realms Using deprecated realms file. Support for this will go away soon. radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = "crypt" Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: passwd = "(null)" mschap: authtype = "MS-CHAP" Module: Instantiated mschap (mschap) Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 rlm_eap: Loaded and initialized the type md5 rlm_eap: Loaded and initialized the type leap Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups" preprocess: hints = "/usr/local/etc/raddb/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" Module: Instantiated realm (suffix) Module: Loaded SQL sql: driver = "rlm_sql_mysql" sql: server = "localhost" sql: port = "" sql: login = "root" sql: password = "" sql: radius_db = "radius" sql: acct_table = "radacct" sql: acct_table2 = "radacct" sql: authcheck_table = "radcheck" sql: authreply_table = "radreply" sql: groupcheck_table = "radgroupcheck" sql: groupreply_table = "radgroupreply" sql: usergroup_table = "usergroup" sql: nas_table = "nas" sql: dict_table = "dictionary" sql: sqltrace = no sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql" sql: deletestalesessions = yes sql: num_sql_socks = 5 sql: sql_user_name = "%{User-Name}" sql: default_user_profile = "" sql: query_on_not_found = no sql: authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id" sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id" sql: authorize_group_check_query = "SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id" sql: authorize_group_reply_query = "SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE use
Re: FreeRadius with Mysql under Solaris can't work
Thanks again. I have check the Makefile in rlm_sql_mysql directory. It says: TARGET = rlm_sql_mysql SRCS = sql_mysql.c And rlm_sql_mysql.a & rlm_sql_mysql.la are both generated. So I think it's not my fault to configure the project. >Hi Zasp, > > Yes. When you do make, there are no error were report, but look= > through the information, you will find make do nothing with= > rlm_sql_mysql. And the TARGET entry in Makefile in the= > correspond directory is empty. If your configure find the head= > file and shared library, this entry will be filled with= > "rlm_sql_mysql". > > Please check it. >=09 > > Jeson >[EMAIL PROTECTED] >=A1=A12003-06-05 > >>If I remember correctly the development package for MySQL that= > comes from sunfreeware puts the files in the wrong location for= > freeradius to look for them. You can specify the location of= > the files or you can download the source and install from that.= > Solaris 8 and 9 fixed the location problem without having ro= > specify. >> >>Gene Parks >>VIP Direct >> >>-Original Message----- >>From: [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, June 04, 2003 8:49 AM >>To: [EMAIL PROTECTED] >>Subject: Re: FreeRadius with Mysql under Solaris can't work >> >> >>Thanks to Jeson. >> >>The MYSQL package is downloaded from sunfreeware and installed= > directly by pkgadd command. I am sure there are development= > header and lib included. Files in the lib directory are as= > follows: >>=09=09libdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.a >>=09=09libmystrings.a libmysys.a >> >>By the way, I had ever compiled and installed mysql 3.23.52 from= > source package. >> >>When I do install freeradius with configure, make and make= > install, there is no error reported. So I don't think it's the= > reason. >> >>Am I right? >> >>Best, >>=09Zasp >> >>>Hi, >>> >>> Please make sure you have the MySQL development package,= > FreeRADIUS >>> compile the rlm_sql_mysql module need the include >file from= > MySQL >>> development package. >>> >>> Enjoy it!=09 >>> >>> =1B$B!!=1B(J =1B$B!!=1B(JJeson >>> >>> >>>>Hi,all >>>>=09I want to use freeradius with mysql support under Solaris= > sparc 2.7. >>>>I meet the same >>>>problem as many newbies when I start radiusd: >>>> >>>>=09rlm_sql (sql): Could not link driver rlm_sql_mysql: file not= > found >>>>=09rlm_sql (sql): Make sure it (and all its dependent= > libraries!) are in the search path of your system's ld. >>>>=09radiusd.conf[14]: sql: Module instantiation failed. >>>> >>>>=09All methods have been tried but failed. MySQL is working= > well.=3D I >>>>try to compile freeradius under gcc 3.2.3 as FAQ says= > "configure >>>>--disable-shared", or set proper LD_LIBRARY_PATH variable, or= > copy >>>>the dynamic lib files to /usr/lib. But the problem keeps= > here. >>>> >>>>=09When I do use rlm_unix not rlm_sql_mysql for authentication,= > it works >>>>well. >>>> I have been confused for several days. Maybe anyone can help= > me? Thanks :) >> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Re: FreeRadius with Mysql under Solaris can't work
Hi Zasp, Do you get the rlm_sql_mysql.so? If not, please recompile your freeRadius project with "configure --enable-static". By default, freeRadius use the shared library. Or, you can try to use the environment variable "LD_PRELOAD=/path/your/rlm_sql_mysql". Jeson [EMAIL PROTECTED] 2003-06-06 >Thanks again. >I have check the Makefile in rlm_sql_mysql directory. It says: > TARGET = rlm_sql_mysql > SRCS = sql_mysql.c >And rlm_sql_mysql.a & rlm_sql_mysql.la are both generated. > >So I think it's not my fault to configure the project. > >>Hi Zasp, >> >> Yes. When you do make, there are no error were report, but look= >> through the information, you will find make do nothing with= >> rlm_sql_mysql. And the TARGET entry in Makefile in the= >> correspond directory is empty. If your configure find the head= >> file and shared library, this entry will be filled with= >> "rlm_sql_mysql". >> >> Please check it. >>=09 >> >> Jeson >>[EMAIL PROTECTED] >>=A1=A12003-06-05 >> >>>If I remember correctly the development package for MySQL that= >> comes from sunfreeware puts the files in the wrong location for= >> freeradius to look for them. You can specify the location of= >> the files or you can download the source and install from that.= >> Solaris 8 and 9 fixed the location problem without having ro= >> specify. >>> >>>Gene Parks >>>VIP Direct >>> >>>-Original Message- >>>From: [mailto:[EMAIL PROTECTED] >>>Sent: Wednesday, June 04, 2003 8:49 AM >>>To: [EMAIL PROTECTED] >>>Subject: Re: FreeRadius with Mysql under Solaris can't work >>> >>> >>>Thanks to Jeson. >>> >>>The MYSQL package is downloaded from sunfreeware and installed= >> directly by pkgadd command. I am sure there are development= >> header and lib included. Files in the lib directory are as= >> follows: >>>=09=09libdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.a >>>=09=09libmystrings.a libmysys.a >>> >>>By the way, I had ever compiled and installed mysql 3.23.52 from= >> source package. >>> >>>When I do install freeradius with configure, make and make= >> install, there is no error reported. So I don't think it's the= >> reason. >>> >>>Am I right? >>> >>>Best, >>>=09Zasp >>> >>>>Hi, >>>> >>>> Please make sure you have the MySQL development package,= >> FreeRADIUS >>>> compile the rlm_sql_mysql module need the include >file from= >> MySQL >>>> development package. >>>> >>>> Enjoy it!=09 >>>> >>>> =1B$B!!=1B(J =1B$B!!=1B(JJeson >>>> >>>> >>>>>Hi,all >>>>>=09I want to use freeradius with mysql support under Solaris= >> sparc 2.7. >>>>>I meet the same >>>>>problem as many newbies when I start radiusd: >>>>> >>>>>=09rlm_sql (sql): Could not link driver rlm_sql_mysql: file not= >> found >>>>>=09rlm_sql (sql): Make sure it (and all its dependent= >> libraries!) are in the search path of your system's ld. >>>>>=09radiusd.conf[14]: sql: Module instantiation failed. >>>>> >>>>>=09All methods have been tried but failed. MySQL is working= >> well.=3D I >>>>>try to compile freeradius under gcc 3.2.3 as FAQ says= >> "configure >>>>>--disable-shared", or set proper LD_LIBRARY_PATH variable, or= >> copy >>>>>the dynamic lib files to /usr/lib. But the problem keeps= >> here. >>>>> >>>>>=09When I do use rlm_unix not rlm_sql_mysql for authentication,= >> it works >>>>>well. >>>>> I have been confused for several days. Maybe anyone can help= >> me? Thanks :) >>> > > > >- >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: FreeRadius with Mysql under Solaris can't work
Yes. As you say, I have altered the MySQL include directory location under Solaris 7, otherwise it can't compile correctly. Now I can't go on the project with MySQL support. I have been discouraged by this unsolved problem. > >If I remember correctly the development package for MySQL that comes from sunfreeware >puts the files in the > wrong location for freeradius to look for them. You can specify the location of the > files > or you can download the source and install from that. Solaris 8 and 9 fixed the > location problem without having ro specify. > >Gene Parks >VIP Direct > > > >>Thanks to Jeson. >> >>The MYSQL package is downloaded from sunfreeware and installed directly by pkgadd >>command. I am sure there are >> development header and lib included. Files in the lib directory are as follows: >> libdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.a >> libmystrings.a libmysys.a >> >>By the way, I had ever compiled and installed mysql 3.23.52 from source package. >> >>When I do install freeradius with configure, make and make install, there is no >>error reported. So I don't think >> it's the reason. >> >>Am I right? >> >> >>>Hi, >>> >>> Please make sure you have the MySQL development package, FreeRADIUS >>> compile the rlm_sql_mysql module need the include >file from MySQL >>> development package. >>> >>> >>>>Hi,all >>>>I want to use freeradius with mysql support under Solaris sparc 2.7. >>>> I meet the same problem as many newbies when I start radiusd: >>>> >>>>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. >>>> >>>>All methods have been tried but failed. MySQL is working well. I >>>> try to compile freeradius under gcc 3.2.3 as FAQ says "configure >>>> --disable-shared", or set proper LD_LIBRARY_PATH variable, or copy >>>> the dynamic lib files to /usr/lib. But the problem keeps here. >>>> >>>>When I do use rlm_unix not rlm_sql_mysql for authentication, it works well. >>>> I have been confused for several days. Maybe anyone can help me? Thanks :) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: FreeRadius with Mysql under Solaris can't work
Hi Zasp, Yes. When you do make, there are no error were report, but look through the information, you will find make do nothing with rlm_sql_mysql. And the TARGET entry in Makefile in the correspond directory is empty. If your configure find the head file and shared library, this entry will be filled with "rlm_sql_mysql". Please check it. Jeson [EMAIL PROTECTED] 2003-06-05 >If I remember correctly the development package for MySQL that comes from sunfreeware >puts the files in the wrong location for freeradius to look for them. You can >specify the location of the files or you can download the source and install from >that. Solaris 8 and 9 fixed the location problem without having ro specify. > >Gene Parks >VIP Direct > >-Original Message- >From: [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 04, 2003 8:49 AM >To: [EMAIL PROTECTED] >Subject: Re: FreeRadius with Mysql under Solaris can't work > > >Thanks to Jeson. > >The MYSQL package is downloaded from sunfreeware and installed directly by pkgadd >command. I am sure there are development header and lib included. Files in the lib >directory are as follows: > libdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.a > libmystrings.a libmysys.a > >By the way, I had ever compiled and installed mysql 3.23.52 from source package. > >When I do install freeradius with configure, make and make install, there is no error >reported. So I don't think it's the reason. > >Am I right? > >Best, > Zasp > >>Hi, >> >> Please make sure you have the MySQL development package, FreeRADIUS >> compile the rlm_sql_mysql module need the include >file from MySQL >> development package. >> >> Enjoy it! >> >> $B!!(J $B!!(JJeson >> >> >>>Hi,all >>> I want to use freeradius with mysql support under Solaris sparc 2.7. >>>I meet the same >>>problem as many newbies when I start radiusd: >>> >>> 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. >>> >>> All methods have been tried but failed. MySQL is working well.= I >>>try to compile freeradius under gcc 3.2.3 as FAQ says "configure >>>--disable-shared", or set proper LD_LIBRARY_PATH variable, or copy >>>the dynamic lib files to /usr/lib. But the problem keeps here. >>> >>> When I do use rlm_unix not rlm_sql_mysql for authentication, it works >>>well. >>> I have been confused for several days. Maybe anyone can help me? Thanks :) > > > > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: FreeRadius with Mysql under Solaris can't work
If I remember correctly the development package for MySQL that comes from sunfreeware (Bputs the files in the wrong location for freeradius to look for them. You can specify (Bthe location of the files or you can download the source and install from that. (BSolaris 8 and 9 fixed the location problem without having ro specify. (B (BGene Parks (BVIP Direct (B (B-Original Message- (BFrom: [mailto:[EMAIL PROTECTED] (BSent: Wednesday, June 04, 2003 8:49 AM (BTo: [EMAIL PROTECTED] (BSubject: Re: FreeRadius with Mysql under Solaris can't work (B (B (BThanks to Jeson. (B (BThe MYSQL package is downloaded from sunfreeware and installed directly by pkgadd (Bcommand. I am sure there are development header and lib included. Files in the lib (Bdirectory are as follows: (Blibdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.a (Blibmystrings.a libmysys.a (B (BBy the way, I had ever compiled and installed mysql 3.23.52 from source package. (B (BWhen I do install freeradius with configure, make and make install, there is no error (Breported. So I don't think it's the reason. (B (BAm I right? (B (BBest, (BZasp (B (B>Hi, (B> (B> Please make sure you have the MySQL development package, FreeRADIUS (B> compile the rlm_sql_mysql module need the include >file from MySQL (B> development package. (B> (B> Enjoy it! (B> (B> $B!!(J $B!!(JJeson (B> (B> (B>>Hi,all (B>> I want to use freeradius with mysql support under Solaris sparc 2.7. (B>>I meet the same (B>>problem as many newbies when I start radiusd: (B>> (B>> rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found (B>> rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the (B>> search path of your system's ld. (B>> radiusd.conf[14]: sql: Module instantiation failed. (B>> (B>> All methods have been tried but failed. MySQL is working well.= I (B>>try to compile freeradius under gcc 3.2.3 as FAQ says "configure (B>>--disable-shared", or set proper LD_LIBRARY_PATH variable, or copy (B>>the dynamic lib files to /usr/lib. But the problem keeps here. (B>> (B>> When I do use rlm_unix not rlm_sql_mysql for authentication, it works (B>>well. (B>> I have been confused for several days. Maybe anyone can help me? Thanks :) (B (B (B (B (B- (BList info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html (B (B- (BList info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius with Mysql under Solaris can't work
Thanks to Jeson. The MYSQL package is downloaded from sunfreeware and installed directly by pkgadd command. I am sure there are development header and lib included. Files in the lib directory are as follows: libdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.a libmystrings.a libmysys.a By the way, I had ever compiled and installed mysql 3.23.52 from source package. When I do install freeradius with configure, make and make install, there is no error reported. So I don't think it's the reason. Am I right? Best, Zasp >Hi, > > Please make sure you have the MySQL development package, FreeRADIUS compile the > rlm_sql_mysql module need the include >file from MySQL development package. > > Enjoy it! > > Jeson > > >>Hi,all >> I want to use freeradius with mysql support under Solaris sparc 2.7. I meet >> the same >>problem as many newbies when I start radiusd: >> >> 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. >> >> All methods have been tried but failed. MySQL is working well.= >> I try to compile freeradius under gcc 3.2.3 as FAQ says "configure >> --disable-shared", >> or set proper LD_LIBRARY_PATH variable, or copy the dynamic lib files to /usr/lib. >> But the problem keeps here. >> >> When I do use rlm_unix not rlm_sql_mysql for authentication, it works well. >> I have been confused for several days. Maybe anyone can help me? Thanks :) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRadius with Mysql under Solaris can't work
Hi, Please make sure you have the MySQL development package, FreeRADIUS compile the rlm_sql_mysql module need the include file from MySQL development package. Enjoy it! Jeson Welcome to: http://www.zyxel.com [EMAIL PROTECTED] 2003-06-04 === 2003-06-04 15:57:00 您在来信中写道:=== >Hi,all > I want to use freeradius with mysql support under Solaris sparc 2.7. I meet > the same >problem as many newbies when I start radiusd: > > 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. > > All methods have been tried but failed. MySQL is working well. I try to > compile freeradius under gcc 3.2.3 as FAQ says "configure --disable-shared", or set > proper LD_LIBRARY_PATH variable, or copy the dynamic lib files to /usr/lib. But the > problem > keeps here. > > When I do use rlm_unix not rlm_sql_mysql for authentication, it works well. I > have been confused for several days. Maybe anyone can help me? Thanks :) > > > > > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRadius with Mysql under Solaris can't work
Hi,all I want to use freeradius with mysql support under Solaris sparc 2.7. I meet the same problem as many newbies when I start radiusd: 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. All methods have been tried but failed. MySQL is working well. I try to compile freeradius under gcc 3.2.3 as FAQ says "configure --disable-shared", or set proper LD_LIBRARY_PATH variable, or copy the dynamic lib files to /usr/lib. But the problem keeps here. When I do use rlm_unix not rlm_sql_mysql for authentication, it works well. I have been confused for several days. Maybe anyone can help me? Thanks :) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with mysql
Le Jeudi 20 Février 2003 17:35, Apostolis Ayianoglou a écrit : > I have one more question about the attribute NAS-Port-Type. > This is a reply or check attribute? Well, incredibly enough, I know the answer for that one :-) It is a check attribute (fairly logic : if the user has dialed into an analog port, you can't change this situation, lest you physically change the user's modem into an ISDN adapter). > And what operator must use. Depends on what you need to do. Most of the time, you will want some users to only be able to dial in with an analog modem. So, you will use something like that in radgroupcheck : | GroupName | Attribute | op | Value | +---+---+--+---+ | analog| NAS-Port-Type | == | Async | But you could probably also use regular expressions (=~) for accounts authorized on different modes, I presume. Regards, -- [ Jacques Caruso <[EMAIL PROTECTED]> Développeur PHP ] [ Monaco Internet http://monaco-internet.mc/ ] [ Tél : (+377) 93 10 00 43Clé PGP : 0x41F5C63D ] [ -+- Trespassers will be shot. Survivors will be prosecuted. -+- ] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius with mysql
Ok kostas, I changed the operator from = to := and everything works fine I have one more question about the attribute NAS-Port-Type. This is a reply or check attribute? And what operator must use. Thanks P.s Sorry for the disclaimer but it is appended automatically from my provider. -Original Message- From: Kostas Kalevras [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 7:29 PM To: [EMAIL PROTECTED] Subject: Re: Freeradius with mysql On Wed, 19 Feb 2003, Apostolis Ayianoglou wrote: > I use freeradius 0.8.1 with Suse 8 and mysql to authenticate users Try > to authenticate and everything is work fine but, when I put option > Simultaneus-Use in radcheck or in radgroupcheck table the > authntication is not working with message Pair is not match. Do you also put an operator (op should be := )? -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with mysql
On Wed, 19 Feb 2003, Apostolis Ayianoglou wrote: > I use freeradius 0.8.1 with Suse 8 and mysql to authenticate users > Try to authenticate and everything is work fine but, > when I put option Simultaneus-Use in radcheck or in radgroupcheck table the > authntication is not working with message Pair is not match. Do you also put an operator (op should be := )? -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius with mysql
No I write (Simultaneous-Use) correct but in message I typed error. -Original Message- From: Evren Yurtesen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 5:29 PM To: [EMAIL PROTECTED] Subject: Re: Freeradius with mysql One thing is that it should be Simultaneous-Use and not Simultaneus-Use Can this be the problem? On Wed, 19 Feb 2003, Apostolis Ayianoglou wrote: > I use freeradius 0.8.1 with Suse 8 and mysql to authenticate users Try > to authenticate and everything is work fine but, when I put option > Simultaneus-Use in radcheck or in radgroupcheck table the > authntication is not working with message Pair is not match. > > DISCLAIMER: The information in this message is confidential and may be > legally privileged. It is intended solely for the addressee. Access > to this message by anyone else is unauthorised. If you are not the > intended recipient, any disclosure, copying, or distribution of the > message, or any action or omission taken by you in reliance on it, is > prohibited and may be unlawful. Please immediately contact the sender > if you have received this message in error. Thank you. > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius with mysql
One thing is that it should be Simultaneous-Use and not Simultaneus-Use Can this be the problem? On Wed, 19 Feb 2003, Apostolis Ayianoglou wrote: > I use freeradius 0.8.1 with Suse 8 and mysql to authenticate users > Try to authenticate and everything is work fine but, > when I put option Simultaneus-Use in radcheck or in radgroupcheck table the > authntication is not working with message Pair is not match. > > DISCLAIMER: The information in this message is confidential and may be > legally privileged. It is intended solely for the addressee. Access to this > message by anyone else is unauthorised. If you are not the intended > recipient, any disclosure, copying, or distribution of the message, or any > action or omission taken by you in reliance on it, is prohibited and may be > unlawful. Please immediately contact the sender if you have received this > message in error. Thank you. > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius with mysql
Title: Freeradius with mysql I use freeradius 0.8.1 with Suse 8 and mysql to authenticate users Try to authenticate and everything is work fine but, when I put option Simultaneus-Use in radcheck or in radgroupcheck table the authntication is not working with message Pair is not match. DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.
RE: Problems building Freeradius with MySQL support
Do you have the mysql development libraries installed when you do the compilation, as this stops it working. regards, Keith > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of john > zurowski > Sent: 28 January 2003 11:06 > To: [EMAIL PROTECTED] > Subject: Problems building Freeradius with MySQL support > > > > I've been using Freeradius with the users file without any problems for a > while now. > > I've decided to upgrade to using MySQL to maintain the users/accounting > database > > I've tried building freeradius using the following ./configure > without any > luck. > > > ./configure --with-rlm-mysql-lib-dir=/usr/local/mysql/lib/ > --with-rlm-mysql-include-dir=/usr/local/mysql/include/ > > and > > ./configure --with-mysql-lib-dir=/usr/local/mysql/lib/ > --with-mysql-include-dir=/usr/local/mysql/include/ > > I'm using freeradius.0.8.1 & MySQL 3.23.54 > > after doing a "make" looking in : > > src/modules/rlm_sql/drivers/rlm_sql_mysql > > no object files are being generated although a Makefile is created > > It would be greatly appreciated if someone could point me at a how-to to > resolve this issue. As I know that its something that I'm not > doing right - > just can't figure out what it is. > > Thanks in advance > > --- > John Zurowski > > > > _ > Overloaded with spam? With MSN 8, you can filter it out > http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=3 > 2&DI=1059 > > > - > 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: Problems building Freeradius with MySQL support
Problem fixed The original installation for mysql was from a binary tar ball. It worked fine once I'd followed the installation steps i.e. >mysql would allow me to talk to the database. However this setup didn't build freeradius with the mysql extensions. I subsequently downloaded the appropriate rpms for mySQL, installed them and then the freeradius ./configure worked fine. http://www.zurowski.btinternet.co.uk";>John Zurowski From: Ossama Suleiman <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Problems building Freeradius with MySQL support Date: Tue, 28 Jan 2003 13:26:57 +0200 _ MSN Messenger - fast, easy and FREE! http://messenger.msn.co.uk --- Begin Message --- hi john, "ABSOLUTELY MAKE SURE you have the mysql-devel (headers and libraries) package installed with your MySQL, otherwise freeradius won't compile with MySQL support properly. Many people seem to miss having this." you can also check http://www.frontios.com/freeradius.html great site, great help hope that helps Regards Ossama john zurowski wrote: I've been using Freeradius with the users file without any problems for a while now. I've decided to upgrade to using MySQL to maintain the users/accounting database I've tried building freeradius using the following ./configure without any luck. ./configure --with-rlm-mysql-lib-dir=/usr/local/mysql/lib/ --with-rlm-mysql-include-dir=/usr/local/mysql/include/ and ./configure --with-mysql-lib-dir=/usr/local/mysql/lib/ --with-mysql-include-dir=/usr/local/mysql/include/ I'm using freeradius.0.8.1 & MySQL 3.23.54 after doing a "make" looking in : src/modules/rlm_sql/drivers/rlm_sql_mysql no object files are being generated although a Makefile is created It would be greatly appreciated if someone could point me at a how-to to resolve this issue. As I know that its something that I'm not doing right - just can't figure out what it is. Thanks in advance --- John Zurowski _ Overloaded with spam? With MSN 8, you can filter it out http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --- End Message ---
Re: Problems building Freeradius with MySQL support
Should have added Building on PC under RedHat 7.3 From: "john zurowski" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Problems building Freeradius with MySQL support Date: Tue, 28 Jan 2003 11:06:03 + I've been using Freeradius with the users file without any problems for a while now. I've decided to upgrade to using MySQL to maintain the users/accounting database I've tried building freeradius using the following ./configure without any luck. ./configure --with-rlm-mysql-lib-dir=/usr/local/mysql/lib/ --with-rlm-mysql-include-dir=/usr/local/mysql/include/ and ./configure --with-mysql-lib-dir=/usr/local/mysql/lib/ --with-mysql-include-dir=/usr/local/mysql/include/ I'm using freeradius.0.8.1 & MySQL 3.23.54 after doing a "make" looking in : src/modules/rlm_sql/drivers/rlm_sql_mysql no object files are being generated although a Makefile is created It would be greatly appreciated if someone could point me at a how-to to resolve this issue. As I know that its something that I'm not doing right - just can't figure out what it is. Thanks in advance --- John Zurowski _ Overloaded with spam? With MSN 8, you can filter it out http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html _ Worried what your kids see online? Protect them better with MSN 8 http://join.msn.com/?page=features/parental&pgmarket=en-gb&XAPID=186&DI=1059 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problems building Freeradius with MySQL support
hi john, "ABSOLUTELY MAKE SURE you have the mysql-devel (headers and libraries) package installed with your MySQL, otherwise freeradius won't compile with MySQL support properly. Many people seem to miss having this." you can also check http://www.frontios.com/freeradius.html great site, great help hope that helps Regards Ossama john zurowski wrote: I've been using Freeradius with the users file without any problems for a while now. I've decided to upgrade to using MySQL to maintain the users/accounting database I've tried building freeradius using the following ./configure without any luck. ./configure --with-rlm-mysql-lib-dir=/usr/local/mysql/lib/ --with-rlm-mysql-include-dir=/usr/local/mysql/include/ and ./configure --with-mysql-lib-dir=/usr/local/mysql/lib/ --with-mysql-include-dir=/usr/local/mysql/include/ I'm using freeradius.0.8.1 & MySQL 3.23.54 after doing a "make" looking in : src/modules/rlm_sql/drivers/rlm_sql_mysql no object files are being generated although a Makefile is created It would be greatly appreciated if someone could point me at a how-to to resolve this issue. As I know that its something that I'm not doing right - just can't figure out what it is. Thanks in advance --- John Zurowski _ Overloaded with spam? With MSN 8, you can filter it out http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Problems building Freeradius with MySQL support
I've been using Freeradius with the users file without any problems for a while now. I've decided to upgrade to using MySQL to maintain the users/accounting database I've tried building freeradius using the following ./configure without any luck. ./configure --with-rlm-mysql-lib-dir=/usr/local/mysql/lib/ --with-rlm-mysql-include-dir=/usr/local/mysql/include/ and ./configure --with-mysql-lib-dir=/usr/local/mysql/lib/ --with-mysql-include-dir=/usr/local/mysql/include/ I'm using freeradius.0.8.1 & MySQL 3.23.54 after doing a "make" looking in : src/modules/rlm_sql/drivers/rlm_sql_mysql no object files are being generated although a Makefile is created It would be greatly appreciated if someone could point me at a how-to to resolve this issue. As I know that its something that I'm not doing right - just can't figure out what it is. Thanks in advance --- John Zurowski _ Overloaded with spam? With MSN 8, you can filter it out http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: (no subject).. compiling freeradius with mysql.... solved
Hi Thanks NN for your cooperation. I have found the problem. the env variable LD_LIBRARY_PATH was not working properly as it was not defined in proper login script. After adding the following line in .profile, everything worked fine. LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib A small mistake but big problem. Thanks again Aqeel -- Nikodim Nikodimov <[EMAIL PROTECTED]> wrote: > Well I don't know how is it with shared libraries in > Solaris...:(( > see this information in the beginning of the > rasius.conf file > > # > # libdir: Where to find the rlm_* modules. > # > # This should be automatically set at > configuration time. > # > # If the server builds and installs, but fails at > execution time > # with an 'undefined symbol' error, then you can > use the libdir > # directive to work around the problem. > # > # The cause is usually that a library has been > installed on your > # system in a place where the dynamic linker > CANNOT find it. When > # executing as root (or another user), your > personal environment MAY > # be set up to allow the dynamic linker to find > the library. When > # executing as a daemon, FreeRADIUS MAY NOT have > the same > # personalized configuration. > # > # To work around the problem, find out which > library contains that symbol, > # and add the directory containing that library to > the end of 'libdir', > # with a colon separating the directory names. NO > spaces are allowed. > # > # e.g. libdir = /usr/local/lib:/opt/package/lib > # > # If that does not work, then you can re-configure > and re-build the > # server to NOT use shared libraries, via: > # > # ./configure --disable-shared > # make > # make install > # > > NN > - Original Message - > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 02, 2002 2:56 PM > Subject: Re: (no subject).. compiling freeradius > with mysql. > > > > I am using freeradius on solaris 2.7. There is no > > /etc/ld.so.conf file and also there is no ldconfig > > file. I have installed gnu binutil but still these > > files are not avaiable. > > > > Thanks for your reply. > > Aqeel > > > > --- Nikodim Nikodimov <[EMAIL PROTECTED]> > wrote: > > > Do you have in /etc/ld.so.conf > > > /usr/local/lib > > > > > > this file tells where to search for shred > > > libraries...if you don't put it > > > and make ldconfig...to update ld.so.cache > > > > > > NN > > > > > > - Original Message - > > > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, April 02, 2002 1:21 PM > > > Subject: Re: (no subject).. compiling freeradius > > > with mysql. > > > > > > > > > > I installed mysql from source and mysql.h is > there > > > in > > > > include directory . With ./configure command i > > > also > > > > provided this include directory. But still I > dont > > > know > > > > whether rlm_sql_mysql has been compiled or > not. In > > > > /usr/local/lib i have the following files > related > > > to > > > > sql. > > > > > > > > rlm_sql.a, rlm_sql.so.0.0.0, > rlm_sql_mysql.so.0 > > > > rlm_sql.la, rlm_sql_mysql.a, > > > rlm_sql_mysql.so.0.0.0 > > > > rlm_sql.so, rlm_sql_mysql.la, rlm_sql.so.0 > > > > rlm_sql_mysql.so > > > > > > > > Thanks for your reply. > > > > Aqeel > > > > --- Nikodim Nikodimov <[EMAIL PROTECTED]> > > > wrote: > > > > > This happens probably because you don't have > > > > > rlm_sql_mysql compiled. How did > > > > > you install mysql? > > > > > from source or rpm...I had the same problem, > > > because > > > > > first I had mysql from > > > > > rpm...and I didn't have mysql.h...and some > other > > > > > header files...so I > > > > > installed mysql from source...and after then > I > > > > > reinstalled freeradius and > > > > > after that I had rlm_sql_mysql. > > > > > > > > > > NN > > > > > > > > > > - Original Message - > > > > > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > > > > > To: <[EMAIL PROTECTED]
Re: (no subject).. compiling freeradius with mysql.
Well I don't know how is it with shared libraries in Solaris...:(( see this information in the beginning of the rasius.conf file # # libdir: Where to find the rlm_* modules. # # This should be automatically set at configuration time. # # If the server builds and installs, but fails at execution time # with an 'undefined symbol' error, then you can use the libdir # directive to work around the problem. # # The cause is usually that a library has been installed on your # system in a place where the dynamic linker CANNOT find it. When # executing as root (or another user), your personal environment MAY # be set up to allow the dynamic linker to find the library. When # executing as a daemon, FreeRADIUS MAY NOT have the same # personalized configuration. # # To work around the problem, find out which library contains that symbol, # and add the directory containing that library to the end of 'libdir', # with a colon separating the directory names. NO spaces are allowed. # # e.g. libdir = /usr/local/lib:/opt/package/lib # # If that does not work, then you can re-configure and re-build the # server to NOT use shared libraries, via: # # ./configure --disable-shared # make # make install # NN - Original Message - From: "Aqeel Anwar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 2:56 PM Subject: Re: (no subject).. compiling freeradius with mysql. > I am using freeradius on solaris 2.7. There is no > /etc/ld.so.conf file and also there is no ldconfig > file. I have installed gnu binutil but still these > files are not avaiable. > > Thanks for your reply. > Aqeel > > --- Nikodim Nikodimov <[EMAIL PROTECTED]> wrote: > > Do you have in /etc/ld.so.conf > > /usr/local/lib > > > > this file tells where to search for shred > > libraries...if you don't put it > > and make ldconfig...to update ld.so.cache > > > > NN > > > > - Original Message - > > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, April 02, 2002 1:21 PM > > Subject: Re: (no subject).. compiling freeradius > > with mysql. > > > > > > > I installed mysql from source and mysql.h is there > > in > > > include directory . With ./configure command i > > also > > > provided this include directory. But still I dont > > know > > > whether rlm_sql_mysql has been compiled or not. In > > > /usr/local/lib i have the following files related > > to > > > sql. > > > > > > rlm_sql.a, rlm_sql.so.0.0.0, rlm_sql_mysql.so.0 > > > rlm_sql.la, rlm_sql_mysql.a, > > rlm_sql_mysql.so.0.0.0 > > > rlm_sql.so, rlm_sql_mysql.la, rlm_sql.so.0 > > > rlm_sql_mysql.so > > > > > > Thanks for your reply. > > > Aqeel > > > --- Nikodim Nikodimov <[EMAIL PROTECTED]> > > wrote: > > > > This happens probably because you don't have > > > > rlm_sql_mysql compiled. How did > > > > you install mysql? > > > > from source or rpm...I had the same problem, > > because > > > > first I had mysql from > > > > rpm...and I didn't have mysql.h...and some other > > > > header files...so I > > > > installed mysql from source...and after then I > > > > reinstalled freeradius and > > > > after that I had rlm_sql_mysql. > > > > > > > > NN > > > > > > > > - Original Message - > > > > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > > > > To: <[EMAIL PROTECTED]> > > > > Sent: Tuesday, April 02, 2002 12:24 PM > > > > Subject: (no subject) > > > > > > > > > > > > > HI all > > > > > I am trying to run radius with mysql. when i > > start > > > > > radius the following error message is shown. > > > > > > > > > > Starting - reading configuration files ... > > > > > Module: Loaded SQL > > > > > rlm_sql: Could not link driver rlm_sql_mysql: > > file > > > > not > > > > > found > > > > > rlm_sql: Make sure it (and all its dependent > > > > > libraries!) are in the search path > > > > > of your system's ld. > > > > > radiusd.conf[4]: sql: Module instantiation > > failed. > > > > > > > > > > what should i do in this case. > > > > > > > > > > Thanks for your help. > >
Re: (no subject).. compiling freeradius with mysql.
I am using freeradius on solaris 2.7. There is no /etc/ld.so.conf file and also there is no ldconfig file. I have installed gnu binutil but still these files are not avaiable. Thanks for your reply. Aqeel --- Nikodim Nikodimov <[EMAIL PROTECTED]> wrote: > Do you have in /etc/ld.so.conf > /usr/local/lib > > this file tells where to search for shred > libraries...if you don't put it > and make ldconfig...to update ld.so.cache > > NN > > - Original Message - > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 02, 2002 1:21 PM > Subject: Re: (no subject).. compiling freeradius > with mysql. > > > > I installed mysql from source and mysql.h is there > in > > include directory . With ./configure command i > also > > provided this include directory. But still I dont > know > > whether rlm_sql_mysql has been compiled or not. In > > /usr/local/lib i have the following files related > to > > sql. > > > > rlm_sql.a, rlm_sql.so.0.0.0, rlm_sql_mysql.so.0 > > rlm_sql.la, rlm_sql_mysql.a, > rlm_sql_mysql.so.0.0.0 > > rlm_sql.so, rlm_sql_mysql.la, rlm_sql.so.0 > > rlm_sql_mysql.so > > > > Thanks for your reply. > > Aqeel > > --- Nikodim Nikodimov <[EMAIL PROTECTED]> > wrote: > > > This happens probably because you don't have > > > rlm_sql_mysql compiled. How did > > > you install mysql? > > > from source or rpm...I had the same problem, > because > > > first I had mysql from > > > rpm...and I didn't have mysql.h...and some other > > > header files...so I > > > installed mysql from source...and after then I > > > reinstalled freeradius and > > > after that I had rlm_sql_mysql. > > > > > > NN > > > > > > - Original Message - > > > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, April 02, 2002 12:24 PM > > > Subject: (no subject) > > > > > > > > > > HI all > > > > I am trying to run radius with mysql. when i > start > > > > radius the following error message is shown. > > > > > > > > Starting - reading configuration files ... > > > > Module: Loaded SQL > > > > rlm_sql: Could not link driver rlm_sql_mysql: > file > > > not > > > > found > > > > rlm_sql: Make sure it (and all its dependent > > > > libraries!) are in the search path > > > > of your system's ld. > > > > radiusd.conf[4]: sql: Module instantiation > failed. > > > > > > > > what should i do in this case. > > > > > > > > Thanks for your help. > > > > Aqeel > > > > > > > > > > > > > > > > > __ > > > > Do You Yahoo!? > > > > Yahoo! Tax Center - online filing with > TurboTax > > > > http://http://taxes.yahoo.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 > > > > > > __ > > Do You Yahoo!? > > Yahoo! Tax Center - online filing with TurboTax > > http://http://taxes.yahoo.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 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: (no subject).. compiling freeradius with mysql.
Do you have in /etc/ld.so.conf /usr/local/lib this file tells where to search for shred libraries...if you don't put it and make ldconfig...to update ld.so.cache NN - Original Message - From: "Aqeel Anwar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 1:21 PM Subject: Re: (no subject).. compiling freeradius with mysql. > I installed mysql from source and mysql.h is there in > include directory . With ./configure command i also > provided this include directory. But still I dont know > whether rlm_sql_mysql has been compiled or not. In > /usr/local/lib i have the following files related to > sql. > > rlm_sql.a, rlm_sql.so.0.0.0, rlm_sql_mysql.so.0 > rlm_sql.la, rlm_sql_mysql.a, rlm_sql_mysql.so.0.0.0 > rlm_sql.so, rlm_sql_mysql.la, rlm_sql.so.0 > rlm_sql_mysql.so > > Thanks for your reply. > Aqeel > --- Nikodim Nikodimov <[EMAIL PROTECTED]> wrote: > > This happens probably because you don't have > > rlm_sql_mysql compiled. How did > > you install mysql? > > from source or rpm...I had the same problem, because > > first I had mysql from > > rpm...and I didn't have mysql.h...and some other > > header files...so I > > installed mysql from source...and after then I > > reinstalled freeradius and > > after that I had rlm_sql_mysql. > > > > NN > > > > - Original Message - > > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, April 02, 2002 12:24 PM > > Subject: (no subject) > > > > > > > HI all > > > I am trying to run radius with mysql. when i start > > > radius the following error message is shown. > > > > > > Starting - reading configuration files ... > > > Module: Loaded SQL > > > rlm_sql: Could not link driver rlm_sql_mysql: file > > not > > > found > > > rlm_sql: Make sure it (and all its dependent > > > libraries!) are in the search path > > > of your system's ld. > > > radiusd.conf[4]: sql: Module instantiation failed. > > > > > > what should i do in this case. > > > > > > Thanks for your help. > > > Aqeel > > > > > > > > > > > > __ > > > Do You Yahoo!? > > > Yahoo! Tax Center - online filing with TurboTax > > > http://http://taxes.yahoo.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 > > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://http://taxes.yahoo.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: (no subject).. compiling freeradius with mysql.
I installed mysql from source and mysql.h is there in include directory . With ./configure command i also provided this include directory. But still I dont know whether rlm_sql_mysql has been compiled or not. In /usr/local/lib i have the following files related to sql. rlm_sql.a, rlm_sql.so.0.0.0, rlm_sql_mysql.so.0 rlm_sql.la, rlm_sql_mysql.a, rlm_sql_mysql.so.0.0.0 rlm_sql.so, rlm_sql_mysql.la, rlm_sql.so.0 rlm_sql_mysql.so Thanks for your reply. Aqeel --- Nikodim Nikodimov <[EMAIL PROTECTED]> wrote: > This happens probably because you don't have > rlm_sql_mysql compiled. How did > you install mysql? > from source or rpm...I had the same problem, because > first I had mysql from > rpm...and I didn't have mysql.h...and some other > header files...so I > installed mysql from source...and after then I > reinstalled freeradius and > after that I had rlm_sql_mysql. > > NN > > - Original Message - > From: "Aqeel Anwar" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 02, 2002 12:24 PM > Subject: (no subject) > > > > HI all > > I am trying to run radius with mysql. when i start > > radius the following error message is shown. > > > > Starting - reading configuration files ... > > Module: Loaded SQL > > rlm_sql: Could not link driver rlm_sql_mysql: file > not > > found > > rlm_sql: Make sure it (and all its dependent > > libraries!) are in the search path > > of your system's ld. > > radiusd.conf[4]: sql: Module instantiation failed. > > > > what should i do in this case. > > > > Thanks for your help. > > Aqeel > > > > > > > > __ > > Do You Yahoo!? > > Yahoo! Tax Center - online filing with TurboTax > > http://http://taxes.yahoo.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 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html