vb.org Archive - sql_connect: Access denied for user

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Sphinx (https://vborg.vbsupport.ru/forumdisplay.php?f=265)

- - sql_connect: Access denied for user (https://vborg.vbsupport.ru/showthread.php?t=241606)

ThorstenA

04-30-2010 11:01 PM

sql_connect: Access denied for user

After installing today, I can not run the scripts, I always get these errors:

Code:

... lots of same errors before

using config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'...

indexing index 'VisitorMessageMain'...

ERROR: index 'VisitorMessageMain': sql_connect: Access denied for user 'correct_db_user'@'localhost' (using password: YES) (DSN=mysql://admin_mysql:***@localhost:3306/correct_db_name).

total 0 docs, 0 bytes

total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec

Sphinx 0.9.8-id64-release (r1371)

Copyright (c) 2001-2008, Andrew Aksyonoff

... and after :)

The database name and all other database information seem to be fetched right, but why is then the access denied for this user?

borbole

04-30-2010 11:05 PM

Does that db user has full permissions and access to the db that he is assigned to?

ThorstenA

04-30-2010 11:12 PM

This is the admin db user. It is the same user that I have in my config.php

--------------- Added [DATE]1272701807[/DATE] at [TIME]1272701807[/TIME] ---------------

I am using CentOS with DirectAdmin, MySQL 5.0.51 and PHP 5.2.10.

I removed all actions I took before, did all the steps again and still this problem occurs.

coffee

05-01-2010 08:07 AM

I had same problem but found it solved here.

So, just remove any pound signs (#) from your db user password.

ThorstenA

05-01-2010 08:30 AM

Thanks!!!! It works now! It was the pound sign in my password - hehe :D

Unbelievable good service here, and that on saturday :)

coffee

05-01-2010 08:31 AM

You're most welcome :)

All times are GMT. The time now is 07:48 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02085 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: