cannot connect to sql databse

Devinder Singh devinbhullar at gmail.com
Tue Jan 29 04:06:04 CET 2008


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.


Regards
Devinder


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080129/66837d77/attachment.html>


More information about the Freeradius-Users mailing list