• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1568
  • Last Modified:

installing zeeauctions

hi i have been stuck installing zeeauctions and cannot seem to get the data base running on the system, i have set the db with the correct DBname user and password with the approp privlidges editied the myconnect.php file with the approp data
used localhost instead of the url and it throws up the below error, i am guessing its the passwords usernamess there are 2 myconfig files one in the root and one in the admin
has any one installed this system
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'abc'@'localhost' (using password: NO) in /home/musician/public_html/tradingpost/myconnect.php  on line 25
0
sydneyguy
Asked:
sydneyguy
  • 7
2 Solutions
 
Ray PaseurCommented:
Can't say I have any familiarity with Zeeauctions, but I can show you the basics of connect and select along with ways to get diagnostics from the functions.
<?php // RAY_mysql_example.php
error_reporting(E_ALL);


// IMPORTANT PAGES FROM THE MANUALS
// MAN PAGE: http://php.net/manual/en/ref.mysql.php
// MAN PAGE: http://php.net/manual/en/mysql.installation.php
// MAN PAGE: http://php.net/manual/en/function.mysql-error.php


// CONNECTION AND SELECTION VARIABLES FOR THE DATABASE
$db_host = "localhost"; // PROBABLY THIS IS OK
$db_name = "??";        // GET THESE FROM YOUR HOSTING COMPANY
$db_user = "??";
$db_word = "??";

// OPEN A CONNECTION TO THE DATA BASE SERVER
// MAN PAGE: http://php.net/manual/en/function.mysql-connect.php
if (!$db_connection = mysql_connect("$db_host", "$db_user", "$db_word"))
{
    $errmsg = mysql_errno() . ' ' . mysql_error();
    echo "<br/>NO DB CONNECTION: ";
    echo "<br/> $errmsg <br/>";
}

// SELECT THE MYSQL DATA BASE
// MAN PAGE: http://php.net/manual/en/function.mysql-select-db.php
if (!$db_sel = mysql_select_db($db_name, $db_connection))
{
    $errmsg = mysql_errno() . ' ' . mysql_error();
    echo "<br/>NO DB SELECTION: ";
    echo "<br/> $errmsg <br/>";
    die('NO DATA BASE');
}
// IF WE GOT THIS FAR WE CAN DO QUERIES

Open in new window

0
 
sydneyguyAuthor Commented:
this si the config fie for the zeeauctions, understanding connections to mysql is not the problem, the problem is if there is a coding problem or i have something not as the code actually wants, this is what i am not sure of, its easy onece you have done it once cause you know what works and what it does not want to operaate

<?php

/*
Copyright Notice                
Web Site URL:  http://www.zeeways.com                  
Script Owner eMail: mail@zeeways.com    
Date: April, 2007        
Script Name: Zeeways Auction Website PHP Script  
Copyright Details: This script is not free.  Do not Remove this Copy Right notice.  
*/

// YOU NEED TO CHANGE THE CONTENTS OF THE values of variables given in single quotes

//CONFIGURATION SECTION STARTS ///

$servername='localhost' ;  // Replace this 'localhost' with your server name
$database_username='musician_username'; // Replace this  with your username
$database_password='musician_password';  // Replace this  with your password
$database_name='musician_DB';//'bidmonster';  // Replace this 'db' with your database name

// CONFIGURATION SECTION ENDS ////



mysql_connect($localhost,$musician_username,$musician_password);
mysql_select_db($musician_db);

?>
0
 
sydneyguyAuthor Commented:
have checked and double checked the connection deatials through sqlmyog so i knoe that the data is 100% correct, so having the wrong connection data is not the problem, and the myconnect scrip is identical so that is not the problem
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
sydneyguyAuthor Commented:
its defeinetly reading the right file
0
 
sydneyguyAuthor Commented:
ok still got some problems with some Warning: session_start() [function.session-start]: Cannot send session cookie -
but its username as set up
password as set up
db as set up
and 'localhost'
not sure what was goign on before
0
 
sydneyguyAuthor Commented:
does not use the admin mycongifg for start up
0
 
sydneyguyAuthor Commented:
just need to close and sbmit points
0
 
sydneyguyAuthor Commented:
thanks ray have dumped this add on its a peice of junk am now using webid brilliant bit of auction software its open source with lots of support and very well laid out and easy to install
hows the weather over there im in the UK again
garry
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now