Re: strange errors from command line vs. web

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux