Forums

Resolved
0 votes
Hi,
I used to use the https://launchpadlibrarian.net/78745738/tuning-primer.sh script to verify that the db is running ok.

Though when I run it on 6.4 I get the following error:
- FINAL LOGIN ATTEMPT FAILED -
Unable to log into socket: /var/lib/system-mysql/mysql.sock
Any ideas?
Thanks.
Saturday, December 21 2013, 08:30 PM
Share this post:
Responses (5)
  • Accepted Answer

    Sunday, December 22 2013, 12:45 AM - #Permalink
    Resolved
    0 votes
    Get your system root password with this:
    cat /var/clearos/system_database/root


    When you run through the script, use the system Mysql socket (I think you did) /var/lib/system-mysql/mysql.sock and the user 'root' along twith that password obtained from the command above.

    Worked for me.

    B.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, December 22 2013, 04:31 AM - #Permalink
    Resolved
    0 votes
    Thanks Ben but it does not seem to work for me.
    I get the same error.
    What version of the script do you run?
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, December 22 2013, 06:00 PM - #Permalink
    Resolved
    0 votes
    In case someone runs into the same issue:
    change the script from
    218 mysql="mysql"
    219 mysqladmin="mysqladmin":
    TO:
    218 mysql="/usr/clearos/sandbox/usr/bin/mysql"
    219 mysqladmin="/usr/clearos/sandbox/usr/bin/mysqladmin"

    After this couple of changes the scripts will run.
    218 is the line number in version 1.6 of the script.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, December 24 2013, 01:28 AM - #Permalink
    Resolved
    0 votes
    You can migrate your system-mysql to faster spindles (RAID 10 or SSD) by using this guide.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, December 24 2013, 05:34 AM - #Permalink
    Resolved
    0 votes
    Thanks Dave,
    These are two different issues.
    I am looking to optimize ( I already may be running db on the mirrored ssd )
    You proposing faster hardware :)
    The reply is currently minimized Show
Your Reply