RE: Database query failed: Table 'radius.radcheck' doesn't exist
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@lists.freeradius.org [mailto:freeradius-users-bounces+jlongland=grintek.com@lists.freeradius. org]On Behalf Of Dusan Djordjevic Liste Sent: 02 November 2006 12:06 To: freeradius-users@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
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
I did exactly the same and it helped me. Thank you for very good answer. Dusan http://dj-dule.blogspot.com
participants (2)
-
Dusan Djordjevic Liste -
John Longland