I am currently running Suse 10.x Linux with Freeradius 1.0.4-42., dailupAdmin 2.7, and apache2. I believe I have everything installed correctly as I can check my info.php page, phpmyadmin, and dialupadmin. Freeradius also rejects my request so I know it is running and working. Here is my issue I am having.; I am also very new the linux/sql/php world fyi. My tables currently under the Radius Database that I have created are as follows: badusers mtotacct totacct userinfo I added these tables via the phpMyadmin located in /srv/www/dialup_admin/sql All tables seem to work via the webgui in dialup admin. However, I am still getting errors on Statistics and Failed Users. * "Database query failed: Table 'radius.radacct' doesn't exit." Also if I try to create a user or new group I get : "Database query failed: Table 'radius.usergroup' doesn't exit." "Database query failed: Table 'radius.radgroupcheck' doesn't exit." I have tried looking for where I setup these tables and values with no luck. I read somewhere that there is a script for automatically generating these tables but I did not reference where the script was. I have tried looking in the /var/log/radius/radacct but not files are in here. I'm assuming once it reads the table this is where the info logs are stored. Do I need to generate another table for the rest of the tables ? If so what are the values needed for this .sql file. I have tried searching for any information on how to create these tables with little luck on how to create this table and values needed. I also could not find any how-tos on how to make these tables. It seems from everything I read that these files should already be there. Thank you for your time to read this and help. Eric eric@linkednetworks.com
Eric Hilden wrote:
My tables currently under the Radius Database that I have created are as follows:
badusers mtotacct totacct userinfo
Why would you expect FreeRADIUS even look at those tables unless you tell it to?
"Database query failed: Table 'radius.radacct' doesn't exit."
Yep, that would be the default accounting table.
Also if I try to create a user or new group I get :
"Database query failed: Table 'radius.usergroup' doesn't exit." "Database query failed: Table 'radius.radgroupcheck' doesn't exit."
....more default tables.
I have tried looking for where I setup these tables and values with no luck. I read somewhere that there is a script for automatically generating these tables but I did not reference where the script was.
Sample SQL scripts to create the tables is included in the source. If suse included it in the rpms, it would probably be in /usr/share someplace. You may want to look at /etc/raddb/sql.conf to try to understand what FreeRADIUS is trying to do with mysql. I wouldn't change it though unless you *really* understand what you are doing. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com
"Database query failed: Table 'radius.radacct' doesn't exit." "Database query failed: Table 'radius.usergroup' doesn't exit." "Database query failed: Table 'radius.radgroupcheck' doesn't exit."
I have tried looking for where I setup these tables and values with no luck. I read somewhere that there is a script for automatically generating these tables but I did not reference where the script was.
Yes you are right, there is an sql-script to generate those tables On my box (FreeRADIUS Version 1.1.1,) it can be found under /usr/local/share/doc/freeradius/examples/mysql.sql It should generate the following tables +------------------+ | Tables_in_radius | +------------------+ | nas | | radacct | | radcheck | | radgroupcheck | | radgroupreply | | radpostauth | | radreply | | usergroup | +------------------+ thomas
participants (3)
-
Dennis Skinner -
Eric Hilden -
thomas.pudil＠t-mobile.at