osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

problem connecting to database from ssl

This is a discussion on problem connecting to database from ssl within the osCMax v1.7 Installation forums, part of the osCMax v1.7 Forums category; G'day, have set up ms2-max at the following location www.evotech.com.au everything works fine in the non ssl environment, but have ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v1.7 Forums > osCMax v1.7 Installation

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 01-24-2004, 03:49 PM
Lurker
 
Join Date: Jan 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sav1
Default problem connecting to database from ssl

G'day,
have set up ms2-max at the following location www.evotech.com.au
everything works fine in the non ssl environment, but have now started setting up ssl. My hosting company does not set up symbolic links and they suggested that i copy accross the required files to the ssl server. i have done this and modified the two config files. Now the catalog still works fine but as soon as you try to log into my account i get the following error message
"Warning: mysql_connect(): Access denied for user: 'evot@localhost.localdomain' (Using password: YES) in /home/hjs617/public_html/catalog/includes/functions/database.php on line 19
Unable to connect to database server!"
Now according to my hosting company the database server is 127.0.0.1 instead of local host. So as i understand the user should be evot@127.0.0.1 instead of 'evot@localhost.localdomain' . i have checked both configure files and they list the db server as 127.0.0.1 so i do not understand where the localhost.localdomain is coming from.

Any help would be greatly appreciated.
Cheers,
Sav
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 01-25-2004, 07:01 AM
New Member
 
Join Date: Jan 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Mibble
Default

localhost is the same as 127.0.0.1, you get to the same page on a system by going to http://localhost as you would http://127.0.0.1
in comparison to where your site is located, where is the SSL site located? you should not have had to change the database information whatsoever, else you would possibly using a new database?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 01-25-2004, 11:10 AM
Lurker
 
Join Date: Jan 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sav1
Default

could the problem be it is a shared ssl cert supplied by my host? perhaps the non-ssl side and the ssl side are hosted on different servers, would this make a difference?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 01-26-2004, 05:51 AM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,694
Thanks: 2
Thanked 96 Times in 82 Posts
Rep Power: 12
jpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of lightjpf is a glorious beacon of light
Default

Ask your HOST what the SQL server IP address actually is. If he can't do a symbolic link then the two are residing on two differnt servers with what would look like two differnt MySQL "server" if you try using 127.0.0.1/localhost. You would need the IP address of the physical SERVER that your MySQL database is on.

(That is ONE of the reasons why it is much better in the LONG run to have your OWN certificate)
__________________
JPF - osCMax Fourm Moderator
Try out our osCMax at: Live Catalog Demo
Limited access Admin: Live Admin Demo
Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Quick update not connecting brewer1st osCMax v2 Installation issues 1 02-05-2006 11:51 PM
Database transfer problem maullah osCMax v1.7 Installation 1 02-16-2005 07:34 AM
errors connecting database os max: how to solve doumawis osCMax v1.7 Installation 7 02-08-2005 12:11 AM
database problem - I think Svanelas osCommerce 2.2 Installation Help 1 09-19-2004 04:58 AM


All times are GMT -8. The time now is 06:04 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax