Bug 81718

Summary:	Broken CHARSET support in firebird-server
Product:	Ports & Packages	Reporter:	Jiri Novak <bati>
Component:	Individual Port(s)	Assignee:	freebsd-ports-bugs (Nobody) <ports-bugs>
Status:	Closed FIXED
Severity:	Affects Only Me
Priority:	Normal
Version:	Latest
Hardware:	Any
OS:	Any

Description Jiri Novak 2005-05-31 15:30:02 UTC

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

Comment 1 novak 2005-06-07 12:06:19 UTC

Nobody cares about broken firebird?
Additional info - after removing and reinstalling firebird-*, the
problems with log and security.fdb vanished, but I still cannot use
CHARSET support, which is really cruciall in our production environment.
--
Jiri Novak

Comment 2 Pav Lucistnik freebsd_committer

2005-06-07 21:58:57 UTC

State Changed
From-To: open->feedback

Can't really help you - have you talked with maintainer or with someone 
who understands Firebird? If you get any patches for port, contact us.

Comment 3 Pav Lucistnik freebsd_committer

2005-06-08 09:07:09 UTC

State Changed
From-To: feedback->closed

Submitter will take this up with maintainer