Error: No credentails found. Add an Azure login script before this action.
- Lenguaje dominante
- TypeScript
- Estrellas
- 142
- Forks
- 73
- Métricas de merge de PR
- Sin PR fusionados en 30 d
Descripción
Using Azure/sql-action@v2.2 to deploy scripts to on-premises SQL Server 2019 using a sql authenticated account. I am not using Azure in any way. I can have a successful deploy of a .sql script one run, and the next run that same script/execution can fail, and keep failing reruns, and then just randomly be successful.
The error is:
Error: No credentails found. Add an Azure login script before this action.
"credentails" is not a spelling error on my end, that is the copy/pasted error from GitHub Actions workflow. In bin/main.js, you can search for "credentails" to see the chunk of code that it is erroring due to something within the code.
I find it strange behavior that with the exact same setup one run will be successful, the next one will fail (and sometimes fail dozens of times in a row), and then randomly will be successful again.
Has anyone else seen this behavior/error message?
```yaml
- name: Deploy Script A
uses: Azure/sql-action@v2.2
with:
connection-string: "${{ secrets.CONNECTION_STRING }}"
path: './sqlscripts/scriptA.sql'
arguments: -b
- name: Deploy Script B
uses: Azure/sql-action@v2.2
with:
connection-string: "${{ secrets.CONNECTION_STRING }}"
path: './sqlscripts/scriptB.sql'
arguments: -b
```
I turned debug mode on and captured the output.
Scenario: the GitHub workflow executes 2 scripts with the above code above, back to back. Same connection string and script contents (select 'Testing debug'), just in separate scripts to catch a success and a failure in the same workflow.
The '.' in the failed attempt at the beginning of the line means it's the same as the successful log.
Here are the logs right before the azure/sql-action kicks off:
SUCCESS - deploy scriptA to AdventureWorks database on sql-server1.domain.com:1433
##[debug]isExplicit: 1.0.0
##[debug]explicit? true
##[debug]checking cache: /opt/hostedtoolcache/go-sqlcmd/1.0.0/x64
##[debug]not found
##[debug]Downloading https://github.com/microsoft/go-sqlcmd/releases/download/v1.0.0/sqlcmd-v1.0.0-linux-x64.tar.bz2
##[debug]Destination /home/gaction/actions-runner/_work/_temp/751ab65d-c2e3-46b2-8d80-4fccce6751ad
##[debug]download complete
##[debug]Checking tar --version
##[debug]tar (GNU tar) 1.34
##[debug]Copyright (C) 2021 Free Software Foundation, Inc.
##[debug]License GPLv3+: GNU GPL version 3 or later .
##[debug]This is free software: you are free to change and redistribute it.
##[debug]There is NO WARRANTY, to the extent permitted by law.
##[debug]
##[debug]Written by John Gilmore and Jay Fenlason.
tar xj -v --warning=no-unknown-keyword --overwrite -C /home/gaction/actions-runner/_work/_temp/c655f6ad-76f2-4fdf-9e30-61e77e092f39 -f /home/gaction/actions-runner/_work/_temp/8a3e0d22-c11d-418c-a2d5-d04a4cbcb575
NOTICE.md
sqlcmd
sqlcmd_debug
##[debug]Caching tool go-sqlcmd 1.0.0 x64
##[debug]source dir: /home/gaction/actions-runner/_work/_temp/c655f6ad-76f2-4fdf-9e30-61e77e092f39
##[debug]destination /opt/hostedtoolcache/go-sqlcmd/1.0.0/x64
##[debug]finished caching tool
##[debug]Get action inputs.
::add-mask::***
::add-mask::***
##[debug]Validating if client has access to 'master' on 'sql-server1.domain.com'.
##[debug]Begin executing sql script
sqlcmd -S sql-server1.domain.com -d AdventureWorks -U *** -i ./sqlscripts/scriptA.sql -b
__Output__
Testing debug
(1 row affected)
Successfully executed SQL file on target database.
__________________________________________________________________________________________________________________________
FAIL - deploy scriptB to AdventureWorks database on sql-server1.domain.com:1433
. ##[debug]isExplicit: 1.0.0
. ##[debug]explicit? true
. ##[debug]checking cache: /opt/hostedtoolcache/go-sqlcmd/1.0.0/x64
. ##[debug]not found
. ##[debug]Downloading https://github.com/microsoft/go-sqlcmd/releases/download/v1.0.0/sqlcmd-v1.0.0-linux-x64.tar.bz2
. ##[debug]Destination /home/gaction/actions-runner/_work/_temp/751ab65d-c2e3-46b2-8d80-4fccce6751ad
. ##[debug]download complete
. ##[debug]Checking tar --version
. ##[debug]tar (GNU tar) 1.34
. ##[debug]Copyright (C) 2021 Free Software Foundation, Inc.
. ##[debug]License GPLv3+: GNU GPL version 3 or later .
. ##[debug]This is free software: you are free to change and redistribute it.
. ##[debug]There is NO WARRANTY, to the extent permitted by law.
. ##[debug]
. ##[debug]Written by John Gilmore and Jay Fenlason.
. tar xj -v --warning=no-unknown-keyword --overwrite -C /home/gaction/actions-runner/_work/_temp/45f3bd31-9bf4-4851-8faa-11cd2b3c0bab -f /home/gaction/actions-runner/_work/_temp/751ab65d-c2e3-46b2-8d80-4fccce6751ad
. NOTICE.md
. sqlcmd
. sqlcmd_debug
. ##[debug]Caching tool go-sqlcmd 1.0.0 x64
. ##[debug]source dir: /home/gaction/actions-runner/_work/_temp/45f3bd31-9bf4-4851-8faa-11cd2b3c0bab
. ##[debug]destination /opt/hostedtoolcache/go-sqlcmd/1.0.0/x64
. ##[debug]finished caching tool
. ##[debug]Get action inputs.
. ::add-mask::***
. ::add-mask::***
. ##[debug]Validating if client has access to 'master' on 'sql-server1.domain.com'.
##[debug]The process 'sqlcmd' failed with exit code 1
##[debug]SqlCmd stderr: unable to open tcp connection with host 'sql-server1.domain.com:1433': dial tcp ip.ad.dre.ss:1433: i/o timeout
##[debug]unable to open tcp connection with host 'sql-server1.domain.com:1433': dial tcp ip.ad.dre.ss:1433: i/o timeout
##[debug]
##[debug]try-get AzureCLIAuthorizer
##[debug]{}
Error: No credentails found. Add an Azure login script before this action.
##[debug]Node Action run completed with exit code 1
##[debug]AZURE_HTTP_USER_AGENT='GITHUBACTIONS_AzureSqlAction_5a2680ec296d517622edbc0a559bf3fb603c4c653bc14cc5d46f5ffc1f2f4e6e'
##[debug]SQLCMDPASSWORD='***'
##[debug]AZURE_HTTP_USER_AGENT=''
##[debug]Finishing: Deploy to Target
@jongilmorejr - tagging because your name is in the debug logs :)
Guía de contribución
Línea de trabajo
Comienza en bin/main.js buscando el mensaje “credentails” indicado y, a continuación, sigue la ruta del fallo de sqlcmd desde el tiempo de espera de TCP registrado hasta la comprobación de AzureCLIAuthorizer. Reproduce los dos pasos consecutivos del workflow usando el YAML proporcionado y compara los logs correctos y fallidos; se considera terminado cuando el error resultante refleja con precisión el fallo de conexión subyacente.
Escrito por el modelo de indexación a partir del texto del issue.
Evaluación
- Stack tecnológico
- github-actions, sql, typescript
- Área
- ci-cd, databases
- Tipo de issue
- Error
- Dificultad
- 4/5
- Tiempo estimado
- 3-5 días
- Estado de actividad
- Estancado
- Claridad
- Bastante claro
- Aptitud para principiantes
- 35/100