RUMped, Leopard, MySQL and MAMP

Contesting and dx-peditioning with the Mac
User avatar
DL2RUM
Administrator
Posts: 2770
Joined: Mon 27. Aug 2007, 13:36
Location: JO40DF

RUMped, Leopard, MySQL and MAMP

Unread post by DL2RUM »

Hi folks,

Léonce, FM5DN uses the MAMP package http://www.mamp.info/en/index.php for the MySQL server. There are some advantages and some disadvantages as well. MAMP is very easy to install and could be your first choice when trying out RUMped.
Under Leopard, there are now some issues with this error message: "Can't connect to local MySQL server throught socket /tmp/mysql.sock(2)" During investigation it was found out, that Leopard was making the trouble because the mysql.sock default location was changed. That means, you can run into the same trouble even when using other MySQL installations and also with other applications which using MySQL as well. It is not a RUMped problem. There is a simple solution: Do not use 'localhost' as hostname, use 127.0.0.1 instead!
LogIn.tiff
LogIn.tiff (19.75 KiB) Viewed 4366 times
LogIn.tiff
LogIn.tiff (19.75 KiB) Viewed 4366 times
The screen shoot was taken using the MAMP as server. Please note the different port setting. The default password in the MAMP installation is 'root'
73 and best dx de Tom, DL2RUM
K6LE
Posts: 142
Joined: Fri 29. Feb 2008, 18:13
Location: Modesto, CA
Contact:

Re: RUMped, Leopard, MySQL and MAMP

Unread post by K6LE »

Thanks for the tip about MAMP.

Got it working right away and finally can play with RUMped.

Can't wait for the next contest!
Rick Prather
K6LE
Modesto, CA

2016 iMac 27" 5K
MacOS - HS
N9RLi
Posts: 1
Joined: Tue 30. Sep 2008, 20:23

Re: RUMped, Leopard, MySQL and MAMP

Unread post by N9RLi »

Even when doing that, you might get an issue is you're using MAMP. If you installed the latest MAMP, and you're using 127.0.0.1 you'll get an error saying "lost connection to mysql server during query". To solve this the easiest way...you'll need to open a terminal (applications, utilities, terminal) and type:

Code: Select all

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock
This will create a link from /tmp/mysql.sock to /Applications/MAMP/tmp/mysql/mysql.sock. If I'm not mistaken, RUMped assumes that the socket mysql is in /tmp. I hope this helps.

Edit: The result of running the command above is that you could use localhost as the server, meaning there is no need for 127.0.0.1...
Locked