Database Connection Fails

[Gloria]

Hi, I've been having problems with my CGI script, it overloads the
server. I think it's because the database connection fails because
the following error is logged whenever the server overloads.

DBI->connect(server=localhost;database=Employee) failed: at db.pm
line 53
db.cgi:: Could not connect to database
db.cgi:: No database connection exists
db.cgi:: No database connection exists

And I use these settings to run mysqld.

/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking

I read some documentation that skip-external-locking should be used
instead of skip-locking, but that seems like a minor thing. I'm not
entirely sure it is the database connections, I'm just trying to
eliminate possible causes. So if this is not in the right
messageboard, I apologize.

TIA,
G

[John]

It sounds like you may have reached the maximum number of connections or
exhausted some other finite resource. Try monitoring these types of
parameters while your server is running and see what changes when the
server overloads.

John
Gloria wrote:

Hi, I've been having problems with my CGI script, it overloads the
server. I think it's because the database connection fails because
the following error is logged whenever the server overloads.

DBI->connect(server=localhost;database=Employee) failed: at db.pm
line 53
db.cgi:: Could not connect to database
db.cgi:: No database connection exists
db.cgi:: No database connection exists

And I use these settings to run mysqld.

/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking

I read some documentation that skip-external-locking should be used
instead of skip-locking, but that seems like a minor thing. I'm not
entirely sure it is the database connections, I'm just trying to
eliminate possible causes. So if this is not in the right
messageboard, I apologize.

TIA,
G

[John]

It sounds like you may have reached the maximum number of connections or
exhausted some other finite resource. Try monitoring these types of
parameters while your server is running and see what changes when the
server overloads.

John
Gloria wrote:

Hi, I've been having problems with my CGI script, it overloads the
server. I think it's because the database connection fails because
the following error is logged whenever the server overloads.

DBI->connect(server=localhost;database=Employee) failed: at db.pm
line 53
db.cgi:: Could not connect to database
db.cgi:: No database connection exists
db.cgi:: No database connection exists

And I use these settings to run mysqld.

/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking

I read some documentation that skip-external-locking should be used
instead of skip-locking, but that seems like a minor thing. I'm not
entirely sure it is the database connections, I'm just trying to
eliminate possible causes. So if this is not in the right
messageboard, I apologize.

TIA,
G

[Gloria]

Thanks, I thought it might be that but I have a hard time getting into
the server when it starts to overload. Is there any type of logging
that shows current parameters?

John <no****@toplevel.tld> wrote in message news:<Ql******************@newsread2.news.atl.eart hlink.net>...

It sounds like you may have reached the maximum number of connections or
exhausted some other finite resource. Try monitoring these types of
parameters while your server is running and see what changes when the
server overloads.

John
Gloria wrote:

Hi, I've been having problems with my CGI script, it overloads the
server. I think it's because the database connection fails because
the following error is logged whenever the server overloads.

DBI->connect(server=localhost;database=Employee) failed: at db.pm
line 53
db.cgi:: Could not connect to database
db.cgi:: No database connection exists
db.cgi:: No database connection exists

And I use these settings to run mysqld.

/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking

I read some documentation that skip-external-locking should be used
instead of skip-locking, but that seems like a minor thing. I'm not
entirely sure it is the database connections, I'm just trying to
eliminate possible causes. So if this is not in the right
messageboard, I apologize.

TIA,
G

[Gloria]

Thanks, I thought it might be that but I have a hard time getting into
the server when it starts to overload. Is there any type of logging
that shows current parameters?

John <no****@toplevel.tld> wrote in message news:<Ql******************@newsread2.news.atl.eart hlink.net>...

It sounds like you may have reached the maximum number of connections or
exhausted some other finite resource. Try monitoring these types of
parameters while your server is running and see what changes when the
server overloads.

John
Gloria wrote:

Hi, I've been having problems with my CGI script, it overloads the
server. I think it's because the database connection fails because
the following error is logged whenever the server overloads.

DBI->connect(server=localhost;database=Employee) failed: at db.pm
line 53
db.cgi:: Could not connect to database
db.cgi:: No database connection exists
db.cgi:: No database connection exists

And I use these settings to run mysqld.

/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking

I read some documentation that skip-external-locking should be used
instead of skip-locking, but that seems like a minor thing. I'm not
entirely sure it is the database connections, I'm just trying to
eliminate possible causes. So if this is not in the right
messageboard, I apologize.

TIA,
G