• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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