Koozali.org: home of the SME Server

Other Languages => Italiano => Topic started by: jonrox on October 01, 2009, 11:24:31 AM

Title: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 11:24:31 AM
Ciao a tutti, ieri ho seguito questa procedura per aggiornare mysql alla versione 5:

--------------------
UPDATE:
I was able to upgrade to MySQL 5.0.68 by doing the following at a command prompt:

yum upgrade mysql --enablerepo=centosplus
signal-event post-upgrade; signal-event reboot

mysql_upgrade
signal-event post-upgrade; signal-event reboot

I then got errors like this in /var/log/httpd/admin_access_log:
Premature end of script headers (index.cgi)
Can’t do setuid (cannot exec sperl)

Which I fixed by doing this:
yum install perl-suidperl
signal-event post-upgrade; signal-event reboot
--------------------------

Oggi provo a accedere a server-manager e mi appare "Errore 500 Internal Server Error" se provo ad entrare nel phpmyadmin invece è tutto regolare.
Nel log admin_access non trovo nulla che mi possa aiutare:
----------------------------

 "GET /server-manager HTTP/1.1" 307 285
"GET /server-common/cgi-bin/login?back=http%3a%2f%2f192.168.0.1%2fserver-manager HTTP/1.1" 200 467
 "GET /server-common/cgi-bin/login?redirect=1&back=https%3A%2F%2F192.168.0.1%2Fserver-manager HTTP/1.1" 200 1082
 "GET /server-common/css/tkt.css HTTP/1.1" 304 -
"GET /server-common/smeserver_logo.jpg HTTP/1.1" 304 -
"POST /server-common/cgi-bin/login HTTP/1.1" 200 426
"GET /server-manager HTTP/1.1" 301 244
"GET /server-manager/ HTTP/1.1" 500 525

Qualcuno può aiutarmi a riristinare il server manager?
Grazie dell'aiuto
Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 11:28:57 AM
Direttamente da riga di comando mi butta fuori all'atto del logi...
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 11:32:16 AM
sarebbe anche carino sapere COME hai risolto, non trovi? :-)
Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 11:36:03 AM
Il bello è che non ho risolto...
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 11:39:19 AM
mmmhh.. c'è grossa crisi, eh? :-)

cosa trovi nei log di errore admin_error_log?
Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 11:43:00 AM
127.0.0.1 - - [01/Oct/2009:11:02:32 +0200] "GET /server-manager HTTP/1.1" 307 285
127.0.0.1 - - [01/Oct/2009:11:02:32 +0200] "GET /server-common/cgi-bin/login?back=http%3a%2f%2f192.168.0.1%2fserver-manager HTTP/1.1" 200 467
127.0.0.1 - - [01/Oct/2009:11:02:33 +0200] "GET /server-common/cgi-bin/login?redirect=1&back=https%3A%2F%2F192.168.0.1%2Fserver-manager HTTP/1.1" 200 1082
127.0.0.1 - - [01/Oct/2009:11:02:34 +0200] "GET /server-common/css/tkt.css HTTP/1.1" 304 -
127.0.0.1 - - [01/Oct/2009:11:02:34 +0200] "GET /server-common/smeserver_logo.jpg HTTP/1.1" 304 -
127.0.0.1 - - [01/Oct/2009:11:02:35 +0200] "POST /server-common/cgi-bin/login HTTP/1.1" 200 426
127.0.0.1 - admin [01/Oct/2009:11:02:36 +0200] "GET /server-manager HTTP/1.1" 301 244
127.0.0.1 - admin [01/Oct/2009:11:02:36 +0200] "GET /server-manager/ HTTP/1.1" 500 525
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 11:47:53 AM
scusa.. i log del server-manager sono in /var/log/httpd-admin

ergo consulta il log con (una volta dentro quella dir)
Code: [Select]
tail -f current | tai64nlocal
Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 12:02:16 PM
Ho lanciato il comando nella cartella selezionata, solo che non mi da segni, sembra che stia pensando, ma sono ormai 5 min che è così...
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 12:17:28 PM
no, significa che non ci sono log.. hai provato ad accedere al server-manager nel frattempo?
il log che hai mandato prima è relativo ad access_log o ad admin_error_log?
Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 12:26:10 PM
Ho provato e non accede. Il log era relativo al admin_access_log
In admin_error_log compare questo:
[Thu Oct 01 10:58:55 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Thu Oct 01 10:58:55 2009] [notice] Digest: generating secret for digest authentication ...
[Thu Oct 01 10:58:55 2009] [notice] Digest: done
[Thu Oct 01 10:58:56 2009] [notice] Apache configured -- resuming normal operations
[Thu Oct 01 12:01:10 2009] [error] [client 127.0.0.1] Can't do setuid (cannot exec sperl)
[Thu Oct 01 12:01:10 2009] [error] [client 127.0.0.1] Premature end of script headers: index.cgi

