Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Failed to install Xeoncross/lowendscript
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

Failed to install Xeoncross/lowendscript

When installing mysql with this command:
./setup-debian.sh mysql

start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Anyone can help?

Comments

  • Make sure mysql is running (/etc/init.d/mysql start) and listening on that socket (see /etc/mysql/my.cnf). Otherwise use a port instead of a socket.

  • Ubuntu? Installing MySQL on Ubuntu sometimes PITA

  • saintsaint Member
    edited February 2015

    @nexusrain said:
    Make sure mysql is running (/etc/init.d/mysql start) and listening on that socket (see /etc/mysql/my.cnf). Otherwise use a port instead of a socket.

    I'm a noob on linux , just copy the command and paste into putty :(

  • saintsaint Member
    edited February 2015

    @NanoG6 said:
    Ubuntu? Installing MySQL on Ubuntu sometimes PITA

    debian 7

  • yywudiyywudi Member
    edited February 2015

    it's because the script was out of date, now the dotdeb mysql is 5.6 version, and the configuration file updated as default engine is Innode.
    you can use the default Innode just remove the below part in /etc/mysql/conf.d/lowendbox.cnf
    >

    -default_storage_engine=MyISAM
    -skip-innodb
    --log-slow-queries=/var/log/mysql/slow-queries.log

    or you need to update a correct configuration to disable Innode and use MyISAM:
    >

    [mysqld]
    key_buffer_size = 12M
    query_cache_size = 0
    table_open_cache = 32

    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    character-set-server = utf8
    collation-server = utf8_unicode_ci
    skip-character-set-client-handshake

    default-storage-engine=MyISAM
    default-tmp-storage-engine=MYISAM
    loose-skip-innodb

    loose-innodb-trx=0
    loose-innodb-locks=0
    loose-innodb-lock-waits=0
    loose-innodb-cmp=0
    loose-innodb-cmp-per-index=0
    loose-innodb-cmp-per-index-reset=0
    loose-innodb-cmp-reset=0
    loose-innodb-cmpmem=0
    loose-innodb-cmpmem-reset=0
    loose-innodb-buffer-page=0
    loose-innodb-buffer-page-lru=0
    loose-innodb-buffer-pool-stats=0
    loose-innodb-metrics=0
    loose-innodb-ft-default-stopword=0
    loose-innodb-ft-inserted=0
    loose-innodb-ft-deleted=0
    loose-innodb-ft-being-deleted=0
    loose-innodb-ft-config=0
    loose-innodb-ft-index-cache=0
    loose-innodb-ft-index-table=0
    loose-innodb-sys-tables=0
    loose-innodb-sys-tablestats=0
    loose-innodb-sys-indexes=0
    loose-innodb-sys-columns=0
    loose-innodb-sys-fields=0
    loose-innodb-sys-foreign=0
    loose-innodb-sys-foreign-cols=0

    slow-query-log = 1
    slow_query_log_file=/var/log/mysql/slow-queries.log

    you can check from mysql official site for reference: http://dev.mysql.com/doc/refman/5.6/en/innodb-turning-off.html

    and also pay attention to php-fpm configuration as the PHP version also updated.
    change all the

    fastcgi_pass 127.0.0.1:9000;

    part to

    fastcgi_pass unix:/var/run/php5-fpm.sock;

    otherwise you'll meet 502 error as can't fine php upstream

  • saintsaint Member
    edited February 2015

    Thank you! it seems hard for linux noob, would you like to recommend some up to date LEB scripts?

  • I just found https://github.com/Xeoncross/lowendscript got some pull request from other users, but i'm not sure if fix the mysql issue. did you use the latest script from the github?

    I made some update based on Xeoncross's script, but it's also 4 months ago, I'm not sure if it works right now. you can just have a try. https://github.com/yywudi/lowendscript

    ANYWAY, if you want to use a system configuration script, you must know every line of this script, not only to understand linux script language but also for your system security.
    keep studying

  • Yes, I used the latest script from the github.
    I'll try yours!

  • saintsaint Member
    edited February 2015

    Also failed :(

    start: Job failed to start

    invoke-rc.d: initscript mysql, action "start" failed.
    dpkg: error processing mysql-server-5.6 (--configure):
    subprocess installed post-installation script returned error exit status 1
    dpkg: dependency problems prevent configuration of mysql-server:
    mysql-server depends on mysql-server-5.6; however:
    Package mysql-server-5.6 is not configured yet.
    dpkg: error processing mysql-server (--configure):
    dependency problems - leaving unconfigured
    Errors were encountered while processing:
    mysql-server-5.6
    mysql-server
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    mysql start/running, process 25460
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'

    I have to give up this script...

  • GoodHostingGoodHosting Member
    edited February 2015

    @saint

    @yywudi said:

    ANYWAY, if you want to use a system configuration script, you must know every line of this script, not only to understand linux script language but also for your system security.

    >

    keep studying

  • yywudiyywudi Member
    edited February 2015

    @saint said:
    Also failed :(

    I have to give up this script...

    yep, it's normal as I didn't update it for over 4 months. As I have no new debian server need to install.
    then try to figure out it by yourself, or submit an issue in Xeoncross's github repository

Sign In or Register to comment.