Jump to content


Photo

mysql_connect fails from cmd line but works through browser


  • Please log in to reply
6 replies to this topic

#1 upuaut

upuaut
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 01 August 2006 - 11:41 PM

I'm a little confounded. I have a simple script with a mysql_connect() call.
On command line
>> php script.php

I get
X-Powered-By: PHP/4.0.6
Content-type: text/html


<br>
<b>Fatal error</b>:  Call to undefined function:  mysql_connect() in <b>/home/somepath/lib/opendb.php</b> on line <b>2</b><br>

and the script doesn't make any database changes.

if I try from a browser
http://somesite.com/script.php

I get the expected output, and I get back data from tables the script uses and the tables that are expected to update some value do get updated.

I created a scrip with phpinfo() in it, I get few mysql entries. I'm sure the connection to db is working since i can read/update tables.

what gives? running on linux, php4.0.6, mysql 3.x

thanks

#2 hitman6003

hitman6003
  • Members
  • PipPipPip
  • Advanced Member
  • 1,807 posts

Posted 02 August 2006 - 01:24 AM

Stupid question, but is the "webserver" and the computer you are executing the code from the command line the same computer?

#3 upuaut

upuaut
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 02 August 2006 - 05:37 AM

Yes.

#4 shoaibi

shoaibi
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 02 August 2006 - 05:46 AM

Yes.

Walla! is this possible! i wanna have such a computer too!, sorry i was not trying to insult, just really too much surprised. i don't think its possible at all, even try re-installing to contacting the MySQL bug report.

#5 upuaut

upuaut
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 02 August 2006 - 05:50 AM

sorry, turns out i'm running mysql 4.0.24-standard

#6 shoaibi

shoaibi
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 02 August 2006 - 05:58 AM

sorry, turns out i'm running mysql 4.0.24-standard

i really have no idea what's happening. Then why do you ahve to use it from prompt, can't you just use the script?

#7 upuaut

upuaut
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 02 August 2006 - 07:22 AM

I tested it at the prompt becuase the output from the browser has 2 empty lines - probably 2 nulls -  at the top (before I print any statement), and because I use the output as input to a javascript function.. which is making the behaviour intermittent.

regardless, it's baffling me why the script works through the browser, but generates the mentioned error on command line. I'm wondering, what's the plumbing difference between the two?

thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users