Unraid mariadb 2nd instance issue

[Dunejeeper]

I'm trying to use a chevereto docker in the apps from unRaid. I don't really know what I'm doing of course because I generally follow step-by steps. I don't work with computers much, but I know my problem is likely related to a second mysql database creation. I will post some pics and if you could help me make corrections I will try it out and also many thanks!
I tried out the same method of creating a database as the Spaceinvaderone video on creating one with nextcloud swapping out a few things.


I created a username and pass, database I named chevereto, granted privs on chevereto.* to my user and pass.
Log says

Log error as follows



Setup page for docker pull as follows



Any help is much appreciated!!

 

[Rodolfo]

When you use Docker it is a common thing to name the DB hostname, in this case "db". What the PHP error line is saying is that the hostname can't be found, chances are that you forgot to edit app/settings.php with the database hostname. If the database hostname is correct, then the problem is that the "db" hostname isn't visible for the container running PHP.

 

[Dunejeeper]

ok. One last question I hope. I can't find app/settings.php. Should I be looking in the file sytem? When I open a command line and type in app/settings.php it says permission denied



Thanks again

 

[Rodolfo]

app/settings.php is created by the system on installation. https://v3-docs.chevereto.com/setup/settings-file.html

That file must exists somewhere at runtime, perhaps you are looking in the wrong place.

 

[Dunejeeper]

Turns out my answer was to replace "db" with my server IP. I'm in.

 

[Dunejeeper]

