FreeRadius and MySQL boot problem
|
View:
New views
10 Messages
—
Rating Filter:
Alert me
|
 |
FreeRadius and MySQL boot problem
by Diniz Da Rocha
::
Rate this Message:
HI,
I have currently setup FreeRadius 1.0.4 with ldap authentication and authorization as well as mysql authorization and its all working fine. My only problem is that when I boot the server (Fedora Core 4) and radiusd starts up there is a rlm_sql_mysql error:
Wed Feb 15 18:38:51 2006 : Info: rlm_sql (sql): Trying to (re)connect unconnected handle 4..
Wed Feb 15 18:38:51 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Wed Feb 15 18:38:51 2006 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server radius_client@... Wed Feb 15 18:38:51 2006 : Error: rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on 'myip' (13)' Wed Feb 15 18:38:51 2006 : Error: rlm_sql (sql): Failed to connect DB handle #4 The MySQL server is on another server with ip "myip" I initially thought it was a firewall block but even with no firewall I get this error. But once the server has started and I run "service radiusd restart" from a terminal the connect to the MySQL server works fine and has no problems. I even tried running the service from
rc.local but it still fails did anyone have this problem??? is anyone running the MySQL server on another machine???? Is there a fix for this???
thanks
diniz
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html |
|
|
Re: FreeRadius and MySQL boot problem
by Alan DeKok
::
Rate this Message:
"Diniz Da Rocha" <dinizd@...> wrote:
> The MySQL server is on another server with ip "myip" I initially thought it > was a firewall block but even with no firewall I get this error. But once > the server has started and I run "service radiusd restart" from a terminal > the connect to the MySQL server works fine and has no problems. I even tried > running the service from rc.local but it still fails did anyone have this > problem??? is anyone running the MySQL server on another machine???? Is > there a fix for this??? The server *should* re-connect to MySQL after a period of time. If it doesn't, it's a bug. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html |
|
|
Re: FreeRadius and MySQL boot problem
by Dennis Skinner-2
::
Rate this Message:
Diniz Da Rocha wrote:
> The MySQL server is on another server with ip "myip" I initially thought > it was a firewall block but even with no firewall I get this error. But > once the server has started and I run "service radiusd restart" from a > terminal the connect to the MySQL server works fine and has no problems. > I even tried running the service from rc.local but it still fails did > anyone have this problem??? is anyone running the MySQL server on > another machine???? Is there a fix for this??? Our SQL server is on another machine and works fine on reboots. It looks like your networking service may not be completely up and functional before radius starts. Add a sleep for 10 or 20sec in rc.local before FR starts and see what happens. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html |
|
|
Re: FreeRadius and MySQL boot problem
by Diniz Da Rocha
::
Rate this Message:
do you know how long it *should* take before retrying??
On 2/27/06, Alan DeKok <aland@...> wrote:
"Diniz Da Rocha" <dinizd@...> wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html |
|
|
Re: FreeRadius and MySQL boot problem
by Diniz Da Rocha
::
Rate this Message:
I also had that impression so I did a sleep for 30 secs but still no luck, I was wondering if it has something to do with the user who runs at startup if its not root??? but havent any info on this yet... what os are you running your FreeRadius on??? On 2/28/06, Dennis Skinner <dskinner@...> wrote:
Diniz Da Rocha wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html |
|
|
Re: FreeRadius and MySQL boot problem
by Alan DeKok
::
Rate this Message:
"Diniz Da Rocha" <dinizd@...> wrote:
> do you know how long it *should* take before retrying?? Why ask me? See the server source. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html |
|
|
Re: FreeRadius and MySQL boot problem
by olisa
::
Rate this Message:
hello i configure chillispot and freeradius and it is working. But whenever i reboot this radiusd server i have to run manually all the time. So how to run this radiusd server at boot time. chillispot ,apche and mysql all run at boot time but radiusd is not.i try it by writing script in /etc/rc.local and also directly copy /usr/local/sbin/radiusd file to /etc/rc.d/init.d but it don't work . So please give me any ideas to start radiusd server at boot time. regards rina
|
|
|
Re: FreeRadius and MySQL boot problem
by olisa
::
Rate this Message:
hello
i configure chillispot and freeradius and it is working. But whenever i reboot this radiusd server i have to run manually all the time. So how to run this radiusd server at boot time. chillispot ,apche and mysql all run at boot time but radiusd is not.i try it by writing script in /etc/rc.local and also directly copy /usr/local/sbin/radiusd file to /etc/rc.d/init.d but it don't work . So please give me any ideas to start radiusd server at boot time. regards rina
|
|
|
Re: FreeRadius and MySQL boot problem
by Hernan Antolini
::
Rate this Message:
Check the scripts dir that came with the freeradius source; there is a rc.radiusd file to do that. regards Hernan Antolini freeradius-users-bounces+antolini=ar.ibm.com@... wrote on 11/24/2006 03:52:53 AM: > > hello > i configure chillispot and freeradius and it is working. But > whenever i reboot this radiusd server i have to run manually all the time. > So how to run this radiusd server at boot time. > chillispot ,apche and mysql all run at boot time but radiusd is > not.i try it by writing script in /etc/rc.local and also directly copy > /usr/local/sbin/radiusd file to /etc/rc.d/init.d but it don't work . So > please give me any ideas to start radiusd server at boot time. > > regards > rina > > > > Diniz Da Rocha wrote: > > > > HI, > > > > I have currently setup FreeRadius 1.0.4 with ldap authentication and > > authorization as well as mysql authorization and its all working fine. My > > only problem is that when I boot the server (Fedora Core 4) and radiusd > > starts up there is a rlm_sql_mysql error: > > > > Wed Feb 15 18:38:51 2006 : Info: rlm_sql (sql): Trying to (re)connect > > unconnected handle 4.. > > Wed Feb 15 18:38:51 2006 : Info: rlm_sql_mysql: Starting connect to MySQL > > server for #4 > > Wed Feb 15 18:38:51 2006 : Error: rlm_sql_mysql: Couldn't connect socket > > to > > MySQL server radius_client@myip:radius > > Wed Feb 15 18:38:51 2006 : Error: rlm_sql_mysql: Mysql error 'Can't > > connect > > to MySQL server on 'myip' (13)' > > Wed Feb 15 18:38:51 2006 : Error: rlm_sql (sql): Failed to connect DB > > handle > > #4 > > > > > > The MySQL server is on another server with ip "myip" I initially thought > > it > > was a firewall block but even with no firewall I get this error. But once > > the server has started and I run "service radiusd restart" from a terminal > > the connect to the MySQL server works fine and has no problems. I even > > tried > > running the service from rc.local but it still fails did anyone have this > > problem??? is anyone running the MySQL server on another machine???? Is > > there a fix for this??? > > > > thanks > > > > diniz > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > > > -- > View this message in context: http://www.nabble.com/FreeRadius-and- > MySQL-boot-problem-tf1191658.html#a7518565 > Sent from the FreeRadius - User mailing list archive at Nabble.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: FreeRadius and MySQL boot problem
by olisa
::
Rate this Message:
I check it freeradius scripts rc.radiusd .it is same as /usr/local/sbin/rc.radiusd.
I am using operating system fedora core 4 and chillispot is chillispot-1.0.i386.rpm and freeradius is freeradius-1.1.0.tar.gz . and whenever i reboot the radiusd server there is the error in radiusd log file like Sun Nov 26 11:00:51 2006 : Info: Using deprecated naslist file. Support for this will go away soon. Sun Nov 26 11:00:51 2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Sun Nov 26 11:00:51 2006 : Error: radiusd.conf[10] Failed to link to module 'rlm_eap': /usr/local/lib/rlm_eap-1.1.0.so: cannot restore segment prot after reloc: Permission denied Sun Nov 26 11:00:51 2006 : Error: radiusd.conf[1749] Unknown module "eap". Sun Nov 26 11:00:51 2006 : Error: radiusd.conf[1696] Failed to parse authenticate section. and when i start the radiusd by typing /usr/src/sbin/radiusd , radiusd server run and it has radiusd log file like Sun Nov 26 11:46:10 2006 : Info: Using deprecated naslist file. Support for this will go away soon. Sun Nov 26 11:46:10 2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Sun Nov 26 11:46:10 2006 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Sun Nov 26 11:46:10 2006 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mypaid Sun Nov 26 11:46:10 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Sun Nov 26 11:46:11 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1 Sun Nov 26 11:46:11 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2 Sun Nov 26 11:46:11 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3 Sun Nov 26 11:46:11 2006 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Sun Nov 26 11:46:11 2006 : Info: Ready to process requests. so , how to run this radiusd server at boot time not by manully starting everytime when server is restart. regards rina
|
| Free embeddable forum powered by Nabble | Forum Help |
