mysql error
Shadow_X - August 24, 2008 - 10:14
| Project: | osCommerce |
| Version: | 6.x-1.0 |
| Component: | User interface |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Shadow_X |
| Status: | postponed (maintainer needs more info) |
Jump to:
Description
My webhost has the mysql servers on a seperate domain rather than localhost. I have the correct mysql information set in the module, yet it continues to say the link is invalid. Any ideas?
#1
Hi Shadow,
The Drupal site needs to be able to see the database where osCommerce is hosted. If it's on a different domain, the database might be behind a firewall.
Are you able to access the osCommerce database from your desktop (eg using MySQL Admin)?
Steve
#2
#3
I've just spotted a bug in the connection and will post an update shortly.
#4
Automatically closed -- issue fixed for two weeks with no activity.
#5
I have the same problem.
Did you get to finding out the bug?
#6
Here is the fix:
In the file sites/all/modules/oscommerce/oscommerce.module change line 254 from:
$host = variable_get('oscommerce_host', '');
To:
$host = variable_get('oscommerce_hostname', '');
That should take care of it :)
#7
hi,CrosiarCM.
I was changed
$host = variable_get('oscommerce_host', '');
to
$host = variable_get('oscommerce_hostname', '');
But i still got the error message like this:
warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mydatabase_name'@'localhost' (using password: YES) in /sites/all/modules/oscommerce/oscommerce.module on line 254.
How do i do to resolve this problem to show my oscommerce products on my Drupal site?
my oscommerce was installed in sub directory in my website
Thanks.
#8
Hi Goodspoint,
Sorry I didn't see your message until now. Did you get this resolved yet? It is difficult for me to tell what is wrong from the information you gave.
It also looks to me that this module is broken for the latest oscommerce. I'm investigating that right now.
M.