[
    {
        "Id": "de260be5048379c4402e0799965228818608227ed6cdd04bc4a21991905578d2",
        "Created": "2020-09-12T20:26:38.013156697Z",
        "Path": "docker-php-entrypoint",
        "Args": [
            "apache2-foreground"
        ],
        "State": {
            "Status": "running",
            "Running": true,
            "Paused": false,
            "Restarting": false,
            "OOMKilled": false,
            "Dead": false,
            "Pid": 24929,
            "ExitCode": 0,
            "Error": "",
            "StartedAt": "2020-09-12T20:59:08.674728926Z",
            "FinishedAt": "2020-09-12T20:59:07.326388606Z"
        },
        "Image": "sha256:ca10c78920b2d9dce5384438aa02f63743cb085c44175609483dd492bd860c59",
        "ResolvConfPath": "/var/lib/docker/containers/de260be5048379c4402e0799965228818608227ed6cdd04bc4a21991905578d2/resolv.conf",
        "HostnamePath": "/var/lib/docker/containers/de260be5048379c4402e0799965228818608227ed6cdd04bc4a21991905578d2/hostname",
        "HostsPath": "/var/lib/docker/containers/de260be5048379c4402e0799965228818608227ed6cdd04bc4a21991905578d2/hosts",
        "LogPath": "/var/lib/docker/containers/de260be5048379c4402e0799965228818608227ed6cdd04bc4a21991905578d2/de260be5048379c4402e0799965228818608227ed6cdd04bc4a21991905578d2-json.log",
        "Name": "/chevereto",
        "RestartCount": 0,
        "Driver": "btrfs",
        "Platform": "linux",
        "MountLabel": "",
        "ProcessLabel": "",
        "AppArmorProfile": "",
        "ExecIDs": null,
        "HostConfig": {
            "Binds": null,
            "ContainerIDFile": "",
            "LogConfig": {
                "Type": "json-file",
                "Config": {
                    "max-file": "1",
                    "max-size": "50m"
                }
            },
            "NetworkMode": "bridge",
            "PortBindings": {
                "80/tcp": [
                    {
                        "HostIp": "",
                        "HostPort": "8011"
                    }
                ]
            },
            "RestartPolicy": {
                "Name": "no",
                "MaximumRetryCount": 0
            },
            "AutoRemove": false,
            "VolumeDriver": "",
            "VolumesFrom": null,
            "CapAdd": null,
            "CapDrop": null,
            "Capabilities": null,
            "Dns": [],
            "DnsOptions": [],
            "DnsSearch": [],
            "ExtraHosts": null,
            "GroupAdd": null,
            "IpcMode": "private",
            "Cgroup": "",
            "Links": null,
            "OomScoreAdj": 0,
            "PidMode": "",
            "Privileged": false,
            "PublishAllPorts": false,
            "ReadonlyRootfs": false,
            "SecurityOpt": null,
            "UTSMode": "",
            "UsernsMode": "",
            "ShmSize": 67108864,
            "Runtime": "runc",
            "ConsoleSize": [
                0,
                0
            ],
            "Isolation": "",
            "CpuShares": 0,
            "Memory": 0,
            "NanoCpus": 0,
            "CgroupParent": "",
            "BlkioWeight": 0,
            "BlkioWeightDevice": [],
            "BlkioDeviceReadBps": null,
            "BlkioDeviceWriteBps": null,
            "BlkioDeviceReadIOps": null,
            "BlkioDeviceWriteIOps": null,
            "CpuPeriod": 0,
            "CpuQuota": 0,
            "CpuRealtimePeriod": 0,
            "CpuRealtimeRuntime": 0,
            "CpusetCpus": "",
            "CpusetMems": "",
            "Devices": [],
            "DeviceCgroupRules": null,
            "DeviceRequests": null,
            "KernelMemory": 0,
            "KernelMemoryTCP": 0,
            "MemoryReservation": 0,
            "MemorySwap": 0,
            "MemorySwappiness": null,
            "OomKillDisable": false,
            "PidsLimit": null,
            "Ulimits": null,
            "CpuCount": 0,
            "CpuPercent": 0,
            "IOMaximumIOps": 0,
            "IOMaximumBandwidth": 0,
            "MaskedPaths": [
                "/proc/asound",
                "/proc/acpi",
                "/proc/kcore",
                "/proc/keys",
                "/proc/latency_stats",
                "/proc/timer_list",
                "/proc/timer_stats",
                "/proc/sched_debug",
                "/proc/scsi",
                "/sys/firmware"
            ],
            "ReadonlyPaths": [
                "/proc/bus",
                "/proc/fs",
                "/proc/irq",
                "/proc/sys",
                "/proc/sysrq-trigger"
            ]
        },
        "GraphDriver": {
            "Data": null,
            "Name": "btrfs"
        },
        "Mounts": [
            {
                "Type": "volume",
                "Name": "c9f13c24915ba89e5ee9f19928425478e071b39145ac0043f5e959727a295e50",
                "Source": "/var/lib/docker/volumes/c9f13c24915ba89e5ee9f19928425478e071b39145ac0043f5e959727a295e50/_data",
                "Destination": "/var/www/html/images",
                "Driver": "local",
                "Mode": "",
                "RW": true,
                "Propagation": ""
            }
        ],
        "Config": {
            "Hostname": "de260be50483",
            "Domainname": "",
            "User": "",
            "AttachStdin": false,
            "AttachStdout": false,
            "AttachStderr": false,
            "ExposedPorts": {
                "80/tcp": {}
            },
            "Tty": false,
            "OpenStdin": false,
            "StdinOnce": false,
            "Env": [
                "HOST_OS=Unraid",
                "CHEVERETO_DB_HOST=192.168.86.23",
                "CHEVERETO_DB_USERNAME=XXXXXXXX",
                "CHEVERETO_DB_PASSWORD=XXXXXXXXX",
                "CHEVERETO_DB_NAME=chevereto",
                "CHEVERETO_DB_PREFIX=chv_",
                "CHEVERETO_DEFAULT_TIMEZONE=",
                "TZ=America/Chicago",
                "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
                "PHPIZE_DEPS=autoconf \t\tdpkg-dev \t\tfile \t\tg++ \t\tgcc \t\tlibc-dev \t\tmake \t\tpkg-config \t\tre2c",
                "PHP_INI_DIR=/usr/local/etc/php",
                "APACHE_CONFDIR=/etc/apache2",
                "APACHE_ENVVARS=/etc/apache2/envvars",
                "PHP_EXTRA_BUILD_DEPS=apache2-dev",
                "PHP_EXTRA_CONFIGURE_ARGS=--with-apxs2 --disable-cgi",
                "PHP_CFLAGS=-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64",
                "PHP_CPPFLAGS=-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64",
                "PHP_LDFLAGS=-Wl,-O1 -pie",
                "GPG_KEYS=CBAF69F173A0FEA4B537F470D66C9593118BCCB6 F38252826ACD957EF380D39F2F7956BC5DA04B5D",
                "PHP_VERSION=7.3.22",
                "PHP_URL=https://www.php.net/distributions/php-7.3.22.tar.xz",
                "PHP_ASC_URL=https://www.php.net/distributions/php-7.3.22.tar.xz.asc",
                "PHP_SHA256=0e66606d3bdab5c2ae3f778136bfe8788e574913a3d8138695e54d98562f1fb5",
                "PHP_MD5=",
                "CHEVERETO_DB_PORT=3306"
            ],
            "Cmd": [
                "apache2-foreground"
            ],
            "Image": "nmtan/chevereto",
            "Volumes": {
                "/var/www/html/images": {}
            },
            "WorkingDir": "/var/www/html",
            "Entrypoint": [
                "docker-php-entrypoint"
            ],
            "OnBuild": null,
            "Labels": {
                "build_signature": "Chevereto free version master; built on 2020-09-11T13:58:29Z; Using PHP version 7.3.22",
                "maintainer": "Tan Nguyen <tan.mng90@gmail.com>",
                "org.label-schema.license": "Apache-2.0",
                "org.label-schema.name": "Chevereto Free",
                "org.label-schema.url": "https://github.com/tanmng/docker-chevereto",
                "org.label-schema.vcs-url": "https://github.com/tanmng/docker-chevereto",
                "org.label-schema.version": "master"
            },
            "StopSignal": "SIGWINCH"
        },
        "NetworkSettings": {
            "Bridge": "",
            "SandboxID": "0599fbee1591f8c788ef65988229ecd66273f727fa0042b529bb65bd210c44c0",
            "HairpinMode": false,
            "LinkLocalIPv6Address": "",
            "LinkLocalIPv6PrefixLen": 0,
            "Ports": {
                "80/tcp": [
                    {
                        "HostIp": "0.0.0.0",
                        "HostPort": "8011"
                    }
                ]
            },
            "SandboxKey": "/var/run/docker/netns/0599fbee1591",
            "SecondaryIPAddresses": null,
            "SecondaryIPv6Addresses": null,
            "EndpointID": "9de8ccb5e0f1b3b5813977e9f8fc2577bf17cde4a90fb9f4721652e6b10e72a7",
            "Gateway": "172.17.0.1",
            "GlobalIPv6Address": "",
            "GlobalIPv6PrefixLen": 0,
            "IPAddress": "172.17.0.6",
            "IPPrefixLen": 16,
            "IPv6Gateway": "",
            "MacAddress": "02:42:ac:11:00:06",
            "Networks": {
                "bridge": {
                    "IPAMConfig": null,
                    "Links": null,
                    "Aliases": null,
                    "NetworkID": "db14ceb4291dc59055cdd8b872b8666b6cea224779fab124da3660293fa8c949",
                    "EndpointID": "9de8ccb5e0f1b3b5813977e9f8fc2577bf17cde4a90fb9f4721652e6b10e72a7",
                    "Gateway": "172.17.0.1",
                    "IPAddress": "172.17.0.6",
                    "IPPrefixLen": 16,
                    "IPv6Gateway": "",
                    "GlobalIPv6Address": "",
                    "GlobalIPv6PrefixLen": 0,
                    "MacAddress": "02:42:ac:11:00:06",
                    "DriverOpts": null
                }
            }
        }
    }
]

 

