Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: "Access denied for user ..." on indexing one db of two.
Started 1 month ago by scriptster
Hi guys, hope someone can point me in the right direction. Banging my head against the wall for few hours already. Situation: a LAMP server with multiple domains / accounts. Sphinx installed couple months ago, used only by one account so far, indexing data from one mysql database just fine. Searchd works, everything is peachy. Now, I need to give a second account access to searchd. I have...
Site: Sphinx - Free open-source SQL full-text search engine  Sphinx - Free open-source SQL full-text search engine - site profile
Forum: Common forum  Common forum - forum profile
Total authors: 2 authors
Total thread posts: 4 posts
Thread activity: no new posts during last week
Domain info for: sphinxsearch.com

Other posts in this thread:

barryhunter replied 1 month ago
When you say 'checked' the credentials, are you doing it visually, or actully copy/pasting? (I've made that mistake before) make sure you construct the mysql client connection by copy/pasting from the DSN string reported by sphinx. (you can specify the password on the command line if dont have a space after -p and also the database name directly) re your hypothesis, have you tried: ...
Size: 551 bytes
Customize:  Customize "<b>Reply 1</b>: "Access denied for user ..." on indexing one db of two. :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

scriptster replied 1 month ago
> When you say 'checked' the credentials, are you doing it visually, or actully > copy/pasting? (I've made that mistake before) > > make sure you construct the mysql client connection by copy/pasting from the DSN string > reported by sphinx. (you can specify the password on the command line if dont have a > space after -p and also the database name directly) > > ...
Size: 1,757 bytes
Customize:  Customize "<b>Reply 2</b>: "Access denied for user ..." on indexing one db of two. :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

scriptster replied 1 month ago
> When you say 'checked' the credentials, are you doing it visually, or actully > copy/pasting? (I've made that mistake before) > > make sure you construct the mysql client connection by copy/pasting from the DSN string > reported by sphinx. (you can specify the password on the command line if dont have a > space after -p and also the database name directly) > > ...
Size: 1,221 bytes
Customize:  Customize "<b>Reply 3</b>: "Access denied for user ..." on indexing one db of two. :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

 

Top contributing authors

Name
Posts
scriptster
3
user's latest post:
"Access denied for user...
Published (2009-11-05 01:48:00)
> When you say 'checked' the credentials, are you doing it visually, or actully > copy/pasting? (I've made that mistake before) > > make sure you construct the mysql client connection by copy/pasting from the DSN string > reported by sphinx. (you can specify the password on the command line if dont have a > space after -p and also the database name directly) > > re your hypothesis, have you tried: >...
barryhunter
1
user's latest post:
"Access denied for user...
Published (2009-11-04 12:45:00)
When you say 'checked' the credentials, are you doing it visually, or actully copy/pasting? (I've made that mistake before) make sure you construct the mysql client connection by copy/pasting from the DSN string reported by sphinx. (you can specify the password on the command line if dont have a space after -p and also the database name directly) re your hypothesis, have you tried: indexer --rotate second_account_index1 and see...

Related threads on "Sphinx - Free open-source SQL full-text search engine":

Indexing DB and attachments?  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Indexing DB and attachments?
Indexing DB and attachments?
Using php exec() for delta indexing on the fly - bad idea?  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Using php exec() for delta indexing on the fly - bad idea?
Using php exec() for delta indexing on the fly - bad idea?

Related threads on other sites:

Access denied for db_connect  DevNetwork Forums - site profile Site News - forum profile Access denied for db_connect
Access denied for db_connect
Access Denied (policy_denied)Your system policy has...  Twitter / EcoR - site profile EcoR - forum profile Access Denied (policy_denied)Your system policy has denied access to the requested URL. For assistance, contact your network support team. 4:32 AM Oct 21st from TweetDeck
Access Denied (policy_denied)Your system policy has denied access to the requested URL. For assistance, contact your network support team. 4:32 AM Oct 21st from TweetDeck
Access denied ot Access DB in microsoft.public.access  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Access denied ot Access DB in microsoft.public.access
Access denied ot Access DB in microsoft.public.access
Mysql db user access denied  Site5 Web Hosting Forums - Powered by vBulletin - site profile Customer-to-Customer Q&A - forum profile Mysql db user access denied
Mysql db user access denied
Access denied error when disabling indexing  Microsoft Answers Forums - site profile Improve Performance - forum profile Access denied error when disabling indexing
Access denied error when disabling indexing
RoR DB Migration Access Denied error  bluehostforum.com - site profile Developers And Designers - forum profile RoR DB Migration Access Denied error
RoR DB Migration Access Denied error
Access denied to MA Access DB  MS OS - Microsoft Forum to Usenet Gateway - site profile Windows Vista Security - forum profile Access denied to MA Access DB
Access denied to MA Access DB
"Access Denied! Only site admin can access Data...  MSDN Forums - site profile SharePoint - Setup, Upgrade, Administration and Operation - forum profile "Access Denied! Only site admin can access Data Source object from user profile DB." in Event Viewer. Why?
"Access Denied! Only site admin can access Data Source object from user profile DB." in Event Viewer. Why?
Help with this errro message: Ad hoc access to OLE DB...  Microsoft TechNet Forums - site profile SQL Server Data Access - forum profile Help with this errro message: Ad hoc access to OLE DB provider 'MSDAORA' has been denied. You must access this provider through a linked server
Help with this errro message: Ad hoc access to OLE DB provider 'MSDAORA' has been denied. You must access this provider through a linked server
Warning: mysql_select_db() [function.mysql-select-db]:...  SitePoint : New Articles, Fresh Thinking for Web Developers and Designers - site profile MySQL - forum profile Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'nobody
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'nobody
Thread profile page for ""Access denied for user ..." on indexing one db of two." on http://sphinxsearch.com. This report page is a snippet summary view from a single thread ""Access denied for user ..." on indexing one db of two.", located on the Message Board at http://sphinxsearch.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity