====== Runbook: DSN upravljanje ======

<WRAP round info>
**Trajanje:** ~10 minuta \\
**Uloga:** Gateway-Operator \\
**Preduvjet:** appsettings.json pristup
</WRAP>

DSN (Data Source Name) definira unaprijed definirane veze s bazom podataka.

----

===== Tijek rada =====

<mermaid>
flowchart TD
    A[DSN zahtjev] --> B{Nova ili postojeca?}
    B -->|Nova| C[appsettings.json urediti]
    B -->|Postojeca| D[Vezu testirati]
    C --> E[Gateway ponovno pokrenuti]
    E --> D
    D --> F{Test uspjesan?}
    F -->|Da| G[Dokumentirati]
    F -->|Ne| H[Connection String provjeriti]
    H --> C

    style G fill:#e8f5e9
    style H fill:#ffebee
</mermaid>

----

===== 1. Postojece DSN prikazati =====

<code bash>
# Sve konfigurirane DSN ispisati (API)
curl -s http://localhost:5000/api/v1/dsn | jq

# Ili direktno u Configu provjeriti
cat appsettings.json | jq '.Gateway.Databases'
</code>

----

===== 2. Novu DSN dodati =====

**appsettings.json urediti:**

<code javascript>
{
  "Gateway": {
    "Databases": {
      "demo": {
        "Provider": "sqlite",
        "ConnectionString": "Data Source=data/demo.db"
      },
      "produktion": {
        "Provider": "sqlserver",
        "ConnectionString": "Server=sql01;Database=ProdDB;User Id=app;Password=***;TrustServerCertificate=True"
      },
      "reporting": {
        "Provider": "postgresql",
        "ConnectionString": "Host=pg01;Database=reports;Username=reader;Password=***"
      }
    }
  }
}
</code>

**Podrzani Provideri:**

| Provider | ConnectionString primjer |
|----------|---------------------------|
| ''sqlserver'' | ''Server=host;Database=db;User Id=user;Password=pwd'' |
| ''sqlite'' | ''Data Source=path/file.db'' |
| ''postgresql'' | ''Host=host;Database=db;Username=user;Password=pwd'' |
| ''mysql'' | ''Server=host;Database=db;User=user;Password=pwd'' |

----

===== 3. Gateway ponovno pokrenuti =====

<code bash>
# Windows
Stop-Process -Name "WvdS.WebAPI.Data.Gateway.Api" -Force
Start-Process -FilePath ".\WvdS.WebAPI.Data.Gateway.Api.exe"

# Linux (systemd)
sudo systemctl restart data-gateway
</code>

----

===== 4. DSN testirati =====

<code bash>
# Tablice nove DSN ispisati
curl -s http://localhost:5000/api/v1/dsn/produktion/tables | jq

# Prve podatke dohvatiti
curl -s "http://localhost:5000/api/v1/dsn/produktion/tables/Customers?\$top=5" | jq
</code>

----

===== 5. DSN ukloniti =====

  - DSN unos iz ''appsettings.json'' obrisati
  - Gateway ponovno pokrenuti
  - Provjeriti da DSN vise nije dostupna:

<code bash>
curl -s http://localhost:5000/api/v1/dsn/alte_dsn/tables
# Ocekivani odgovor: 404 Not Found
</code>

----

===== Kontrolna lista =====

| # | Provjera | Da/Ne |
|---|-----------|---|
| 1 | Provider ispravan (sqlserver/sqlite/...) | - |
| 2 | Connection String valjan | - |
| 3 | Lozinka nije vidljiva u logu | - |
| 4 | Gateway ponovno pokrenut | - |
| 5 | API test uspjesan | - |

----

===== Rjesavanje problema =====

| Problem | Uzrok | Rjesenje |
|---------|---------|--------|
| ''Database not found'' | Pogresna baza podataka | Ime baze provjeriti |
| ''Login failed'' | Pogresna lozinka | Credentiale provjeriti |
| ''Connection refused'' | Firewall blokira | Port 1433/5432/3306 otvoriti |
| ''Provider not supported'' | Pogresan Provider-name | sqlserver, sqlite, postgresql, mysql |
| ''JSON parse error'' | Sintaksna greska | JSON validirati (jsonlint.com) |

----

===== Sigurnosne napomene =====

<WRAP round important>
**Lozinke nikad ne logirati u cistom tekstu!**

Koristite varijable okruzenja za Credentiale:
<code javascript>
"ConnectionString": "Server=sql01;Database=ProdDB;User Id=${DB_USER};Password=${DB_PASS}"
</code>
</WRAP>

----

===== Povezani runbookovi =====

  * [[.:server-starten|Server pokrenuti]] - Nakon Config promjene
  * [[.:health-check|Health Check]] - Vezu provjeriti
  * [[..:..:administrator:konfiguration:datenbanken|Konfiguracija baze podataka]] - Detaljna referenca

----

<< [[.:server-starten|<- Server pokrenuti]] | [[.:health-check|-> Health Check]] >>

----
//Wolfgang van der Stille @ EMSR DATA d.o.o. - Data Gateway Professional//

{{tag>operator runbook dsn datenbank konfiguration}}