Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote:
> > >
> > > Hey Devinder,
> > >
> > > On Jan 28, 2008 8:44 AM, Devinder Singh <[EMAIL PROTECTED]>
> > > 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 <[EMAIL PROTECTED]> wrote:
> > > >
> > > > >
> > > > > Hey Devinder,
> > > > >
> > > > > On Jan 28, 2008 4:35 AM, Devinder Singh <[EMAIL PROTECTED]>
> > > > > 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
