<div>Hi Liran</div>
<div> </div>
<div>The exact error message on Dial Up Admin is </div>
<div> </div>
<div>cannot connec to sql database.</div>
<div> </div>
<div>Rgds</div>
<div>Devinder<br><br> </div>
<div><span class="gmail_quote">On 29/01/2008, <b class="gmail_sendername">Liran Tal</b> <<a href="mailto:liran@enginx.com">liran@enginx.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hey Devinder,<br><br>
<div class="gmail_quote"><span class="q">On Jan 29, 2008 9:41 AM, Devinder Singh <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:devinbhullar@gmail.com" target="_blank">devinbhullar@gmail.com</a>> wrote:<br>
</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>Hi Liran</div>
<div> </div><span class="q">
<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 class="sg">Liran Tal.<br><br><br> </span></div>
<div><span class="e" id="q_117c4bb7bc4a5110_7">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><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 onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:liransgarage@gmail.com" target="_blank">liransgarage@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hey Devinder,<br><br>
<div class="gmail_quote">
<div><span>On Jan 29, 2008 5:06 AM, Devinder Singh <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:devinbhullar@gmail.com" target="_blank">devinbhullar@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">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="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>
<div><br><br><br>
<div><span class="gmail_quote">On 28/01/2008, <b class="gmail_sendername">Devinder Singh</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:devinbhullar@gmail.com" target="_blank">devinbhullar@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<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 onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:liran@enginx.com" target="_blank">liran@enginx.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hey Devinder,<br><br>
<div class="gmail_quote"><span>On Jan 28, 2008 8:44 AM, Devinder Singh <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:devinbhullar@gmail.com" target="_blank">devinbhullar@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<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="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><br>
<div> </div>
<div>
<div><span class="gmail_quote">On 28/01/2008, <b class="gmail_sendername">liran tal</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:liransgarage@gmail.com" target="_blank">liransgarage@gmail.com</a>> wrote:</span> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>
<div></div>
<div><br>Hey Devinder,<br><br>
<div class="gmail_quote"><span>On Jan 28, 2008 4:35 AM, Devinder Singh <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:devinbhullar@gmail.com" target="_blank">devinbhullar@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><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 onclick="return top.js.OpenExtLink(window,event,this)" href="http://sourceforge.net/projects/daloradius/" target="_blank">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 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> </div>
</blockquote></div><br><br clear="all"><br>-- <br><font color="#888888">Devinder </font><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></span></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 </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 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></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 </div></div><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></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