sampathkumara Posted February 28, 2009 Posted February 28, 2009 Hi, i have OSC store setup and contents files are in server and mysql database is located another servers which is remote data base so i have declare data base connection in configure file properly but i am getting below error message please help any one have idea how to make it active (remote mysql data base connection) Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'mysql.w......s.com' (4) in /home/.....public_html/includes/functions/database.php on line 17 Unable to connect to database server! here i have declare data base connection properly define('DB_SERVER', ''); define('DB_SERVER_', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', ''); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); ?>
♥geoffreywalton Posted February 28, 2009 Posted February 28, 2009 Have never seen define('DB_SERVER_', ''); Might be the version you are running. Try this format define('DB_SERVER', '200.0.0.123'); Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
sampathkumara Posted February 28, 2009 Author Posted February 28, 2009 Hi, Actually i am using db connection as below define('DB_SERVER', 'mysql.win-servers.com'); define('DB_SERVER_USERNAME', 'username'); define('DB_SERVER_PASSWORD', 'password'); define('DB_DATABASE', 'database'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); but i am getting this error can u help please Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'mysql.w......s.com' (4) in /home/.....public_html/includes/functions/database.php on line 17 Unable to connect to database server!
ricksteruk2005 Posted February 28, 2009 Posted February 28, 2009 do win-servers allow remote connections? I dont help with templates (thats what the seller is for) th search function will often help, when it dont try this in google. site:http://www.oscommerce.com/forums then your search word
spooks Posted February 28, 2009 Posted February 28, 2009 Have you told the host? Is there a firewall? Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al.
sampathkumara Posted February 28, 2009 Author Posted February 28, 2009 hi thanks for all replies. actually that server support remote db connection but i have no idea whats going wrong. any idea please ?
ricksteruk2005 Posted February 28, 2009 Posted February 28, 2009 I would say you got your username or password name incorrect usually the names would be in the format of something_something I dont help with templates (thats what the seller is for) th search function will often help, when it dont try this in google. site:http://www.oscommerce.com/forums then your search word
sampathkumara Posted February 28, 2009 Author Posted February 28, 2009 i am using everything correct. is there any further setting in configure file ?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.