[BSD] perl, mysql 5.5

2011. Feb. 24., Cs, 14:38:39 CET

Hello!

Telepítési sorrend (mindent ports-bol):
1. mysql55-server
-> telepíti a klienst is
2. dovecot2
3. postfix
4. sqlgrey
-> telepíti a p5-DBD-mysql-t
5. amavis

Miután nem ment p5.10-zel, frissítettel p5.12-re
(/usr/ports/lang/perl5.12). Szintén portsból telepítve. UPDATING szerint.

Teljesen friss install eseten, alap (gyári) adatbazissal is ezt csinalja
az sql. Teljes ujratelepites utan is.

#ldd /usr/local/lib/perl5/site_perl/5.12.3/mach/auto/DBD/mysql/mysql.so:
        libmysqlclient.so.16 => /usr/local/lib/mysql/libmysqlclient.so.16
(0x800c00000)
        libz.so.5 => /lib/libz.so.5 (0x801035000)
        libm.so.5 => /lib/libm.so.5 (0x80114a000)
        libc.so.7 => /lib/libc.so.7 (0x800647000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x801269000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x801474000)
        libthr.so.3 => /lib/libthr.so.3 (0x801581000)
Minden megvan elvileg.

#ls -l /usr/local/share/mysql/english/errmsg.sys
-rw-r--r--  1 root  wheel  41938 Feb 24 13:39
/usr/local/share/mysql/english/errmsg.sys

#ls -l /usr/local/share/mysql/hungarian/errmsg.sys
-rw-r--r--  1 root  wheel  42670 Feb 24 13:39
/usr/local/share/mysql/hungarian/errmsg.sys

#mysqlcheck -A -u root -p
Enter password:
Itt kiad 45 sort, a táblákat, mind mellett OK. Semmi problémát nem ír.

Ide vágó csomagok csomagok:
#pkg_version -v
mysql-client-5.5.9                  =   up-to-date with port
mysql-server-5.5.9                  =   up-to-date with port
p5-DBD-mysql-4.017                  =   up-to-date with port
p5-BerkeleyDB-0.43_1                =   up-to-date with port

Köszi a segítséget.
A

