Mysql Sessions..

layer · Post by **layer** » 2005-02-06 19:34

Hie,

look at this copy from phpmyadmin...
is this number of processes of hmailserver normal ??

thanks

Termina 66 hmailserver localhost:1194 hmailserver Sleep 1044 --- ---
Termina 67 hmailserver localhost:1201 hmailserver Sleep 1020 --- ---
Termina 68 hmailserver localhost:1202 hmailserver Sleep 1015 --- ---

<~50 lines removed for easier reading>

Post by **martin** » 2005-02-06 19:39

No, that's not normal.

Hard to say anything about it though since you don't say which web server or PHP version you are using. I'm pretty sure it's a configuration error in your web server. :-\

layer · Post by **layer** » 2005-02-06 20:00

hie,

i'm using last version of apache 2 and php 4.3.10...
more details in my sig...

PS: i have restarted my apache web server and it comes to normal mysql operation...

Post by **martin** » 2005-02-06 20:07

That PHP version contains a serious COM bug that "should" make it impossible to use COM such as the hMailServer objects with it. The bug will be fixed in 4.3.11 (or whatever next version will be named)

http://www.hmailserver.com/forum/viewtopic.php?t=1086

Are you really sure you are using 4.3.10? The PHPWebAdmin interface shouldn't work whatsoever with that version. :\

layer · Post by **layer** » 2005-02-06 20:14

martin wrote:That PHP version contains a serious COM bug that "should" make it impossible to use COM such as the hMailServer objects with it. The bug will be fixed in 4.3.11 (or whatever next version will be named)

http://www.hmailserver.com/forum/viewtopic.php?t=1086

Are you really sure you are using 4.3.10? The PHPWebAdmin interface shouldn't work whatsoever with that version. :\

is i'm sure...
and it works fine, is only that problem...

thanks

Post by **martin** » 2005-02-06 20:19

Well, it's not _only_ that problem. You reported another hMailServer/PHP problem in another thread as well just an hour ago.

I'm not going to put any work into solving this. If you're using PHP 4.3.10, you're on your own. The PHP-bug has been confirmed by the PHP developers and they agree that it's critical. I'm not saying that I'm 100% sure that the next PHP version will solve the problem. But the chances are good..

layer · Post by **layer** » 2005-02-07 23:36

martin, i have updated the php to the 5.0.3 version and the problem continue... now i think is very important because is causing my mysql server very busy after 15min in use of PHPWebAdmin, the PHPWebAdmin is genereating too many connetions!!!

#1040 - Too many connections --> this is the message of phpmyadmin

Fatal error: Uncaught exception 'com_exception' with message 'Source: hMailServer COM library
Description: MySQL: Too many connections' in C:\www\webfolder\layersys.com\mailadmin\mhwainit.php:75 Stack trace: #0 C:\www\webfolder\layersys.com\mailadmin\mhwainit.php(75): com->Connect() #1 C:\www\webfolder\layersys.com\mailadmin\index.php(36): require_once('C:\www\webfolde...') #2 {main} thrown in C:\www\webfolder\layersys.com\mailadmin\mhwainit.php on line 75

This is the error of PHPWebAdmin...
i'm using apache 2.0.52 and mysql 4.0.23

Help me

PS: every click i do in phpwebadmin, one session is created in mysql server...

Post by **martin** » 2005-02-07 23:58

I'll put together a test version with an extra disconnect. Will be available in ~15 minutes.

Post by **martin** » 2005-02-08 00:16

http://www.hmailserver.com/download/hMa ... ild-72.exe

If it still does not work, turn on debug logging, visit the webpage, leave the webpage and post the log here.

layer · Post by **layer** » 2005-02-08 00:53

martin wrote:http://www.hmailserver.com/download/hMa ... ild-72.exe

If it still does not work, turn on debug logging, visit the webpage, leave the webpage and post the log here.

Martin, loging of hmailserver?

Post by **martin** » 2005-02-08 09:50

What do you mean with "Martin, loging of hmailserver?" ?

layer · Post by **layer** » 2005-02-08 13:53

martin wrote:What do you mean with "Martin, loging of hmailserver?" ?

i mean, "what log? the log of hmailserver? mysql ?"

Thanks

Post by **martin** » 2005-02-08 14:15

hMailServer log.
Did it solve the problem?

layer · Post by **layer** » 2005-02-08 15:48

martin wrote:hMailServer log.
Did it solve the problem?

but the hmailserver log is emptry (yes i have activated it...)
phpwebadmin don't make any entry in hmailsever log...

Post by **martin** » 2005-02-08 16:04

But did the upgrade to the latest build solve the problem or is PHPWebAdmin still not disconnecting from MySQL?

Have you turned on debug-logging in hMailAdmin? PHPWebAdmin should log to the hMailServer log directory if you turn on debug logging.

layer · Post by **layer** » 2005-02-08 16:10

"But did the upgrade to the latest build solve the problem or is PHPWebAdmin still not disconnecting from MySQL?"

yes i have upgraded but the problem is not solved.

Have you turned on debug-logging in hMailAdmin? PHPWebAdmin should log to the hMailServer log directory if you turn on debug logging.

yes the debug is ON but i don't have any entry!

Post by **martin** » 2005-02-08 16:17

If you just start and stop hMailAdmin, are lines added to the log then?
Or if you send an email through the server?

layer · Post by **layer** » 2005-02-08 16:22

martin wrote:If you just start and stop hMailAdmin, are lines added to the log then?
Or if you send an email through the server?

if i do this, one log is created... if a send e-mails too...

Post by **martin** » 2005-02-08 17:17

I'll do some more research this evening. I think this is a bug in PHP that has nothing to do with hMailServer though..

Post by **martin** » 2005-02-08 18:58

Can confirm the problem. Will see why it happens now.

Post by **martin** » 2005-02-08 19:58

http://www.hmailserver.com/download/hMa ... ild-72.exe

Try to install that and see if it solves your problem. I've added some more disconnects. Apparantly, Apache reuses the same COM object all the time instead of creating new when a new page is loaded. I have done some changes that hopefully solves it for you now.

layer · Post by **layer** » 2005-02-08 21:20

martin wrote:http://www.hmailserver.com/download/hMa ... ild-72.exe

Try to install that and see if it solves your problem. I've added some more disconnects. Apparantly, Apache reuses the same COM object all the time instead of creating new when a new page is loaded. I have done some changes that hopefully solves it for you now.

IT WORKS

thanks