+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html)
+--- Thread: cannot login as admin without password (/thread-75.html)
cannot login as admin without password - Stephen - 01-13-2010
matzofast
2004-10-18 11:08:59 PDT
on new installation it says , created db, could not set grant !!
when logging in as admin this error results:
Error in query: SELECT id, username, password FROM user WHERE username = 'admin' AND password = password(''). Table 'fakedatabasename.user' doesn't exist
matzofast
2004-10-18 11:10:53 PDT
any help would be greatly appreciated.
I have been stuck here since yesterday.
logart
2004-10-18 11:20:45 PDT
fakedatabasename? Is that the name of your database? make sure config.php is set up properly with your db connection values.
Also note: the cvs version has some fixes in it that 1.2final do not.
steve
matzofast
2004-10-18 11:35:15 PDT
how can I manually set grant access for a user in a MySQL db?
I get this at the setup.php:
installing...
Database Created
Database Selected
Could not set GRANT;
could this be my first problem?
matzofast
2004-10-18 11:41:29 PDT
It seems to be setting up the db and selecting it however when I look at the db through phpmyadmin; no tables are created the db is completely empty. huh?
at the risk of sounding stupid... isn't the setup.php supposed to have created some initial tables?
I'm really new to this program and MySQL/PHP too, so you will not offend me if you assume that I know very little.
logart
2004-10-18 11:44:54 PDT
what type of environment are you working with? Are you on a shared server? Do you have the mysql root password?
steve
matzofast
2004-10-18 11:48:25 PDT
yes I am on a shared server.
here is my enviroment info:
Operating system Linux
Kernel version 2.4.26-grsec
Apache version 1.3.31 (Unix)
PERL version 5.8.1
PHP version 4.3.9
MySQL version 4.0.20-standard
logart
2004-10-18 11:51:36 PDT
So you do not have root mysql access? That is probably the issue. The setup.php assumes you have grant permissions for the database you are using. If not, you should just do a manual install.
steve
matzofast
2004-10-18 11:54:27 PDT
thank you for clarifying that. I was beating my head against the wall thinking it might be some ftp transmission error in uploading.
now I'm off to do the manual install.
keep your fingers crossed.
Thank you for your fast replies and help.
logart
2004-10-19 08:39:50 PDT
BTW, I released a new version yesterday.
steve