We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
adding new database error
adding new database error
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.
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.
Re: adding new database error
It's sad to hear this. But give more info about what you do and your system.
Re: adding new database error
What I found to work is to make a copy of /usr/local/vesta/conf/mysql.conf and name it mysqld.conf.
Re: adding new database error
woo that did the trick thanks m8! but i think is a bug since the upgrade they have to look at.
Re: adding new database error
Your right there is a bug the developers made some changes which you can see here.Teo wrote:woo that did the trick thanks m8! but i think is a bug since the upgrade they have to look at.
Code: Select all
nano $VESTA/conf/vesta.conf
ToDB_SYSTEM='mysqld'
Remove or rename to mysql.confDB_SYSTEM='mysql'
Code: Select all
/usr/local/vesta/conf/mysqld.conf
Code: Select all
nano $VESTA/bin/v-list-sys-services
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
Re: adding new database error
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.
Re: adding new database error
Teo wrote: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.
Re: adding new database error
i cannot add any database because localhost is blank, can you please help me fixing this bug? thanks.