Jump to content


Photo

MySQL Is Giving Me More Problems


  • Please log in to reply
7 replies to this topic

#1 ThePsychologist

ThePsychologist
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 26 April 2003 - 10:11 PM

ok reinstalled linux using the build in packages, but now i can\'t figure out what the predefined user and password are. I\'ve tried every combo i could think of. redhat has no documentation(which is a big problem i have with them, lack of help) and no where on the net has resulted in any leads. If anyone could help me with this i\'d really appreciate it.

#2 ThePsychologist

ThePsychologist
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 26 April 2003 - 10:28 PM

Ok I Figured out my password, which turned out to be nothing. Pissed me off but i\'ll get over it. Ok now the quesiton remains: Why after all that work did I end up at the place I first started off at?

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/invboard1_1_2/upload/sources/Drivers/mySQL.php on line 61

PHP, PERL, APACHE, Are all set to work with MySQL. Anyways i\'m going to post up my config files in hopes someone can pin point an error I might have made/missed.

PHP.ini
http://afcub.servebeer.com/php.ini

Apache.Conf
http://afcub.servebeer.com/apache.conf

Thanks,
The Pscyhologist

#3 ThePsychologist

ThePsychologist
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 26 April 2003 - 11:27 PM

Ok i\'ve finally figured out the problem thanks to a .cgi forum that can use MySQL database. I was able to connect to MySQL while under CGI-BIN directory, Only problem is now how do I make it so i can execute under html directory?

#4 ThePsychologist

ThePsychologist
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 27 April 2003 - 03:09 AM

I\'m going crazy here. I really need to get MySQL running with PHP. I\'ve followed several step by step installations, with the same problem:

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/invboard1_1_2/upload/sm_install.php on line 395

It has nothing to do with anything about logging in. MySQL is running just fine as is PHP and the apache server. Under Perl MySQL runs just fine exept for i get this error:

http://afcub.servebe...m/perlerror.txt

Please I really need help and I am waste much valueable time(about 2 weeks of straight trying to fix this).

The Psychologist

#5 ThePsychologist

ThePsychologist
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 27 April 2003 - 05:45 AM

Hey I deleted my libphp4.so file, and i have no idea how to get it, so i was woundering if someone could email it to me @ LaadMarine@aol.com , I\'d appreciate it very much.

The Psychologist

#6 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 27 April 2003 - 07:29 PM

i\'m not sure, but i believe those files are customized to your system on configuration. you can get it from the source and reconfigure. i see you are trying the cgi-way... make sure you follow the php.net instruction how to set it up... it needs to extra Alias line i think.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#7 ThePsychologist

ThePsychologist
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 27 April 2003 - 08:10 PM

Ok after much headache I have figure out the problem. For some reason no matter what i put in the php.ini file it won\'t load mysql. If i changed say pgsql to off it doesn\'t show up under phpinfo and if i turn it on it shows back up. So my question is how do i set up php.ini to use mysql. Here is a few helpfull links

PHP.INI

http://afcub.servebeer.com/php.ini

PHP INFO

http://afcub.servebeer.com/phpinfo.php

SERVER INFO

http://afcub.servebe...phpSysInfo-2.1/

SMALL UPDATE:
i searched for the mysql.so file and found it upder perl library files, but not under php4 lib files. So I moved it Will No luck still. Is there something else I need to load like a mod_mysql file for apache that I don\'t know about? I see there is one for pgsql but not one for mysql and phsql works with php. If so how do I install the module under apache for mysql?

#8 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 28 April 2003 - 12:09 AM

your mysql configure lines was:
--with-mysql=shared,/usr
which looks odd. the actual path to mysql does not work? the php.ini is only used to tweak mysql settings, not actually turn support on and off; the default php.ini is fine.

there was a fellow that was having trouble with a cgi install. you may want to search and see if he can help? i have only used php as an apache module.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users