Help wanted

[G-Unit0405]

Shlink version

shlink4.4.0_php8.4_dist

PHP version

php8.4

How do you serve Shlink

Self-hosted nginx

Database engine

PostgreSQL

Database version

15

Summary

Hello! Could you help me please.
I have installed postgres 15, nginx. Then after installing shlink using setting env variables and command php ./vendor/bin/shlink-installer init --initial-api-key --no-interaction --skip-download-geolite, I can create via cli a few short urls. I can see created urls on database. Everything looks good. But, when I enter page with short url, I got an error : Unexpected Error.
If I install shlink using vendor/bin/shlink-installer install and pass parameters manually everything works perfectly.
I can't understand what is problem. Did anyone have problem with installing shlink using env vars?

[acelaya]

I'm guessing the env vas are likely not "available" to Shlink when run through nginx. How and where did you set them?

[G-Unit0405]

I set them

export DEFAULT_DOMAIN="shlink.test.xyz"
export IS_HTTPS_ENABLED="false"
export DB_DRIVER="postgres"
export DB_NAME="pdo_pgsql"
export DB_USER="pdo_pgsql"
export DB_PASSWORD="Qwerty@123"
export DB_HOST="10.68.0.149"
export DB_PORT="5432"
export DB_USE_ENCRYPTION="false"
export REDIRECT_EXTRA_PATH_MODE="default"
export MEMORY_LIMIT="2G"

[acelaya]

But where did you set them

[G-Unit0405]

I have also tried to set them in file /etc/bashrc . Then I rebooted system and tried to install. No effect. As soon as I entered short link I entered an Unxpected error

[G-Unit0405]

But where did you set them.

I just set them in console /bin/bash
In env I can see them .

[acelaya]

/bin/bash is a binary file, so I very much doubt you have set them there 😅

Env vars can be set in many different ways, depending on what tools need to read them and how they should be accessed.

Most straightforward ways make them available for your own user, that's why everything works when running Shlink from the CLI, but nginx runs using a different user which probably doesn't have access to those. Even if it had, it might isolate subprocesses to hide those en vas yo your apps.

[G-Unit0405]

How to set up env vars correctly? :)

[acelaya]

It depends on the operating system, and many other aspects, but that's precisely what you need to Google.

[G-Unit0405]

The most interesting thing as soon as I got error on browser . I go to cli shlink and execute command bin/cli short-url:list I also got en error :

bin/cli short-url:list

In ExceptionConverter.php line 52:

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 no such table: short_urls

In Exception.php line 28:

SQLSTATE[HY000]: General error: 1 no such table: short_urls

In Connection.php line 45:

SQLSTATE[HY000]: General error: 1 no such table: short_urls

Although I can see created short urls on my database.

[G-Unit0405]

Here are created tables

pdo_pgsql=# \dt
List of relations
Schema | Name | Type | Owner
--------+-------------------------------------------------+-------+-----------
public | api_key_roles | table | pdo_pgsql
public | api_keys | table | pdo_pgsql
public | domains | table | pdo_pgsql
public | geolocation_db_updates | table | pdo_pgsql
public | migrations | table | pdo_pgsql
public | orphan_visits_counts | table | pdo_pgsql
public | redirect_conditions | table | pdo_pgsql
public | redirect_conditions_in_short_url_redirect_rules | table | pdo_pgsql
public | short_url_redirect_rules | table | pdo_pgsql
public | short_url_visits_counts | table | pdo_pgsql
public | short_urls | table | pdo_pgsql
public | short_urls_in_tags | table | pdo_pgsql
public | tags | table | pdo_pgsql
public | visit_locations | table | pdo_pgsql
public | visits | table | pdo_pgsql