Database query failed: Table 'radius.radcheck' doesn't exist

[John Longland]

Dusan

1. I assume you did run the db_sql_mysql.sql  script to create the database
schema ??
This will create the majority of the schema. 

2. Did you run the sql-scripts in /usr/local/dialup_admin/sql ?
They are executed in a similar fashion.

Note: In my case , I got error messages when executing some of these
scripts.
What I did was to remove the "DEFAULT '0'" from the scripts that failed.

You execute a script as follows:

First you log into mysql :
mysql -uroot -p<password>

Then you create the database:
CREATE DATABASE radius;

Then execute the script:
mysql -uroot -p<rootpassword> radius < db_sql_mysql.sql

Hope this helps

John

-----Original Message-----
From:
freeradius-users-bounces+jlongland=grintek.com at lists.freeradius.org
[mailto:freeradius-users-bounces+jlongland=grintek.com at lists.freeradius.
org]On Behalf Of Dusan Djordjevic Liste
Sent: 02 November 2006 12:06
To: freeradius-users at lists.freeradius.org
Subject: Database query failed: Table 'radius.radcheck' doesn't exist


Hi all,

I am trying to install dialup admin. I followed HOWTO located in doc/
directory. I created all tables in radius database using provided .sql
files in sql/ dir. Now i have 4 tables in radius database: badusers,
mtotacct, totacct, userinfo.

When I connect to dialup admin and try to create new user, it gives me
following error:

Database query failed: Table 'radius.radcheck' doesn't exist
(after bunch of error messages that some queries and inserts are not valid).

I am not good with databases, but AFAIK this means that there is no
radcheck table in radius database. Also, if i understand admin.conf
properly, there is part that sayst following:

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
sql_total_accounting_table: totacct
sql_nas_table: nas

Also lot of tables mentioned here do not exist.

Did I missed something or ?

TIA
Dusan
http://dj-dule.blogspot.com


- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20061102/4c6c0605/attachment.html>