Vesta Control Panel - Forum

dpeca wrote:Please test scenario where (in cPanel) the same mysql user is used for two databases, or one database has granted to two different mysql users.
I noticed that importer script creates the same database two times in db.conf, and it brakes backup system.

# default cpanel user has all database privileges
# if you use default user in your config files to connect with database
# you will need remove && [ "$userdb" != "$sk_cp_user" ] to restore main user, but
# this will cause database duplication in db.conf and will interfer with vestacp backups 
			if [ "$userdb" == "$user" ] && [ "$userdb" != "$sk_cp_user" ] && [ "$userdb" != "$sk_real_cp_user" ] ; then
				echo "DB='$db' DBUSER='$userdb' MD5='$end_user_pass' HOST='localhost' TYPE='mysql' CHARSET='UTF8' U_DISK='0' SUSPENDED='no' TIME='$TIME' DATE='$DATE'" >> /usr/local/vesta/data/users/${sk_cp_user}/db.conf
			fi
		done
done

-- DB --
2017-03-29 23:19:10 novisind_nst (mysql)
2017-03-29 23:19:10 novisind_nst (mysql)
gzip: /backup/tmp.T9RmIk9lg1/db/novisind_nst/novisind_nst.mysql.sql.gz already exists; do you wish to overwrite (y or n)?

dpeca wrote:I found a vesta backup.log, to help you to figure ot how it breaks the backup.

So, in /usr/local/vesta/log/backup.log i found this:

-- DB --
2017-03-29 23:19:10 novisind_nst (mysql)
2017-03-29 23:19:10 novisind_nst (mysql)
gzip: /backup/tmp.T9RmIk9lg1/db/novisind_nst/novisind_nst.mysql.sql.gz already exists; do you wish to overwrite (y or n)?

That was last line of backup.log - so it means that backup script get stucked there.
Vesta backup script wait for y/n response (do you wish to overwrite (y or n)).

In /usr/local/vesta/data/users/novisad/db.conf I found elfi83_db1 two times, in two lines, with different mysql users - I'm talking this from my remember, dont trust me 100% about different mysql users.

System is Debian 8.7.
Maybe it's not reproducible on CentOS.

Probably two different mysql users was granted to the same database in cPanel, I guess.

dpeca wrote:Maybe Vesta backup script should be fixed.
If I'll have a time I will try to add parameter to gzip (in vesta backup script) to prevent blocking.

skamasle wrote:I cant reproduce this yet. I will test with more backups

dmitry.vd wrote:

skamasle wrote:I cant reproduce this yet. I will test with more backups

If it helps I can send you cPanel back up link using private message.

skamasle wrote:

dmitry.vd wrote:

skamasle wrote:I cant reproduce this yet. I will test with more backups

If it helps I can send you cPanel back up link using private message.

Ok send me it, I will investigate when get some time this week