wrong value appeares in the host cell of the "dovecot_user" in mysql.user table

jonci · Aug 26th 2013

for example:
eth0's IP is 192.168.0.1 (external interface) -> set for i-MSCP IP address
eth1's IP is 10.0.0.1 (local lan interface)
remote sql server's IP is 10.0.0.10

i-MSCP version: 1.1.0-rc3

If "remote server" is being choosen at "SQL service" page, and I set 10.0.0.10 as SQL server address during the installation process, wrong value appeares in the host cell of the "dovecot_user" in mysql.user table. The eth1 IP address should appeare in the host cell instead of eth0, as at the other user's happen (vftp, roundcube_mail, pma).

**Nuxwin** · Aug 26th 2013

Quote from jonci

for example:
eth0's IP is 192.168.0.1 (external interface) -> set for i-MSCP IP address
eth1's IP is 10.0.0.1 (local lan interface)
remote sql server's IP is 10.0.0.10

i-MSCP version: 1.1.0-rc3

If "remote server" is being choosen at "SQL service" page, and I set 10.0.0.10 as SQL server address during the installation process, wrong value appeares in the host cell of the "dovecot_user" in mysql.user table. The eth1 IP address should appeare in the host cell instead of eth0, as at the other user's happen (vftp, roundcube_mail, pma).

Display More

Hello ;

I'll check.

You are normally also asked for SQL hostname to use. You entered what value for that question?

jonci · Aug 26th 2013

Quote from Nuxwin

Hello ;

I'll check.

You are normally also asked for SQL hostname to use. You entered what value for that question?

I changed the default "localhost" value to "10.0.0.10".

**Nuxwin** · Aug 26th 2013

Quote from jonci

I changed the default "localhost" value to "10.0.0.10".

When you choose the remote option for the SQL server, you are asked for the IP address of the remote SQL server and you are also asked for the hostname to use for SQL users created by i-MSCP.

What is the value of the parameter DATABASE_USER_HOST in your /etc/imscp/imscp.conf file?

[hr]

Edit: I've checked the code for the 1.1.0-rc3 and its appear that for dovecot, the DATABASE_USER_HOST was not used... Well, it's normally already fixed in Git Master so please, update.

Diff 1.1.0-rc3 - Git master for the Dovecot installer

Diff

