Link to home
Start Free TrialLog in
Avatar of kretzschmar
kretzschmarFlag for Germany

asked on

Interbase Version Problem

hi interbase experts,

i have developed an interbase 5.5 application with delphi.

now a customer installed another software,
which uses firebird (v6.2.2).

since this installation the customer cannot
login with my app into the ib 5.5 database
-> username/password unknown-message comes up
(was default sysdba/masterkey)

any suggestions about how to solve this?
-> i have already replaced the server and client files without any success

meikl ;-)
Avatar of kacor
kacor
Flag of Hungary image

hi meikl,

try as follows:

1. Backup
2. Reload
3. Login with masterkey

I hope it helps

wbr

Janos
Of course you can use in this case an other dialect to use the newer possibilities.

regards

Janos
Avatar of kretzschmar

ASKER

hi janos,

thanks for your suggestion,
but

>1. Backup
not possible because unable to login :-(

meikl ;-)
hi michael,

did you try it?
If you are sysdba you can backup it (of course you can't login). This was a security problem fo IB. If somebody can acces to the drive which stores the database simply can make a copy of the database and after reloading on an other PC(??)/computer he can acces the database with sysdba grants!!

please try it

Janos
well janos, the problem lies deeper

currently i cannot login on the server nor on the database itself.

my customer installed the software

TNT Speedbooking

which uses firebird v6.2.2

this installationm replaced all interbase files and i guess
they also patched a dll to its needs (some kind of loginprotection to
theior own database-file) so that the default sysdba is nevermore masterkey
for all databases.

do you know anything about
TNT Speedbooking


meikl ;-)
If the first would be wrong it is an other idea! Not to comfortable but useful.

The InterBase passwords are max 8 character long. It can be longer but only the first 8 are evaluated!! Try, for example masterkey or masterke are equal!!

So you can write a macro to generate incrementing login name and pw and you'll get in a short time the pw!

In this moment I have no more idea

wbr

Janos
In the meantime  I've got your newer comment. I suggest the second way. The login name is known I mean so it wouldn't be to long time to detect the pw

have a complete success

Janos
ASKER CERTIFIED SOLUTION
Avatar of Stummel
Stummel

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks stummel,

i guessed also that ib5.5 database-file is corrupted,
during accessing with the firebird server/client software

my customer is now searching his latest backup
(this may take some time/days, bad organised)

a bit history

original software (an ordering and workflow-app)
was developed by me with delphi and ib 5.5
for another customer (ib was on a file-server there). this
customer gave up because of lack of money and orders.

the problemcustomer got the database and i installed him a local ib 5.5
with default directory structure on a standalone-PC, all works perfectly

the story so far the customer told me:

he got the software "TNT SpeedBooking" from TNT Germany and installed
it on the standalone-PC, there was no warning that the current ib-installation will be
overwritten with the firebird-files, he said.

Result:
The Ordering and Workflow-App cannot accessed since.
(username/password unknown), which is needed for the business,
whereas the "TNT SpeedBooking"-Installation was just for fun,
to see what is this software.

well, as next steps, if the backup is available,
i will deinstall firebird and interbase completly,
and reinstall ib5.5. My Customer confirmed,
that the "TNT SpeedBooking"-Software, if it is needed,
will be installed on another pc.

thanks for your help both

meikl ;-)

Janos, watch out for a q for you

Avatar of vowca
vowca

BTW Yaffil SQL server may appear faster than IB and FB 1.0.x and has IB5 compatibility better than FB.
Though Yaffil is limited to Win32 platform only.