Thread: [phpslash-users] Database issue in 0.8
Brought to you by:
joestewart,
nhruby
From: Sigmund L. <Sig...@ut...> - 2004-09-22 07:38:08
|
0.8 setup is great, and sort of worked, but every time I try to write new information to my mysql-dbase, I get the error 1044 - session halted. I figure this must be some misconfiguration in phpslash. I use the mysqlserver on www.freesql.org for testing purposes, but I am also testing freeWPS, and freeWPS manages to write on the same server. I must say that phpslash looks more promising than freeWPS, though... :) Sigmund Lahn |
From: Sigmund L. L. <sig...@on...> - 2004-09-22 12:32:10
|
This is the complete error message: Database error: Invalid SQL: lock tables db_sequence write MySQL Error: 1044 (Access denied for user: 'phpslash@%' to database 'phpslash') Please contact the webmaster and report the exact error message. Session halted. Sigmund Lahn |
From: Joe S. <joe...@us...> - 2004-09-22 14:11:40
|
on 09/22/04 07:31 Sigmund L. Lahn said the following: > This is the complete error message: > > Database error: > Invalid SQL: lock tables db_sequence write > > MySQL Error: 1044 (Access denied for user: 'phpslash@%' to database > 'phpslash') > Please contact the webmaster and report the exact error message. > Session halted. > > That's the one. From the mysql doc: "As of MySQL 4.0.2, to use LOCK TABLES you must have the LOCK TABLES privilege and a SELECT privilege for the involved tables. In MySQL 3.23, you must have SELECT, INSERT, DELETE, and UPDATE privileges for the tables." This has to be GLOBAL and some admins think it is a problem. You still only have access to the database they give you. Joe > > > Sigmund Lahn > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 > Project Admins to receive an Apple iPod Mini FREE for your judgement on > who ports your project to Linux PPC the best. Sponsored by IBM. > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php > _______________________________________________ > phpslash-users mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpslash-users |
From: Joe S. <joe...@us...> - 2004-09-22 10:44:17
|
On Wed, Sep 22, 2004 at 09:37:55AM +0200, Sigmund Lahn wrote: > 0.8 setup is great, and sort of worked, but every time I try to write > new information to my mysql-dbase, I get the error 1044 - session > halted. > > I figure this must be some misconfiguration in phpslash. > http://dev.mysql.com/doc/mysql/en/Error-handling.html Error: 1044 SQLSTATE: 42000 (ER_DBACCESS_DENIED_ERROR) Message: Access denied for user '%s'@'%s' to database '%s' So I guess check your DB_ settings in config.ini.php. You can see the extended mysql error code by turning on debugging info in config.ini.php as well. Set to true: ;; Debug variables and messages (i.e., do not suppress output from calls ;; to the debug function) debug = true > I use the mysqlserver on www.freesql.org for testing purposes, but I am > also testing freeWPS, and freeWPS manages to write on the same server. > > I must say that phpslash looks more promising than freeWPS, though... :) > have fun, Joe > Sigmund Lahn > > > ------------------------------------------------------- > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 > Project Admins to receive an Apple iPod Mini FREE for your judgement on > who ports your project to Linux PPC the best. Sponsored by IBM. > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php > _______________________________________________ > phpslash-users mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpslash-users |
From: Joe S. <joe...@us...> - 2004-09-22 11:11:52
|
On Wed, Sep 22, 2004 at 09:37:55AM +0200, Sigmund Lahn wrote: > 0.8 setup is great, and sort of worked, but every time I try to write > new information to my mysql-dbase, I get the error 1044 - session > halted. > Sorry, I misread that it is when writing to db. It might be the freesql.org mysql setup does not give users the global file-locking privilege. This should not concern them, it doesn't give you any access to other db's. The locking is only done when generating new db entries. But I thought that gave a more specific errorcode that explained better. Turn debugging on as in the previous email and let us know what it says and what you did to generate. Joe > I figure this must be some misconfiguration in phpslash. > > I use the mysqlserver on www.freesql.org for testing purposes, but I am > also testing freeWPS, and freeWPS manages to write on the same server. > > I must say that phpslash looks more promising than freeWPS, though... :) > > Sigmund Lahn > |