diff --git a/engine/PerlLib/Servers/po/dovecot/installer.pm b/engine/PerlLib/Servers/po/dovecot/installer.pm
index 39eac90..8e7f386 100644
--- a/engine/PerlLib/Servers/po/dovecot/installer.pm
+++ b/engine/PerlLib/Servers/po/dovecot/installer.pm
@@ -106,25 +106,23 @@ sub askDovecot
my $dbPort = main::setupGetQuestion('DATABASE_PORT');
my $dbName = main::setupGetQuestion('DATABASE_NAME');
- my $dbUser = $main::preseed{'DOVECOT_SQL_USER'} || $self::dovecotConfig{'DATABASE_USER'} ||
- $self::dovecotOldConfig{'DATABASE_USER'} || 'dovecot_user';
+ my $dbUser = main::setupGetQuestion('DOVECOT_SQL_USER') || $self->{'config'}->{'DATABASE_USER'} || 'dovecot_user';
- my $dbPass = $main::preseed{'DOVECOT_SQL_PASSWORD'} || $self::dovecotConfig{'DATABASE_PASSWORD'} ||
- $self::dovecotOldConfig{'DATABASE_PASSWORD'} || '';
+ my $dbPass = main::setupGetQuestion('DOVECOT_SQL_PASSWORD') || $self->{'config'}->{'DATABASE_PASSWORD'} || '';
my ($rs, $msg) = (0, '');
if(
- $main::reconfigure ~~ ['po', 'servers', 'all', 'forced'] ||
- (
- ! $main::preseed{'DOVECOT_SQL_USER'} &&
- main::setupCheckSqlConnect($dbType, '', $dbHost, $dbPort, $dbUser, $dbPass)
- )
+ $main::reconfigure ~~ ['po', 'servers', 'all', 'forced'] || ! ($dbUser && $dbPass)
+ #(
+ # ! $main::preseed{'DOVECOT_SQL_USER'} &&
+ # main::setupCheckSqlConnect($dbType, '', $dbHost, $dbPort, $dbUser, $dbPass)
+ #)
) {
# Ask for the dovecot restricted SQL username
do{
($rs, $dbUser) = iMSCP::Dialog->factory()->inputbox(
- "\nPlease enter an username for the restricted dovecot SQL user:", $dbUser
+ "\nPlease enter a username for the restricted dovecot SQL user:", $dbUser
);
# i-MSCP SQL user cannot be reused
@@ -142,9 +140,10 @@ sub askDovecot
if($rs != 30) {
if(! $dbPass) {
- $dbPass = '';
my @allowedChars = ('A'..'Z', 'a'..'z', '0'..'9', '_');
- $dbPass .= $allowedChars[rand()*($#allowedChars + 1)]for (1..16);
+
+ $dbPass = '';
+ $dbPass .= $allowedChars[rand @allowedChars] for 1..16;
}
$dbPass =~ s/('|"|`|#|;|\/|\s|\||<|\?|\\)/_/g;
@@ -155,8 +154,8 @@ sub askDovecot
}
if($rs != 30) {
- $self::dovecotConfig{'DATABASE_USER'} = $dbUser;
- $self::dovecotConfig{'DATABASE_PASSWORD'} = $dbPass;
+ $self->{'config'}->{'DATABASE_USER'} = $dbUser;
+ $self->{'config'}->{'DATABASE_PASSWORD'} = $dbPass;
}
$rs;
@@ -226,12 +225,12 @@ sub buildPostfixConf
if($filename eq 'main.cf') {
# SASL part
- my $dovecotConfigSnippet = <<EOF;
+ my $configSnippet = <<EOF;
smtpd_sasl_type = dovecot
smtpd_sasl_path = private/auth
EOF
- $$content =~ s/(# SASL parameters\n)/$1$dovecotConfigSnippet/;
+ $$content =~ s/(# SASL parameters\n)/$1$configSnippet/;
# LDA part
$$content .= <<EOF
@@ -242,14 +241,14 @@ EOF
} elsif($filename eq 'master.cf') {
# LDA part
- my $dovecotConfigSnippet .= <<EOF;
+ my $configSnippet .= <<EOF;
dovecot unix - n n - - pipe
flags=DRhu user={ARPL_USER} argv=/usr/lib/dovecot/deliver -f \${sender} -d \${recipient} {SFLAG}
EOF
$$content .= iMSCP::Templator::process(
{ SFLAG => (version->new($self->{'version'}) < version->new('2.0.0') ? '-s' : '') },
- $dovecotConfigSnippet
+ $configSnippet
);
}
@@ -276,24 +275,26 @@ sub _init
$self->{'hooksManager'} = iMSCP::HooksManager->getInstance();
+ $self->{'po'} = Servers::po::dovecot->getInstance();
+
$self->{'hooksManager'}->trigger(
'beforePodInitInstaller', $self, 'dovecot'
) and fatal('dovecot - beforePoInitInstaller hook has failed');
- $self->{'cfgDir'} = "$main::imscpConfig{'CONF_DIR'}/dovecot";
+ $self->{'cfgDir'} = $self->{'po'}->{'cfgDir'};
$self->{'bkpDir'} = "$self->{'cfgDir'}/backup";
$self->{'wrkDir'} = "$self->{'cfgDir'}/working";
- $self::dovecotConfig = $self->{'dovecotConfig'};
+ $self->{'config'} = $self->{'po'}->{'config'};
my $oldConf = "$self->{'cfgDir'}/dovecot.old.data";
if(-f $oldConf) {
- tie %self::dovecotOldConfig, 'iMSCP::Config', 'fileName' => $oldConf, 'noerrors' => 1;
+ tie %{$self->{'oldConfig'}}, 'iMSCP::Config', 'fileName' => $oldConf, 'noerrors' => 1;
- for(keys %self::dovecotOldConfig) {
- if(exists $self::dovecotConfig{$_}) {
- $self::dovecotConfig{$_} = $self::dovecotOldConfig{$_};
+ for(keys %{$self->{'oldConfig'}}) {
+ if(exists $self->{'config'}->{$_}) {
+ $self->{'config'}->{$_} = $self->{'oldConfig'}->{$_};
}
}
}
@@ -324,10 +325,10 @@ sub _getVersion
return $rs if $rs;
my ($stdout, $stderr);
- $rs = execute('dovecot --version', \$stdout, \$stderr);
+ $rs = execute('/usr/sbin/dovecot --version', \$stdout, \$stderr);
debug($stdout) if $stdout;
error($stderr) if $stderr;
- error("Unable to get dovecot version") if $rs && ! $stderr;
+ error('Unable to get dovecot version') if $rs && ! $stderr;
return $rs if $rs;
chomp($stdout);
@@ -360,8 +361,8 @@ sub _bkpConfFile
$rs = $self->{'hooksManager'}->trigger('beforePoBkpConfFile', $cfgFile);
return $rs if $rs;
- if(-f "$self::dovecotConfig{'DOVECOT_CONF_DIR'}/$cfgFile") {
- my $file = iMSCP::File->new('filename' => "$self::dovecotConfig{'DOVECOT_CONF_DIR'}/$cfgFile");
+ if(-f "$self->{'config'}->{'DOVECOT_CONF_DIR'}/$cfgFile") {
+ my $file = iMSCP::File->new('filename' => "$self->{'config'}->{'DOVECOT_CONF_DIR'}/$cfgFile");
if(! -f "$self->{'bkpDir'}/$cfgFile.system") {
$rs = $file->copyFile("$self->{'bkpDir'}/$cfgFile.system");
@@ -389,31 +390,31 @@ sub _setupDb
my $self = shift;
my $rs = 0;
- my $dbUser = $self::dovecotConfig{'DATABASE_USER'};
- my $dbOldUser = $self::dovecotOldConfig{'DATABASE_USER'} || '';
- my $dbPass = $self::dovecotConfig{'DATABASE_PASSWORD'};
- my $dbUserHost = $main::imscpConfig{'SQL_SERVER'} ne 'remote_server'
- ? $main::imscpConfig{'DATABASE_HOST'} : $main::imscpConfig{'BASE_SERVER_IP'};
+ my $dbUser = $self->{'config'}->{'DATABASE_USER'};
+ my $dbUserHost = main::setupGetQuestion('DATABASE_USER_HOST');
+ my $dbPass = $self->{'config'}->{'DATABASE_PASSWORD'};
+
+ my $dbOldUser = $self->{'oldConfig'}->{'DATABASE_USER'} || '';
$rs = $self->{'hooksManager'}->trigger('beforePoSetupDb', $dbUser, $dbOldUser, $dbPass, $dbUserHost);
return $rs if $rs;
- # Remove old dovecot restricted SQL user and all it privileges (if any)
- for($main::imscpOldConfig{'DATABASE_HOST'} || '', $main::imscpOldConfig{'BASE_SERVER_IP'} || '') {
- next if $_ eq '' || $dbOldUser eq '';
- $rs = main::setupDeleteSqlUser($dbOldUser, $_);
- error("Unable to remove old dovecot '$dbOldUser' restricted SQL user") if $rs;
- return 1 if $rs;
- }
+ # Remove any old dovecot SQL user (including privileges)
+ for my $sqlUser ($dbOldUser, $dbUser) {
+ next if ! $sqlUser;
- # Ensure new dovecot restricted SQL user do not already exists by removing it
- $rs = main::setupDeleteSqlUser($dbUserHost, $dbUser);
- error("Unable to delete dovecot '$dbUser' restricted SQL user") if $rs;
- return 1 if $rs;
+ for($dbUserHost, $main::imscpOldConfig{'DATABASE_HOST'}, $main::imscpOldConfig{'BASE_SERVER_IP'}) {
+ next if ! $_;
+
+ $rs = main::setupDeleteSqlUser($sqlUser, $_);
+ error("Unable to remove '$sqlUser\@$_' SQL user or one of its privileges") if $rs;
+ return 1 if $rs;
+ }
+ }
# Get SQL connection with full privileges
my ($database, $errStr) = main::setupGetSqlConnect();
- fatal('Unable to connect to SQL Server: $errStr') if ! $database;
+ fatal("Unable to connect to SQL Server: $errStr") if ! $database;
# Add new dovecot restricted SQL user with needed privileges
@@ -463,8 +464,7 @@ sub _buildConf
my $rs = 0;
require Servers::mta;
-
- my $mta = Servers::mta->factory($main::imscpConfig{'MTA_SERVER'});
+ my $mta = Servers::mta->factory();
my $cfg = {
DATABASE_TYPE => $main::imscpConfig{'DATABASE_TYPE'},
@@ -473,18 +473,18 @@ sub _buildConf
? "$main::imscpConfig{'DATABASE_HOST'} port=$main::imscpConfig{'DATABASE_PORT'}"
: $main::imscpConfig{'DATABASE_HOST'}
),
- DATABASE_USER => $self::dovecotConfig{'DATABASE_USER'},
- DATABASE_PASSWORD => $self::dovecotConfig{'DATABASE_PASSWORD'},
+ DATABASE_USER => $self->{'config'}->{'DATABASE_USER'},
+ DATABASE_PASSWORD => $self->{'config'}->{'DATABASE_PASSWORD'},
DATABASE_NAME => $main::imscpConfig{'DATABASE_NAME'},
GUI_CERT_DIR => $main::imscpConfig{'GUI_CERT_DIR'},
HOST_NAME => $main::imscpConfig{'SERVER_HOSTNAME'},
DOVECOT_SSL => ($main::imscpConfig{'SSL_ENABLED'} eq 'yes' ? 'yes' : 'no'),
COMMENT_SSL => ($main::imscpConfig{'SSL_ENABLED'} eq 'yes' ? '' : '#'),
- MAIL_USER => $mta->{'MTA_MAILBOX_UID_NAME'},
- MAIL_GROUP => $mta->{'MTA_MAILBOX_GID_NAME'},
- vmailUID => scalar getpwnam($mta->{'MTA_MAILBOX_UID_NAME'}),
- mailGID => scalar getgrnam($mta->{'MTA_MAILBOX_GID_NAME'}),
- DOVECOT_CONF_DIR => $self::dovecotConfig{'DOVECOT_CONF_DIR'},
+ MAIL_USER => $mta->{'config'}->{'MTA_MAILBOX_UID_NAME'},
+ MAIL_GROUP =>$mta->{'config'}->{'MTA_MAILBOX_GID_NAME'},
+ vmailUID => scalar getpwnam($mta->{'config'}->{'MTA_MAILBOX_UID_NAME'}),
+ mailGID => scalar getgrnam($mta->{'config'}->{'MTA_MAILBOX_GID_NAME'}),
+ DOVECOT_CONF_DIR => $self->{'config'}->{'DOVECOT_CONF_DIR'},
ENGINE_ROOT_DIR => $main::imscpConfig{'ENGINE_ROOT_DIR'}
};
@@ -519,14 +519,14 @@ sub _buildConf
$rs = $file->mode(0640);
return $rs if $rs;
- $rs = $file->owner($main::imscpConfig{'ROOT_USER'}, $mta->{'MTA_MAILBOX_GID_NAME'});
+ $rs = $file->owner($main::imscpConfig{'ROOT_USER'}, $mta->{'config'}->{'MTA_MAILBOX_GID_NAME'});
return $rs if $rs;
- $rs = $file->copyFile($self::dovecotConfig{'DOVECOT_CONF_DIR'});
+ $rs = $file->copyFile($self->{'config'}->{'DOVECOT_CONF_DIR'});
return $rs if $rs;
}
- my $file = iMSCP::File->new('filename' => "$self::dovecotConfig{'DOVECOT_CONF_DIR'}/dovecot.conf");
+ my $file = iMSCP::File->new('filename' => "$self->{'config'}->{'DOVECOT_CONF_DIR'}/dovecot.conf");
$file->mode(0644);
}
@@ -598,8 +598,8 @@ sub _migrateFromCourier
require Servers::mta;
my $mta = Servers::mta->factory();
- my $binPath = "perl $main::imscpConfig{'ENGINE_ROOT_DIR'}/PerlVendor/courier-dovecot-migrate.pl";
- my $mailPath = "$mta->{'MTA_VIRTUAL_MAIL_DIR'}";
+ my $binPath = "$main::imscpConfig{'CMD_PERL'} $main::imscpConfig{'ENGINE_ROOT_DIR'}/PerlVendor/courier-dovecot-migrate.pl";
+ my $mailPath = "$mta->{'config'}->{'MTA_VIRTUAL_MAIL_DIR'}";
# Converting all mailboxes to dovecot format

Display More

jonci · Aug 26th 2013

Quote from Nuxwin

When you choose the remote option for the SQL server, you are asked for the IP address of the remote SQL server and you are also asked for the hostname to use for SQL users created by i-MSCP.

What is the value of the parameter DATABASE_USER_HOST in your /etc/imscp1/imscp.conf file?

$ grep 'DATABASE.*HOST' /etc/imscp/imscp.conf
DATABASE_HOST = 10.0.0.10
DATABASE_USER_HOST = 10.0.0.10

**Nuxwin** · Aug 26th 2013

Quote from jonci

$ grep 'DATABASE.*HOST' /etc/imscp/imscp.conf
DATABASE_HOST = 10.0.0.10
DATABASE_USER_HOST = 10.0.0.10

Ok; Despite the problem as mentioned in my previous post, which is already fixed in master, you are wrong here.

Code

DATABASE_USER_HOST = 10.0.0.10

Should be

Code

DATABASE_USER_HOST = 10.0.0.1

Please update to last master and after, do a reconfigure:

Code

# perl imscp-autoinstall -dr sql

If you want, I can help you via teamviewer.

jonci · Aug 26th 2013

Quote from Nuxwin

Ok; Despite the problem as mentioned in my previous post, which is already fixed in master, you are wrong here.

Code

DATABASE_USER_HOST = 10.0.0.10

Should be

Code

DATABASE_USER_HOST = 10.0.0.1

Please update to last master and after, do a reconfigure:

Code

# perl imscp-autoinstall -dr sql

If you want, I can help you via teamviewer.

Display More

Thank you for taking care of this issue!

I have already solved it with updating the mysql.user table with right value.

wrong value appeares in the host cell of the "dovecot_user" in mysql.user table

Share

Daily visitors