Activities of "Anjaneyulu"
Im using dockersektop with wsl2 in windows machine. I believe this has nothing to do with that because im able to connect from ssms with external port 1434 from host machien when i run individually based on the micrsoft documentation.
The error logs from container :
2025-02-06 05:30:00 05:09:54.54 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:54 2025-02-06 05:30:00 05:09:54.59 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:54 2025-02-06 05:30:00 05:09:54.59 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.98 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.98 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.99 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:54.99 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.13 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.13 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1] 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.17 Logon Error: 18456, Severity: 14, State: 8. 2025-02-06 10:39:55 2025-02-06 05:30:00 05:09:55.17 Logon Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 172.18.0.1]
Inspect sql container configuration
"Env": [ "ACCEPT_EULA=Y", "SA_PASSWORD=myPassw@rd", "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "BUILD_VERSION=16.0.5100.7245", "PAL_BOOT_WITH_MINIMAL_CONFIG=1", "PAL_ENABLE_PAGE_ALIGNED_PE_FILE_CREATION=1", "LD_LIBRARY_PATH=/opt/mssql/lib"
let me try to create an new project and check again.
Ohh that my bad, i have attached a wrong screenshot , I have changed the password for testing,incase that works.
I confirm the password was myPassw@rd when tried to run the applications
This the error that im getting with services and similar to authserver as well.
SqlException has been thrown. The operation will be tried 2 times more. Exception: Login failed for user 'sa'.. Stack Trace: at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen() --- End of stack trace from previous location -
I have tried connecting to sql server running in docker from ssms host machine localhost,1434 -
Hi, can you check your container and inspect it to ensure about the password and also confirm it's same in your microservice application?
Yes, In the docker desktop, i could inspect the docker container and see the password same as which im trying to login
To be more specific it is the default password that comes with the microservice template architute using abp studio
Hi, can you check your container and inspect it to ensure about the password and also confirm it's same in your microservice application?
Yes, In the docker desktop, i could inspect the docker container and see the password same as which im trying to login
hi
openid client credentials are not created in the tenant
The openiddict application/client should always store on Host database.
Tommorow if i create a tenant for customer, Should i not give the tenant admin provision to add openid applications/clients ??
showing invalid certificate but it is showing as valid certificate for web.xyx.com
Your HTTPS certification should contain the
*.web.xyx.com.
Rather than having multilevel subdomains, if i use three certificates for api,authserver and web and create a tenant test, will abp support test.api.com -> test.authserver.com -> test.web.com tenant resolution?
acme.sh --issue --dns dns_cf -d getabp.net -d '*.getabp.net' -d '*.api.getabp.net' -d '*.ids.getabp.net' -d '*.ng.getabp.net' -d '*.web.getabp.net'
I have configured the widl card i.e., *.xyz.com to my server as follows
API Host - api.xyz.com AuthServer - auth.xyz.com WebServer - web.xyz.com
I have observerd two issues here
- When add tenant lets say 'test1' - I couldn't login to test1.web.xyz.com as the openid client credentials are not created in the tenant ,so it is redirecting to auth.xyz.com rather than t1.auth.xyz.com
- Also when i do t1.web.xyz.com the certificate is showing invalid certificate but it is showing as valid certificate for web.xyx.com
Thanks, i got the issue. Issue seems to be with Rabbitmq for some reason.
Altough i have configured the rabbitmq, application is not able to connect on 5672. Altough i didnt see any issue while debug, insertasync is throwing an expection after some time saying "not able to reach specific endpoint" rabbitmq server etc..,
Once i fix the rabbitmq connection, im able see users in the DB
If possible, I would like to connect with you and share the screen, so that we can have better context of it.
Hi , I could debug it, as i see the all the line are getting executed, and i even see the identityuser object response from the insert function.
What should i log to get more information.
Thanks
