<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2658.24">
<TITLE>RE: Database query failed: Table 'radius.radcheck' doesn't exist</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Dusan</FONT>
</P>
<P><FONT SIZE=2>1. I assume you did run the db_sql_mysql.sql script to create the database schema ??</FONT>
<BR><FONT SIZE=2>This will create the majority of the schema. </FONT>
</P>
<P><FONT SIZE=2>2. Did you run the sql-scripts in /usr/local/dialup_admin/sql ?</FONT>
<BR><FONT SIZE=2>They are executed in a similar fashion.</FONT>
</P>
<P><FONT SIZE=2>Note: In my case , I got error messages when executing some of these scripts.</FONT>
<BR><FONT SIZE=2>What I did was to remove the "DEFAULT '0'" from the scripts that failed.</FONT>
</P>
<P><FONT SIZE=2>You execute a script as follows:</FONT>
</P>
<P><FONT SIZE=2>First you log into mysql :</FONT>
<BR><FONT SIZE=2>mysql -uroot -p<password></FONT>
</P>
<P><FONT SIZE=2>Then you create the database:</FONT>
<BR><FONT SIZE=2>CREATE DATABASE radius;</FONT>
</P>
<P><FONT SIZE=2>Then execute the script:</FONT>
<BR><FONT SIZE=2>mysql -uroot -p<rootpassword> radius < db_sql_mysql.sql</FONT>
</P>
<P><FONT SIZE=2>Hope this helps</FONT>
</P>
<P><FONT SIZE=2>John</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From:</FONT>
<BR><FONT SIZE=2>freeradius-users-bounces+jlongland=grintek.com@lists.freeradius.org</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:freeradius-users-bounces+jlongland=grintek.com@lists.freeradius">mailto:freeradius-users-bounces+jlongland=grintek.com@lists.freeradius</A>.</FONT>
<BR><FONT SIZE=2>org]On Behalf Of Dusan Djordjevic Liste</FONT>
<BR><FONT SIZE=2>Sent: 02 November 2006 12:06</FONT>
<BR><FONT SIZE=2>To: freeradius-users@lists.freeradius.org</FONT>
<BR><FONT SIZE=2>Subject: Database query failed: Table 'radius.radcheck' doesn't exist</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi all,</FONT>
</P>
<P><FONT SIZE=2>I am trying to install dialup admin. I followed HOWTO located in doc/</FONT>
<BR><FONT SIZE=2>directory. I created all tables in radius database using provided .sql</FONT>
<BR><FONT SIZE=2>files in sql/ dir. Now i have 4 tables in radius database: badusers,</FONT>
<BR><FONT SIZE=2>mtotacct, totacct, userinfo.</FONT>
</P>
<P><FONT SIZE=2>When I connect to dialup admin and try to create new user, it gives me</FONT>
<BR><FONT SIZE=2>following error:</FONT>
</P>
<P><FONT SIZE=2>Database query failed: Table 'radius.radcheck' doesn't exist</FONT>
<BR><FONT SIZE=2>(after bunch of error messages that some queries and inserts are not valid).</FONT>
</P>
<P><FONT SIZE=2>I am not good with databases, but AFAIK this means that there is no</FONT>
<BR><FONT SIZE=2>radcheck table in radius database. Also, if i understand admin.conf</FONT>
<BR><FONT SIZE=2>properly, there is part that sayst following:</FONT>
</P>
<P><FONT SIZE=2>sql_database: radius</FONT>
<BR><FONT SIZE=2>sql_accounting_table: radacct</FONT>
<BR><FONT SIZE=2>sql_badusers_table: badusers</FONT>
<BR><FONT SIZE=2>sql_check_table: radcheck</FONT>
<BR><FONT SIZE=2>sql_reply_table: radreply</FONT>
<BR><FONT SIZE=2>sql_user_info_table: userinfo</FONT>
<BR><FONT SIZE=2>sql_groupcheck_table: radgroupcheck</FONT>
<BR><FONT SIZE=2>sql_groupreply_table: radgroupreply</FONT>
<BR><FONT SIZE=2>sql_usergroup_table: usergroup</FONT>
<BR><FONT SIZE=2>sql_total_accounting_table: totacct</FONT>
<BR><FONT SIZE=2>sql_nas_table: nas</FONT>
</P>
<P><FONT SIZE=2>Also lot of tables mentioned here do not exist.</FONT>
</P>
<P><FONT SIZE=2>Did I missed something or ?</FONT>
</P>
<P><FONT SIZE=2>TIA</FONT>
<BR><FONT SIZE=2>Dusan</FONT>
<BR><FONT SIZE=2><A HREF="http://dj-dule.blogspot.com" TARGET="_blank">http://dj-dule.blogspot.com</A></FONT>
</P>
<BR>
<P><FONT SIZE=2>- </FONT>
<BR><FONT SIZE=2>List info/subscribe/unsubscribe? See <A HREF="http://www.freeradius.org/list/users.html" TARGET="_blank">http://www.freeradius.org/list/users.html</A></FONT>
</P>
</BODY>
</HTML>