Bug 224715 - dev-db/firebird cannot find intl charsets
Bug#: 224715 Product:  Gentoo Linux Version: unspecified Platform: All
OS/Version: Linux Status: RESOLVED Severity: normal Priority: P2
Resolution: FIXED Assigned To: wltjr@gentoo.org Reported By: thor_n@yahoo.com
Component: Ebuilds
URL: 
Summary: dev-db/firebird cannot find intl charsets
Keywords:  InCVS
Status Whiteboard: 
Opened: 2008-06-03 08:01 0000
Description:   Opened: 2008-06-03 08:01 0000 
Firebird (stable 2.0.3 and unstable 2.1.0) in current ebuilds is failing to use
intl charsets even though they are installed in 
/usr/lib/firebird/intl/.

I've got database file encoded in win1250 (not in unicode as most of decent
databases) and couldn't use it. :(

Reproducible: Always

Steps to Reproduce:
1. $ fbsql
2. SQL> connect file.fdb user sysdba password pass; -- file.fdb wncoded in
win1250
3. SQL> select * from existingtable;


Actual Results:  
1. $ fbsql
Use CONNECT or CREATE DATABASE to specify a database
2. SQL> connect file.fdb user sysdba password pass;
Database:  file.fdb, User: sysdba
3. SQL> select * from existingtable;
Statement failed, SQLCODE = -204
CHARACTER SET WIN1250 is not installed


Expected Results:  
Just select and show rows, eh?

CHARACTER SET WIN1250 is not installed?
But it's there.

So I made symlink, restarted firebird and things are working.

# cd /usr/share/firebird
# ln -s  /usr/lib/firebird/intl

Put this in your ebuilds, please.

------- Comment #1 From Jeroen Roovers 2008-06-03 08:10:28 0000 ------- 
Your emerge --info might help here as well.

------- Comment #2 From William L. Thomson Jr. (RETIRED) 2008-06-03 16:35:54 0000 ------- 
Been aware of it for a bit, also know of a fix. Just need to add another line
of sed to the ebuild. I will do so ASAP today. I forgot last time a user
reported, and no bug was filed at the time. So it slipped my mind :)

------- Comment #3 From William L. Thomson Jr. (RETIRED) 2008-06-04 04:19:43 0000 ------- 
Actually it seems the problem is in the conf.d file. Seems I am still setting
the root dir to FIREBIRD=/usr/share/firebird when it should be
FIREBIRD=/usr/lib/firebird. So lose that symlink, update the conf.d file and
restart Firebird. Please let me know if that resolves the problem.

------- Comment #4 From Jan Slezak 2008-06-04 11:17:43 0000 ------- 
It seems the FIREBIRD modification in conf.d resolves the problem. But I think
LD_LIBRARY_PATH in the same file and all settings in /etc/env.d/70firebird are
also wrong, maybe unnecessary.

------- Comment #5 From William L. Thomson Jr. (RETIRED) 2008-06-04 13:44:05 0000 ------- 
Yes they are wrong, and pretty sure unnecessary. Now that things have been
moved out of opt. Thanks for confirming the conf.d file problem. I will correct
both ASAP today.

------- Comment #6 From thorn 2008-06-04 13:47:23 0000 ------- 
Setting FIREBIRD=/usr/lib/firebird in /etc/conf.d/firebird does indeed fix the
problem. (Without intl link in /usr/share/firebird, of course.)

And Jan Slezak is right that LD_LIBRARY_PATH=$FIREBIRD/lib seems weird since
there is no directory like that.
As well as those two paths in /etc/env.d/70firebird to /opt dir are not used
anymore.

------- Comment #7 From William L. Thomson Jr. (RETIRED) 2008-06-06 02:44:52 0000 ------- 
Ok just committed revisions with updated conf.d file and removed env.d file.
Should resolve this bug. Although I will likely move the fbintl.conf file to
/etc/ from /usr/lib/firebird/intl. Saving that for another day.

Please reopen if not resolved, and thanks for reporting.