Re: Difficulty using DB_DataObject, could someone lend a second pair of eyes?
| From: | Billy Gray | Date: | Thu, 09 Dec 2004 14:48:57 +0000 |
| Subject: | Re: Difficulty using DB_DataObject, could someone lend a second pair of eyes? | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16145@lists.php.net to get a copy of this message | ||
> I hope this isn't your real password. It's never a good idea to give
> people your real password for anything.
I've been around the block long enough. ;-) The example is close
enough to the original to show the problem I was having (it had
multiple spaces, a comma, and an explanation point).
>
> Try using quotes:
>
>
> database = "mysql://honky:honky, please!@localhost/test_do"
>
Works fantastic, thanks.
> > But in any event, the next problem has me really stumped:
> > ---------------------------------------------
> > ./createTables.php
> > /usr/local/apache/htdocs/cvs/test_do/includes/TestDataObjects.ini
> > db_dataobject_generator : 0 : CREATING FOR test_do
> >
> > db_dataobject_generator : ERROR : DB Error: insufficient permissions
> >
> > Fatal error: Call to undefined function: getlistof() in
> > /usr/local/lib/php/DB/DataObject/Generator.php on line 161
> > ---------------------------------------------
> >
> > I've made certain that honky@localhost is granted all permissions on
> > the database test_do, so I'm not sure why I'm getting this permission
> > denied message.
> >
> > Am I overlooking something?
>
> Check the other permissions tables. Perhaps you don't have table
> permissions? Maybe you have a spurious host entry? etc...
>
Turns out I had a character wrong in the database name! Insufficient
permissions to access a DB that doesn't exist - but to a non-root user
just appears as not having enough permissions to access.
Thanks Justin,
Billy