FeedForAll Forum Index ?
?Home?????FAQ????? Search ?????Register ?????Profile? ????Log in
?rss2sql INSERT command denied to user View next topic
View previous topic
Post new topicReply to topic
Author Message
randeh



Joined: 16 Sep 2015
Posts: 8
Location: Florida

PostPosted: Thu Sep 17, 2015 4:05 pm Reply with quoteBack to top

From the rss2sql_install.php page it says [quote] Username The username to access your database. The database will only be read from, so a username with read only access is ideal.[/quote]

After logging into rss2sql_admin.php with my admin name and password I submit a feed and I get [quote] INSERT command denied to user 'gdt_readon'@'localhost' for table 'feedInfo' [/quote] I did not log in as that user.

I changed the privileges for the read only user to be able to write and the feed is added. It seems that the code wants to use the read only user instead of the admin user when submitting a feed. Please let me know what I need to change. My admin user has full privileges.

Thank you,

Randy[/quote]
View user's profile
Tech Support



Joined: 27 Aug 2004
Posts: 2694

PostPosted: Fri Sep 18, 2015 5:36 am Reply with quoteBack to top

That appears to be a typo (mistake) in wording. The username to access the database must also have write access to the database, so it can add new data to it. You don't need to use an admin database user, but you do need to use a username that has both read and write access.

Sorry for the problem.

_________________
Create RSS Feeds
Audio Recording and Editing
View user's profile
randeh



Joined: 16 Sep 2015
Posts: 8
Location: Florida

PostPosted: Fri Sep 18, 2015 11:35 am Reply with quoteBack to top

Thank you,
View user's profile
Display posts from previous:?? ? ?
Post new topicReply to topic


?Jump to:? ?



View next topic
View previous topic


Powered by phpBB ? 2001, 2002 phpBB Group :: FI Theme