cannot connect to sql databse
Liran Tal
liran at enginx.com
Wed Jan 30 10:45:19 CET 2008
On Jan 30, 2008 10:15 AM, Devinder Singh <devinbhullar at gmail.com> wrote:
> Hi Liran
> This is my log file i cant find any errors for cannot connect to sql
> database
>
>
If you don't find any connection attempts information then it means
that dialupadmin isn't initiating a connection due to one of the reasons
I have mentioned before or something else. We've been exchanging
so many emails so far and you haven't checked what I've told you to.
I can't help you more with dialupadmin as I am not aware of its
common configuration issues, if daloradius is an appropriate
alternative for you I will be happy to assist you with it.
Regards,
Liran Tal.
>
> 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
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080130/6d960329/attachment.html>
More information about the Freeradius-Users
mailing list