Guest vivid Posted September 12, 2006 Share Posted September 12, 2006 hi guys My host has upgraded from mysql4 to mysql5 ive done the database conversion but cant file the file in cubecart to change to point to the new db. Local (web applications): Host: localhost | Socket: /tmp/mysql.sock is what im looking for because according to my host supprt i need to change this to Local (web applications): Host: localhost | Socket: /tmp/mysql5.sock any ideas thanks in advance Quote Link to comment Share on other sites More sharing options...
Guest vivid Posted September 13, 2006 Share Posted September 13, 2006 any ideas surely this is an easy one for you guys Quote Link to comment Share on other sites More sharing options...
rowdyplace Posted September 13, 2006 Share Posted September 13, 2006 yoursite/includes/global.inc.php is THE file that has the database linkage in it. Quote Link to comment Share on other sites More sharing options...
Guest vivid Posted September 13, 2006 Share Posted September 13, 2006 this is my global file what perameters do i change ?? mysql.sock to mysql5.sock <?php $glob['dbdatabase'] = 'testaccount'; $glob['dbhost'] = 'localhost'; $glob['dbpassword'] = 'password'; $glob['dbprefix'] = ''; $glob['dbusername'] = 'testaccount'; $glob['installed'] = '1'; $glob['rootDir'] = '/home/vividwholesale/www/test'; $glob['rootRel'] = '/'; $glob['storeURL'] = 'http://test.vividwholesale.com.au'; ?> Quote Link to comment Share on other sites More sharing options...
rowdyplace Posted September 13, 2006 Share Posted September 13, 2006 When I setup my database, My database file is "ccrt1" my server hosting account name is "bamabar" Note that the database name has the site name appended to it when I set up the database in CPanel's MySQL manager. "bamabar_ccrt1" My global.inc.php file: $glob['dbdatabase' ] = 'bamabar_ccrt1' ; $glob['dbhost' ] = 'localhost' ; $glob['dbusername' ] = 'bamabar_ccrt1' ; $glob['dbpassword' ] = 'aabbccddd' ; $glob['dbprefix' ] = '' ; $glob['installed' ] = '1' ; $glob['rootDir' ] = '/home/bamabar/public_html/cart' ; $glob['rootRel' ] = '/cart/' ; $glob['storeURL' ] = 'http://bamabar.com/cart' ; I'm thinking that you need the correct database and user names (with the appended site name...) in your global.inc.php file. I hope I'm not sending you down the wrong path... Quote Link to comment Share on other sites More sharing options...
Guest vivid Posted September 13, 2006 Share Posted September 13, 2006 any help is appreciated ill look into it Quote Link to comment Share on other sites More sharing options...
Guest vivid Posted September 13, 2006 Share Posted September 13, 2006 mmm? i dont think this is the solution I have 2 other databases with cube working on them and they are exactly the same as this on and they work ok. This is my test account. What my host has done is upgrade their sql database from 4 to 5 with both running side by side( so my other two stores are on 4 and still running ok) what I believe i need to do is change this sock /tmp/mysql.sock to /tmp/mysql5.sock file since there are 2 DB so cube knows which one to access as i think it defaults to mysql.sock. Thanx rowdy for your response, maybe you r on the right track but my eyes are blind and i cant see the answer!! Quote Link to comment Share on other sites More sharing options...
Guest vivid Posted September 14, 2006 Share Posted September 14, 2006 ok got the answer from my host support <?php $glob['dbdatabase'] = 'testaccount'; $glob['dbhost'] = 'localhost'; DELETE ABOVE LINE AND REPLACE WITH BELOW LINE $glob['dbhost'] = 'localhost:/tmp/mysql5.sock'; $glob['dbpassword'] = '2561mb'; $glob['dbprefix'] = ''; $glob['dbusername'] = 'vividwholesale'; $glob['installed'] = '1'; $glob['rootDir'] = '/home/vividwholesale/www/test'; $glob['rootRel'] = '/'; $glob['storeURL'] = 'http://www.test.vividwholesale.com.au'; ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.