1.5.3 (2018120800) - Cannot switch between various servers - No database selected

**fulltilt** · Dec 13th 2018

imSCP 1.5.3

Debian 9

not sure if it's a bug or not ...

after upgrading 1.5.3 to latest 1.5.3 (build 2018120800) everything went fine when I then wanted to change dovecot and php-fcid:

perl imscp-autoinstall --debug --reconfigure

Code

following error has occurred:
iMSCP::Stepper::_callback: DBD::mysql::db selectrow_hashref failed: No database selected at /usr/local/src/imscp-1.5.3-2018120800/engine/PerlLib/iMSCP/Dialog/InputValidation.pm line 487.

perl imscp-autoinstall -d worked after that, but it seems changing from courier to dovecot and/or php-fcgi to php-fpm produced this issue.

**Nuxwin** · Dec 13th 2018

fulltilt

This is a critical issue. Could you please report the issue on our bug tracker? Any bug should be reported on our bug tracker. It become really difficult to track them on our forums.

Thank you.

**fulltilt** · Dec 23rd 2018

i-MSCP 1.5.3

Build: 2018120800

FRONTEND_SERVER = nginx

FTPD_SERVER = proftpd

HTTPD_SERVER = apache_fcgid

MTA_SERVER = postfix

NAMED_SERVER = bind

PHP_SERVER = php7.0

PO_SERVER = courier

SQL_SERVER = mariadb_10.1

after the failed upgrade (could not change to dovecot and apache fpm) I was able to run the standrad upgrade process.

but now my php7.0-fpm shows:

Code

service php7.0-fpm status
● php7.0-fpm.service
Loaded: masked (/dev/null; bad)
Active: inactive (dead)

and also a restart is no longer possible:

Code

service php7.0-fpm restart
Failed to restart php7.0-fpm.service: Unit php7.0-fpm.service is masked.

How can I solve these issues?

**fulltilt** · Dec 23rd 2018

I have unmasked the service now ... right way and did I missed something?

Code

systemctl unmask php7.0-fpm.service
systemctl enable php7.0-fpm
service php7.0-fpm restart
service php7.0-fpm status
● php7.0-fpm.service - The PHP 7.0 FastCGI Process Manager
Loaded: loaded (/lib/systemd/system/php7.0-fpm.service; disabled; vendor preset: enabled)
Active: active (running) since Sun 2018-12-23 11:27:29 CET; 6s ago
Docs: man:php-fpm7.0(8)
Main PID: 21450 (php-fpm7.0)
Status: "Ready to handle connections"
Tasks: 3 (limit: 4915)
CGroup: /system.slice/php7.0-fpm.service
├─21450 php-fpm: master process (/etc/php/7.0/fpm/php-fpm.conf)
├─21453 php-fpm: pool www
└─21454 php-fpm: pool www

Display More

**Nuxwin** · Dec 26th 2018

I cannot reproduce the issue.

Switching from courier to dovecot (and vice-versa) OK
switching Httpd server implementation from Fcgid to FPM (and vice-versa) OK
Reconfiguring the whole and switching OK

Regarding you last question, you MUST NOT process manually. More work is done by the installer, specially for the PHP binary copy (panel instance). If you play too much by closing your eyes, you'll break your server.

**fulltilt** · Dec 26th 2018

thanks for investigation!

some more details:

- I have switched from courier to dovecot & fcgid to fpm during one upgrade process.

- my original database is named "ispcp" not imscp due to a prior migration.

I will run a few upgrades w7 same database for testing in a VB soon & give you an update on this.

**theemstra** · Jan 1st 2019

Quote from fulltilt

thanks for investigation!

some more details:

- I have switched from courier to dovecot & fcgid to fpm during one upgrade process.

- my original database is named "ispcp" not imscp due to a prior migration.

I will run a few upgrades w7 same database for testing in a VB soon & give you an update on this.

Hi!

I'll leave this open, I was wondering if you had any news on this?

**fulltilt** · Jan 1st 2019

Quote from theemstra

Hi!

I'll leave this open, I was wondering if you had any news on this?

thanks, I'm just a little sick and need some time for revover!

**fulltilt** · Jan 2nd 2019

ok, it seems there is a bug in latest imscp build, I have tried a migration into a VM (vbox) today to check for reasons by the upgrade issue as above ...

- first I have installed the same system and afterwards I have tried to do a migration as hundred times before ... the migration or upgrade process fails with following error:

Code

───────────────────────────────────────────────────i-MSCP Installer Dialog───────────────────────────────────────────────────────┐
│ [ERROR] │
│ │
│ Error while performing step: │
│ │
│ Processing setup dialog │
│ │
│ Error was: │
│ │
│ iMSCP::Stepper::_callback: Can't use string ("DBD::mysql::db selectall_hashref"...) as an ARRAY ref while "strict refs" in use │
│ at /usr/local/src/imscp-1.5.3-2018120800/engine/PerlLib/Servers/sqld/mysql/installer.pm line 885. │
│ │
│ Please have a look at http://i-mscp.net/forum if you need help.
[ERROR] iMSCP::Stepper::_callback: Can't use string ("DBD::mysql::db selectall_hashref"...) as an ARRAY ref while "strict refs" in use at /usr/local/src/imscp-1.5.3-2018120800/engine/PerlLib/Servers/sqld/mysql/installer.pm line 885, <DATA> line 1.
[ERROR] autoinstaller::Functions::install: An error occurred while performing installation steps

Display More

I have tried w/ both comands:

Code

perl imscp-autoinstall -d
perl imscp-autoinstall --debug --reconfigure

**Nuxwin** · Jan 2nd 2019

fulltilt

That not the same error as shown in your first post... That error look strange too me.

Please show me the DATABASE_NAME parameter value of your /etc/imscp/imscp.conf file.

also run as root user:

SQL

# mysql
> use <IMSCP_DBNAME>;
> show tables;

where <IMSCP_DBNAME> must be your i-MSCP db name. The, show me the result..

1.5.3 (2018120800) - Cannot switch between various servers - No database selected

Nuxwin Dec 13th 2018

Nuxwin Dec 13th 2018

Share

Daily visitors