Re: [gentoo-user] Re: Any one using www-apps/online-bookmarks
On Jan 23, 2008 6:45 AM, [EMAIL PROTECTED] wrote: snip ls -al /var/lib/mysql drwx-- 2 mysql mysql 1752 Jan 22 15:55 mysql drwx-- 2 mysql mysql 48 Jan 22 15:55 test It struck me odd that /var/lib/mysql has another directory inside with the same name... but that was how the previous install looked as well. Yeah - the sub-dirs under /var/lib/mysql are the individual named database schemas, and mysql uses the mysql schema to store the info about users, databases, privileges, etc., which brings us to the next point: Also, what do you get in the MySQL console if you do a: show databases; mysql show databases; ++ | Database | ++ | information_schema | ++ 1 row in set (0.03 sec) This is *very* abnormal. You should have *at least* seen 3 items: information_schema, mysql, and test. The fact that nothing but the meta database shows up (AFAIK, information_schema isn't actually a DB in MySQL, it's just metadata about the server - kind of like the /proc filesystem in *nix). So, this leads me to think that maybe the MySQL service had not been restarted since the last time you emerged mysql? This would explain why cleaning the log dir and then restarting MySQL fixed it... Also, try doing the create database procedure as previously outlined, then do a tail -n100 /var/log/mysql/mysql.err and /var/log/mysql/mysqld.err and /var/log/mysql/mysql.log - anything relative showing up in there? Maybe post the output of the above commands, as well as (tbz2'd, if they're large) attaching the /var/log/mysql/* files - might help us track this down... My first impulse was to look there as well but strangely nothing was being written about those errors. So in response to your post I thought I would clean out those logs with rm -f /var/log/mysql/my* Then restart mysql. Surprisingly after doing those steps. It now works. Apparently you've backhandedly fixed it simply with a request for information... : ). Heh. Stranger things have happened, but not *too* much stranger... ;) Now smooth as silk: Awesome, glad it's working for you! Reminds me of a comment a neighbor made yrs ago. I was a sort of neighborhood fixit guy. Pretty handy with my hands from a lifetime of bluecollar work and being raised as a kid in the country. Neighbors would call me when their fixit chores got out of there league. This one neighbor, on having me come over for an electrical problem, swore things at his house started just working when he called me to come over... said they'd see me coming and just know they'd have to work shortly. That appears to be what happened here. Yeah, I've seen that happen quite a bit with computers - someone is having a problem (consistently, too), they call in the computer tech, and it starts working perfectly as soon as the tech is there... :) A hypothesis of mine is that (at least some of the time), as soon as the computer tech is there, and asking to see the problem duplicated, the user focuses more on what they are actually doing, and in doing so, performs the action in the correct manner... Possibly... :) -James -- gentoo-user@lists.gentoo.org mailing list
Re: [gentoo-user] Re: Any one using www-apps/online-bookmarks
On Jan 23, 2008 7:03 AM, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] writes: And I guess... not surprisingly the bookmark page now works too? One lingering mysql command that is printed when the bookmarks page configuration steps is gone through: From bookmarks page: [...] After completing the configuration, create useraccounts with the following MySQL command: (wrapped for mail) mysql INSERT INTO user (username, password) VALUES ('johndoe', MD5('johndoes_password')); If I use that command (filling in the johndoe and johndoes_password part it fails with this error: ERROR 1046 (3D000): No database selected First tell MySQL what database you want to use: use bookmarks; INSERT INTO (...); -James -- gentoo-user@lists.gentoo.org mailing list
Re: [gentoo-user] Re: Any one using www-apps/online-bookmarks
On Wed, 23 Jan 2008 08:26:16 -0800, James Ausmus wrote: Yeah, I've seen that happen quite a bit with computers - someone is having a problem (consistently, too), they call in the computer tech, and it starts working perfectly as soon as the tech is there... :) A hypothesis of mine is that (at least some of the time), as soon as the computer tech is there, and asking to see the problem duplicated, the user focuses more on what they are actually doing, and in doing so, performs the action in the correct manner... Possibly... :) That doesn't explain why physical symptoms disappear as soon as you get the the doctor's :( -- Neil Bothwick SCORE! Monkeys: one. Humans: zero. signature.asc Description: PGP signature
Re: [gentoo-user] Re: Any one using www-apps/online-bookmarks
On Tuesday 22 January 2008, [EMAIL PROTECTED] wrote: OK, this one is easy to fix: login in to MySQL as root: mysql -uroot -p enter your password when prompted That part fails here: # mysql -uroot -p Enter password: root passwd entered ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Sorry for doubting and probably stating the obvious, but the database user named root has nothing to do with the system user named root. What root password did you enter? -- gentoo-user@lists.gentoo.org mailing list
Re: [gentoo-user] Re: Any one using www-apps/online-bookmarks
On Jan 22, 2008 2:02 PM, [EMAIL PROTECTED] wrote: I may have spoken too soon. Re-installing mysql got me to where I can login to the console but the suggested commands still fail: # mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16 Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r2 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database bookmarks; ERROR 1006 (HY000): Can't create database 'bookmarks' (errno: 2) snip Hmm - odd. What does the output of: ls -al /var/lib/mysql give you? Also, what do you get in the MySQL console if you do a: show databases; Also, try doing the create database procedure as previously outlined, then do a tail -n100 /var/log/mysql/mysql.err and /var/log/mysql/mysqld.err and /var/log/mysql/mysql.log - anything relative showing up in there? Maybe post the output of the above commands, as well as (tbz2'd, if they're large) attaching the /var/log/mysql/* files - might help us track this down... -James -- gentoo-user@lists.gentoo.org mailing list
Re: [gentoo-user] Re: Any one using www-apps/online-bookmarks
On Jan 21, 2008 7:49 PM, [EMAIL PROTECTED] wrote: snip So I tried adding a passwd leaving the rest as is.. That failed with: Access denied for user 'bookmarkmgr'@'localhost' (using password: YES) (YES was not what I inserted so I guess its just saying a passwd was used) I'm not really sure what to do about mysql but at least it appears the bookmark pkg is trying to work. OK, this one is easy to fix: login in to MySQL as root: mysql -uroot -p enter your password when prompted In the MySQL console type the following commands: create database bookmarks; grant ALL on bookmarks.* to 'bookmarkmgr'@'localhost' identified by 'the password you want to use'; flush privileges; quit And then retry the bookmark setup. HTH- James -- gentoo-user@lists.gentoo.org mailing list