>Number: 81718
>Category: ports
>Synopsis: Broken CHARSET support in firebird-server
>Confidential: no
>Severity: serious
>Priority: medium
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Tue May 31 14:30:02 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator: Jiri Novak
>Release: 5.4-RELEASE-p1
>Organization:
Nostromo ICT
>Environment:
FreeBSD sulaco.dmz.hq.nostromo.cz 5.4-RELEASE-p1 FreeBSD 5.4-RELEASE-p1 #0: Fri May 13 12:30:37 CEST 2005 root@sulaco.dmz.hq.nostromo.cz:/usr/obj/usr/src/sys/SULACO-HQ i386
>Description:
After upgrading firebird to firebird-client and firebird-server I started to notice strange behavior of firebird-server. It no longer creates locks and logfile in /usr/local/firebird, but directly in /usr/local. It also cannot find security.fdb until moved/linked into /usr/local. Also there seems to be some problem with charset support, so connects from PHP with charset parameter of ibase_connect() supplied fails (with warning, but empty connection). I'd tried other charsets with same result.
I'd also noticed some troubles with interbase.so php4 extension, but reported them separately.
>How-To-Repeat:
- Deinstall firebird, install firebird-server firebird-client
- Observe log/lockfiles in /usr/local
- Try to connect using charset (ie from PHP) as:
ibase_connect($db, $user, $pass, 'WIN1250')
- You'll get:
Warning: ibase_connect(): bad parameters on attach or create database CHARACTER SET WIN1250 is not defined in /data/www/pub-inc/lib/lib_db.php on line 61
>Fix:
>Release-Note:
>Audit-Trail:
>Unformatted: