Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th May 2011, 03:27
luke240778 luke240778 is offline
Junior Member
 
Join Date: Jan 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default daloRADIUS errors after following AAA on Centos tutorial

i just followed through this tutorial:
http://www.howtoforge.com/authentica...ith-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!
Reply With Quote
Sponsored Links
  #2  
Old 5th June 2011, 14:33
Paricitoi Paricitoi is offline
Junior Member
 
Join Date: Jun 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems connecting my HTC Desire outgoing mail client to Postfix and ISP Config 2 j.smith1981 Server Operation 6 12th July 2010 19:07
ISPconfig3 login not presented after Perfect Server tutorial CentOS 5.5 sdoradus HOWTO-Related Questions 2 20th June 2010 04:58
Fedora 10 - Virtual Users And Domains With Postfix, Courier etc j.smith1981 Server Operation 6 17th February 2010 01:01
Errors installing CentOS 5.3 kevin.cousins Installation/Configuration 3 24th August 2009 07:07
Centos 5.2 + ISPConfig 3 tutorial - Problem with email tanakskool Server Operation 1 3rd June 2009 16:22


All times are GMT +2. The time now is 18:53.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.