@Kostas
I'm still trying to get this work. Now I get closer to the problem.
have a look at "show_groups.php3". Everything is fine until line 64.
while( $row = @da_sql_fetch_array($search,$config) ){
$row returns 0 on my server, altough there are 6 rows. Even the debug result
says there are 6 row's.
function @da_sql_fetch_array is using a function called
array_change_key_case
Is this a problem with our PHP version ? We have 4.1.2
best rgds
-Karel
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stadler
Karel
Sent: Donnerstag, 8. Juli 2004 14:44
To: '[EMAIL PROTECTED]'
Subject: RE: Dialup Admin - Can't see any mysql record
I download and used the snippet from 2004-07-08 adjusted the config. No
success so far.
Version we use:
Apache/1.3.23
mysql Ver 11.16 Distrib 3.23.49
By the way, still got
Fatal error: Cannot redeclare xlat() in
/opt/radius/dialup_admin/lib/xlat.php3 on line 2
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kostas
Kalevras
Sent: Donnerstag, 8. Juli 2004 13:54
To: '[EMAIL PROTECTED]'
Subject: RE: Dialup Admin - Can't see any mysql record
On Thu, 8 Jul 2004, Stadler Karel wrote:
> It happens with all pages.
>
> This is the sql_debug if one presses "Show Groups": DEBUG(SQL,MYSQL
> DRIVER): Query: SELECT COUNT(*) as counter,groupname FROM usergroup
> GROUP BY groupname; DEBUG(SQL,MYSQL DRIVER): Query Result: Num rows::
> 6
>
> But there is nothing on the page.
I 've tested the CVS version myself and it works just fine. So try checking
your configuration again. What is our installation (mysql,apache versions?)
>
> Also, when pressing "Online Users" I get:
> DEBUG(SQL,MYSQL DRIVER): Query: SELECT * FROM nas ;
>
> Fatal error: Cannot redeclare xlat() in
> /opt/radius/dialup_admin/lib/xlat.php3 on line 2
Those problems have been fixed in the CVS. Thanks a lot
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Kostas Kalevras
> Sent: Mittwoch, 7. Juli 2004 19:56
> To: '[EMAIL PROTECTED]'
> Subject: RE: Dialup Admin - Can't see any mysql record
>
>
> On Wed, 7 Jul 2004, Stadler Karel wrote:
>
> > @Kostas Kalevras:
> > sql_debug is enabled. I see dialup admin can connect to mysql
> > "radius" db. Sometimes (Show Groups Button) it says. Returning 6
> > rows. But i don't
> >
> > see any row returning.
> >
> > While using the new CVS snippet, the only thing i did not upgrade is
> > to use the changed mysql scheme's. I saw some fields changed. For
> > example: in userinfo.sql "Name" changed to "Admin". But i don't
> > think this is the problem.
> >
> > Can you help ?
>
> Does this happen with all the pages or only with specific ones? Are
> the sql queries run correct?
>
> >
> > best rgds
> > Karel
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > To: '[EMAIL PROTECTED]'
> > Sent: 07.07.04 17:12
> > Subject: Re: Dialup Admin - Can't see any mysql record
> >
> > On Wed, 7 Jul 2004, Stadler Karel wrote:
> >
> > > Just downloaded and tried the latest CVS snippet from
> > > dialup_admin.
> > >
> > > I'm not using the http_credentials (#sql_use_http_credentials:
> > > yes) to connect to the radius database. Instead I use the same
> > > mySQL User as before. But
> > dialup
> > > admin does not show
> > > one single record (f.e.: our radacct table has about 250000
> > > records)
> > But I
> > > see, it connects to
> > > the DB.
> >
> > Enable sql_debug to see what's happening.
> >
> > >
> > > I saw, there's a new file called "username.mappings" and I added
> > > my
> > name,
> > > since we
> > > use htpasswd. But, it still doesn't work.
> > >
> > > Any ideas are welcome ?
> > >
> > > -----------------------------------
> > > Karel Stadler
> > > Network Technican
> > > Paul Scherrer Institute
> > > CH-5332 Villigen
> > > Switzerland
> > > -----------------------------------
> > > PGP KeyId:0x1B740D81
> > >
> > > -
> > > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> > >
> >
> > --
> > Kostas Kalevras Network Operations Center
> > [EMAIL PROTECTED] National Technical University of Athens, Greece
> > Work Phone: +30 210 7721861
> > 'Go back to the shadow' Gandalf
> >
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> >
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> >
>
> --
> Kostas Kalevras Network Operations Center
> [EMAIL PROTECTED] National Technical University of Athens, Greece
> Work Phone: +30 210 7721861
> 'Go back to the shadow' Gandalf
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
