Firebird News

Firebird 3 is using new method to validate users on the server.
Direct upgrade of security database is therefore impossible.
Described procedure will let you keep the list of firebird 2.X users
and all related information (firstname, lastname, etc.) except
password – new passwords will be generated randomly. Pay attention
that SYSDBA user is not touched – i.e. it will remain as was after
execution of upgrade procedure. In the commands below replace
‘masterkey’ with actual SYSDBA password for appropriate (2.X/3.0)
firebird server.

In firebird 2.5 backup security database:

gbak -user sysdba -pas masterkey -b {host/path}security2.fdb security.fbk

In firebird 3 restore copy of 2.5 security database:

gbak -user sysdba -pas masterkey -c security.fbk {host/path}security2.5

And run users upgrade sql script:

isql -user sysdba -pas masterkey -i security_database.sql {host/path}security2.5

“security2.5” is a sample database name – you may use any other if you wish.

Upgrade Script will create users with new random passwords and type them to you.
It’s your responsibility to notify users about new passwords.

The FireBird RDBMS can be crashed remotely by an authenticated client
by invoking gbak via the service manager using invalid command line
switch and lead to denial of service.

The issue was introduced in version 2.5.5.

Upstream report:
http://tracker.firebirdsql.org/browse/CORE-5068

Upstream fix: 
http://sourceforge.net/p/firebird/code/62783/

Debian bug:
https://bugs.debian.org/810599

CVE-2016-1569 Status in Debian:
https://security-tracker.debian.org/tracker/CVE-2016-1569

Vote for Firebird as Database of the Year 2015 at LinuxQuestions (must be registered user with at least one Linux related post)

http://www.linuxquestions.org/questions/2015-linuxquestions-org-members-choice-awards-117/database-of-the-year-4175562708/

FirebirdWebAdmin 3.3.0 is released .

Changes :

Review User Page. Modal popup for Role creation. Delete role button for each role.
Users: Remove “Customizing” panel. Is not database/server related.
Initial integration with Crowdin. Convert all files to UTF-8.
Update Romanian & Russian translations.
UI improvements: Roles, Users, Exceptions, UDF, Table comments.
Integration with CodeMirror.
In-browser code editor http://codemirror.net/

Now we have autocomplete/suggestions with table names and fields and SQL reserved words.

Hajime Nakagami created an pure Erlang Firebird client library (Work in progress)

https://github.com/nakagami/efirebirdsql

Mark Rotteveel published a new Jaybird 3.0.0-SNAPSHOT version for testing.

Release notes available at:
http://www.firebirdsql.org/file/documentation/drivers_documentation/java/3.0.0-SNAPSHOT/release_notes.html

We would really appreciate it if people would start testing Jaybird 3 with
their applications and report problems or incompatibilities.

For Maven it is available from the Sonatype OSS snapshot repository
(https://oss.sonatype.org/content/repositories/snapshots) which you need
to add to your maven config or POM.

It is also uploaded to sourceforge:
https://sourceforge.net/projects/firebird/files/firebird-jca-jdbc-driver/3.0.0-SNAPSHOT

Thank you to all what was participated to improve translations of FirebirdWebAdmin!

German: 100% done! Thanks to Martin Köditz!
Polish: Amost done. Thanks to Piotr Czepek and Grzegorz Skoczylas!
Czech: New translation language. Thanks to Tomas Krejzek!
Spanish: Thanks to Duilio Juan Isola!
Portuguese, Brazilian: Thanks to Paulo Junqueira da Costa!
Dutch: Thanks to LucavanB!
Romanian: New translation language. Will be translated step by step by me 🙂

If you want to help us to cover all translations you can join in our project:
https://crowdin.com/project/firebirdwebadmin