[Camps-users] psql error when configured for mysql

[Russell Steinert]

On 8/31/12 3:03 PM, Sam Batschelet wrote:
> On Aug 31, 2012, at 2:54 PM, Jon Jensen <jon at endpoint.com> wrote:
>
>> On Thu, 30 Aug 2012, Russell Steinert wrote:
>>
>>> Occasionally when running test instances of mkcamp, we get an error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/home/camp/camp[camp no.]/mysql/tmp/mysql.[camp no.].sock' (2) Error piping command to psql:"
>>>
>>> We are configured for MySQL. Why would it reference PostgreSQL or am I misreading this?
>> The error message just wrongly always said psql, since mysql support was added later on. I just pushed an update that says "database" generically instead. :)
>>
>>> Most of the time the script connects just fine.  Only happens occasionally.
>> Strange. I've never seen that with MySQL or Postgres. I wonder if it's a timing problem, where the MySQL server may not be fully ready when we're sending that command.
>
> I have seen this as well I believe that it is caused by camps not being completely erased.  This happens if your mkcamp croaks and rmcamp doesn't see what it needs to go through the kill pid process and stops so you still have
>
> /bin/sh /usr/bin/mysqld_safe --defaults-file=/home/sam/camp15/my.cnf
>
> after error from rmcamp
>
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/home/sam/camp15/mysql/tmp/mysql.15.sock' (2)
> Check that mysqld is running and that the socket: '/home/sam/camp15/mysql/tmp/mysql.15.sock' exists!
>
> then try to build camp15 again. and camps no likey
>
> Not 100% but might be a lead.
>
> I think rmcamp should perhaps search and kill mysql camp even if it doesn't find the socket.
>
> -Sam
Yes, I confess that I only recently discovered the wonders of 
rmcamp....... and before was just crudely disposing of the accumulated 
test camps by manually clearing the camps table from the master database 
and deleting the camp folders from the user directory.  I am now doing 
it properly and it is much nicer..... ;) ~Russell