adding new database error

[Teo]

Hello,

i cannot add any database because it doesn't set localhost as host automatically anymore from 2day. In the scroll down menu there is no option as well..

thanks.

[skurudo]

It's sad to hear this. But give more info about what you do and your system.

[Teo]

OS: Centos 6.6

system is a Xen VPS 2 Gb RAM - 2 Core

just it stoped working since your last update it was working fine b4.


here a screenshot:



Thank you.

[joem]

What I found to work is to make a copy of /usr/local/vesta/conf/mysql.conf and name it mysqld.conf.

[Teo]

woo that did the trick thanks m8! but i think is a bug since the upgrade they have to look at.

[joem]

woo that did the trick thanks m8! but i think is a bug since the upgrade they have to look at.

Your right there is a bug the developers made some changes which you can see here.

Code: Select all

nano $VESTA/conf/vesta.conf

Change

DB_SYSTEM='mysqld'

To

DB_SYSTEM='mysql'

Remove or rename to mysql.conf

Code: Select all

/usr/local/vesta/conf/mysqld.conf

Code: Select all

nano $VESTA/bin/v-list-sys-services

Find

Code: Select all

# DB
service=$DB_SYSTEM
if [ ! -z "$service" ] && [ "$service" != 'remote' ]; then
    for db in ${DB_SYSTEM//,/ }; do
        service="$db"
        if [ "$service" == 'mysql' ]; then
            db_proc_name='mysqld'
        fi
        if [ "$service" == 'pgsql' ]; then
            service='postgresql'
            db_proc_name='postmaster'
            if [ ! -e "/etc/redhat-release" ]; then
                db_proc_name='postgres'
            fi
        fi
        get_srv_state $service $db_proc_name
        str="$str\nNAME='$service' SYSTEM='database server' STATE='$state'"
        str="$str CPU='$cpu' MEM='$mem' RTIME='$rtime'"
    done
fi

Change to

Code: Select all

# DB
service=$DB_SYSTEM
if [ ! -z "$service" ] && [ "$service" != 'remote' ]; then
    for db in ${DB_SYSTEM//,/ }; do
        service="$db"
        if [ "$service" == 'mysql' ]; then
            if [ ! -e "/etc/init.d/$service" ]; then
                service='mysqld'
            fi
            if [ ! -e "/etc/redhat-release" ]; then
                db_proc_name='mysqld'
            fi
        fi
        if [ "$service" == 'pgsql' ]; then
            service='postgresql'
            db_proc_name='postmaster'
            if [ ! -e "/etc/redhat-release" ]; then
                db_proc_name='postgres'
            fi
        fi
        get_srv_state $service $db_proc_name
        str="$str\nNAME='$service' SYSTEM='database server' STATE='$state'"
        str="$str CPU='$cpu' MEM='$mem' RTIME='$rtime'"
    done
fi

[Teo]

hello this doesn't work. i applied the edits but nothing, localhost disappeared again. is there a way to come back to the previous version?? i cannot add database neither now seems everything fucked.

[joem]

hello this doesn't work. i applied the edits but nothing, localhost disappeared again. is there a way to come back to the previous version?? i cannot add database neither now seems everything fucked.

Once you apply the fix you must logout then log back in.

[Teo]

i cannot add any database because localhost is blank, can you please help me fixing this bug? thanks.