Re: [BMSYNC-USERS] RE: bookmarksync-users digest, Vol 1 #52 - 1 msg

[Brian C. S. <bsh...@st...>]

Sounds like you might not have "flush(ed) privileges" after executing 
your GRANTs.  The restart effectively did this for you.

Yeah, it's a gnawing "feature" of MySQL, but who am I to complain.  It's 
otherwise a great product.

-b

Rich wrote:

>OK - I may have sorted that problem, I think apache just got a bit confused
>- I restarted it & it was fine.  However it still wouldn't add stuff to the
>database - it kept on telling me the email had already been entered when it
>hadn't.  This was sorted by changing the grant statement for the syncit
>mysql database from 
>
>GRANT ALL PRIVILEGES ON syncit TO mysqluser@localhost IDENTIFIED BY
>'password'
>
>To
>
>GRANT ALL PRIVILEGES ON syncit.* TO mysqluser@localhost IDENTIFIED BY
>'password'
>
>Is this reasonable?  Are the instructions wrong, or did I do something else
>wrong?
>
>Another question now, regarding use of the client.  It picked up my web
>browsers fine, and uploaded the bookmarks to my server.  Is it now possible
>to get the merged bookmarks back down to my web browsers?  I thought this
>was what it would do, but I can't see how?
>
>Thanks!
>
>  
>
>>-----Original Message-----
>>From: boo...@li... [mailto:bookmarksync-
>>use...@li...] On Behalf Of bookmarksync-users-
>>re...@li...
>>Sent: 21 July 2004 04:06
>>To: boo...@li...
>>Subject: bookmarksync-users digest, Vol 1 #52 - 1 msg
>>
>>Send bookmarksync-users mailing list submissions to
>>	boo...@li...
>>
>>To subscribe or unsubscribe via the World Wide Web, visit
>>	https://lists.sourceforge.net/lists/listinfo/bookmarksync-users
>>or, via email, send a message with subject or body 'help' to
>>	boo...@li...
>>
>>You can reach the person managing the list at
>>	boo...@li...
>>
>>When replying, please edit your Subject line so it is more specific
>>than "Re: Contents of bookmarksync-users digest..."
>>
>>
>>Today's Topics:
>>
>>   1. config.php not working on linux host (Rich Stanton)
>>
>>--__--__--
>>
>>Message: 1
>>From: "Rich Stanton" <sta...@cf...>
>>To: <boo...@li...>
>>Date: Tue, 20 Jul 2004 10:25:04 +0100
>>Subject: [BMSYNC-USERS] config.php not working on linux host
>>
>>Hi,
>>
>>I've tried to set up the latest stable version of bookmarksync on a
>>yellowdog 3 host.  I followed the minimal setup instructions.  If I now
>>browse to http://host/syncit/config.php the config page comes up.  However
>>when I put my info in & press 'register' it just comes up with a blank
>>page.
>>What have I missed, or how do I work out what's wrong?
>>
>>here's what I did up till now:
>>In mysql I created a database (syncit).  I then created a user on the host
>>(useradd mysqluser), and ran 'GRANT ALL PRIVILEGES ON syncit TO
>>mysqluser@localhost IDENTIFIED BY 'password'.  I ran FLUSH PRIVILEGES, and
>>then quit & ran 'mysql -u root -p syncit < bookmarksync.sql'.  If I run
>>'SHOW GRANTS FOR mysqluser@localhost' in mysql I see:
>>GRANT USAGE ON *.* TO 'mysqluser'@'localhost' IDENTIFIED BY PASSWORD
>>'numbers and letters'
>>GRANT ALL PRIVILEGES ON syncit.syncit TO 'mysqluser'@'localhost'
>>
>>If I run 'mysql show syncit' I see:
>>+------------------+
>>|      Tables      |
>>+------------------+
>>| syncit_bookmarks |
>>| syncit_config    |
>>| syncit_link      |
>>| syncit_person    |
>>+---------------
>>
>>I assume this is all correct so far?
>>
>>I then copied the php file to /var/log/www/html/syncit & edited db.php (&
>>masterpassword in config.php) accordingly:
>>$SYNCIT_DATABASE= "syncit";
>>$MYSQL_HOST     = "localhost";
>>$MYSQL_USER     = "mysqluser";
>>$MYSQL_PASSWORD = "same password as set with the grant statement";
>>
>>What have I done wrong, or how do I find out what's up?
>>
>>Thanks for any help!
>>
>>
>>
>>
>>
>>--__--__--
>>
>>_______________________________________________
>>bookmarksync-users mailing list
>>boo...@li...
>>https://lists.sourceforge.net/lists/listinfo/bookmarksync-users
>>
>>
>>End of bookmarksync-users Digest
>>    
>>
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by BEA Weblogic Workshop
>FREE Java Enterprise J2EE developer tools!
>Get your free copy of BEA WebLogic Workshop 8.1 today.
>http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
>_______________________________________________
>bookmarksync-users mailing list
>boo...@li...
>https://lists.sourceforge.net/lists/listinfo/bookmarksync-users
>  
>