Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Featured Products MySQL Bit


Guest

Recommended Posts

I'm tearing my hair out here - I've tried to avoid use of mySQL things like phpmyadmin so far because they just seem so user unfriendly and I haven't got time to be mastering sql.... but the Featured Products contribution requires that I run a file to create a new table in the database.

 

No problems there, I think I could do that... IF I COULD JUST GET PHPMYADMIN TO WORK. Man I hate this stuff.

 

Anyway, sorry for the angst - I'm getting this error message:

 

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
I looked about on the internet - tried changing the hostname to 127.0.0.1 (but I thought that was the local machine?)... tried adding a bit about sockets which you can see below - this is my config file with some bits edited out:

 

<?php

/*

* Generated configuration file

* Generated by: phpMyAdmin 2.10.0-rc1 setup script by Michal ÄŒihaÅ™ <[email protected]>

* Version: $Id: setup.php 9697 2006-11-13 08:32:28Z nijel $

* Date: Wed, 21 Feb 2007 10:50:01 GMT

*/

 

/* Servers configuration */

$i = 0;

 

/* Server 213.171.***.*** (config:highsports) [1] */

$i++;

$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

$cfg['Servers'][$i]['relation'] = 'pma_relation';

$cfg['Servers'][$i]['table_info'] = 'pma_table_info';

$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'pma_column_info';

$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

$cfg['Servers'][$i]['history'] = 'pma_history';

$cfg['Servers'][$i]['host'] = '127.0.0.1';

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['controluser'] = '*****';

$cfg['Servers'][$i]['controlpass'] = '*****';

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = '*****';

$cfg['Servers'][$i]['password'] = '*****';

$cfg['Servers'][$i]['only_db'] = 'HSsql';

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['LogoutURL'] = '*****';

$cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';

 

/* End of servers configuration */

 

$cfg['DefaultTabServer'] = 'main.php';

$cfg['DefaultTabDatabase'] = 'db_structure.php';

$cfg['DefaultTabTable'] = 'tbl_structure.php';

$cfg['LightTabs'] = false;

$cfg['LeftFrameLight'] = true;

$cfg['LeftFrameDBTree'] = true;

$cfg['LeftFrameDBSeparator'] = '_';

$cfg['LeftFrameTableSeparator'] = '__';

$cfg['LeftFrameTableLevel'] = 1;

$cfg['LeftDisplayLogo'] = true;

$cfg['LeftDisplayServers'] = false;

$cfg['DisplayServersList'] = false;

$cfg['DisplayDatabasesList'] = false;

$cfg['LeftPointerEnable'] = true;

$cfg['ErrorIconic'] = true;

$cfg['MainPageIconic'] = true;

$cfg['ReplaceHelpImg'] = true;

$cfg['NavigationBarIconic'] = 'both';

$cfg['PropertiesIconic'] = 'both';

$cfg['BrowsePointerEnable'] = true;

$cfg['BrowseMarkerEnable'] = true;

$cfg['ModifyDeleteAtRight'] = false;

$cfg['ModifyDeleteAtLeft'] = true;

$cfg['RepeatCells'] = 100;

$cfg['DefaultDisplay'] = 'horizontal';

$cfg['TextareaCols'] = 40;

$cfg['TextareaRows'] = 7;

$cfg['LongtextDoubleTextarea'] = true;

$cfg['TextareaAutoSelect'] = true;

$cfg['CharEditing'] = 'input';

$cfg['CharTextareaCols'] = 40;

$cfg['CharTextareaRows'] = 2;

$cfg['CtrlArrowsMoving'] = true;

$cfg['DefaultPropDisplay'] = 'horizontal';

$cfg['InsertRows'] = 2;

$cfg['EditInWindow'] = true;

$cfg['QueryWindowHeight'] = 310;

$cfg['QueryWindowWidth'] = 550;

$cfg['QueryWindowDefTab'] = 'sql';

$cfg['AllowAnywhereRecoding'] = false;

$cfg['DefaultCharset'] = 'iso-8859-1';

$cfg['RecodingEngine'] = 'iconv';

$cfg['IconvExtraParams'] = '//TRANSLIT';

$cfg['GD2Available'] = 'yes';

$cfg['QueryHistoryDB'] = false;

$cfg['QueryHistoryMax'] = 25;

$cfg['BrowseMIME'] = true;

$cfg['PDFDefaultPageSize'] = 'A4';

?>

 

If anyone could help me out with this I'd really appreciate it, grrrrrr!!!!! Going for lunch at 11am... I feel like that guy in Office Space.

Link to comment
Share on other sites

No one? Am I not providing enough information or something?

 

Everyone that installed this contribution must have a config file like this..... if you could even just copy and paste yours in I'd appreciate it!

Link to comment
Share on other sites

Right, well I finally got it working - it's always the simple things. Despite reading what seemed like every post on the internet regarding this error, and trying about 100 different variations of the config file, it seems I was using the wrong username!!!!

 

Typical. Not sure why this would cause the socket error but there you go. In the end I used a simple config file which I'll paste below for anyone that has similar problems to try... (although there seem to be thousands of solutions to this problem out there, good luck with that!).

 

<?php

/*

* Generated configuration file

* Generated by: phpMyAdmin 2.10.0-rc1 setup script by Michal Cihar <[email protected]>

* Version: $Id: setup.php 9697 2006-11-13 08:32:28Z nijel $

* Date: Mon, 26 Feb 2007 10:25:30 GMT

*/

 

/* Servers configuration */

$i = 0;

 

/* Server MySQL server IP (config:highsports) [1] */

$i++;

$cfg['Servers'][$i]['host'] = 'MySQL server IP address here';

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'username here';

$cfg['Servers'][$i]['password'] = 'password here';

$cfg['Servers'][$i]['only_db'] = 'HSsql';

 

 

/* End of servers configuration */

 

?>

 

There was a huge cheer from my little office when it worked... quickly followed by a huge grin when I realised what I'd been doing wrong :blush:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...