It sound like you have just installed or downloaded the 'dialup_admin' package and not the freeradius one. 'dialup_admin' is part of the freeeradius package but is 'just' the web based administration interface. You also _need_ the freeradius system to administer. <http://wiki.freeradius.org/index.php/Dialup_admin> Chris Roger Ham wrote:

thanks for you help.

i am use: centos 4.7

[root@localhost dialup_admin]# ls AUTHORS bin Changelog conf FAQ HELP_WANTED htdocs html lib README sql TODO [root@localhost dialup_admin]# pwd /usr/local/dialup_admin

and i am have just this .sql to make the tables

[root@localhost sql]# ls badusers.sql mtotacct.sql totacct.sql userinfo.sql

thanks and so sorry for my bad english

On Thu, Apr 30, 2009 at 12:55 PM, Chris Moules <chris@gms.lu <mailto:chris@gms.lu>> wrote:

Depending on where you got your freeradius and where you installed it, the DB schema should be included.

Check something like: /etc/raddb/sql/mysql/schema.sql

Chris

Roger Ham wrote: > hi all > > i am from honduras and i am try of use the dialup_admin to freeradius. > > and i was run with phpMyadmin the tables to the BD dialup_admin, but > some pages this show me this messages: > > Database query failed: Table 'radius.radacct' doesn't exist > Database query failed: Table 'radius.usergroup' doesn't exist > Database query failed: Table 'radius.radgroupcheck' doesn't exist > > how or when can find the structure of the tables for this db? > > thanks and so sorry for my bad english. > > -- > Saludos! > roghax85 > > > ------------------------------------------------------------------------ > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html

-- Saludos!

Atte. Roger Ham www.rogha.info <http://www.rogha.info>

------------------------------------------------------------------------

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

Then look in the Freeradius configuration folder (as stated before), not the dialup_admin one. By default I believe this is: /etc/raddb/sql/mysql/ On Debian, which I use, it is: /etc/freeradius/... not /etc/raddb/... Chris Roger Ham wrote:

i haved installed the radius, beleive

[root@localhost sql]# /etc/init.d/radiusd status radiusd (pid 6519) is running..

[root@localhost freeradius-server-2.1.4]# netstat -nulp Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name udp 0 0 0.0.0.0:1812 <http://0.0.0.0:1812> 0.0.0.0:* 6519/radiusd udp 0 0 0.0.0.0:1813 <http://0.0.0.0:1813> 0.0.0.0:* 6519/radiusd udp 0 0 0.0.0.0:1814 <http://0.0.0.0:1814> 0.0.0.0:* 6519/radiusd

what more can try to create the other tables of the bd radius.

thanks

On Thu, Apr 30, 2009 at 1:09 PM, Chris Moules <chris@gms.lu <mailto:chris@gms.lu>> wrote:

It sound like you have just installed or downloaded the 'dialup_admin' package and not the freeradius one.

'dialup_admin' is part of the freeeradius package but is 'just' the web based administration interface. You also _need_ the freeradius system to administer.

<http://wiki.freeradius.org/index.php/Dialup_admin>

Chris

Roger Ham wrote: > thanks for you help. > > i am use: centos 4.7 > > [root@localhost dialup_admin]# ls > AUTHORS bin Changelog conf FAQ HELP_WANTED htdocs html lib > README sql TODO > [root@localhost dialup_admin]# pwd > /usr/local/dialup_admin > > and i am have just this .sql to make the tables > > [root@localhost sql]# ls > badusers.sql mtotacct.sql totacct.sql userinfo.sql > > thanks and so sorry for my bad english > > > On Thu, Apr 30, 2009 at 12:55 PM, Chris Moules <chris@gms.lu <mailto:chris@gms.lu> > <mailto:chris@gms.lu <mailto:chris@gms.lu>>> wrote: > > Depending on where you got your freeradius and where you installed it, > the DB schema should be included. > > Check something like: /etc/raddb/sql/mysql/schema.sql > > Chris > > Roger Ham wrote: > > hi all > > > > i am from honduras and i am try of use the dialup_admin to freeradius. > > > > and i was run with phpMyadmin the tables to the BD dialup_admin, but > > some pages this show me this messages: > > > > Database query failed: Table 'radius.radacct' doesn't exist > > Database query failed: Table 'radius.usergroup' doesn't exist > > Database query failed: Table 'radius.radgroupcheck' doesn't exist > > > > how or when can find the structure of the tables for this db? > > > > thanks and so sorry for my bad english. > > > > -- > > Saludos! > > roghax85 > > > > > > > ------------------------------------------------------------------------ > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/devel.html > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/devel.html > > > > > -- > Saludos! > > Atte. > Roger Ham > www.rogha.info <http://www.rogha.info> <http://www.rogha.info> > > > ------------------------------------------------------------------------ > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html

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

-- Saludos!

Atte. Roger Ham www.rogha.info <http://www.rogha.info>

------------------------------------------------------------------------

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

