no start of radiusd after reboot : mysql connection error

[mailinglists]

Alan DeKok a écrit :
> mailinglists wrote:
>   
>> Hello,
>> I use freeradius-1.1.3-1.2.el5 and freeradius-mysql-1.1.3-1.2.el5. the
>> mysql database (mysql-server-5.0.22-2.1.0.1) is hosted on a remote host
>> (both centos5).
>> When I use /etc/init.d/radiusd as root it starts up correctly. But when
>> the service is launched at boot time, I get this error-log :
>>     
>
>   The server is configured with "user" and "group" in radiusd.conf, and
> that user/group does not have permission to talk to the MySQL server.
>
>   
>> I set a tcpdump on the mysql-server host, and during the boot of my
>> freeradius server, I see no traffic comming from freeradius host.
>> There is no reject in the firewall.
>> I've tried to put the radius rc.d script in S99 to start it as late as
>> possible, but nothing changes.
>>     
>
>   It's a permission problem, not a boot order problem.
>
>   
>> I also noticed that it doesen't seem to retry to connect to the database
>> later. Or is it after a long time ?
>> Is this a bug ?
>> Where is the retry time configured (I cant try to set up to 5 seconds) ?
>>     
>
>   Re-trying when it doesn't have permission to connect won't help.
>
>   Alan DeKok.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>   
Do you mean that I must allow my user on the mysql server ? I don't 
think so, since there is no traffic from the freeradius to mysql at boot 
time. And furthermore, the user *is* allowed to connect to database from 
the free-radius host
There are perhaps permissions problems on the freeradius hosts, to 
launch a particular process ?
Please can you telle me how I can allow user/group to talk to the MySQL 
server ?

thanks
laetitia