[gentoo-user] Any one using www-apps/online-bookmarks

[gentoo-user] Any one using www-apps/online-bookmarks

[reader]

I'm having a little trouble getting www-apps/online-bookmarks set up.

Near as I can tell there is literally no help installed when you
install this package.... A few readmes with a URL to an online help
site:
  http://www.frech.ch/online-bookmarks/installation.php

However, I'm not seeing the behavior described there and it appears
there is no other resource for getting started.

You are told to aim your browser at: 
  http://www.yourserver.com/online-bookmarks/

When I fill in my server I see a listing like one might see in a file
browser.  

The online site claims it will be linked to an install process but
that is true here.

Its a file listing of a bunch of php files but opening the install.php
does not lead to anything usefull... Instead you see a php text file
that doesn't really work as described.

I'm guessing something in the my php setup/config is not done right.

However I've done no config of php.  I just installed the
online-bookmarks/ which pulled in php stuff.  I didn't see messages
about configuring it. 

Anyone here using this package that can provide a few tips?

-- 
gentoo-user@lists.gentoo.org mailing list

Re: [gentoo-user] Any one using www-apps/online-bookmarks

[James Ausmus]

On Jan 21, 2008 11:16 AM,  <reader@newsguy.com> wrote:
> I'm having a little trouble getting www-apps/online-bookmarks set up.

<snip>

> When I fill in my server I see a listing like one might see in a file
> browser.
>
> The online site claims it will be linked to an install process but
> that is true here.
>
> Its a file listing of a bunch of php files but opening the install.php
> does not lead to anything usefull... Instead you see a php text file
> that doesn't really work as described.


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...)


HTH-

James
-- 
gentoo-user@lists.gentoo.org mailing list

Re: [gentoo-user] Any one using www-apps/online-bookmarks

[Jason Carson]

You may have to emerge php with the "apache2" USE flag if it still doesn't
work.

> On Jan 21, 2008 11:16 AM,  <reader@newsguy.com> wrote:
>> I'm having a little trouble getting www-apps/online-bookmarks set up.
>
> <snip>
>
>> When I fill in my server I see a listing like one might see in a file
>> browser.
>>
>> The online site claims it will be linked to an install process but
>> that is true here.
>>
>> Its a file listing of a bunch of php files but opening the install.php
>> does not lead to anything usefull... Instead you see a php text file
>> that doesn't really work as described.
>
>
> 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...)
>
>
> HTH-
>
> James
> --
> gentoo-user@lists.gentoo.org mailing list
>
>


-- 
gentoo-user@lists.gentoo.org mailing list

[gentoo-user] Re: Any one using www-apps/online-bookmarks

[reader]

"Jason Carson" <jay@canuckster.org> 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

[reader]

"James Ausmus" <james.ausmus@gmail.com> 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

[James Ausmus]

On Jan 21, 2008 7:49 PM,  <reader@newsguy.com> 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

[gentoo-user] Re: Any one using www-apps/online-bookmarks

[reader]

"James Ausmus" <james.ausmus@gmail.com> writes:

> On Jan 21, 2008 7:49 PM,  <reader@newsguy.com> 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

[Etaoin Shrdlu]

On Tuesday 22 January 2008, reader@newsguy.com 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

[reader]

Etaoin Shrdlu <shrdlu@unlimitedmail.org> writes:

> On Tuesday 22 January 2008, reader@newsguy.com 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

[reader]

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

[James Ausmus]

On Jan 22, 2008 2:02 PM,  <reader@newsguy.com> 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

[reader]

"James Ausmus" <james.ausmus@gmail.com> writes:

> On Jan 22, 2008 2:02 PM,  <reader@newsguy.com> 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
      -> 'xxxxxxxx';
  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

[reader]

reader@newsguy.com 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

[Brian Marshall]

[-- Attachment #1: Type: text/plain, Size: 848 bytes --]

On Wed, 23 Jan 2008 09:03:06 -0600
reader@newsguy.com wrote:

> reader@newsguy.com 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?
> 
You need to select a database first with "use dbname;"


	Brian

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-user] Re: Any one using www-apps/online-bookmarks

[James Ausmus]

On Jan 23, 2008 6:45 AM,  <reader@newsguy.com> 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

[James Ausmus]

On Jan 23, 2008 7:03 AM,  <reader@newsguy.com> wrote:
> reader@newsguy.com 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

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 714 bytes --]

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.

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 189 bytes --]