[isf-wifidog] Postgresql and wifidog.

[Max Horváth]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Well, it's a package 1.0.0_m2 version with some patches from CVS.

Environment shouldn't be a problem ...

Debian Sarge, Apache 2, PHP 5.1.1 source, PostgreSQL 7.4

But shouldn't be a problem, it's been running fine till a few weeks  
ago ...

Cheers, Max!

Am 20.01.2006 um 22:28 schrieb Chris Rowson:

> Hi there,
>
> What version of wifidog auth server are you running? Are you building
> your auth server from the source on CVS, or using the package 1.0.0_m2
> from sourceforge?
>
> Maybey a dumb question, but just thought I'd ask.
>
> Also what OS, and versions of PostgreSQL, php, apache, etc are you
> using? Don't suppose it could be specific to that could it?
>
> Chris
>
> On 1/20/06, Max Horváth <max.horvath at maxspot.de> wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Well,
>>
>> I can't imagine it's PHP - but it might be the case ...
>>
>> I'll be profiling the code to see where we have a speed bottle  
>> neck ...
>>
>> But right now I think it has to do with PostgreSQL ...
>>
>> Benoit, Francios - have you guys any idea?
>>
>> Cheers, Max!
>>
>> Am 20.01.2006 um 21:14 schrieb Joe Bowser:
>>
>>> Yeah, I'm noticing a similar problem as well on our dev server as
>>> well.
>>> Has this already been sent in as a bug?
>>>
>>> --
>>> Joe Bowser <bowserj at bcwireless.net>
>>>
>>> On Fri, 2006-01-20 at 19:07 +0100, Max Horváth wrote:
>>>> -----BEGIN PGP SIGNED MESSAGE-----
>>>> Hash: SHA1
>>>>
>>>> Well, we got it, too ... at least kinda similar ...
>>>>
>>>> WiFiDog runs slower and slower every day. Funny thing is, that we
>>>> don't run out of RAM or swap ... but calling one of our WiFiDog  
>>>> pages
>>>> takes seconds now ...
>>>>
>>>> I already did a manual VACUUM ANALYZE ... without any luck ...
>>>>
>>>> Anyone has a clue what our problem might be?
>>>>
>>>> Cheers, Max!
>>>>
>>>> Am 19.01.2006 um 08:47 schrieb Dr.Marios Moutzouris:
>>>>
>>>>> My mistake I replied to a previous posting. Here is the proper
>>>>> posting.
>>>>>
>>>>> Hello...
>>>>>
>>>>> I am having a strange problem. It has to do with Postgresql and  
>>>>> the
>>>>> wifi
>>>>> auth server. It seems that when the hotspot sends in the ping get
>>>>> request,postgresql doesn't close down the process once it is
>>>>> finished. That
>>>>> is the machine runs out of resources pretty quickly. Any ideas?
>>>>>
>>>>> Thanks
>>>>> Marios
>>>>>
>>>>>
>>>>> --
>>>>> No virus found in this outgoing message.
>>>>> Checked by AVG Free Edition.
>>>>> Version: 7.1.375 / Virus Database: 267.14.20/233 - Release Date:
>>>>> 18/1/2006
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> WiFiDog mailing list
>>>>> WiFiDog at listes.ilesansfil.org
>>>>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>>>>
>>>> -----BEGIN PGP SIGNATURE-----
>>>> Version: GnuPG v1.4.1 (Darwin)
>>>>
>>>> iD8DBQFD0Sby+BKgC+eQ3ooRAo9tAJ9oWxxJralMccT0Rdb2gfadY+/UIwCePA9V
>>>> Ca8xESbu5QfD4IIZQ1k0b0k=
>>>> =lBZr
>>>> -----END PGP SIGNATURE-----
>>>> _______________________________________________
>>>> WiFiDog mailing list
>>>> WiFiDog at listes.ilesansfil.org
>>>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>>>
>>>
>>> _______________________________________________
>>> WiFiDog mailing list
>>> WiFiDog at listes.ilesansfil.org
>>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.1 (Darwin)
>>
>> iD8DBQFD0Ur++BKgC+eQ3ooRAocSAJ9A/4QSpiYtMeu8esde/X/jIiYMTQCeMrUt
>> NkuXIz5cUU2IefgsLm7J3Eo=
>> =3fMn
>> -----END PGP SIGNATURE-----
>>
>>
>> _______________________________________________
>> WiFiDog mailing list
>> WiFiDog at listes.ilesansfil.org
>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>>
>>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)

iD8DBQFD0V06+BKgC+eQ3ooRAjtdAJ9pAH5VbcO+mdgismkSf7NQQIPlYQCfY+Li
HHYkD0qseLll+AxhTIML6Ds=
=YExh
-----END PGP SIGNATURE-----