[PHP-DB] mysql database not 'taking' changes
Hello, I'm using a product called Squirrelmail for my web based email. In it, it uses a database for user preferences and address books. (I posted to that list, and it was suggested to check here) I created the database squirrel. I created two tables, one called addresses and one called prefs. For some reason, when I try to change preferences, it never writes that information to the database. But, I can addresses just fine. Is there anything with php settings, or the database itself that may need to be changed? Thanks! Oh, I'm running Redhat 8, Apache 2, PHP 4.3.0 RC1. -Jody Cleveland Winnefox Library System Computer Support Specialist [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql database not 'taking' changes
Does the user that the script runs as have full CRUD access to the new tables? Have you set any restrictions on what that user can do to the table(s)? --- Jody Cleveland [EMAIL PROTECTED] wrote: Hello, I'm using a product called Squirrelmail for my web based email. In it, it uses a database for user preferences and address books. (I posted to that list, and it was suggested to check here) I created the database squirrel. I created two tables, one called addresses and one called prefs. For some reason, when I try to change preferences, it never writes that information to the database. But, I can addresses just fine. Is there anything with php settings, or the database itself that may need to be changed? Thanks! Oh, I'm running Redhat 8, Apache 2, PHP 4.3.0 RC1. -Jody Cleveland Winnefox Library System Computer Support Specialist [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Mark Weinstock [EMAIL PROTECTED] *** You can't demand something as a right unless you are willing to fight to death to defend everyone else's right to the same thing. -Stolen from the now-defunct Randy's Random mailing list. *** __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql database not 'taking' changes
Does the user that the script runs as have full CRUD access to the new tables? Have you set any restrictions on what that user can do to the table(s)? Boy, do I feel lost... How would I check that? Thanks! Jody -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql database not 'taking' changes
Sorry. Stupid technospeak on my part. When you connect to the database, you tell it to use a particular username and password. When these new tables were created, did you change the permissions in the mysql table for the user, or does that account have access to all the tables/databases? Basically, did you grant or change permissions when the new tables were created? BTW, CRUD = Create, Read, Update, Delete --- Jody Cleveland [EMAIL PROTECTED] wrote: Does the user that the script runs as have full CRUD access to the new tables? Have you set any restrictions on what that user can do to the table(s)? Boy, do I feel lost... How would I check that? Thanks! Jody -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Mark Weinstock [EMAIL PROTECTED] *** You can't demand something as a right unless you are willing to fight to death to defend everyone else's right to the same thing. -Stolen from the now-defunct Randy's Random mailing list. *** __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql database not 'taking' changes
Sorry. Stupid technospeak on my part. No problem, much ignorance on my part. When you connect to the database, you tell it to use a particular username and password. When these new tables were created, did you change the permissions in the mysql table for the user, or does that account have access to all the tables/databases? Basically, did you grant or change permissions when the new tables were created? I created a database called squirrelmail. I was logged in as root when I created it, but after I created the database, I typed: GRANT select,insert,update,delete ON squirrelmail.* TO squirreluser@localhost IDENTIFIED BY 'sqpassword'; BTW, CRUD = Create, Read, Update, Delete I was wondering what that meant! It looks like the changes take now, but I have to logout of squirrelmail and log back in for them to take effect. Any ideas? Thanks! Jody -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql database not 'taking' changes
--- Jody Cleveland [EMAIL PROTECTED] wrote: Sorry. Stupid technospeak on my part. No problem, much ignorance on my part. When you connect to the database, you tell it to use a particular username and password. When these new tables were created, did you change the permissions in the mysql table for the user, or does that account have access to all the tables/databases? Basically, did you grant or change permissions when the new tables were created? I created a database called squirrelmail. I was logged in as root when I created it, but after I created the database, I typed: GRANT select,insert,update,delete ON squirrelmail.* TO squirreluser@localhost IDENTIFIED BY 'sqpassword'; BTW, CRUD = Create, Read, Update, Delete I was wondering what that meant! It looks like the changes take now, but I have to logout of squirrelmail and log back in for them to take effect. Any ideas? Not to punt, but you might want to check with the Squirrelmail folks to see if that's normal behavior. I don't use it personally, but I can refer you to a few people who do if no one on this list knows... Thanks! Jody = Mark Weinstock [EMAIL PROTECTED] *** You can't demand something as a right unless you are willing to fight to death to defend everyone else's right to the same thing. -Stolen from the now-defunct Randy's Random mailing list. *** __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
