Bug 2873 - Update candidate for firebird-2.5.0.26074.0-1
Summary: Update candidate for firebird-2.5.0.26074.0-1
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 1
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: QA Team
QA Contact:
URL:
Whiteboard:
Keywords: validated_update
Depends on:
Blocks:
 
Reported: 2011-09-29 18:04 CEST by Philippe Makowski
Modified: 2011-10-15 02:06 CEST (History)
2 users (show)

See Also:
Source RPM:
CVE:
Status comment:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Philippe Makowski 2011-09-29 18:04:42 CEST 
There is a missing symlink when installing client only utils

urpmi firebird-utils-common firebird-utils-superserver
ls -la /usr/bin/isql-fb
lrwxrwxrwx 1 root root 33 sept. 29 17:49 /usr/bin/isql-fb -> ../../usr/lib64/firebird/bin/isql

but there is no /usr/lib64/firebird/bin

urpme firebird-utils-common firebird-utils-superserver lib64fbclient2

urpmi new packages (2.5.1.26349.0-1):

then:
ls -la /usr/lib64/firebird/bin
lrwxrwxrwx 1 root root 35 sept. 29 17:54 /usr/lib64/firebird/bin -> /usr/lib64/firebird/bin-superserver/


it is also an upstream bug fix release (http://tracker.firebirdsql.org/browse/CORE/fixforversion/10333)

example of bug fix upstream :http://tracker.firebirdsql.org/browse/CORE-3479

to test it under Mageia :
urpmi firebird-superserver
/sbin/service firebird-superserver start

then :
isql-fb localhost:employee -user SYSDBA -password masterkey
Database:  localhost:employee, User: SYSDBA
SQL> select ascii_val('') from rdb$database; 

ASCII_VAL 
========= 
        0 

SQL> exit;

is the correct answer
Comment 1 claire robinson 2011-10-04 12:57:15 CEST 
i586:

Before
------

urpmi firebird-utils-common firebird-utils-superserver
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch   
(medium "Core Release")
  firebird-utils-common          2.5.0.26074> 1.mga1        i586    
  firebird-utils-superserver     2.5.0.26074> 1.mga1        i586    
  libfbclient2                   2.5.0.26074> 1.mga1        i586  

ll /usr/bin/isql-fb
lrwxrwxrwx 1 root root 31 Oct  4 11:26 /usr/bin/isql-fb -> ../../usr/lib/firebird/bin/isql

isql-fb localhost:employee -user SYSDBA -password masterkey
-bash: isql-fb: command not found


After
-----
#rpm -qa | grep firebird
firebird-utils-superserver-2.5.1.26349.0-1.mga1
firebird-utils-common-2.5.1.26349.0-1.mga1
# rpm -qa | grep libfbclient
libfbclient2-2.5.1.26349.0-1.mga1

# ll /usr/bin/isql-fb
lrwxrwxrwx 1 root root 31 Oct  4 11:32 /usr/bin/isql-fb -> ../../usr/lib/firebird/bin/isql*

#urpmi firebird-superserver

# rpm -qa | grep firebird
firebird-server-superserver-2.5.1.26349.0-1.mga1
firebird-utils-superserver-2.5.1.26349.0-1.mga1
firebird-utils-common-2.5.1.26349.0-1.mga1
firebird-server-common-2.5.1.26349.0-1.mga1
firebird-superserver-2.5.1.26349.0-1.mga1
# rpm -qa | grep libfb
libfbembed2-2.5.1.26349.0-1.mga1
libfbclient2-2.5.1.26349.0-1.mga1

# service firebird-superserver start
Starting Firebird server [default]                              [  OK  ]

# isql-fb localhost:employee -user SYSDBA -password masterkey
Database:  localhost:employee, User: SYSDBA
SQL> select ascii_val('') from rdb$database;

ASCII_VAL 
========= 
        0 

SQL> exit;


Thankyou for the precise testing procedure, it makes this so much easier!

Testing complete i586, I will test x86_64 shortly.
Comment 2 claire robinson 2011-10-04 14:15:29 CEST 
x86_64:

Before
------

urpmi firebird-utils-common firebird-utils-superserver
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch
(medium "Core Release (distrib1)")
  firebird-utils-common          2.5.0.26074> 1.mga1        x86_64
  firebird-utils-superserver     2.5.0.26074> 1.mga1        x86_64
  lib64fbclient2                 2.5.0.26074> 1.mga1        x86_64

# ll /usr/bin/isql-fb
lrwxrwxrwx 1 root root 33 Oct  4 13:03 /usr/bin/isql-fb -> ../../usr/lib64/firebird/bin/isql

# isql-fb localhost:employee -user SYSDBA -password masterkey
-bash: isql-fb: command not found


After
-----
# rpm -qa | grep firebird
firebird-utils-common-2.5.1.26349.0-1.mga1
firebird-utils-superserver-2.5.1.26349.0-1.mga1
# rpm -qa | grep lib64fb
lib64fbclient2-2.5.1.26349.0-1.mga1

# ll /usr/bin/isql-fb
lrwxrwxrwx 1 root root 33 Oct  4 13:06 /usr/bin/isql-fb -> ../../usr/lib64/firebird/bin/isql*

# urpmi firebird-superserver
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch
(medium "Core Updates Testing (distrib5)")
  firebird-server-common         2.5.1.26349> 1.mga1        x86_64
  firebird-server-superserver    2.5.1.26349> 1.mga1        x86_64
  firebird-superserver           2.5.1.26349> 1.mga1        x86_64
  lib64fbembed2                  2.5.1.26349> 1.mga1        x86_64

# service firebird-superserver start
Starting Firebird server [default]                              [  OK  ]

# isql-fb localhost:employee -user SYSDBA -password masterkey
Database:  localhost:employee, User: SYSDBA
SQL> select ascii_val('') from rdb$database;

ASCII_VAL
=========
        0

SQL> exit;

All is well x86_64.

One thing I spotted though in both versions when installing the superserver..

Mandriva mentioned with the mdv package
----------------------------------------------------------------------
More information on package firebird-server-common-2.5.1.26349.0-1.mga1.x86_64
You just installed or update firebird server.
You can found important informations about mandriva firebird rpms and database
management in:

/usr/share/doc/firebird-server-common/firebird.mdv.releasenote

Please, read it.

----------------------------------------------------------------------

This really needs correcting.
Comment 4 claire robinson 2011-10-05 15:40:02 CEST 
# less /usr/share/doc/firebird-server-common/firebird.mga.releasenote
/usr/share/doc/firebird-server-common/firebird.mga.releasenote: No such file or directory

# ls /usr/share/doc/firebird-server-common
firebird.mdv.releasenote  IDPL.txt  README.license.usage.txt  README.urpmi

The file is still created as mdv instead of mga although the README.urpmi now states mga.
Comment 5 Philippe Makowski 2011-10-05 23:51:03 CEST 
sorry
rebuilds done firebird-2.5.1.26349.0-3.mga1 and firebird-2.5.1.26349.0-3.mga2
Comment 6 claire robinson 2011-10-12 18:00:57 CEST 
Confirmed fixed x86_64
Comment 7 claire robinson 2011-10-12 18:16:04 CEST 
Confirmed fixed i586

Update validated, apologies for the delay and thankyou for the testing procedures Philippe.


Advisory
-----------------------
There was a missing symlink when installing client only utils.

isql-fb was symlinked to /usr/lib64/firebird/bin which didn't exist.

This update corrects the issue. It is also an upstream bugfix release
(http://tracker.firebirdsql.org/browse/CORE/fixforversion/10333)

-----------------------

SRPM: firebird-2.5.1.26349.0-3.mga1.src.rpm  


Could sysadmin please push from core/updates_testing to core/updates

Thankyou!

Keywords: (none) => validated_update
CC: (none) => sysadmin-bugs

Comment 8 D Morgan 2011-10-15 02:06:31 CEST 
update pushed.

Status: NEW => RESOLVED
CC: (none) => dmorganec
Resolution: (none) => FIXED
Note You need to log in before you can comment on or make changes to this bug.