Re: [webmin-l] VirtualMin Errors after server move

[Jamie C. <jca...@we...>]

On 16/Aug/2006 21:40 Pablo Medina wrote ..
> Hello List:
> 
> I am having a weird issue with virtualmin. (Webmin 1.290 Virtualmin
> 3.190.gpl running under Centos 3.7). You will see below the first
> message and two updates.
> 
> 
> 
> Server was running virtualmin ok with 8 domains in it with several
> users each domain. For some very specific reason we were forced to
> move to a different server, and after the move virtualmin stopped
> working.
> This is a list of errors:
> 
> After pressing "Save Virtual Server" in edit_domain.cgi, i receive a
> blank page in the frame i should be receiving the "Modifying Unix user
> .... done...Saving server details .." stuff.
> 
> When in the virtual server list, i select the "List" link (to display
> users) i am prompted to download list_users.cgi.
> 
> After pressing "Create Server" in domain_form.cgi, i am prompted to
> download domain_setup.cgi.
> 
> In some way, the issue seems to be related to config files, but the
> same config files gziped and moved again to old server, do not give
> errors.
> 
> I have reinstalled webmin and virtualmin at least three times.
> Unfortunately i cannot play with existing users because it is a live
> site, but i wonder if the issue may be related to /etc/passwd.
> 
> I have restored configure files using backup/restore and copying
> /etc/webmin from old to new server.
> 
> I have checked logs for apache and webmin error logs and no
> significatives entries are there.
> 
> UPDATE
> 
> After some insane debugging i have found this:
> 
> If i comment the line:
> 
> @dbu = &$dfunc($_[0], $db->{'name'});
> 
> In virtual-server-lib.pl, so it is like:
> 
> if (&indexof($db->{'type'}, @database_plugins) < 0) {
>                        # Core database
>                        local $dfunc = "list_".$db->{'type'}."_database_users";
>                        next if (!defined(&$dfunc));
>                        $ufunc = $db->{'type'}."_username";
>                        #@dbu = &$dfunc($_[0], $db->{'name'});
>                        }
> 
> the errors related to users are gone, and i can manage them properly.
> The error creating servers remains. My next step is to find the line
> causing the error so i can add domains properly, but i need to ask if
> anyone has a clue about how could this happens. It seems to be related
> to mysql plugin (which was installed previously but deleted after
> updating virtualmin). But the same config files are working ok in old
> server.
> Well, it seems if i configure a virtual server without mysql geatuire
> enabled, everything goes ok.
> 
> UPDATE 2:
> I have uninstalled webmin / virtualmin and deleted every reference to it
> .
> Reinstalled webmin and virtualmin (3.201)
> 
> Then i started from 0 importing virtual servers. I imported first
> domain without MySQL database enabled. and importing was ok.
> 
> Second website was imported with MySQL database option enabled, and
> two databases specified. Importing process was ok and domain is in the
> list. But when i select the option to list users,  i am prompted for
> downloading list_users.cgi again. (that does not happens in first
> domain).
> 
> Also i have noticed scheduled backups stopped. running it from command
> line i get:
> 
> [root@xxxxxx]# /etc/webmin/virtual-server/backup.pl
> Segmentation fault
> 
> strace returns:
> 
> write(5, "\231\0\0\0\3select user.user,user.passw"..., 157) = 157
> read(5, "\1\0\0\1", 4)                  = 4
> read(5, "\2", 1)                        = 1
> read(5, "+\0\0\2", 4)                   = 4
> read(5, "\3def\5mysql\4user\4user\4user\4User\f\10"..., 43) = 43
> read(5, "3\0\0\3", 4)                   = 4
> read(5, "\3def\5mysql\4user\4user\10password\10Pa"..., 51) = 51
> read(5, "\1\0\0\4", 4)                  = 4
> read(5, "\376", 1)                      = 1
> read(5, "\"\0\0\5", 4)                  = 4
> read(5, "\20xxxxxxxxx\020395128db0b2a93"..., 34) = 34
> read(5, "\5\0\0\6", 4)                  = 4
> read(5, "\376\0\0\"\0", 5)              = 5
> fcntl64(5, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
> read(5, 0xc7206a0, 8192)                = -1 EAGAIN (Resource
> temporarily unavailable)
> fcntl64(5, F_SETFL, O_RDWR)             = 0
> write(5, "\1\0\0\0\1", 5)               = 5
> shutdown(5, 2 /* send and receive */)   = 0
> close(5)                                = 0
> --- SIGSEGV (Segmentation fault) @ 0 (0) ---
> +++ killed by SIGSEGV +++
> 
> SO it seems i am really having issues with mysql feature, but mysql is
> working ok outside webmin / virtualmin and even webmin mysql module is
> working ok.
> 
> I am pretty lost and any hint will be appreciated.

That SEGV indicates a crash in the mysql driver, which is
consistent with the rest of your problems. I'd suggest upgrading the
mysql-client RPM and the DBD::mysql Perl module, as the versions you
are running may be out of date.

Failing that, you can try going to the MySQL module in Webmin, clicking
on the Module Config link changing the 'Use DBI to connect if available?'
setting to 'No'.

 - Jamie