[firebase-br] Atualização HQBird 2020 p/ 2022 SQLState: 28000.

[Carlos H. Cantu]

Aparentemente você não tem o SYSDBA criado no plugin SRP, que é o padrão no FB
3. Alguma razão específica para estar usando autenticação legada?

De qualquer forma, experimente criar o SYSDBA no SRP e veja se resolve seu 
problema.

[]s
Carlos H. Cantu
eBook Guia de Migração para o FB 4 - www.firebase.com.br/guiafb4.php
www.FireBase.com.br - www.firebirdnews.org - blog.firebase.com.br

Jvl> Cantu, primeiramente obrigado pelo retorno.

Jvl> Consultei, conforme instrução.
Jvl> Para o sysdba e para os demais está Legacy_UserManager (admin=true) apenas
Jvl> para esse registro.

Jvl> USERNAME = SYSDBA
Jvl> ADMIN = true
Jvl> PLUGIN = Legacy_UserManager

Jvl> O teste de conexão, usando isql, outros clientes, conecta normalmente então
Jvl> a senha está ok.
Jvl> Fiz mais alguns testes com firebird.conf nos parametros AuthServer,
Jvl> AuthClient combinando Srp, Win_Sspi, Legacy_Auth, criando outros admins e
Jvl> configurando no hqbird, também sem sucesso.

Jvl> Poderia ser algum outro recurso do serviço hqbird / java / jdbc que está
Jvl> gerando esse problema ?

Jvl> + Logs de: ../outdataguard/logs/general

Jvl>         at
Jvl> org.dataguard.helpers.spring.QuartzJobAdapter.execute(QuartzJobAdapter.java:35)
Jvl>         at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
Jvl>         at
Jvl> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)

Jvl> *Caused by: java.sql.SQLInvalidAuthorizationSpecException: Your user name
Jvl> and password are not defined. Ask your database administrator to set up a
Jvl> Firebird login. [SQLState:28000, ISC error code:335544472]*        at
Jvl> org.firebirdsql.gds.ng.FbExceptionBuilder$Type$4.createSQLException(FbExceptionBuilder.java:579)
Jvl>         at
Jvl> org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:304)
Jvl>         at
Jvl> org.firebirdsql.gds.ng.wire.version13.V13WireOperations.authReceiveResponse(V13WireOperations.java:176)
Jvl>         at
Jvl> org.firebirdsql.gds.ng.wire.version10.V10Database.authReceiveResponse(V10Database.java:569)
Jvl>         at
Jvl> org.firebirdsql.gds.ng.wire.WireConnection.identify(WireConnection.java:335)
Jvl>         at
Jvl> org.firebirdsql.gds.ng.wire.FbWireDatabaseFactory.performConnect(FbWireDatabaseFactory.java:51)
Jvl>         at
Jvl> org.firebirdsql.gds.ng.wire.FbWireDatabaseFactory.connect(FbWireDatabaseFactory.java:39)
Jvl>         at
Jvl> org.firebirdsql.gds.ng.wire.FbWireDatabaseFactory.connect(FbWireDatabaseFactory.java:32)
Jvl>         at
Jvl> org.firebirdsql.management.FBServiceManager.attachDatabase(FBServiceManager.java:249)
Jvl>         at
Jvl> org.firebirdsql.management.FBStatisticsManager.getDatabaseTransactionInfo(FBStatisticsManager.java:144)
Jvl>         at org.dataguard.shared.impl.FBService.getTxInfo(FBService.java:58)
Jvl>         at
Jvl> org.dataguard.shared.impl.DatabaseHelper.getTransactionInfo(DatabaseHelper.java:268)
Jvl>         at
Jvl> org.dataguard.jobs.impl.agent.server.database.checkTransactions.CheckTransactionsJob.runJobWithDatabase(CheckTransactionsJob.java:81)
Jvl>         ... 6 more
Jvl> Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: Your user name and
Jvl> password are not defined. Ask your database administrator to set up a
Jvl> Firebird login.
Jvl> 09:04:41,051 [DG:Scheduler_Worker-10] ERROR  jobs.BaseDGJob
Jvl>                     - Error in job CheckTransactionsJob, transaction-info@[
Jvl> hqbirdsrv / 6ff95dda-340c-41e6-b8b0-95339e8d66be ] -> Job transaction-info@[
Jvl> hqbirdsrv / 6ff95dda-340c-41e6-b8b0-95339e8d66be ] met the condition,
Jvl> preventing it from doing it's best:
Jvl> org.dataguard.jobs.JobMalFunctionException
Jvl> Error in obtaining tx info
Jvl> Your user name and password are not defined. Ask your database
Jvl> administrator to set up a Firebird login. [SQLState:28000, ISC error
Jvl> code:335544472]
Jvl> Your user name and password are not defined. Ask your database
Jvl> administrator to set up a Firebird login.
Jvl> 09:04:41,055 [DG:Scheduler_Worker-10] INFO
Jvl> notification2.NotificationManager                  - emailDebugLog: block
Jvl> sending tag
Jvl> "/agent/servers/hqbirdsrv/databases/6ff95dda-340c-41e6-b8b0-95339e8d66be/jobs/transaction-info/job-malfunction"
Jvl> due spam delay, limit time: Wed Apr 20 09:56:41 BRT 2022
Jvl> 09:04:41,055 [DG:Scheduler_Worker-10] INFO
Jvl> notification2.NotificationManager                  - emailDebugLog: send
Jvl> alarm process complete
Jvl> 09:04:41,055 [DG:Scheduler_Worker-10] INFO   jobs.BaseDGJob
Jvl>                     - <--O: transaction-info@[ hqbirdsrv /
Jvl> 6ff95dda-340c-41e6-b8b0-95339e8d66be ] 36ms


