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