Jump to content
Sign in to follow this  
High Sports

Featured Products MySQL Bit

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Å™ <michal@cihar.com>

* 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.

Share this post


Link to post
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!

Share this post


Link to post
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 <michal@cihar.com>

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×