View Full Version : Error in Setup


Fagulhas
05-19-2004, 03:58 PM
Hello,

First of all, my server is not configured to run .cgi extensions so i renamed all these files to *****.pl
Also, inside the files, i changed all that pointed to a .cgi file to point to the same .pl file

I uploaded all messenger files (the necessary ones in asci mode) but when i try to run it the first time i get the following error:

Error message:
Can't connect(DBI::database=:host= ), no database driver specified and DBI_DSN env var not set at /home/httpd/vhosts/paimail.net/httpdocs/e-mail/messenger/functions.pl line 1833

... wich is ofcourse a ERROR 500 situation ...

So, with this happening when i call messenger.pl?Change_Settings routine, i will not be able to setup the script to work.

I did not create any database tables because i'm suposing the setup program will do it and because i didn't find any sql file in the compilation, but the connection settings i changed in setup.pl file are correct and are the same ones other scripts use on my site for a very long time.

What should i do or check?
Thks!

Jafo
05-19-2004, 04:35 PM
Hmm I am pretty sure this error means that your server does not have the MySQL driver installed for the DBI module. It sounds like you have to install DBD::MySQL.

I have not seen this error before however, so it could be a faulty DBI installation.

Fagulhas
05-20-2004, 12:38 PM
Ok,

Do you ever tested it with Net-MySQL module?
Is it worth a try adding for instance: use SQL::MySQL; in messenger.pl where MySQL is the corresponding .pm file?

I will try this before installing DBI drivers, wich should be a bit more tricky. If sucessful i will put the results on the forum for everybody to have the idea.

Regards.

Jafo
05-20-2004, 05:33 PM
I dont think it will work, but let me know if you get it going.

Fagulhas
05-20-2004, 08:44 PM
Ok, it doesn't works! I tried this afternoon...
I also tried to install DBI and DBD::MySQL using rpm's suiting my system (RedHat 9.0) and none had installed itself, resulting respectively in:

package perl-DBD-MySQL-2.1021-3 is already installed

package perl-DBI-1.32-5 is already installed

So, i assume the problem is not in the lack of MySQL drivers...

INFO: rpm -qa | grep mysql results:

php-mysql-4.2.2-17.2
mysql-3.23.56-1.9
mysql-devel-3.23.56-1.9
mysql-server-3.23.56-1.9

Is there a way to confirm if this drivers are really installed, besides trusting in the mentioned rpm's information?

Jafo
05-21-2004, 01:01 AM
When your call the script with the Change_Settings arguement, what do you have for the dbtype variable in the settings screen?

Fagulhas
05-21-2004, 01:47 AM
When i call messenger.pl?Change_Settings now i get this:

Can't connect to data source database=:host=, no database driver specified and DBI_DSN env var not set at /home/httpd/vhosts/paimail.net/httpdocs/e-mail/messenger/functions.pl line 1833

... and still not able to continue and setup the script

Jafo
05-21-2004, 01:51 AM
Did you change the setup at all before? If so, upload your backup copy of setup.cgi (rename it on your server to setup.cgi) and start over.

You should not get a MySQL error on the Change_Settings if it has never been altered as it does not use the DBI module until the initial setup is finished.

If you are however getting the message, I can only assume the script is not picking up the path to the setup file, if so, you can try this:

Open messenger.cgi and find these lines:

## If all else fails then define and uncomment the next line (No trailing slash!);
## $the_main_path = "/some/path/to/messenger/directory";

Uncomment the second line, and define the path to the messenger directory.