• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Resolved Can´t set up Proxy Rule for Docker Containers (Internal Error)

hansitheking

Basic Pleskian
I have installed a OnlyOffice Docker Container. It is up and running, and If I open the mapped port in the firewall I can access the container via the web. Now I like to set up a Proxy Rule fore one of my Domains to have SSL-Support and access via a Domain. I have enabled manual port mapping for the container. Once I try to set up the Proxy the following message appears:

Code:
Internal error ;-P
ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database, query was: INSERT INTO &quot;ProxyRules&quot; (&quot;domainId&quot;, &quot;configurationId&quot;, &quot;path&quot;, &quot;port&quot;) VALUES (?, ?, ?, ?) (Pdo.php:235)<br />
<br><a href='http://kb.plesk.com/plesk-error/search?metaId=b6bc422620304b60865ed2e1c91f6f4d&messageId=95673f8f2fc23c2ddbfce1e97ee1de0f&file=Pdo.php&line=235&type=Zend_Db_Statement_Exception&version=17.5.3&message=SQLSTATE%5BHY%5D%3A+General+error%3A++attempt+to+write+a+readonly+database%2C+query+was%3A+INSERT+INTO++%28%2C+%2C+%2C+%29+VALUES+%28%3F%2C+%3F%2C+%3F%2C+%3F%29' target='_blank'>Search for related Knowledge Base articles</a>

error-msg.png

I am running Plesk 17.5.3 with MU 21 on Ubuntu 16.04.3
 
Please make sure that you have the same permissions here:

# ll /usr/local/psa/var/modules/docker/db.sqlite3
-rw------- 1 psaadm psaadm 6144 Sep 18 11:42 /usr/local/psa/var/modules/docker/db.sqlite3
 
@IgorG Thank you for your advice! It helped me to so solve the Issue. The DB was owned by root therefore I changed it to
Code:
chown psaadm:psaadm /usr/local/psa/var/modules/docker/db.sqlite3

now the Proxy rules can be setup without any error. But the Docker container can´t be accessed (default Plesk Page ist showing up). There are no entries in the Apache error log. Is the proxy a Apache proxy or does nginx have to be up and running for this feature?

UPDATE:
I switched on Nginx and know it is working!
 
Last edited:
Back
Top