Posted by Shadow_X on August 24, 2008 at 10:14am
Jump to:
| Project: | osCommerce |
| Version: | 6.x-1.0 |
| Component: | User interface |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Shadow_X |
| Status: | postponed (maintainer needs more info) |
Issue Summary
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?
Comments
#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.
#9
This module seems to be a great way to connect with my other site which is running osCommerce.
I would hope eventually to port the contents to my drupal site and stop paying for the package and hosting of the os Commerce site.
However I have run into a problem very early on.
At my first run I got the xxxxxxx@localhost error due to the incorrect spelling of the hostname variable, figured it and fixed ,just as in #7 above.
When I ran it again I get :
warning: mysql_connect() [function.mysql-connect]: Host 'xxxx-xxxxxx-x-x-xxxxxx.aztw.cable.virginmedia.com' is not allowed to connect to this MySQL server in F:\dsnet\drupal\sites\all\modules\oscommerce\oscommerce.module on line 256.The variables being used are
for hostname : www.mysite.com
for user : my cpanel username
for password : my cpanel password
Have I input my details incorrectly or is this a security measure I can't get around?
Environment:
Drupal version 6.14
PHP version 5.3 (as part of the XAMPP installation)