daloRADIUS errors after following AAA on Centos tutorial

Discussion in 'HOWTO-Related Questions' started by luke240778, May 25, 2011.

  1. luke240778

    luke240778 New Member

    i just followed through this tutorial:
    http://www.howtoforge.com/authentic...ckend-and-webbased-management-with-daloradius

    Followed it exactly. I am using a different version of daloradius. 0-9.9 rather that 0-9.7 as in the tutorial, but there were just a couple things that needed to be changed in daloradius.conf.php to get it to work.

    My problem is this, when i go to 'Users' and then 'List Users' in daloRADIUS, i get the following error:

    Database error
    Error Message: DB Error: no such table
    Debug info: SELECT * FROM operators_acl WHERE operator_id='1' AND file='mng_list_all' [nativecode=1146 ** Table 'radiusdb.operators_acl' doesn't exist]

    Can anyone tell me why? This tutorial didnt mention needing to create any tables, just to import the schema from the downloaded file which i did.. Then i did a SHOW TABLES; in mysql and see the following:

    mysql> show tables;
    +--------------------+
    | Tables_in_radiusdb |
    +--------------------+
    | dictionary |
    | hotspots |
    | nas |
    | operators |
    | proxys |
    | radacct |
    | radcheck |
    | radgroupcheck |
    | radgroupreply |
    | radippool |
    | radpostauth |
    | radreply |
    | radusergroup |
    | rates |
    | realms |
    | userinfo |
    +--------------------+
    16 rows in set (0.00 sec)

    So, whats wrong? where did somehow tables not get installed or something ? My knowledge of all this is low, hence the reason following the tutorial. I would really appreciate some assistance with this. thanks in advance!
     
  2. Paricitoi

    Paricitoi New Member

    It seems you are missing other tables. Here is a listing of mine:
    mysql> show tables;
    +------------------------+
    | Tables_in_radius |
    +------------------------+
    | batch_history |
    | billing_history |
    | billing_merchant |
    | billing_paypal |
    | billing_plans |
    | billing_plans_profiles |
    | billing_rates |
    | dictionary |
    | hotspots |
    | invoice |
    | invoice_items |
    | invoice_status |
    | invoice_type |
    | nas |
    | node |
    | operators |
    | operators_acl |
    | operators_acl_files |
    | payment |
    | payment_type |
    | proxys |
    | radacct |
    | radcheck |
    | radgroupcheck |
    | radgroupreply |
    | radpostauth |
    | radreply |
    | radusergroup |
    | realms |
    | userbillinfo |
    | userinfo |
    +------------------------+
    31 rows in set (0.00 sec)

    I am using the same dal version as you. Debian instead of Centos but it shouldn't matter since the schema for the creation of the tables should be the same.
     

Share This Page