[BSD] perl, mysql 5.5

[Gabor HALASZ]

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.

-- 
Gabor HALASZ <halasz.g at freemail.hu>