On Fri, 9 Jul 2004, Stadler Karel wrote:
> @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
I 've added a missing.php3 file with the corresponding function. So even if you
are using an older PHP version things should work ok.
>
> 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
>
--
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