Jvl> Se houver mais alguma ação ou material ou dica para indicar, agradeço !

Jvl> Juliano Veroneze.

Jvl> Em seg., 18 de abr. de 2022 às 15:55, Juliano <jveroneze em gmail.com>
Jvl> escreveu:

>> Boa tarde a todos,
>>
>>
>> Temos uma situação em que após atualização do HQbird 2020 para 2022
>> apresenta mensagem de username/password para sysdba não definida.
>> No nosso caso, já utilizavamos senha diferente da padrão sysdba /
>> masterkey e não realizamos nenhuma alteração neste sentido.
>>
>> Algum procedimento | sugestão | correção para esse erro ?
>>
>> *Log das transações:*
>> Job transaction-info@[ hqbirdsrv / <database-id> ] met the condition,
>> preventing it from doing it's best:
>> org.dataguard.jobs.JobMalFunctionException
>> Error in obtaining tx info
>> *Your user name and password are not defined. Ask your database
>> administrator to set up a Firebird login. [SQLState:28000, ISC error
>> code:335544472]*
>> Your user name and password are not defined. Ask your database
>> administrator to set up a Firebird login.
>>
>> *Painel de Alertas:*
>> 1 2022/04/18 15:01:06 GMT-0300 MALFUNCTION Teste Job malfunction Job
>> transaction-info@[ hqbirdsrv / <database-id> ] met the condition,
>> preventing it from doing it's best:
>> org.dataguard.jobs.JobMalFunctionException
>> Error in obtaining tx info
>> *Your user name and password are not defined. Ask your database
>> administrator to set up a Firebird login. [SQLState:28000, ISC error
>> code:335544472]*
>> Your user name and password are not defined. Ask your database
>> administrator to set up a Firebird login.
>>
>> Server é Linux.
>>
>> Grato,
>> Juliano
>>
Jvl> ______________________________________________
Jvl> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
Jvl> Para saber como gerenciar/excluir seu cadastro na lista, use:
Jvl> http://www.firebase.com.br/fb/artigo.php?id=1107
Jvl> Para consultar mensagens antigas: http://www.firebase.com.br/pesquisa_lista.html