Thank you very much. That solves my problem
-Message d'origine-
De : Dan Nelson [mailto:[EMAIL PROTECTED]
Envoyé : 13 décembre 2004 12:03
À : Duhaime Johanne
Cc : [EMAIL PROTECTED]
Objet : Re: DBI->connect does not work in crontab but works interactively
In the last episode
In the last episode (Dec 13), Duhaime Johanne said:
> I have a script that check the status of all innodb tables. It works
> fine interactively.
>
> But not from the crontab tab.
>
> Here is the error message and also a list of the environment variables
> from the crontab
>
> The message is abou
In the last episode (Dec 13), Dan Nelson said:
> In the last episode (Dec 13), Duhaime Johanne said:
> > I have a script that check the status of all innodb tables. It works
> > fine interactively.
> >
> > But not from the crontab tab.
> >
> > Here is the error message and also a list of the envi
Thursday, October 24, 2002 10:32 AM
> To: [EMAIL PROTECTED]
> Subject: RE: DBI Connect Fails after 20,000 record inserts/updates
>
>
> Do you connect/disconnect before/after every insert?
>
> -Original Message-
> From: Dallas Engelken [mailto:dallase@;nmgi.com]
> Sent
Do you connect/disconnect before/after every insert?
-Original Message-
From: Dallas Engelken [mailto:dallase@;nmgi.com]
Sent: Thursday, October 24, 2002 9:52 AM
To: [EMAIL PROTECTED]
Subject: DBI Connect Fails after 20,000 record inserts/updates
I am trying to parse an email log databas
It looks like you are using a network connection.
Perhaps you are running out of connections, as closed sessions may take
a while to be freed.
Try keeping the second connection open until you are done.
Dallas Engelken wrote:
I am trying to parse an email log database with about 900,000 records f
Umm, you didn't specify a username or password...you instead passed 'undef'.
This is the connect string I use:
$dbh = DBI->connect( "DBI:mysql:database=$pb_db; host=$pb_server;
port=$pb_port",
$pb_user,
$pb_password,
{Rai
Looks like a perl script, so you can use 'or' (||) to evaluate your
'connect' string, i.e.
To stop the script if connect fails use
$dbh = DBI->connect("dbi:mysql:database:localhost",'user','password') || die
"No connection to database";
To issue a warning only
$dbh = DBI->connect("dbi:mysql:data
