Re: [PHP] strange errors from command line vs. web
- From: blackwaterdev@xxxxxxxxx ("blackwater dev")
- Date: Thu, 28 Sep 2006 12:12:09 -0400
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 <I.F.A.C.Fokkema@xxxxxxx> 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 <ceo@xxxxxxxxx> 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
- Follow-Ups:
- Re: [PHP] strange errors from command line vs. web
- From: Travis Doherty
- Re: [PHP] strange errors from command line vs. web
- References:
- strange errors from command line vs. web
- From: "blackwater dev"
- Re: [PHP] strange errors from command line vs. web
- From: "Richard Lynch"
- Re: [PHP] strange errors from command line vs. web
- From: "blackwater dev"
- Re: [PHP] strange errors from command line vs. web
- From: "Ivo F.A.C. Fokkema"
- strange errors from command line vs. web
- Prev by Date: RE: [PHP] Convert UTF-8 to windows-874?
- Next by Date: CfP: IEEE Software Special Issue on Rapid Application Development with Dynamically Typed Languages
- Previous by thread: Re: [PHP] strange errors from command line vs. web
- Next by thread: Re: [PHP] strange errors from command line vs. web
- Index(es):
Relevant Pages
|
|
