cannot connect to sql databse

Ivan Kalik tnt at kalik.net
Wed Jan 30 11:50:09 CET 2008 

1. You are not sending login requests to this server, or at least they
are not getting there. Is server set up not to recieve auth requests
from the network (only local reqests)? Can you log into it from a
different machine?

2. Is this server restarting on it's own or are you doing that?

Ivan Kalik
Kalik Informatika ISP


Dana 30/1/2008, "Devinder Singh" <devinbhullar at gmail.com> piše:

>Hi Liran
>This is my log file i cant find any errors for cannot connect to sql
>database
>
>Thanks
>Devinder
>
>
>080124 14:48:58  mysqld ended
>
>080124 14:48:58  mysqld started
>080124 14:48:58  InnoDB: Started; log sequence number 0 43655
>080124 14:48:58 [Note] /usr/sbin/mysqld: ready for connections.
>Version: '5.0.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  SUSE
>MySQL RPM
>080124 15:26:09 [Note] /usr/sbin/mysqld: Normal shutdown
>
>080124 15:26:09  InnoDB: Starting shutdown...
>080124 15:26:11  InnoDB: Shutdown completed; log sequence number 0 43655
>080124 15:26:11 [Note] /usr/sbin/mysqld: Shutdown complete
>
>080124 15:26:11  mysqld ended
>
>080124 15:26:11  mysqld started
>080124 15:26:11  InnoDB: Started; log sequence number 0 43655
>080124 15:26:11 [Note] /usr/sbin/mysqld: ready for connections.
>Version: '5.0.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  SUSE
>MySQL RPM
>080124 15:40:56 [Note] /usr/sbin/mysqld: Normal shutdown
>
>080124 15:40:56  InnoDB: Starting shutdown...
>080124 15:40:57  InnoDB: Shutdown completed; log sequence number 0 43655
>080124 15:40:57 [Note] /usr/sbin/mysqld: Shutdown complete
>
>080124 15:40:57  mysqld ended
>
>080124 15:40:57  mysqld started
>080124 15:40:57  InnoDB: Started; log sequence number 0 43655
>080124 15:40:58 [Note] /usr/sbin/mysqld: ready for connections.
>Version: '5.0.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  SUSE
>MySQL RPM
>
>
>On 29/01/2008, liran tal <liransgarage at gmail.com> wrote:
>>
>> Hey Devinder,
>>
>> On Jan 29, 2008 9:50 AM, Devinder Singh <devinbhullar at gmail.com> wrote:
>>
>> > Hi Liran
>> >
>> > The exact error message on Dial Up Admin is
>> >
>> > cannot connec to sql database.
>> >
>>
>> Well that's not too helpful now, is it?
>> I'm not too familiar with dialupadmin, maybe someone else can donate
>> his 2 cents if they had this problem as well. Like I said before, you
>> should
>> try debugging the problem by taking a look at log files instead of
>> trying to guess the problem into discovery.
>>
>> Some thoughts to think about:
>> - is this working if you run it from console?
>>   mysql -u freeradius -pmysuperpassword radius
>>
>> - do you have the necessary php mysql package installed?
>>   (php4-mysql or php5-mysql)
>>
>>
>>
>> Regards,
>> Liran Tal.
>>
>>
>>
>> >
>> >
>> >  On 29/01/2008, Liran Tal <liran at enginx.com> wrote:
>> > >
>> > > Hey Devinder,
>> > >
>> > > On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar at gmail.com>
>> > > wrote:
>> > >
>> > > > Hi Liran
>> > > >
>> > > > Where shoud i turn on the Logging in which file could you let me
>> > > > know what files are involved to do logging.
>> > > >
>> > > >
>> > >
>> > > Turning on the mysql logging is done in mysql's configuration
>> > > file (on debian it's found at /etc/mysql/my.cnf).
>> > >
>> > > What is the exact error message you receive in the web page?
>> > > "Dial Up admin page i get cannot connect to sql databse" is too
>> > > ambiguous.
>> > > Copy and paste it here.
>> > >
>> > >
>> > > Regards,
>> > > Liran Tal.
>> > >
>> > >
>> > >
>> > >
>> > > >
>> > > >
>> > > >   On 29/01/2008, liran tal <liransgarage at gmail.com> wrote:
>> > > > >
>> > > > > Hey Devinder,
>> > > > >
>> > > > >  On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar at gmail.com>
>> > > > > wrote:
>> > > > >
>> > > > > > Dear Liran
>> > > > > >
>> > > > > > this is my dialup_admin.conf file
>> > > > > > sql_type: mysql
>> > > > > > sql_server: localhost
>> > > > > > sql_port: 3306
>> > > > > > sql_username: freeradius
>> > > > > > sql_password: mysuperpassword
>> > > > > > sql_database: radius
>> > > > > > sql_accounting_table: radacct
>> > > > > > sql_badusers_table: badusers
>> > > > > > sql_check_table: radcheck
>> > > > > > sql_reply_table: radreply
>> > > > > > sql_user_info_table: userinfo
>> > > > > > sql_groupcheck_table: radgroupcheck
>> > > > > > sql_groupreply_table: radgroupreply
>> > > > > > sql_usergroup_table: usergroup
>> > > > > >
>> > > > > > and this is the /usr/raddb/sql.conf confihguration
>> > > > > >
>> > > > > > sql {
>> > > > > >         # Database type
>> > > > > >         # Current supported are: rlm_sql_mysql,
>> > > > > > rlm_sql_postgresql,
>> > > > > >         # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc,
>> > > > > > rlm_sql_freetds
>> > > > > >         driver = "rlm_sql_mysql"
>> > > > > >
>> > > > > >         # Connect info
>> > > > > >         server = "localhost"
>> > > > > >         login = "freeradius"
>> > > > > >         password = "mysuperpassword"
>> > > > > >
>> > > > > >         # Database table configuration
>> > > > > >         radius_db = "radius"
>> > > > > >
>> > > > > >         # If you want both stop and start records logged to the
>> > > > > >         # same SQL table, leave this as is.  If you want them in
>> > > > > >         # different tables, put the start table in acct_table1
>> > > > > >         # and stop table in acct_table2
>> > > > > >         acct_table1 = "radacct"
>> > > > > >         acct_table2 = "radacct"
>> > > > > >
>> > > > > >         # Allow for storing data after authentication
>> > > > > >         postauth_table = "radpostauth"
>> > > > > >
>> > > > > > Is there anything that i as missing pls advise.
>> > > > > >
>> > > > >
>> > > > >
>> > > > > I guess that looks alright but you haven't done any debugging like
>> > > > > I suggested. Turn on mysql logging and see if there's even a
>> > > > > connection
>> > > > > attempt and if there is you can track what query is going wrong.
>> > > > >
>> > > > > You haven't detailed what is the exact error, it could just as
>> > > > > well be that
>> > > > > everything is configured fine but you haven't installed any
>> > > > > php-mysql
>> > > > > package and you have error_reporting turned off and so you are not
>> > > > > seeing
>> > > > > the error.
>> > > > >
>> > > > > Please check these things first.
>> > > > >
>> > > > > Regards,
>> > > > > Liran Tal.
>> > > > >
>> > > > >
>> > > > >
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > > On 28/01/2008, Devinder Singh <devinbhullar at gmail.com> wrote:
>> > > > > > >
>> > > > > > > Hi Liran
>> > > > > > >
>> > > > > > > Are the a lot of changes to be made on Dial Up Admin
>> > > > > > > admin.conf file
>> > > > > > >
>> > > > > > >
>> > > > > > > Could you suggest any specific changes as well in
>> > > > > > > etc/raddb/sql.conf
>> > > > > > >
>> > > > > > >
>> > > > > > > Regards
>> > > > > > > Devinder
>> > > > > > >
>> > > > > > >
>> > > > > > >  On 28/01/2008, Liran Tal <liran at enginx.com> wrote:
>> > > > > > > >
>> > > > > > > > Hey Devinder,
>> > > > > > > >
>> > > > > > > > On Jan 28, 2008 8:44 AM, Devinder Singh <
>> > > > > > > > devinbhullar at gmail.com> wrote:
>> > > > > > > >
>> > > > > > > > > Hi  Liran
>> > > > > > > > >
>> > > > > > > > >
>> > > > > > > > >
>> > > > > > > > > I amd using MySQL would daloradius work with MySQL
>> > > > > > > > >
>> > > > > > > >
>> > > > > > > > Yes, daloradius has native support for mysql.
>> > > > > > > > You check on dialupadmin for configuring errors - what is
>> > > > > > > > the
>> > > > > > > > error message that you get?
>> > > > > > > >
>> > > > > > > > It is also very useful to turn on mysql logging to see if
>> > > > > > > > there's
>> > > > > > > > even a connection attempt and if there is, what is causing
>> > > > > > > > the error.
>> > > > > > > >
>> > > > > > > > Regards,
>> > > > > > > > Liran Tal.
>> > > > > > > >
>> > > > > > > >
>> > > > > > > >
>> > > > > > > >
>> > > > > > > > >
>> > > > > > > > >  On 28/01/2008, liran tal <liransgarage at gmail.com> wrote:
>> > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > > Hey Devinder,
>> > > > > > > > > >
>> > > > > > > > > > On Jan 28, 2008 4:35 AM, Devinder Singh <
>> > > > > > > > > > devinbhullar at gmail.com> wrote:
>> > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > > > Hi
>> > > > > > > > > > >
>> > > > > > > > > > > I am using Dial Up Admin on Free radius
>> > > > > > > > > > >
>> > > > > > > > > > >
>> > > > > > > > > > > Free Radius is Running but when i acccess Dial Up
>> > > > > > > > > > > admin page i get cannot connect to sql databse
>> > > > > > > > > > >
>> > > > > > > > > > > I have done most of the configuration settings and
>> > > > > > > > > > > followed the wiki tutorial on Free Radius.
>> > > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > > Did you check that your sql server is actually running?
>> > > > > > > > > > Did you import the radius database schema into the sql
>> > > > > > > > > > server?
>> > > > > > > > > > Did you configure all the required settings to connect
>> > > > > > > > > > to the
>> > > > > > > > > > sql server in dialupadmin?
>> > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > > You also might want to take a look at daloRADIUS for
>> > > > > > > > > > easy web management
>> > > > > > > > > > of freeradius with sql servers:
>> > > > > > > > > > http://sourceforge.net/projects/daloradius/
>> > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > > Regards,
>> > > > > > > > > > Liran.
>> > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > > > -
>> > > > > > > > > > List info/subscribe/unsubscribe? See
>> > > > > > > > > > http://www.freeradius.org/list/users.html
>> > > > > > > > > >
>> > > > > > > > > >
>> > > > > > > > >
>> > > > > > > > >
>> > > > > > > > >
>> > > > > > > > > --
>> > > > > > > > > Devinder
>> > > > > > > > > -
>> > > > > > > > > List info/subscribe/unsubscribe? See
>> > > > > > > > > http://www.freeradius.org/list/users.html
>> > > > > > > > >
>> > > > > > > >
>> > > > > > > >
>> > > > > > > > -
>> > > > > > > > List info/subscribe/unsubscribe? See
>> > > > > > > > http://www.freeradius.org/list/users.html
>> > > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > > > --
>> > > > > > > Devinder
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > > --
>> > > > > > Devinder
>> > > > > > -
>> > > > > > List info/subscribe/unsubscribe? See
>> > > > > > http://www.freeradius.org/list/users.html
>> > > > > >
>> > > > >
>> > > > >
>> > > > > -
>> > > > > List info/subscribe/unsubscribe? See
>> > > > > http://www.freeradius.org/list/users.html
>> > > > >
>> > > >
>> > > >
>> > > >
>> > > > --
>> > > > Devinder
>> > > >
>> > > > -
>> > > > List info/subscribe/unsubscribe? See
>> > > > http://www.freeradius.org/list/users.html
>> > > >
>> > >
>> > >
>> > > -
>> > > List info/subscribe/unsubscribe? See
>> > > http://www.freeradius.org/list/users.html
>> > >
>> >
>> >
>> >
>> > --
>> > Devinder
>> >
>> > -
>> > List info/subscribe/unsubscribe? See
>> > http://www.freeradius.org/list/users.html
>> >
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>
>
>--
>Devinder
>
>

More information about the Freeradius-Users mailing list