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:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED].
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
