[gentoo-user] Re: Any one using www-apps/online-bookmarks
James Ausmus [EMAIL PROTECTED] writes: 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 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. 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) 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... : ). Now smooth as silk: mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 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; Query OK, 1 row affected (0.00 sec) mysql grant ALL on bookmarks.* to 'bookmarkmgr'@'localhost' identified by - ''; Query OK, 0 rows affected (0.02 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) And I guess... not surprisingly the bookmark page now works too? 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. -- gentoo-user@lists.gentoo.org mailing list
[gentoo-user] Re: Any one using www-apps/online-bookmarks
[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 Apparently the syntax is not complete? And trying: mysql help INSERT INTO gets me: Nothing found Please try to run 'help contents' for a list of all accessible topics Going on to that help screen doesn't appear to offer anything very helpful. -- gentoo-user@lists.gentoo.org mailing list
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
[gentoo-user] Re: Any one using www-apps/online-bookmarks
James Ausmus [EMAIL PROTECTED] writes: 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 That part fails here: # mysql -uroot -p Enter password: root passwd entered ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) == But trying from my user shell: I at least can log in. mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 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. But when I try to run the command (wrapped for mail): mysql create database bookmarks; ERROR 1044 (42000): Access denied for user 'reader'@'localhost' to database 'bookmarks' The help offered inside the mysql shell doesn't appear very helpful to me. But apparently I need to start over some how. -- gentoo-user@lists.gentoo.org mailing list
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
[gentoo-user] Re: Any one using www-apps/online-bookmarks
Etaoin Shrdlu [EMAIL PROTECTED] writes: 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? I set up some stuff mnths ago trying to learn to use bacula. I don't really recal what all I might have done. I just zapped /var/lib/mysql and emerge -vC mysql, followed by emrege -vD mysql Once done I followed the advice given: emerge --config =dev-db/mysql-5.0.44-r2 Things are working like expected now. -- gentoo-user@lists.gentoo.org mailing list
[gentoo-user] Re: Any one using www-apps/online-bookmarks
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) Neither the help offered in the console nor man mysql appear to be very helpful in figuring out why that command fails. -- 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
[gentoo-user] Re: Any one using www-apps/online-bookmarks
Jason Carson [EMAIL PROTECTED] writes: You may have to emerge php with the apache2 USE flag if it still doesn't work. When I emerged the bookmarks package it pulled in php and I see apache2 was one of the useflags used. -- gentoo-user@lists.gentoo.org mailing list
[gentoo-user] Re: Any one using www-apps/online-bookmarks
James Ausmus [EMAIL PROTECTED] writes: Haven't used online-bookmarks before myself, but it soulds like Apache isn't configured properly for PHP scripts - try *adding* the following to your /etc/conf.d/apache2 file in the APACHE2_OPTS line (inside the double-quotes): -D PHP -D PHP5 and then do: /etc/init.d/apache2 stop /etc/init.d/apache2 start (I've found that sometimes a /etc/init.d/apache2 restart tries to start the apache2 processes again before the old processes have fully closed out, so will sometimes error out...) Thanks, I did get further along doing that. I already had this in there: APACHE2_OPTS=-D DEFAULT_VHOST -D INFO -D LANGUAGE -D SSL -D SSL_DEFAULT_VHOST -D PHP5 So I just stuck in the -D PHP and restarted. Now I see a real page as described in the documentation... However, now I'm running into some kind of conf problem with mysql. I haven't been using it for anything (although its been installed for some time) so I may have to get that configured properly. I left: Hostname: [localhost] username: [bookmarkmgr] Password: [left blank on first try] Database-Name [bookmarks] That fails with: Access denied for user ''@'localhost' to database 'bookmarks' 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. -- 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