help with dialup_admin

Chris Moules chris at gms.lu
Thu Apr 30 22:12:20 CEST 2009


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 at localhost ~]# cd /etc/raddb/
> [root at 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 at gms.lu
> <mailto:chris at 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 at localhost sql]# /etc/init.d/radiusd status
>     > radiusd (pid 6519) is running..
>     >
>     > [root at 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 at gms.lu
>     <mailto:chris at gms.lu>
>     > <mailto:chris at gms.lu <mailto:chris at 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 at localhost dialup_admin]# ls
>     >     > AUTHORS  bin  Changelog  conf  FAQ  HELP_WANTED  htdocs
>      html  lib
>     >     > README  sql  TODO
>     >     > [root at localhost dialup_admin]# pwd
>     >     > /usr/local/dialup_admin
>     >     >
>     >     > and i am have just this .sql to make the tables
>     >     >
>     >     > [root at 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 at gms.lu
>     <mailto:chris at gms.lu>
>     >     <mailto:chris at gms.lu <mailto:chris at gms.lu>>
>     >     > <mailto:chris at gms.lu <mailto:chris at gms.lu>
>     <mailto:chris at gms.lu <mailto:chris at 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



More information about the Freeradius-Devel mailing list