Offline laptop / Can't connect with default credentials

[fgadot]

Greetings,

I was able to put my hands on an Intel based iMac. I installed Resgrid off line. Dockers are starting correctly.
Followed the offline laptop documentation. Went to the 3 https pages to validate certificates. Back to https://rg.mylocal , login with admin / changeme1234 gives an error on the web page.

The docker-compose console shows this:

2025-09-25 12:10:48.93 Logon       Error: 18456, Severity: 14, State: 38.
2025-09-25 12:10:48.93 Logon       Login failed for user 'sa'. Reason: Failed to open the explicitly specified database 'Resgrid'. [CLIENT: 172.16.193.51]
web-1         | [12:10:48 FTL] 
web-1         | System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Resgrid" requested by the login. The login failed.
web-1         | Login failed for user 'sa'.
web-1         |    at System.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)
web-1         |    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
web-1         |    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
web-1         |    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
web-1         |    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
web-1         |    at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
web-1         |    at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
web-1         | --- End of stack trace from previous location ---
web-1         |    at Resgrid.Repositories.DataRepository.IdentityUserRepository.GetByUserNameAsync(String userName) in /src/Repositories/Resgrid.Repositories.DataRepository/IdentityUserRepository.cs:line 180
web-1         | ClientConnectionId:4911adf9-a5d6-4abb-97a0-2e07d1bfa7e0
web-1         | Error Number:4060,State:1,Class:11
web-1         | 
web-1         | AssemblyName:Resgrid.Framework, Version=0.7.19.0, Culture=neutral, PublicKeyToken=null
web-1         | CallerFilePath:/src/Repositories/Resgrid.Repositories.DataRepository/IdentityUserRepository.cs
web-1         | CallerMemberName:GetByUserNameAsync
web-1         | CallerLineNumber:193r
web-1         | CorrelationId:
web-1         | System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Resgrid" requested by the login. The login failed.
web-1         | Login failed for user 'sa'.

[ucswift]

Did you pull the latest laptop branch from the resgrid-setup repo? I was working on that yesterday.

[fgadot]

@ucswift I pulled the branch from the git as per the offline laptop documentation as per:

'''git clone https://github.com/Resgrid/resgrid-setup.git -b laptop resgrid'''

Is this the repo you were working on?

[ucswift]

Hey @fgadot yea that's the right repo and branch. I just took a look and 2 sections did not have the correct connection strings for pgsql. Delete what you have and pull fresh and see if that works.

[fgadot]

@ucswift I tried again today, and had another issue. I thought I crashed something, so started from scratch.
The docker run (...) import worked well. But the docker compose crashed.

frank@iMac:~/DEV/docker/resgrid> docker ps
CONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES
frank@iMac:~/DEV/docker/resgrid> docker compose up
Attaching to api-1, caddy-1, db-1, events-1, rabbitmq-1, redis-1, tileserver-1, web-1, worker-1
redis-1  | Starting Redis Server
tileserver-1  | ++ ls -A /data/style/
tileserver-1  | + '[' '!' 'CARTOGRAPHY.md
tileserver-1  | CHANGELOG.md
tileserver-1  | CODE_OF_CONDUCT.md
tileserver-1  | CONTRIBUTING.md
tileserver-1  | DOCKER.md
tileserver-1  | Dockerfile
tileserver-1  | Dockerfile.db
tileserver-1  | Dockerfile.import
tileserver-1  | INSTALL.md
tileserver-1  | LICENSE.txt
tileserver-1  | README.md
tileserver-1  | RELEASES.md
tileserver-1  | USECASES.md
tileserver-1  | docker-compose.yml
tileserver-1  | external-data.yml
tileserver-1  | indexes.sql
tileserver-1  | indexes.yml
tileserver-1  | mapnik.xml
tileserver-1  | openstreetmap-carto.lua
tileserver-1  | openstreetmap-carto.style
tileserver-1  | patterns
tileserver-1  | preview.png
tileserver-1  | project.mml
tileserver-1  | road-colors.yaml
tileserver-1  | scripts
tileserver-1  | style
tileserver-1  | symbols' ']'
tileserver-1  | + '[' '!' -f /data/style/mapnik.xml ']'
tileserver-1  | + '[' run == import ']'
tileserver-1  | + '[' run == run ']'
tileserver-1  | + rm -rf /tmp/httpd_shm.72 /tmp/httpd_shm_delay.72
tileserver-1  | + '[' -f /data/database/PG_VERSION ']'
tileserver-1  | + '[' -f /nodes/flat_nodes.bin ']'
tileserver-1  | + '[' -f /data/tiles/data.poly ']'
tileserver-1  | + '[' -f /data/tiles/planet-import-complete ']'
tileserver-1  | + '[' -f /data/database/planet-import-complete ']'
tileserver-1  | + '[' -f /data/tiles/planet-import-complete ']'
tileserver-1  | + chown -R postgres: /var/lib/postgresql/ /data/database/postgres/
Error response from daemon: failed to create task for container: failed to create shim task: OCI runtime create failed: runc create failed: unable to start container process: error during container init: error mounting "/host_mnt/Users/frank/DEV/docker/resgrid/docker-data/sql" to rootfs at "/var/lib/postgresql/data": change mount propagation through procfd: open o_path procfd: open /var/lib/docker/rootfs/overlayfs/bec59bccc0f0b4276ba8ab343b2a5281987256626d83ec500ca2497d2789677f/var/lib/postgresql/data: no such file or directory: unknown   w Enable Watch

[ucswift]

Hey @fgadot, interesting ok looks like there is a missing folder, path or file. Let me take a look, it's possible I forgot a .gitignore in a folder to keep it in git even if it's empty.

[ucswift]

Hey @fgadot I've pushed a new change to the laptop setup, there were a couple folders that got stripped oout for git when I pushed them up, both the folders were pgsql ones, so that matched the error. I have no had a chance to test it out yet though.