Well Ive tried dialupadmin..apart from the fact that it might be troubleling to set up...it worked just fine for me..I used it to authenicate ISP clients through pppoe..and to Dusan..as Vasea said...find the .sql file containing the tables for freeradius and import them using phpmyadmin or the mysql shell. On 11/2/06, Vasea Marii <vascim@yahoo.com> wrote:

radcheck is one of the most important tables in freeradius if working with mysql! Is the table where users username, passwors and other data is stored for authenticating users when they are connecting!find! In you freeradius distribution find mysql.sql file and create the tables that are missing! By the way dialup-admin has a lot of bugs! You'll have a lot of work:)try phpmyprepaid!

*Dusan Djordjevic Liste <dj.dule.lists@gmail.com>* wrote:

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

------------------------------ Get your email and see which of your friends are online - Right on the new Yahoo.com <http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview>

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- With Regards Ali Jawad

Vasea Marii wrote:

radcheck is one of the most important tables in freeradius if working with mysql! Is the table where users username, passwors and other data is stored for authenticating users when they are connecting!find! In you freeradius distribution find mysql.sql file and create the tables that are missing! By the way dialup-admin has a lot of bugs! You'll have a lot of work:)try phpmyprepaid!

Thank you very much for response. I will check phpmyprepaid. btw. I am trying to sort out solution for VoIP termination, that is why I need radius. Can someone recommend me good software for that. It should work on Red Hat Enterprise Linux and support freeradius. TIA Dusan http://dj-dule.blogspot.com