Si diceva che veniva risolto con :
Code: [Select]
yum install perl-suidperl
signal-event post-upgrade; signal-event reboot
ma il comando l'ho mandato e il problema è sempre il medesimo...
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 12:34:25 PM
cosa ti restituisce
Code: [Select]
rpm -qa | grep perl
?

e, inoltre, cosa hai da
Code: [Select]
yum --disablerepo=* list perl perl-suidperl perl-Time-HiRes
?
Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 12:39:08 PM
avvertimento: only V3 signatures can be verified, skipping V4 signature
perl-suidperl-5.8.5-49.el4
avvertimento: only V3 signatures can be verified, skipping V4 signature
avvertimento: only V3 signatures can be verified, skipping V4 signature
avvertimento: only V3 signatures can be verified, skipping V4 signature
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 12:42:04 PM
ok.. scusa ma ho editato il mio post durante la tua risposta..

prova a dare il secondo comando, grazie

Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 12:44:28 PM
Figurati, grazie della disponibilità

questo è il quanto:
Loading "smeserver" plugin
Loading "fastestmirror" plugin
Loading "installonlyn" plugin
Loading "protect-packages" plugin
Setting up repositories
No Repositories Available to Set Up
Loading mirror speeds from cached hostfile
Reading repository metadata in from local files
Installed Packages
perl.i386                                4:5.8.8-9.el4s1_4      installed
perl-suidperl.i386                       3:5.8.5-49.el4         installed
================================================================
No new rpms were installed. No additional commands are required.
================================================================
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 01:04:58 PM
ti sei _leggermente_ sputtanato il perl, perchè nell'aggiornamento di mysql ti ha aggiornato anche quello..

infatti
Quote
Updating:
 mysql                   i386       5.0.82sp1-1.el4_8  centosplus        3.3 M
Installing for dependencies:
 mysql-libs              i386       5.0.82sp1-1.el4_8  centosplus        1.8 M
 mysqlclient14           i386       4.1.22-1.el4s1.1  centosplus        1.2 M
 php-common              i386       5.1.6-3.el4s1.10  centosplus        136 k
 php-pdo                 i386       5.1.6-3.el4s1.10  centosplus        220 k
Updating for dependencies:
 mysql-server            i386       5.0.82sp1-1.el4_8  centosplus        9.9 M
 perl                    i386       4:5.8.8-9.el4s1_4  centosplus         11 M
 perl-DBD-MySQL          i386       4.008-1.el4s1    centosplus        141 k
 php-mysql               i386       5.1.6-3.el4s1.10  centosplus         77 k

ok.. vediamo di venirne fuori

Code: [Select]
rpm -e --no-deps perl
yum install perl --disablerepo=centosplus
signal-event post-upgrade
signal-event reboot

fammi sapere


Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 01:08:12 PM
Quando lancio
rpm -e --no-deps perl
Risultato
-bash: -no-deps:: command not found

Può essere:
rpm -e --nodeps perl
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 01:10:31 PM
carenza di zuccheri.. evidentmente devo andare a pranzo.. --nodeps :-)
Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 01:16:32 PM
é anche l'ora giusta...

al comando
Code: [Select]
signal-event post-upgrade
signal-event reboot

appare
Can't locate Time/HiRes.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/5.8.5/i386-linux-thread-multi /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/.8.0 /usr/lib/perl5/vendor_perl .) at /usr/lib/perl5/site_perl/esmith/event.pm line 11.
BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/esmith/event.pm line 11.
Compilation failed in require at /sbin/e-smith/signal-event line 11.
BEGIN failed--compilation aborted at /sbin/e-smith/signal-event line 11.
Title: Re: Problema aggiornamento a mysql 5
Post by: Stefano on October 01, 2009, 01:19:53 PM
ok.. allora...

Code: [Select]
yum install perl-Time-HiRes --disablerepo=centosplus
signal-event post-upgrade
signal-event reboot

Title: Re: Problema aggiornamento a mysql 5
Post by: jonrox on October 01, 2009, 01:31:18 PM
Perfetto, sei un grande... perciò il problema è stato l'aggiornamento del perl...
Grazie mille