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 <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



Relevant Pages

  • Re: [opensuse] How do I change my dvd writer permissions?
    ... up and now I have to burn as root. ... to restore user write permissions? ... So user has to be in group disk. ... I hope as "YOUR USERNAME";) ...
    (SuSE)
  • Re: [SLE] /etc/resolv.conf
    ... >> read and write permissions. ... >> I create the file from root and KPPP works fine until I close it ... my ppp connection is established. ...
    (SuSE)
  • Re: cant install WP8 on Suse 9.0
    ... > other than user root and group root or users, it stands to reason that ... I never had to bother much with permissions in Suse 7.2 and 8.0, ... username, and I tried to change group to my username also, but when I ...
    (alt.os.linux.suse)
  • Re: Connection to Access Database Problem
    ... UserName & Password are OK as I have to enter them when I open ... Originally the mdb didn't have any userid/password set (which is how I had ... I've just deleted the above connection and tried setting up a new one. ... Like it isn't even looking at the database. ...
    (borland.public.delphi.database.ado)
  • [opensuse] Re: OpenSuse 10.2
    ... Last night I successfully installed OpenSuse 10.2. ... a root username and password unsuccessfully. ...
    (SuSE)