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

[Juliano]

Cantu, primeiramente obrigado pelo retorno.

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

USERNAME = SYSDBA
ADMIN = true
PLUGIN = Legacy_UserManager

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

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

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

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

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


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

Juliano Veroneze.

Em seg., 18 de abr. de 2022 às 15:55, Juliano <jveroneze em gmail.com>
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
>