Mysql Sessions..

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

Mysql Sessions..

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>

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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. :-\

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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...

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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. :\

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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..

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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 :cry:

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

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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.

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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.

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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?

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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

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

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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 :)

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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

hMailServer log.
Did it solve the problem?

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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... :?

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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.

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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! :? :?

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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?

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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...

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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..

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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

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

User avatar
martin
Developer
Developer
Posts: 6837
Joined: 2003-11-21 01:09
Location: Sweden
Contact:

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.

User avatar
layer
Normal user
Normal user
Posts: 55
Joined: 2004-09-12 14:19
Location: Portugal

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 :P

thanks :twisted:

Post Reply