[Dunejeeper]

Is any of the above post helpful in finding the location of the php or a path to create a new one?

Thanks again!

 

[Dunejeeper]

I got it. It was getting the paths correct before installing it in unRaid. Can you take a look at my nginx config? I can get it to work fine remotely with http but not https. Thanks

# ------------------------------------------------------------
# jbpic.duckdns.org
# ------------------------------------------------------------


server {
  set $forward_scheme https;
  set $server         "192.168.86.23";
  set $port           8011;

  listen 8080;
listen [::]:8080;

listen 4443 ssl http2;
listen [::]:4443;


  server_name jbpic.duckdns.org;


  # Let's Encrypt SSL
  include conf.d/include/letsencrypt-acme-challenge.conf;
  include conf.d/include/ssl-ciphers.conf;
  ssl_certificate /etc/letsencrypt/live/npm-3/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/npm-3/privkey.pem;






  # Block Exploits
  include conf.d/include/block-exploits.conf;






  access_log /config/log/proxy_host-3.log proxy;







  location / {

    


    # Force SSL
    include conf.d/include/force-ssl.conf;







    

    # Proxy!
add_header       X-Served-By $host;
proxy_set_header Host $host;
proxy_set_header X-Forwarded-Scheme $scheme;
proxy_set_header X-Forwarded-Proto  $scheme;
proxy_set_header X-Forwarded-For    $remote_addr;
proxy_pass       https://$server:$port;
  }


  # Custom
  include /data/nginx/custom/server_proxy[.]conf;
}