Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 03-27-2007, 09:45 PM
kj_ugs kj_ugs is offline
 
Join Date: Oct 2004
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Can't create database connection to vb database

I keep getting the following warnings when i try and connect to my vbulletin database.

Warning: mysql_connect(): Access denied for user 'nobody'@'localhost' (using password: YES) in /testing.php on line 7

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /testing.php on line 8

Warning: mysql_query(): Access denied for user 'nobody'@'localhost' (using password: NO) in /testing.php on line 14

Warning: mysql_query(): A link to the server could not be established in /testing.php on line 14
Access denied for user 'nobody'@'localhost' (using password: NO)

I'm using the following code to connect to the database

$strServer="localhost"; // Server IP Address 'or' Name
$strDatabase="xxx"; // Database Name
$strUser="xxx"; // User ID
$strPwd="xxx"; // Password

$strDB=mysql_connect("$strServer","$struser","$str Pwd");
$database=mysql_select_db($strDatabase,$strDB);


and i've made sure the correct details have been entered. I'm connecting to the database from a non vbulletin page, it's custom. Any ideas? I've tried a few different connection techniques but all result in the same warnings.

Thanks in advance

KJ

PS. i've searched the forums and see that this is a common issue and is usually resolved by correcting account details but this is not the case here Everything looks right to me.
Reply With Quote
  #2  
Old 03-27-2007, 10:13 PM
MarkPW MarkPW is offline
 
Join Date: Apr 2006
Posts: 65
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your $struser is all lowercase, it should be $strUser

And you don't need apostrophes in your mysql_connect function.

Also, just wondering.. on your non-vb page, are you including vb's global.php or is this page seperate? If so, there's no need to create another connection to your database.
Reply With Quote
  #3  
Old 03-28-2007, 05:56 PM
kj_ugs kj_ugs is offline
 
Join Date: Oct 2004
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Cannot believe i didn't spot that. Thanks again. I've not included the global.php file. Would it be more efficient to do that?
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 05:13 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.04470 seconds
  • Memory Usage 2,158KB
  • 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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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