Help - Search - Members - Calendar
Full Version: User Accoount Access
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
GreenboxLG
Hi

I recent;y installed a program called osCommerce on my site. Its a shopping basket/shop system that allows people to make orders with no hassle. I entered all the required fields in the installation( eg. server=localhost, DBname=whatever_zxq_net_oscom, DBuser=whatever_zxq_net_sdmin) which i had prepared before hand. The installation progressed without any problems (supposedly) and after the installation, the program gave links to the shops page and the programs shop-management-admin page. they both displayed these similar messages:

for the shop page:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'vhostswww'@'10.10.124.196' (using password: NO) in /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/includes/functions/database.php on line 19
Unable to connect to database server!


and for the admin page:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'10.10.124.196' (using password: NO) in /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/database.php on line 19
Unable to connect to database server!


I asked someone elsewhere on the company support forums and he asked

"Have you set up these users, to have access to the osC database you had previously set up, in your hosting service's control panel?"

Listed in the warnings are these "users" that i have seen when i opened phpMyadmin. i don't know how to assign privileges to these users. Has anyone experienced this problem before?

(note: i am completely ignorant of SQL) wacko.gif
Brandon
Read though this wink.gif
http://www.zymic.com/forum/index.php?showtopic=536
GreenboxLG
Actually there was no problem with that. what is strange is that it is asking for the users 'vhostswww'@'10.10.124.196' and 'mysql'@'10.10.124.196' which i don't know how to add a password for.
Brandon
QUOTE(GreenboxLG @ Apr 16 2008, 09:47 AM) *
Actually there was no problem with that. what is strange is that it is asking for the users 'vhostswww'@'10.10.124.196' and 'mysql'@'10.10.124.196' which i don't know how to add a password for.

Look for a "config.php" file it should have some space to put the "Host, Database User & Database Password"

Example
CODE
$conn = mysql_connect("localhost","Database User","Database Password");
mysql_select_db(UserSystem) or die(mysql_error());

$logged = MYSQL_QUERY("SELECT * FROM `members` WHERE `id` = '$_SESSION[id]' AND `password` = '$_SESSION[password]'");
$logged = mysql_fetch_array($logged);


If you have a Problem PM me and ill try help you out smile.gif
GreenboxLG
Actually, before you posted that, i reinstalled the program, and it seems to work, but the admin page is still not functioning.

it displays this now:


Warning: session_save_path() [function.session-save-path]: SAFE MODE Restriction in effect. The script whose uid is 58105 is not allowed to access owned by uid 0 in /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/sessions.php on line 165

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/sessions.php:165) in /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/sessions.php on line 102

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/sessions.php:165) in /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/sessions.php on line 102

Warning: Cannot modify header information - headers already sent by (output started at /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/sessions.php:165) in /www/zxq.net/g/r/e/greenboxmalaysia/htdocs/catalog/admin/includes/functions/general.php on line 22


Thanks for your help by the way smile.gif
GreenboxLG
is there anyway to turn off Safemode myself?
Valency
Safemode is disabled for security reasons. Next time please use our advanced search for problems regarding Safemode
(You can find a link to Advanced Search in my Signature)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2012 Invision Power Services, Inc.