28 Jul
2003
28 Jul
'03
5:24 p.m.
Thanks a lot for your advise.
I tried to do
$psql -h localhost -p 5432 -U seruser -W ser
Connecting database ser is success.
But in the log file, these following lines appeared
after SER started using /usr/sbin/ser command.
FATAL: Non_superuser connection limit exceeded
LOG: pq_recvbuf:unexpected EOF on client connection
Maybe this is the reason database doesn't work, I think.
It seems SER can't connect to postgres.
What should I do?
Another problem: SER processes don't stop using /usr/sbin/ser stop.
Many SER processes are surviving.
Is it strange?
Most sincerely
Takefumi
28 Jul
28 Jul
6:49 p.m.
I had this issue as well.
I reported to the list several months ago. I thought
I posted the fix as well, perhaps not.
The reason is that SER opens many, many database
connections. I believe 32 connections are opened. So
You have to increase the number of database connections you
handle in the postgres configuration, which defaults to 16
I think.
The setting you need to tweak is
max_connections = 256
in the postgresql.conf file. The database then needs to be
restarted. Note that this setting affects others, both directly
related
to postgres and also the operating system (file descriptors, etc)...
---greg
-----Original Message-----
From: serusers-bounces(a)lists.iptel.org
[mailto:serusers-bounces@lists.iptel.org] On Behalf Of Takefumi Naito
Sent: Monday, July 28, 2003 10:25 AM
To: serusers(a)lists.iptel.org
Subject: [Serusers] PostgreSQL
Thanks a lot for your advise.
I tried to do
$psql -h localhost -p 5432 -U seruser -W ser
Connecting database ser is success.
But in the log file, these following lines appeared
after SER started using /usr/sbin/ser command.
FATAL: Non_superuser connection limit exceeded
LOG: pq_recvbuf:unexpected EOF on client connection
Maybe this is the reason database doesn't work, I think.
It seems SER can't connect to postgres.
What should I do?
Another problem: SER processes don't stop using /usr/sbin/ser stop.
Many SER processes are surviving.
Is it strange?
Most sincerely
Takefumi
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
29 Jul
29 Jul
1:01 a.m.
On Mon, 2003-07-28 at 12:49, Greg Fausak wrote:
The reason is that SER opens many, many database
connections. I believe 32 connections are opened. So
Just SER running:
root@marte:~# ps aux | grep mysql | wc -l
16
SER + one user on Serweb:
root@marte:~# ps aux | grep mysql | wc -l
18
--
Juanjo sin .sig :(
7586
days inactive
7586
days old
2 comments
3 participants
participants (3)
-
Greg Fausak -
Juan J. Sierralta P. -
Takefumi Naito