mysql error

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

I've just spotted a bug in the connection and will post an update shortly.

I have the same problem.

Did you get to finding out the bug?

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 :)

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.

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.

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)

I am closing this issue, since it's for a Drupal version no longer supported.