1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Update 10.2 to 10.3 (Ubuntu 10 LTS) - autoresponder not working afterwards

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by t.van.der.plas, Jul 18, 2011.

  1. t.van.der.plas

    t.van.der.plas New Pleskian

    22
    73%
    Joined:
    Sep 17, 2007
    Messages:
    22
    Likes Received:
    0
    Dear all, after Upgrading from 10.2 to 10.3 and trying to activate an autoresponder for a email adress, i get the following errormessage, any idea what could cause this:

    Specified column "isLegacyUser" is not in the row

    Cheers

    Tobias
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    Looks like smb_users table in Plesk database was not correctly upgraded during Plesk upgrade procedure. Try to fix upgrade with bootstrapper repair.
     
  3. t.van.der.plas

    t.van.der.plas New Pleskian

    22
    73%
    Joined:
    Sep 17, 2007
    Messages:
    22
    Likes Received:
    0
    unfortunately this does not seem to work, prior to running bootstrapper, mysql works fine, but during repair i get this errormessage:

    `/opt/psa/suexec/psa-suexec' -> `/usr/lib/apache2/suexec'
    Trying to set up APS controller database... Attempting to check APS db connection via ODBC, using /usr/bin/isql (empty output is good)
    [ISQL]ERROR: Could not SQLConnect
    Failed, rc = 1.
    Attempting to check APS db connection via ODBC, using /usr/bin/iusql (empty output is good)
    [ISQL]ERROR: Could not SQLDriverConnect
    Failed, rc = 1.
    Failed to establish test connection. Cleaning up.

    ERROR while trying to establish test connection to APS database via ODBC
    Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again

    ***** problem report *****
    ERROR while trying to establish test connection to APS database via ODBC
    Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again
     
  4. t.van.der.plas

    t.van.der.plas New Pleskian

    22
    73%
    Joined:
    Sep 17, 2007
    Messages:
    22
    Likes Received:
    0
    p.s. in the logfile it seems that the mysql user is ok, and a connection is possible:

    Checking for the system groups and users necessary for MySQL...
    Checking for the group 'mysql'...
    Group 'mysql' already exists

    Checking for the user 'mysql'...
    User 'mysql' already exists

    .....................

    Trying to start service mysql... /usr/sbin/mysqld (pid 1152) is running...
    done
    Trying to establish test connection... connected
    done
    Trying to backup MySQL database... done
    MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20110719-073505.dump.gz
    Checking that /opt/psa/bin/chrootsh registered as login shell...

    Create PPSB support group
    Checking for the group 'psasb'...
    Group 'psasb' already exists

    Checking for the group 'psasb'...
    Trying to add supplementary group 'psasb' for user 'psaadm'... already there
    Checking for the group 'psasb'...
    Trying to add supplementary group 'psasb' for user 'www-data'... already there

    ===> Performing safe prep-install database actions


    ===> Upgrading database

    Trying to start service mysql... /usr/sbin/mysqld (pid 1152) is running...
    done
    Trying to establish test connection... connected
    done
    Trying to find psa database... version is 010120
    Version is OK, no need to create psa database.
    Trying to backup MySQL database... done
    MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20110719-073507.dump.gz

    ...........................

    ===> Installing phpMyAdmin
    Trying to create pmadb... done
    done

    after the upgrade / repair attempt, hosting is no longer working, i need to run a httpdmgr --reconfigure-all
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    The problem can be related to mysql not accepting to network connections. Check it with:
    ODBC connects to mysql via local TCP/IP connection on port 3306. Try comment out a line in /etc/my.cnf to enable it
    #skip-networking

    After that bootstrapper repair could be run with no issue.
     
  6. t.van.der.plas

    t.van.der.plas New Pleskian

    22
    73%
    Joined:
    Sep 17, 2007
    Messages:
    22
    Likes Received:
    0
    thanks a lot, this solved the issue....
     
  7. mediagiantdesign

    mediagiantdesign Guest

    0
     
    Still doesnt work...

    Hello,
    I am upgrading our Ubuntu 10.04 server from 10.2 to 10.3 and have followed the instructions here with no luck:

    Here is a step by step:


    root@dev:~# mysql -h 127.0.0.1 -P 3306 -uadmin -p`cat /etc/psa/.psa.shadow`
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 999
    Server version: 5.1.41-3ubuntu12.10 (Ubuntu)

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql> exit
    Bye
    root@dev:~# /opt/psa/bootstrapper/pp10.12.0-bootstrapper/bootstrapper.sh repair
    config updated
    ===> Updated /etc/psa/psa.conf
    ===> Preparing upgrade
    Stopping psa... done
    Stopping mail handlers tmpfs storage
    psa is stopped
    Stopping psa... done
    Stopping mail handlers tmpfs storage
    ===> Cumulative database upgrade has been started
    ===> Upgrade completed.
    System start/stop links for /etc/init.d/xinetd already exist.
    System start/stop links for /etc/init.d/xinetd already exist.
    Module ssl already enabled
    ln: creating symbolic link `/var/named/run-root/etc/bind/rndc.conf': File exists
    update-rc.d: /etc/init.d/named: file does not exist
    mknod: `/var/www/vhosts/chroot/dev/null': File exists
    Module suexec already enabled
    Module include already enabled
    Module rewrite already enabled
    Module userdir already enabled

    **** Product repair started.

    ===> Checking for previous installation ... found.
    Create user 'psaadm' and group 'psaadm'
    Checking for the group 'psaadm'...
    Group 'psaadm' already exists

    Checking for the user 'psaadm'...
    User 'psaadm' already exists

    Create group swkey-data
    Checking for the group 'swkey-data'...
    Group 'swkey-data' already exists

    Checking for the group 'swkey-data'...
    Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
    Create Mail accounts
    Checking for the group 'popuser'...
    Group 'popuser' already exists

    Checking for the user 'popuser'...
    User 'popuser' already exists

    Checking for the user 'mhandlers-user'...
    User 'mhandlers-user' already exists

    Trying to got legacy variables... done
    Trying to save legacy variables... done
    Checking for the system groups and users necessary for ftp server...
    Checking for the group 'psaftp'...
    Group 'psaftp' already exists

    Checking for the user 'psaftp'...
    User 'psaftp' already exists


    Checking for the system groups and users necessary for Apache...
    Checking for the group 'www-data'...
    Group 'www-data' already exists

    Checking for the user 'www-data'...
    User 'www-data' already exists


    ===> Checking for the necessary system accounts
    Checking for the system groups and users necessary for MySQL...
    Checking for the group 'mysql'...
    Group 'mysql' already exists

    Checking for the user 'mysql'...
    User 'mysql' already exists

    Checking for the system groups and users necessary for admin server...
    Checking for the group 'psaadm'...
    Group 'psaadm' already exists

    Checking for the user 'psaadm'...
    User 'psaadm' already exists

    Checking for the group 'psaserv'...
    Group 'psaserv' already exists

    Checking for the group 'psaserv'...
    Trying to add supplementary group 'psaserv' for user 'www-data'... already there
    Checking for the group 'psaserv'...
    Trying to add supplementary group 'psaserv' for user 'psaftp'... already there
    Checking for the group 'psaserv'...
    Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
    Checking for the group 'psacln'...
    Group 'psacln' already exists

    Trying to start service mysql... /usr/sbin/mysqld (pid 15337) is running...
    done
    Trying to establish test connection... connected
    done
    Trying to backup MySQL database... done
    MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20110725-115440.dump.gz
    Checking that /opt/psa/bin/chrootsh registered as login shell...

    Create PPSB support group
    Checking for the group 'psasb'...
    Group 'psasb' already exists

    Checking for the group 'psasb'...
    Trying to add supplementary group 'psasb' for user 'psaadm'... already there
    Checking for the group 'psasb'...
    Trying to add supplementary group 'psasb' for user 'www-data'... already there

    ===> Performing safe prep-install database actions


    ===> Upgrading database

    Trying to start service mysql... /usr/sbin/mysqld (pid 15337) is running...
    done
    Trying to establish test connection... connected
    done
    Trying to find psa database... version is 010120
    Version is OK, no need to create psa database.
    Trying to backup MySQL database... done
    MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.10.11.0-10.12.0.20110725-115441.dump.gz
    no upgrade for 80
    no upgrade for 81
    no upgrade for 82
    no upgrade for 83
    no upgrade for 84
    no upgrade for 86
    no upgrade for 90
    no upgrade for 92
    no upgrade for 93
    no upgrade for 95
    no upgrade for 100
    no upgrade for 101
    no upgrade for 107
    no upgrade for 108
    no upgrade for 109
    no upgrade for 1010
    no upgrade for 1011
    no upgrade for 1012
    Trying to set psa database version to 010120... Warning: there are no bootstrapper prep_install actions for component 'horde'
    Trying to generate default psa SSL Certificate... default certificate already exists
    done
    Trying to install PAM module... PAM configuration loaded from (directory="/etc/pam.d", file="/etc/pam.conf"). Configuration contains 25 file(s)
    PAM configuration saved (directory="/etc/pam.d", file="/etc/pam.conf")
    done
    Checking that /bin/false registered as login shell...

    Checking for ftp home directory for 'clients' group...
    @psacln
    '@psacln' is already in the /etc/ftpchroot

    Trying to register service xinetd... done
    Trying to restart service xinetd... * Stopping internet superserver xinetd
    ...done.
    * Starting internet superserver xinetd
    ...done.
    done
    Trying to restart service xinetd... * Starting internet superserver xinetd
    ...fail!
    done
    Checking for the group 'psaadm'...
    Trying to add supplementary group 'psaadm' for user 'sw-cp-server'... already there
    Trying to register service xinetd... done
    Trying to restart service xinetd... * Stopping internet superserver xinetd
    ...done.
    * Starting internet superserver xinetd
    ...done.
    done
    Setting the default locale
    The default locale is set to en-US (ENGLISH, UNITED STATES)


    ===> Installing rbash
    Checking that /bin/rbash registered as login shell...
    /bin/rbash
    /bin/rbash is already registered as login shell

    Trying to define valid mysql credentials... Trying to establish test connection... connected
    done
    Trying to start service mysql... /usr/sbin/mysqld (pid 15337) is running...
    done
    Trying to establish test connection... connected
    done

    ===> Installing Admin Server

    ===> Installing Apache Server
    Trying to stop service apache2... * Stopping web server apache2
    ... waiting ...done.
    done
    Copying apache files... done


    ===> Installing and configuring Named Server

    Checking for the system groups and users necessary for named (bind)...
    Checking for the group 'bind'...
    Group 'bind' already exists

    Checking for the user 'bind'...
    User 'bind' already exists

    Stop running named daemon
    Trying to stop service bind9... * Stopping domain name service... bind9
    WARNING: key file (/etc/bind/rndc.key) exists, but using default configuration file (/etc/bind/rndc.conf)
    named: no process found
    named: no process found
    named: no process found
    named: no process found
    named: no process found
    named: no process found
    named: no process found
    named: no process found
    named: no process found
    named: no process found
    ...done.
    done
    Trying to untar named run-root directory structure... mknod: `dev/random': File exists
    mknod: `dev/urandom': File exists
    done
    Trying to set up default permissions... done
    Trying to register service named... done
    Trying to stop service bind9... done
    Trying to start service bind9... * Starting domain name service... bind9
    ...done.
    done
    Trying to install chrooted environment... `/bin/bash' -> `bash'
    `/bin/cat' -> `cat'
    `/bin/cp' -> `cp'
    `/bin/grep' -> `grep'
    `/usr/bin/head' -> `head'
    `/usr/bin/id' -> `id'
    `/bin/less' -> `less'
    `/bin/ln' -> `ln'
    `/bin/ls' -> `ls'
    `/bin/mkdir' -> `mkdir'
    `/bin/more' -> `more'
    `/bin/mv' -> `mv'
    `/bin/pwd' -> `pwd'
    `/bin/rm' -> `rm'
    `/bin/rmdir' -> `rmdir'
    `/bin/sh' -> `sh'
    `/usr/bin/tail' -> `tail'
    `/bin/touch' -> `touch'
    `/usr/bin/du' -> `du'
    `/usr/bin/vi' -> `vi'
    `/bin/true' -> `true'
    `/bin/false' -> `false'
    `/usr/bin/scp' -> `scp'
    `/usr/bin/groups' -> `groups'
    Trying to install sftp-server binary into chroot environment... `/usr/lib/openssh/sftp-server' -> `/var/www/vhosts/chroot/usr/lib/openssh/sftp-server'
    done
    done
    ===> Installing phpMyAdmin
    Trying to create pmadb... done
    done
    ===> Installing /usr/lib/apache2/suexec replacement
    Leaving `diversion of /usr/lib/apache2/suexec to /usr/lib/apache2/suexec.distrib by psa'
    `/opt/psa/suexec/psa-suexec' -> `/usr/lib/apache2/suexec'
    Trying to set up APS controller database... Attempting to check APS db connection via ODBC, using /usr/bin/isql (empty output is good)
    [ISQL]ERROR: Could not SQLConnect
    Failed, rc = 1.
    Attempting to check APS db connection via ODBC, using /usr/bin/iusql (empty output is good)
    [ISQL]ERROR: Could not SQLDriverConnect
    Failed, rc = 1.
    Failed to establish test connection. Cleaning up.

    ERROR while trying to establish test connection to APS database via ODBC
    Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again

    ***** problem report *****
    ERROR while trying to establish test connection to APS database via ODBC
    Check the error reason(see log file: /tmp/plesk_10.3.0_installation.log), fix and try again



    Your help is appreciated.
     
  8. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    This option in /etc/my.cnf also seems to have similar effect on isql (as ip's are not resolved to hostnames and therefore user fails to login): skip-name-resolve
     
  9. MarianF

    MarianF Guest

    0
     
    same problem here

    Hello,

    same Problem here (Specified column "isLegacyUser" is not in the row), and i need an solution asap, because mail settings are not working in plesk since the upgrade!!!

    Wether you are creating an alias, a forward or an autoresponder nothing is working but the creation of an email box itself.

    the bootstrap thing produces the same error all the time as seen in in another Post here (2 before this one).

    Is there a way to manually update the database? so what is todo?

    Thanks a lot in advance

    Regards Marian
     
  10. MarianF

    MarianF Guest

    0
     
    Also I was not able to create new customers without getting an "Internal Error.".
    After adding the following to the table "smb_users" User creation worked without problems.

    imNumber, varchar(255), Allow NULL
    imType, int(11), Allow NULL
    additionalInfo, longtext, Allow NULL

    so maybe someone can tell me where to add the "isLegacyUser" Column? And what type?

    Thanks in advance
     
  11. MarianF

    MarianF Guest

    0
     
    Problem solved until next update!?

    bootstrap always gives the same error with APS ODBC connection failed. This Problem could not be solved,
    But we needed to create and edit customers, as well as our customers needed to handle their Mail-Accounts with forwarding, aliases and Autoresponder.

    Altering the smb_users table with the following gave me the success to solve the written issues:

    ALTER TABLE `smb_users` add isLegacyUser int(11) NULL, add imNumber varchar(255) NULL, add imType int(11) NULL, add additionalInfo longtext NULL after isDomainAdmin

    Maybe someone from Parallels tells us if there were more updates to the DB between 10.2 and 10.3

    Kind Regards from Germany

    Marian
     
Loading...