Firstly, this is not really a 'developer' question. This type of thing belongs on the '-users' list. Humm, looks like the packaging for the CentOS Freeradius is quite different to that that I know. If you can list the files in a package, try that. It could be that they are included as part of the 'documentation' (/use/share/doc/?). If all else fails, download the source tarball from the freeradius website. That will include your schema.sql. Chris Roger Ham wrote:

to me no exist /etc/raddb/sql/mysql only ....raddb/

[root@localhost ~]# cd /etc/raddb/ [root@localhost raddb]# ls acct_users clients.conf hints naslist preproxy_users snmp.conf x99passwd.sample attrs dictionary huntgroups naspasswd proxy.conf sql.conf certs eap.conf ldap.attrmap oraclesql.conf radiusd.conf users clients experimental.conf mssql.conf postgresql.conf realms x99.conf

you no have this files? to can make the tables to the db of dialup_admin?

thanks

On Thu, Apr 30, 2009 at 2:02 PM, Chris Moules <chris@gms.lu <mailto:chris@gms.lu>> wrote:

Then look in the Freeradius configuration folder (as stated before), not the dialup_admin one.

By default I believe this is: /etc/raddb/sql/mysql/ On Debian, which I use, it is: /etc/freeradius/... not /etc/raddb/...

Chris

Roger Ham wrote: > i haved installed the radius, beleive > > [root@localhost sql]# /etc/init.d/radiusd status > radiusd (pid 6519) is running.. > > [root@localhost freeradius-server-2.1.4]# netstat -nulp > Active Internet connections (only servers) > Proto Recv-Q Send-Q Local Address Foreign > Address State PID/Program name > udp 0 0 0.0.0.0:1812 <http://0.0.0.0:1812> <http://0.0.0.0:1812> > 0.0.0.0:* 6519/radiusd > udp 0 0 0.0.0.0:1813 <http://0.0.0.0:1813> <http://0.0.0.0:1813> > 0.0.0.0:* 6519/radiusd > udp 0 0 0.0.0.0:1814 <http://0.0.0.0:1814> <http://0.0.0.0:1814> > 0.0.0.0:* 6519/radiusd > > what more can try to create the other tables of the bd radius. > > thanks > > On Thu, Apr 30, 2009 at 1:09 PM, Chris Moules <chris@gms.lu <mailto:chris@gms.lu> > <mailto:chris@gms.lu <mailto:chris@gms.lu>>> wrote: > > It sound like you have just installed or downloaded the 'dialup_admin' > package and not the freeradius one. > > 'dialup_admin' is part of the freeeradius package but is 'just' the web > based administration interface. You also _need_ the freeradius system to > administer. > > <http://wiki.freeradius.org/index.php/Dialup_admin> > > Chris > > Roger Ham wrote: > > thanks for you help. > > > > i am use: centos 4.7 > > > > [root@localhost dialup_admin]# ls > > AUTHORS bin Changelog conf FAQ HELP_WANTED htdocs html lib > > README sql TODO > > [root@localhost dialup_admin]# pwd > > /usr/local/dialup_admin > > > > and i am have just this .sql to make the tables > > > > [root@localhost sql]# ls > > badusers.sql mtotacct.sql totacct.sql userinfo.sql > > > > thanks and so sorry for my bad english > > > > > > On Thu, Apr 30, 2009 at 12:55 PM, Chris Moules <chris@gms.lu <mailto:chris@gms.lu> > <mailto:chris@gms.lu <mailto:chris@gms.lu>> > > <mailto:chris@gms.lu <mailto:chris@gms.lu> <mailto:chris@gms.lu <mailto:chris@gms.lu>>>> wrote: > > > > Depending on where you got your freeradius and where you > installed it, > > the DB schema should be included. > > > > Check something like: /etc/raddb/sql/mysql/schema.sql > > > > Chris > > > > Roger Ham wrote: > > > hi all > > > > > > i am from honduras and i am try of use the dialup_admin to > freeradius. > > > > > > and i was run with phpMyadmin the tables to the BD > dialup_admin, but > > > some pages this show me this messages: > > > > > > Database query failed: Table 'radius.radacct' doesn't exist > > > Database query failed: Table 'radius.usergroup' doesn't exist > > > Database query failed: Table 'radius.radgroupcheck' doesn't > exist > > > > > > how or when can find the structure of the tables for this db? > > > > > > thanks and so sorry for my bad english. > > > > > > -- > > > Saludos! > > > roghax85 > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > - > > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/devel.html > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/devel.html > > > > > > > > > > -- > > Saludos! > > > > Atte. > > Roger Ham > > www.rogha.info <http://www.rogha.info> <http://www.rogha.info> <http://www.rogha.info> > > > > > > > ------------------------------------------------------------------------ > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/devel.html > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/devel.html > > > > > -- > Saludos! > > Atte. > Roger Ham > www.rogha.info <http://www.rogha.info> <http://www.rogha.info> > > > ------------------------------------------------------------------------ > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html

-- Saludos!

Atte. Roger Ham www.rogha.info <http://www.rogha.info>

------------------------------------------------------------------------

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