Hello, just some other information which might help to address this problem: OTRS 1.1.3 MySQL 3.23.48 SuSE 8.0 Quoted from page MySQL manual (page http://www.mysql.com/doc/en/Too_many_connections.html): "A.2.6 Too many connections Error If you get the error Too many connections when you try to connect to MySQL, this means that there is already max_connections clients connected to the mysqld server. If you need more connections than the default (100), then you should restart mysqld with a bigger value for the max_connections variable." It seems OTRS create more connections with the increase of number of e-mails to retrieve. Is this an error or it is like this? The e-mail traffic is very low in our work. I can devide the 400 e-mails and retreive them seperately. After that, the PostMasterPOP3.pl cronjob should have no any problem. Best regards, Yong Li Yong Li wrote:
we started to use OTRS in our project, because it fits our need very well.
After I have set it up, when I want to get all the e-mails (more than 400 total) by PostMasterPOP3.pl, it stops at 48 and 49th e-mail with the following error:
......
Message 44/427 (gabikat@mail.mpiz-koeln.mpg.de)
Message 45/427 (gabikat@mail.mpiz-koeln.mpg.de)
Message 46/427 (gabikat@mail.mpiz-koeln.mpg.de)
Message 47/427 (gabikat@mail.mpiz-koeln.mpg.de)
Message 48/427 (gabikat@mail.mpiz-koeln.mpg.de) DBI->connect(database=otrs;host=host.mpiz-koeln.mpg.de;) failed: Too many connections at /vol/home/yli/otrs/Kernel/System/DB.pm line 103 ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: linux Time: Sat Aug 2 22:39:10 2003
Message: Too many connections
Traceback (29509): Module: Kernel::System::DB::new (v1.26.2.1) Line: 81 Module: Kernel::System::PostMaster::new (v1.31.2.3) Line: 54 Module: main::FetchMail (v1.9.2.2) Line: 163 Module: ./PostMasterPOP3.pl (v1.9.2.2) Line: 106
Message 49/427 (gabikat@mail.mpiz-koeln.mpg.de) DBI->connect(database=otrs;host=host.mpiz-koeln.mpg.de;) failed: Too many connections at /vol/home/yli/otrs/Kernel/System/DB.pm line 103 ERROR: OTRS-PM3-10 Perl: 5.6.1 OS: linux Time: Sat Aug 2 22:39:10 2003
Message: Too many connections
Traceback (29509): Module: Kernel::System::DB::new (v1.26.2.1) Line: 81 Module: Kernel::System::PostMaster::new (v1.31.2.3) Line: 37 Module: main::FetchMail (v1.9.2.2) Line: 163 Module: ./PostMasterPOP3.pl (v1.9.2.2) Line: 106
Got no DBObject at /vol/home/yli/otrs/Kernel/System/PostMaster.pm line 43.
Can someone help me on this?
Best regards, Yong Li _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs