Can't login to ispconfig controlpanel after db sync

ikrudolf · Jul 30, 2014

I used this script to sync all my db's from the old server to the new server but can't login on the new servers ispconfig controlpanel after syncing.

#!/bin/bash
# where your mysql commands are
CMD_MYSQL="/usr/bin/mysql"
CMD_MYSQLDUMP="/usr/bin/mysqldump"

# login credentials of the submitting side
DB_USER_FROM="root"
DB_PASS_FROM="password"
DB_HOST_FROM="localhost"

# login credentials of the receiving side
DB_USER_TO="root"
DB_PASS_TO="password"
DB_HOST_TO="192.168.2.159" # IP of target server...

# index all databases on the local (submitting) side
echo "database sync"
DATABASES=`echo "SHOW DATABASES;" | ${CMD_MYSQL} -p${DB_PASS_FROM} -u ${DB_USER_FROM} -h ${DB_HOST_FROM}`

# loop over all the databases
for DATABASE in $DATABASES; do
# skip non-databases
if [ "${DATABASE}" != "Database" ] && [ "${DATABASE}" != "information_schema" ]; then
echo "transmitting ${DATABASE}"

# create database on remote (receiving) side if it doesn't exist
echo "CREATE DATABASE IF NOT EXISTS ${DATABASE}" | ${CMD_MYSQL} -p${DB_PASS_TO} -u ${DB_USER_TO} -h ${DB_HOST_TO}

# dump the current database and pipe it directly to the remote (receiving) side to inject it
${CMD_MYSQLDUMP} -Q -B --create-options --delayed-insert --complete-insert --quote-names --add-drop-table -p${DB_PASS_FROM} -u${DB_USER_FROM} -h${DB_HOST_FROM} ${DATABASE} | ${CMD_MYSQL} -p${DB_PASS_TO} -u ${DB_USER_TO} -h ${DB_HOST_TO} ${DATABASE}
fi
done
Click to expand...

Any tips/suggestions?

till · Jul 30, 2014

Maybe you overwrote the ispconfig database user. You can get the correct password from the file /usr/local/ispconfig/server/lib/config.inc.php. Use this password and set it again in mysql with phpmyadmin. dont change the password in the config file.

ikrudolf · Jul 30, 2014

Till,

The password for user ispconfig in the MySQL db via phpmyadmin starts with *4AA9F8F7C9676E8A... but the password in the config file starts like 21c46cdd00a....

How to add it in phpmyadmin?

till · Jul 30, 2014

copy the password from the file into the password field in phpmyadmin, then select "PASSWORD" as function for this field in phpmyadmin and click on save.

ikrudolf · Jul 30, 2014

Tnx Till that did it
(and restarted mysql after changing the password)

Log in or Sign up

Can't login to ispconfig controlpanel after db sync

ikrudolf Member

till Super Moderator Staff Member ISPConfig Developer

ikrudolf Member

till Super Moderator Staff Member ISPConfig Developer

ikrudolf Member

Share This Page

Log in or Sign up

Can't login to ispconfig controlpanel after db sync

ikrudolf Member

till Super Moderator Staff Member ISPConfig Developer

ikrudolf Member

till Super Moderator Staff Member ISPConfig Developer

ikrudolf Member

Share This Page

Useful Searches