Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 01-23-2004, 09:54 PM
N_Jay N_Jay is offline
 
Join Date: Dec 2003
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL Permissions error, Help

I have just moved my test installation from one server to another.
The original was running Linux, and the new is running Windows (Apache/PHP/MySQL).
After moving the files, I created a new database with the same name, and created a user with the same user name and password.
I made the minor IP and DIR changes to the config files.

And this is what I get;

Warning: mysql_connect(): Access denied for user: 'apache@localhost' (Using password: YES) in G:\Apache2\htdocs\forums\admin\db_mysql.php on line 40

Now apache is the database user name (I know this works because I used the same name and password with a virgin installation on the Windows box).

I have recreated the password and even the whole user several times, even reloading a fresh copy of the transfered database. (the password is simple to keep typos from being an issue)

WTF am I doing wrong?????
Reply With Quote
  #2  
Old 01-23-2004, 09:58 PM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you edit OR re-edit the admincp/config.php?

Regards,
g-force2k2
Reply With Quote
  #3  
Old 01-23-2004, 11:19 PM
N_Jay N_Jay is offline
 
Join Date: Dec 2003
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by g-force2k2
Did you edit OR re-edit the admincp/config.php?

Regards,
g-force2k2
You mean /forums/admin/config.php

No need to edit, and the database name (forum_3), server name (localhost), user name (apache), and User Password all stay the same.
Reply With Quote
  #4  
Old 01-23-2004, 11:56 PM
N_Jay N_Jay is offline
 
Join Date: Dec 2003
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Stupid me, and Stupid Windows.

In all the changes I made a typo.
BUT, the first failure was caused by WINDOWS calling the PHP user @'computer_name' instead of @localhost (UGH!)

So, I set the user apache to "anyhost" instead of "localhost" and all is well. . . . . . . . ALLMOST!!!!!!!!!!! Ugh!

Now Forums work, vB Admin CP works, vBP admin cp works, user CP works, BUT . . .

Most vBP pages cause;

Fatal error: Cannot redeclare advblocks() (previously declared in G:\apache2\htdocs\includes\advblocks.php:5) in G:\apache2\htdocs\includes\advblocks.php on line 5

But thats a discussion fro the vBPortal group.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:46 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03878 seconds
  • Memory Usage 2,179KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete