Here is a common question.
Installed the latest Mysql onto Redhat 6.1 and the mysql database is
working great.
My problem begins when I try to insert data through the web forms.
Actually had this problem before and didn't write down what I did to fix
it, so forgive me for
bringing it up again almost a year later.
Here is how it all starts:
I ran one of my .pl files from the command line and it gives the long
error about not being able to find Mysql.pm in
the path.
I look at my script and I am using "use Mysql;" near the top.
I do a find for Mysql.pm on the server - nothing found
I do a search for mysql.pm(lowercase m) on the server and this finds
several mysql.pm
I copy mysql.pm to Mysql.pm and make a link to it with cp ln mysql.pm
Mysql.pm
Now I run the same script and I get different errors that state - I have
called the method correctly but error with connect?
Sorry, don't have the exact error message - its not that long of an
error message.
here is the connect script:
#
my $dbh = Mysql->connect("Localhost","database",$usrn,$pass2);
my $command="";
In the permissions table does case matter? I have localhost instead of
Localhost in all permissions tables to acces the db?
I think I actually solved this by re-installing the Mysql msql module
again inside the perl directory, but wondered if anyone can
shed and light on this problem?
This time I will print out the solution.
Thanks
Dougolus
--
Douglas Brantz
Computer Consultant
Fine & Applied Arts
Appalachian State University
Boone, NC 28608
828-262-6312 FAX
828-262-6549 OFFICE
brantzdr@stripped
