Re: [PHP] strange errors from command line vs. web
On Thu, 28 Sep 2006 14:29:13 -0400, blackwater dev wrote: Yep, I get called to undefined function so I need to somehow re-compile the cli version? How do I give support to just the cli version? I'm going to the docs now. Thanks! I guess it's dependent on your OS, but you might be able to just enable this line in your php.ini file for the cli version: extension=mysql.so Your php.ini file may be found in /etc/php4/cli/php.ini That's where mine (PHP4) is, but it's dependent on your specific distro. Are you on a package type of distro, such as Debian, Ubuntu, Fedora, Suse or the like? Or are you compiling stuff like on Gentoo? Ivo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] strange errors from command line vs. web
Ok, I've set up a username and password using Grant All Privileges, blah. with username and password. For some reason though the web now can't login with that. I then changed the root db password and put that in the config and the web side does run properly with that username, password. I still can't run the script from the command line even when I su to root. I am in a virtual hosting situation so not sure if that's it. Does it not know what to do with localhost in a virtual hosting situation when running it from the command line but does from the web? I'm trying to print the error but it just seems to die: echo about to connect; $this-connectionID= @mysql_connect($this-host, $this-user, $this-password); echo after connect; From the command line, it never prints the after connect...just seems to die without error...or at least no error to the screen and I do have a check right after to kick off the mysql error if there is no connection ID but again, I am su'ing to root so I thought it would always have rights. Not really sure what to do next. Thanks! On 9/27/06, Richard Lynch [EMAIL PROTECTED] wrote: On Wed, September 27, 2006 11:36 am, blackwater dev wrote: I have some code that makes a connection to the db. When I run this code from the command line, it stops at the db connection. Show us the code, without any embedded passwords, of course... If I call the script from the browser, it works fine. This almost always boils down to: PHP runs as nobody or a similarly unpowered user You log in as you, blackwaterdev or whatever, with many powers. In this case, it looks like 'nobody' has their own database, and is allowed to connect to it, but you are not. I've changed the permissions and that didn't work. Changed which permissions? mysql_admin? If so, did you reload the permissions after change? File executable? What? The db connection is the basic, localhost, root, with no password. Now that is an entirely separate problem. DON'T DO THAT! :-) What else can I try? You're going to have to create a user and set a password anyway, so do that first. There's no point in getting localhost/root/[blank] to work when it's not what you want anyway. -- Like Music? http://l-i-e.com/artists.htm
Re: [PHP] strange errors from command line vs. web
Hi, (sorry for top-posting) This is the great way PHP-cli lets you know it hasn't got any MySQL support :) Enable that, and you're good to go. Mind you, PHP-cli has a separate php.ini file. Ivo On Thu, 28 Sep 2006 08:26:13 -0400, blackwater dev wrote: Ok, I've set up a username and password using Grant All Privileges, blah. with username and password. For some reason though the web now can't login with that. I then changed the root db password and put that in the config and the web side does run properly with that username, password. I still can't run the script from the command line even when I su to root. I am in a virtual hosting situation so not sure if that's it. Does it not know what to do with localhost in a virtual hosting situation when running it from the command line but does from the web? I'm trying to print the error but it just seems to die: echo about to connect; $this-connectionID= @mysql_connect($this-host, $this-user, $this-password); echo after connect; From the command line, it never prints the after connect...just seems to die without error...or at least no error to the screen and I do have a check right after to kick off the mysql error if there is no connection ID but again, I am su'ing to root so I thought it would always have rights. Not really sure what to do next. Thanks! On 9/27/06, Richard Lynch [EMAIL PROTECTED] wrote: On Wed, September 27, 2006 11:36 am, blackwater dev wrote: I have some code that makes a connection to the db. When I run this code from the command line, it stops at the db connection. Show us the code, without any embedded passwords, of course... If I call the script from the browser, it works fine. This almost always boils down to: PHP runs as nobody or a similarly unpowered user You log in as you, blackwaterdev or whatever, with many powers. In this case, it looks like 'nobody' has their own database, and is allowed to connect to it, but you are not. I've changed the permissions and that didn't work. Changed which permissions? mysql_admin? If so, did you reload the permissions after change? File executable? What? The db connection is the basic, localhost, root, with no password. Now that is an entirely separate problem. DON'T DO THAT! :-) What else can I try? You're going to have to create a user and set a password anyway, so do that first. There's no point in getting localhost/root/[blank] to work when it's not what you want anyway. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] strange errors from command line vs. web
Ok, dumb question but how do I do that? I know how to re-compile the standard php. My code also uses mssql via freetds, does that somehow need to be enabled as it doesn't seem to fail there. Thanks! On 9/28/06, Ivo F.A.C. Fokkema [EMAIL PROTECTED] wrote: Hi, (sorry for top-posting) This is the great way PHP-cli lets you know it hasn't got any MySQL support :) Enable that, and you're good to go. Mind you, PHP-cli has a separate php.ini file. Ivo On Thu, 28 Sep 2006 08:26:13 -0400, blackwater dev wrote: Ok, I've set up a username and password using Grant All Privileges, blah. with username and password. For some reason though the web now can't login with that. I then changed the root db password and put that in the config and the web side does run properly with that username, password. I still can't run the script from the command line even when I su to root. I am in a virtual hosting situation so not sure if that's it. Does it not know what to do with localhost in a virtual hosting situation when running it from the command line but does from the web? I'm trying to print the error but it just seems to die: echo about to connect; $this-connectionID= @mysql_connect($this-host, $this-user, $this-password); echo after connect; From the command line, it never prints the after connect...just seems to die without error...or at least no error to the screen and I do have a check right after to kick off the mysql error if there is no connection ID but again, I am su'ing to root so I thought it would always have rights. Not really sure what to do next. Thanks! On 9/27/06, Richard Lynch [EMAIL PROTECTED] wrote: On Wed, September 27, 2006 11:36 am, blackwater dev wrote: I have some code that makes a connection to the db. When I run this code from the command line, it stops at the db connection. Show us the code, without any embedded passwords, of course... If I call the script from the browser, it works fine. This almost always boils down to: PHP runs as nobody or a similarly unpowered user You log in as you, blackwaterdev or whatever, with many powers. In this case, it looks like 'nobody' has their own database, and is allowed to connect to it, but you are not. I've changed the permissions and that didn't work. Changed which permissions? mysql_admin? If so, did you reload the permissions after change? File executable? What? The db connection is the basic, localhost, root, with no password. Now that is an entirely separate problem. DON'T DO THAT! :-) What else can I try? You're going to have to create a user and set a password anyway, so do that first. There's no point in getting localhost/root/[blank] to work when it's not what you want anyway. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] strange errors from command line vs. web
On Thu, September 28, 2006 7:26 am, blackwater dev wrote: Ok, I've set up a username and password using Grant All Privileges, blah. with username and password. For some reason though the web now can't login with that. I then changed the root db password and put that in the config and the web side does run properly with that username, password. I still can't run the script from the command line even when I su to root. su root or not does *nothing* to help you run MySQL and do database things. MySQL has a user called 'root' but it's not in any way, shape, or form related to the OS 'root'. Well, okay, the *idea* is the same, and the *name* is the same... But that's it! The *only* thing that matters to MySQL is the username/password used to connect, and what permissions have been granted in MySQL to that username/password. echo about to connect; $this-connectionID= @mysql_connect($this-host, $this-user, $this-password); echo after connect; Get rid of the @, at least until you figure out what is going on. again, I am su'ing to root so I thought it would always have rights. Don't bother su-ing to root. It has no effect on MySQL whatsoever. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] strange errors from command line vs. web
blackwater dev wrote: Ok, dumb question but how do I do that? I know how to re-compile the standard php. My code also uses mssql via freetds, does that somehow need to be enabled as it doesn't seem to fail there. Thanks! echo about to connect; $this-connectionID= @mysql_connect($this-host, $this-user, $this-password); echo after connect; Just to verify that this is in fact the problem you should remove the '@' sign from mysql_connect. '@' is a way of supressing errors, you specifically WANT that error. Is there a reason you have the '@' there? If the error is 'Undefined function mysql_connect' then you do need to get MySQL support compiled in... If it is available on the apache module it should be available to the CLI as well. If there is no 'undefined function' error then you should also be calling 'echo mysql_error()' to see what the error is after connecting. That error is going to give you more info than any of us can. Travis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] strange errors from command line vs. web
Yep, I get called to undefined function so I need to somehow re-compile the cli version? How do I give support to just the cli version? I'm going to the docs now. Thanks! On 9/28/06, Travis Doherty [EMAIL PROTECTED] wrote: blackwater dev wrote: Ok, dumb question but how do I do that? I know how to re-compile the standard php. My code also uses mssql via freetds, does that somehow need to be enabled as it doesn't seem to fail there. Thanks! echo about to connect; $this-connectionID= @mysql_connect($this-host, $this-user, $this-password); echo after connect; Just to verify that this is in fact the problem you should remove the '@' sign from mysql_connect. '@' is a way of supressing errors, you specifically WANT that error. Is there a reason you have the '@' there? If the error is 'Undefined function mysql_connect' then you do need to get MySQL support compiled in... If it is available on the apache module it should be available to the CLI as well. If there is no 'undefined function' error then you should also be calling 'echo mysql_error()' to see what the error is after connecting. That error is going to give you more info than any of us can. Travis
[PHP] strange errors from command line vs. web
I have some code that makes a connection to the db. When I run this code from the command line, it stops at the db connection. If I call the script from the browser, it works fine. I've changed the permissions and that didn't work. The db connection is the basic, localhost, root, with no password. What else can I try?
Re: [PHP] strange errors from command line vs. web
I have some code that makes a connection to the db. When I run this code
from the command line, it stops at the db connection. If I call the script
from the browser, it works fine. I've changed the permissions and that
didn't work. The db connection is the basic, localhost, root, with no
password.
What else can I try?
Try to get the error message from the DB Connection when it stops.
If MySQL something like this (from the PHP Manual for mysql_connect)
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
Travis Doherty
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] strange errors from command line vs. web
On Wed, September 27, 2006 11:36 am, blackwater dev wrote: I have some code that makes a connection to the db. When I run this code from the command line, it stops at the db connection. Show us the code, without any embedded passwords, of course... If I call the script from the browser, it works fine. This almost always boils down to: PHP runs as nobody or a similarly unpowered user You log in as you, blackwaterdev or whatever, with many powers. In this case, it looks like 'nobody' has their own database, and is allowed to connect to it, but you are not. I've changed the permissions and that didn't work. Changed which permissions? mysql_admin? If so, did you reload the permissions after change? File executable? What? The db connection is the basic, localhost, root, with no password. Now that is an entirely separate problem. DON'T DO THAT! :-) What else can I try? You're going to have to create a user and set a password anyway, so do that first. There's no point in getting localhost/root/[blank] to work when it's not what you want anyway. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
