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

[Ali Jawad]

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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20061102/61ce5b04/attachment.html>