On Thu, 24 Feb 2011 13:20:08 +0100, Gabor HALASZ <halasz.g at freemail.hu>
wrote:
> On 2011.02.24. 9:01, Kovács András wrote:
>> Sziasztok!
>> FBSD 8.1-R, mail szervert szeretnék telepíteni. MySQL 5.5, sqlgrey,
>> amavisd-new sikeresen települt ports-ból. Most 5.12-es perl van,
>> ugyanezt a
>> helyzet 5.10-es verzióval is. 8.2-R is ugyanez a hiba. Más verziós
>> mysql-lel nem próbáltam.
> 
> Erdekes, nekem meg 5.10 van a portsban. Felraktad forrasbol?
> 
>>
>> Mysql csak mysqld_safe&  paranccsal indul (ilyenkor azonban tökéletesen
>> megy). Log:
>> 110224  8:54:56 [Note] /usr/local/libexec/mysqld: Normal shutdown
>>
>> 110224  8:54:56 [Note] Event Scheduler: Purging the queue. 0 events
>> 110224  8:54:56  InnoDB: Starting shutdown...
>> 110224  8:54:56  InnoDB: Shutdown completed; log sequence number
1778548
>> 110224  8:54:56 [Note] /usr/local/libexec/mysqld: Shutdown complete
>>
>> 110224 08:54:56 mysqld_safe mysqld from pid file
>> /var/db/mysql/bmeg.local.pid ended
>> 110224 08:54:56 mysqld_safe Starting mysqld daemon with databases from
>> /var/db/mysql
>> 110224  8:54:56 [ERROR] Can't find messagefile
>> '/usr/local/share/mysql/errmsg.sys'
> 
> Ez komoly kavarodas jele, ez a file nem itt van. Mintha nem lenne nls 
> beforditva.
> 
>> 110224  8:54:56 InnoDB: The InnoDB memory heap is disabled
>> 110224  8:54:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins
>> 110224  8:54:56 InnoDB: Compressed tables use zlib 1.2.3
>> 110224  8:54:56 InnoDB: Initializing buffer pool, size = 128.0M
>> 110224  8:54:56 InnoDB: Completed initialization of buffer pool
>> 110224  8:54:56 InnoDB: highest supported file format is Barracuda.
>> 110224  8:54:57  InnoDB: Waiting for the background threads to start
>> 110224  8:54:58 InnoDB: 1.1.5 started; log sequence number 1778548
>> 110224  8:54:58 [ERROR] Aborting
>>
>> 110224  8:54:58  InnoDB: Starting shutdown...
>> 110224  8:54:58  InnoDB: Shutdown completed; log sequence number
1778548
>> 110224  8:54:58 [Note]
>> 110224 08:54:58 mysqld_safe mysqld from pid file
>> /var/db/mysql/bmeg.local.pid ended
>>
> 
> Ez eleg fura, talan megserult valamelyik adatbazis. mysqlcheck?
> 
>> ls -l /usr/local/share/mysql/errmsg.sys
>> -rw-r--r--  1 mysql  wheel  42670 Feb 16 23:15
>> /usr/local/share/mysql/errmsg.sys
>>
> 
> /usr/local/share/mysql/<lang>/errmsg.sys a file helye.
> 
>> -----8<-----
>>
>> sqlgrey nem tud kapcsolódni a mysql-hez, valami DBD-mysql perl modul
>> hiánya miatt (szintén telepítve):
>> Feb 24 08:46:53 bmeg sqlgrey: fatal: Can't locate loadable object for
>> module DBD::mysql in @INC (@INC contains:
>> /usr/local/lib/perl5/5.12.3/BSDPAN
>> /usr/local/lib/perl5/site_perl/5.12.3/mach
>> /usr/local/lib/perl5/site_perl/5.12.3 /usr/local/lib/perl5/5.12.3/mach
>> /usr/local/lib/perl5/5.12.3 .) at (eval 14) line 3
>> Feb 24 08:46:53 bmeg sqlgrey: fatal: Can't locate loadable object for
>> module DBD::mysql in @INC (@INC contains:
>> /usr/local/lib/perl5/5.12.3/BSDPAN
>> /usr/local/lib/perl5/site_perl/5.12.3/mach
>> /usr/local/lib/perl5/site_perl/5.12.3 /usr/local/lib/perl5/5.12.3/mach
>> /usr/local/lib/perl5/5.12.3 .) at (eval 14) line 3 Compilation failed
in
>> require at (eval 14) line 3.
>> Feb 24 08:46:53 bmeg sqlgrey: fatal: install_driver(mysql) failed:
Can't
>> locate loadable object for module DBD::mysql in @INC (@INC contains:
>> /usr/local/lib/perl5/5.12.3/BSDPAN
>> /usr/local/lib/perl5/site_perl/5.12.3/mach
>> /usr/local/lib/perl5/site_perl/5.12.3 /usr/local/lib/perl5/5.12.3/mach
>> /usr/local/lib/perl5/5.12.3 .) at (eval 14) line 3 Compilation failed
in
>> require at (eval 14) line 3. Perhaps a module that DBD::mysql requires
>> hasn't been fully installed  at /usr/local/sbin/sqlgrey line 814
>>
>> ls -l /usr/local/lib/perl5/site_perl/5.12.3/mach/DBD/mysql
>> total 78
>> -r--r--r--  1 root  wheel  16031 Apr 12  2010 GetInfo.pm
>> -r-xr-xr-x  1 root  wheel  22221 Apr 12  2010 INSTALL.pod
> 
> Eleg fura a hibauzenet, szerintem inkabb a 
> mach/auto/DBD/mysql/mysql.so-ra panaszkodik.
> ldd /usr/local/lib/perl5/site_perl/5.10.1/mach/auto/DBD/mysql/mysql.so 
> minden dependencyje megvan?
> 
>>
>> Igyekeztem kuglizni, de nem találtam általam használható megoldást.
>>
> 
> Szerintem ird le, hogy mit es milyen sorrendben telepitettel.