ssl creating error

Discussion in 'Installation/Configuration' started by aurelius, Apr 26, 2014.

  1. aurelius

    aurelius Member

    After upgrade to 3.0.5.4p1 I still get this message when I try to create a ssl certificate. I was hoping that this issue resolves itself when I upgraded. But that is not true. By the way, the certificate is made, but the fields in ispconfig are empty.

    I get this message:

    This happends on a multiserver Debian Setup. The message comes from the slave server. How can I resolve this problem.

    Thanks, Aurelius


    26.04.2014-11:21 - WARNING - DB::query(UPDATE web_domain SET ssl_request = '-----BEGIN CERTIFICATE REQUEST-----\nMIIDCDCCAfACAQAwgZ0xCzAJBgNVBAYTAk5MMRYwFAYDVQQIEw1Ob29yZC1Ib2xs\nYW5kMRIwEAYDVQQHEwlBbXN0ZXJkYW0xFDASBgNVBAoTC1RhbWJvZXIgSUNUMQow\nCAYDVQQLEwEtMRcwFQYDVQQDEw50YW1ib2VyLWljdC5ubDEnMCUGCSqGSIb3DQEJ\nARYYd2VibWFzdGVyQHRhbWJvZXItaWN0Lm5sMIIBIjANBgkqhkiG9w0BAQEFAAOC\nAQ8AMIIBCgKCAQEAxtG5/3hocch2wXEYPIe3sYztre5ZNE3bpDRi+CzcdxWy0Rrb\nE7Pu3zDym8FJm/xfMqcfKbmCs2g7hjfF7orW+l7k45F9TkdJufmc/Gh21cE3qeQE\nb33TS451phyu2BK5THGDPqGAs7Z+PQrJI15c4mdT0Dn+v/7CzUb0Vbfs+afkFvST\nerVyMZODIyncOGxV7Ysm7IFixgvDmmv7l0j+qnAxHKQ3R/frhNKs1tjwCdvjyKin\njAZl6BxweHgBobSRZrrjOqGSXp2pythqhh3jfnBf9IbjmPsY+RoiqN8EQd6Mzm20\nD7RajqPKE/0EjGdOhxbmgZR6hEQk1cnDAbipNQIDAQABoCUwIwYJKoZIhvcNAQkH\nMRYTFEEgY2hhbGxlbmdlIHBhc3N3b3JkMA0GCSqGSIb3DQEBBQUAA4IBAQBFQ7Sw\nyRT4UFgR0ydVitXVaKXkcF+g4r3OhzjbsOSI83DZVZH7oOI/Lwpgbqx2iPZ+pIU+\nZUvvxdKamOV3dXUPwunhI9gYrZAVrEp4/BY7aG6ZXCp/fC0c+agdv4KCWMT+zZTV\nK/gw4+Lvk62Vbiezlnq
    e912FdT9QVOnWH52LcIp29fN5M8f/ez2ip6mbe0BXaj/4\ngZ2l/sLpEFZAZtUC86xGy67DoS4Fj6mVFiMonEEVcE8vSa/iXjKR6pKBwU1tRxND\nqr4qbXA5F305T179tXs/2RTcvnHy3wUdFSD/Qc5M0Ee7yKOEZzw0mpA/o/+G9T4B\nh+jimKEkRotRaDHl\n-----END CERTIFICATE REQUEST-----\n', ssl_cert = '-----BEGIN CERTIFICATE-----\nMIIDuDCCAqACCQDvaRsR11AbDzANBgkqhkiG9w0BAQUFADCBnTELMAkGA1UEBhMC\nTkwxFjAUBgNVBAgTDU5vb3JkLUhvbGxhbmQxEjAQBgNVBAcTCUFtc3RlcmRhbTEU\nMBIGA1UEChMLVGFtYm9lciBJQ1QxCjAIBgNVBAsTAS0xFzAVBgNVBAMTDnRhbWJv\nZXItaWN0Lm5sMScwJQYJKoZIhvcNAQkBFhh3ZWJtYXN0ZXJAdGFtYm9lci1pY3Qu\nbmwwHhcNMTQwNDI2MTEyMTAyWhcNMjQwNDIzMTEyMTAyWjCBnTELMAkGA1UEBhMC\nTkwxFjAUBgNVBAgTDU5vb3JkLUhvbGxhbmQxEjAQBgNVBAcTCUFtc3RlcmRhbTEU\nMBIGA1UEChMLVGFtYm9lciBJQ1QxCjAIBgNVBAsTAS0xFzAVBgNVBAMTDnRhbWJv\nZXItaWN0Lm5sMScwJQYJKoZIhvcNAQkBFhh3ZWJtYXN0ZXJAdGFtYm9lci1pY3Qu\nbmwwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDG0bn/eGhxyHbBcRg8\nh7exjO2t7lk0TdukNGL4LNx3FbLRGtsTs+7fMPKbwUmb/F8ypx8puYKzaDuGN8Xu\nitb6XuTjkX1OR0m5+Zz8aHbVwTep5ARvfdNLjnWmHK7YErlMcYM+o
    YCztn49Cskj\nXlziZ1PQOf6//sLNRvRVt+z5p+QW9JN6tXIxk4MjKdw4bFXtiybsgWLGC8Oaa/uX\nSP6qcDEcpDdH9+uE0qzW2PAJ2+PIqKeMBmXoHHB4eAGhtJFmuuM6oZJenanK2GqG\nHeN+cF/0huOY+xj5GiKo3wRB3ozObbQPtFqOo8oT/QSMZ06HFuaBlHqERCTVycMB\nuKk1AgMBAAEwDQYJKoZIhvcNAQEFBQADggEBAA775+wjcfp1EgZyuIQ0CA8RyFse\ndA4frnlWfr9BpIWcjjgdoMefjZSsGXjP90lkJX1SKEyLsnoFvfTMpbmoocbeEsnY\nzLSVAp1vZoBsXpZjAQG8wsM0fVIIe5goSV/j0ee8V5Dc2+v92t4QntY2eUP1VK0T\nwq4vnKN1yZSdX1PtmhaTm1L9teasG974H+a/tDhdd+kGMueyFIRsMxZRK/dba+/I\nP4ZCfyO+JPchBZzGRQ/R8V5Kod3WCRVzQXs5W0Fn1zVbfQzPeWpRsg4X31qSRFvW\nIGXONfQZ8tj8dxH82XMx3YzLMQefB47IxYe6C1ZO98EGGekinQz14JZBOlo=\n-----END CERTIFICATE-----\n', ssl_key = '-----BEGIN RSA PRIVATE KEY-----\nMIIEpAIBAAKCAQEAxtG5/3hocch2wXEYPIe3sYztre5ZNE3bpDRi+CzcdxWy0Rrb\nE7Pu3zDym8FJm/xfMqcfKbmCs2g7hjfF7orW+l7k45F9TkdJufmc/Gh21cE3qeQE\nb33TS451phyu2BK5THGDPqGAs7Z+PQrJI15c4mdT0Dn+v/7CzUb0Vbfs+afkFvST\nerVyMZODIyncOGxV7Ysm7IFixgvDmmv7l0j+qnAxHKQ3R/frhNKs1tjwCdvjyKin\njAZl6BxweHgBobSRZrrjOqGSXp2pythqhh3jfnBf9IbjmPsY
    +RoiqN8EQd6Mzm20\nD7RajqPKE/0EjGdOhxbmgZR6hEQk1cnDAbipNQIDAQABAoIBAQCGxmD5hxv2Fdg6\n5XlyfuXNHCV6hFpAFI9RzplQdsi0iScAjN35iz3gWoP7hZlqfjfiVFvRowmwqHXB\nVEl+nOuCKZWrllKFH9ogkc8TY5U67ZHYPtOq6Ha1f0rNYiA8JOUrpr87U6u1J36H\nzqnuqeb5KuYr/0Rrzj0rfm/fM6EW0r9qFcaVFhsbQ65UUyl0i3u1edlQakmcRndk\nNESLJxEGvu7jF+eP/SfgN6HbplhlbxH+Dbb2OymtikaJ+McY+yZOWGk2auBzw6ZN\nXBq0diLG/dg6mk202UXvFARcwIGb8V+4SDGYGY0MtQNaa6eIS5WCT53fHbvo8cCE\nVhHB6LfBAoGBAPlebrb6YKxHeuYbCh3G8TXf0uzWjzoFw2ys3gyuxdFKrnwUyWyc\nnhnKQP3xn9pCSG7vPWdUS6WaeKAd9o9m7qGzohjYQyHzbZaWKURhsnkCWOtuf6Zy\nLJWpXwsVa1J5NDDUWZ1FGrt6iSzzYgVKX5XvCEcSIXrFjPYZmXxO9F0JAoGBAMwb\nLgEKmf1l+6dqYC4kpr67mLmhBI12gxJf6rQT2/9qD1/xbEDy5H9sIl1oZZrkYSdx\nP4Uc994dJNVXo9GHht2EMsgQIKZW51GVaMoxvMYWt07zPt4CA5GK40hAknySQ0iY\nG1a9oMtyjJfxyTY1WLIAnW/VciD0m33aLDUWrCHNAoGAbTE9d5/xHt754LJsXpeT\nXYzRlmVpN/X4GakkXhdVhYyXFLwhaw61aAOZK9lWrsKhZvoZQBq4OR6HvU0Bfs+K\npIG88/YWh1JJZUwBa/D/rl8pwoWTHbYW8b3FYVwSr31lLhB94RC2YOuKD4XPIRPt\nAQE29a/puxGv5L9W5wjHlckCgYAbmxF90pFBVKnU2u5nT02
    +PmFJuh2DhKP1uENm\nV8lJom6x61VY84E0OsvrFlOnv3vkecy9lE1yHT7+G/xsOohjLZ4wsP25gceHoU2r\nC08c+7WPWBcIr/0Lkl1rSFCHyMCQ8QHBmaRF4Bhj9K/iRRTZ/ntMxPHKw0rEmt2f\n0JE3gQKBgQCqrST+FfMRohATjUjPqu3i0VmaQwlkwJmQC4O2btrvyWd5BzxPf2dy\njTqUJ6qGMJD2H975ndGI8fgesMfDBeCmjRXtHanv+CGoo7TQyFriS5tWlCs5qQYW\n1/xz0RqY+y1M7h18xzRkyhjJqONK5ljwiTULQKePjlocMuN17NXmHA==\n-----END RSA PRIVATE KEY-----\n' WHERE domain = '***.**') -> mysqli_query UPDATE command denied to user 'ispcsrv3'@'*****' for column 'ssl_key' in table 'web_domain'
     
  2. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Have you chosen "Reconfigure permissions in master database" during update? If not, try updating again with reconfiguring permissions.
     
  3. aurelius

    aurelius Member

    How do I do that. I have just upgraded to the latest version. Ispconfig_update.sh says 'there are no updates'

    Can I manually reconfigure the permissions?
     
  4. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Just download the latest stable version from the ispconfig.org website.
    Then run the updater with php -q update.php inside the install directory of the extracted archive.
     
  5. aurelius

    aurelius Member

    thanks reconfiguring did the trick.
     

Share This Page