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

John Longland jlongland at
Thu Nov 2 11:27:27 CET 2006


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
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:

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

Hope this helps


-----Original Message-----
From: at
[ at lists.freeradius.
org]On Behalf Of Dusan Djordjevic Liste
Sent: 02 November 2006 12:06
To: freeradius-users at
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 ?


List info/subscribe/unsubscribe? See
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Freeradius-Users mailing list