Your username and password are not defined. ask a database administrator to setup a login

[Aurel Bartmann]

Hello,

i just started working with firebase today and i wanted to connect it to ibexpert to create a new database but whatever i try i can not access the database. i only used the username sysdba and the password masterkey. I created the databse in the firebird Isql tool and want to connect the database with Ibexpert.

[Mark Rotteveel]

On 06/04/2024 02:50, Aurel Bartmann wrote:
> i just started working with firebase today and i wanted to connect it to

I assume you mean Firebird, because Firebase is a whole different type
of database system/application platform.

> ibexpert to create a new database but whatever i try i can not access
> the database. i only used the username sysdba and the password
> masterkey. I created the databse in the firebird Isql tool and want to
> connect the database with Ibexpert.

Either you made a typo, or there is a mismatch between the
authentication plugins tried by the client library and those used by the
server.

In firebird.conf, what is the setting for AuthServer and UserManager?
Are there any errors in firebird.log at the same time?

That error it couldn't format BTW, is error 336396386, or "Unsuccessful
execution caused by a system error that precludes successful execution
of subsequent statements", which I can't recall ever seeing during login.

Mark
--
Mark Rotteveel

[liviuslivius]

Hi

I do not know ibexpert, but looking on your screenshot you have checked "trusted auth" which is Windows Domain auth. Turn it off if you login with sysdba masterkey.

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: Aurel Bartmann <aurelb...@gmail.com>

Data: 6.04.2024 02:50 (GMT+01:00)

Do: firebird-support <firebird...@googlegroups.com>

Temat: [firebird-support] Your username and password are not defined. ask a database administrator to setup a login

Hello,

i just started working with firebase today and i wanted to connect it to ibexpert to create a new database but whatever i try i can not access the database. i only used the username sysdba and the password masterkey. I created the databse in the firebird Isql tool and want to connect the database with Ibexpert.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/6cfa119e-af68-4d44-9d21-3682430ffbefn%40googlegroups.com.

[Mark Rotteveel]

On 06/04/2024 10:21, 'liviuslivius' via firebird-support wrote:
> I do not know ibexpert, but looking on your screenshot you have checked
> "trusted auth" which is Windows Domain auth. Turn it off if you login
> with sysdba masterkey.

That depends on which order authentication plugins are actually tried by
the client.

Mark
--
Mark Rotteveel

[Karol Bieniaszewski]

This depend on the tool too. After check on trusted auth, tool can send empty user and password.

 

Regards,

Karol Bieniaszewski

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/e9281e28-b4ea-4730-ac15-97facce67550%40lawinegevaar.nl.

 

[Aurel Bartmann]

Thanks for your reply! Yeah it was a typo i actually meant firebird.  I reinstalled firebird completely and created a new database. This is the usermanager and then the authserver I get this error in ibexpert when trying to login. The same time when trying to access the database through the firebird isql  tool i can access the database without a problem.  The firebird.log give this output: Authentication error
Your user name and password are not defined. Ask your database administrator to set up a Firebird login. The username is: SYSDBA and the password is: masterkey

 

[Mark Rotteveel]

On 06/04/2024 15:21, Aurel Bartmann wrote:
> authserver.pngThanks for your reply! Yeah it was a typo i actually meant

> firebird. I reinstalled firebird completely and created a new database.

> This is the usermanager and then the authserver usermanager.png I get

> this error in ibexpert when trying to login. The same time when trying
> to access the database through the firebird isql  tool i can access the
> database without a problem.  The firebird.log give this output:
> Authentication error
> Your user name and password are not defined. Ask your database
> administrator to set up a Firebird login. The username is: SYSDBA and
> the password is: masterkey

That suggests to me that IB Expert is not using a compatible client
library. You could try if changing the AuthServer setting works:

AuthServer = Srp256, Srp

But for comparison sake, how are you connecting in ISQL? If you only
specify the filename, ISQL is probably connecting using Firebird
Embedded, which doesn't perform any authentication!

Mark
--
Mark Rotteveel

[Aurel Bartmann]

Yeah sadly it didnt work but thank you for trying to help me! I got the exactly same error. I am using ib expert education only version from my professor that could be an issue too. This is how i am connecting to firebird isql tool:

[Mark Rotteveel]

On 06/04/2024 15:48, Aurel Bartmann wrote:
> Yeah sadly it didnt work but thank you for trying to help me! I got the
> exactly same error. I am using ib expert education only version from my
> professor that could be an issue too. This is how i am connecting to

> firebird isql tool: Screenshot 2024-04-06 154647.png

As I suspected, your connection in ISQL is probably using embedded. In
ISQL, try connecting with XNET, which will connect through the server
and which will actually perform authentication

connect 'xnet://C:\Program files\firebird_4_0\DATENBANKEN1.fdb' user
sysdba password 'masterkey';

I suspect you'll get the same error as in IBExpert. If that is the case,
then connect again in ISQL (without the xnet:// prefix), and reset the
password of sysdba (or create it if it doesn't exist yet):

create or alter user sysdba password 'masterkey';

and then try again in IBExpert.

Mark
--
Mark Rotteveel

[Aurel Bartmann]

Thank you so much! it worked! I got the same error when doing wiht xnet and then i did it without the xnet. Then i created and alterd the username and password. After that i registered a new database but this time with xnet it
Then it worked! Thank you so much!