to me no exist /etc/raddb/sql/mysql only ....raddb/<br><br>[root@localhost ~]# cd /etc/raddb/<br>[root@localhost raddb]# ls<br>acct_users clients.conf hints naslist preproxy_users snmp.conf x99passwd.sample<br>
attrs dictionary huntgroups naspasswd proxy.conf sql.conf<br>certs eap.conf ldap.attrmap oraclesql.conf radiusd.conf users<br>clients experimental.conf mssql.conf postgresql.conf realms x99.conf<br>
<br>you no have this files? to can make the tables to the db of dialup_admin?<br><br>thanks<br><br><div class="gmail_quote">On Thu, Apr 30, 2009 at 2:02 PM, Chris Moules <span dir="ltr"><<a href="mailto:chris@gms.lu">chris@gms.lu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Then look in the Freeradius configuration folder (as stated before), not<br>
the dialup_admin one.<br>
<br>
By default I believe this is: /etc/raddb/sql/mysql/<br>
On Debian, which I use, it is: /etc/freeradius/... not /etc/raddb/...<br>
<br>
Chris<br>
<div class="im"><br>
Roger Ham wrote:<br>
> i haved installed the radius, beleive<br>
><br>
> [root@localhost sql]# /etc/init.d/radiusd status<br>
> radiusd (pid 6519) is running..<br>
><br>
> [root@localhost freeradius-server-2.1.4]# netstat -nulp<br>
> Active Internet connections (only servers)<br>
> Proto Recv-Q Send-Q Local Address Foreign<br>
> Address State PID/Program name<br>
</div>> udp 0 0 <a href="http://0.0.0.0:1812" target="_blank">0.0.0.0:1812</a> <<a href="http://0.0.0.0:1812" target="_blank">http://0.0.0.0:1812</a>><br>
<div class="im">> 0.0.0.0:* 6519/radiusd<br>
</div>> udp 0 0 <a href="http://0.0.0.0:1813" target="_blank">0.0.0.0:1813</a> <<a href="http://0.0.0.0:1813" target="_blank">http://0.0.0.0:1813</a>><br>
<div class="im">> 0.0.0.0:* 6519/radiusd<br>
</div>> udp 0 0 <a href="http://0.0.0.0:1814" target="_blank">0.0.0.0:1814</a> <<a href="http://0.0.0.0:1814" target="_blank">http://0.0.0.0:1814</a>><br>
<div class="im">> 0.0.0.0:* 6519/radiusd<br>
><br>
> what more can try to create the other tables of the bd radius.<br>
><br>
> thanks<br>
><br>
> On Thu, Apr 30, 2009 at 1:09 PM, Chris Moules <<a href="mailto:chris@gms.lu">chris@gms.lu</a><br>
</div><div class="im">> <mailto:<a href="mailto:chris@gms.lu">chris@gms.lu</a>>> wrote:<br>
><br>
> It sound like you have just installed or downloaded the 'dialup_admin'<br>
> package and not the freeradius one.<br>
><br>
> 'dialup_admin' is part of the freeeradius package but is 'just' the web<br>
> based administration interface. You also _need_ the freeradius system to<br>
> administer.<br>
><br>
> <<a href="http://wiki.freeradius.org/index.php/Dialup_admin" target="_blank">http://wiki.freeradius.org/index.php/Dialup_admin</a>><br>
><br>
> Chris<br>
><br>
> Roger Ham wrote:<br>
> > thanks for you help.<br>
> ><br>
> > i am use: centos 4.7<br>
> ><br>
> > [root@localhost dialup_admin]# ls<br>
> > AUTHORS bin Changelog conf FAQ HELP_WANTED htdocs html lib<br>
> > README sql TODO<br>
> > [root@localhost dialup_admin]# pwd<br>
> > /usr/local/dialup_admin<br>
> ><br>
> > and i am have just this .sql to make the tables<br>
> ><br>
> > [root@localhost sql]# ls<br>
> > badusers.sql mtotacct.sql totacct.sql userinfo.sql<br>
> ><br>
> > thanks and so sorry for my bad english<br>
> ><br>
> ><br>
> > On Thu, Apr 30, 2009 at 12:55 PM, Chris Moules <<a href="mailto:chris@gms.lu">chris@gms.lu</a><br>
> <mailto:<a href="mailto:chris@gms.lu">chris@gms.lu</a>><br>
</div><div><div></div><div class="h5">> > <mailto:<a href="mailto:chris@gms.lu">chris@gms.lu</a> <mailto:<a href="mailto:chris@gms.lu">chris@gms.lu</a>>>> wrote:<br>
> ><br>
> > Depending on where you got your freeradius and where you<br>
> installed it,<br>
> > the DB schema should be included.<br>
> ><br>
> > Check something like: /etc/raddb/sql/mysql/schema.sql<br>
> ><br>
> > Chris<br>
> ><br>
> > Roger Ham wrote:<br>
> > > hi all<br>
> > ><br>
> > > i am from honduras and i am try of use the dialup_admin to<br>
> freeradius.<br>
> > ><br>
> > > and i was run with phpMyadmin the tables to the BD<br>
> dialup_admin, but<br>
> > > some pages this show me this messages:<br>
> > ><br>
> > > Database query failed: Table 'radius.radacct' doesn't exist<br>
> > > Database query failed: Table 'radius.usergroup' doesn't exist<br>
> > > Database query failed: Table 'radius.radgroupcheck' doesn't<br>
> exist<br>
> > ><br>
> > > how or when can find the structure of the tables for this db?<br>
> > ><br>
> > > thanks and so sorry for my bad english.<br>
> > ><br>
> > > --<br>
> > > Saludos!<br>
> > > roghax85<br>
> > ><br>
> > ><br>
> > ><br>
> ><br>
> ------------------------------------------------------------------------<br>
> > ><br>
> > > -<br>
> > > List info/subscribe/unsubscribe? See<br>
> > <a href="http://www.freeradius.org/list/devel.html" target="_blank">http://www.freeradius.org/list/devel.html</a><br>
> > -<br>
> > List info/subscribe/unsubscribe? See<br>
> > <a href="http://www.freeradius.org/list/devel.html" target="_blank">http://www.freeradius.org/list/devel.html</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Saludos!<br>
> ><br>
> > Atte.<br>
> > Roger Ham<br>
</div></div>> > <a href="http://www.rogha.info" target="_blank">www.rogha.info</a> <<a href="http://www.rogha.info" target="_blank">http://www.rogha.info</a>> <<a href="http://www.rogha.info" target="_blank">http://www.rogha.info</a>><br>
<div><div></div><div class="h5">> ><br>
> ><br>
> ><br>
> ------------------------------------------------------------------------<br>
> ><br>
> > -<br>
> > List info/subscribe/unsubscribe? See<br>
> <a href="http://www.freeradius.org/list/devel.html" target="_blank">http://www.freeradius.org/list/devel.html</a><br>
><br>
> -<br>
> List info/subscribe/unsubscribe? See<br>
> <a href="http://www.freeradius.org/list/devel.html" target="_blank">http://www.freeradius.org/list/devel.html</a><br>
><br>
><br>
><br>
><br>
> --<br>
> Saludos!<br>
><br>
> Atte.<br>
> Roger Ham<br>
> <a href="http://www.rogha.info" target="_blank">www.rogha.info</a> <<a href="http://www.rogha.info" target="_blank">http://www.rogha.info</a>><br>
><br>
><br>
> ------------------------------------------------------------------------<br>
><br>
> -<br>
> List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/devel.html" target="_blank">http://www.freeradius.org/list/devel.html</a><br>
-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/devel.html" target="_blank">http://www.freeradius.org/list/devel.html</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Saludos!<br><br>Atte.<br>Roger Ham<br><a href="http://www.rogha.info">www.rogha.info</a><br>