You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2019/01/10 12:23:21 UTC
[GitHub] marabesi opened a new issue #3123: Db exception trying to upload
SSL certificate
marabesi opened a new issue #3123: Db exception trying to upload SSL certificate
URL: https://github.com/apache/cloudstack/issues/3123
<!--
Verify first that your issue/request is not already reported on GitHub.
Also test if the latest release and master branch are affected too.
Always add information AFTER of these HTML comments, but no need to delete the comments.
-->
##### ISSUE TYPE
* Bug Report
##### COMPONENT NAME
<!--
Categorize the issue, e.g. API, VR, VPN, UI, etc.
-->
~~~
Accounts > SSL certificates
~~~
##### CLOUDSTACK VERSION
<!--
New line separated list of affected versions, commit ID for issues on master branch.
-->
~~~
4.12.0.0-SNAPSHOT (pulled from docker hub)
~~~
##### CONFIGURATION
<!--
Information about the configuration if relevant, e.g. basic network, advanced networking, etc. N/A otherwise
-->
~~~
N/A
~~~
##### OS / ENVIRONMENT
<!--
N/A
-->
##### SUMMARY
I am developing a feature that integrates with the SSL certificate endpoint, but I couldn't make ir work by the UI interface nor by the API end point.
#2558 might be a related issue.
The following bug occurs in the latest version pulled from docker (4.12.0.0-SNAPSHOT) and 4.9.*.
##### STEPS TO REPRODUCE
Via UI:
~~~
1) Login with admin user
2) Go to the accounts menu
3) Select the tab "SSL Certificates"
4) Click in "Add Certificate"
5) Fill in the field "Name"
6) Fill in the field "Certificate"
7) Fill in the field "Private Key"
~~~
Via PHP code (pseudo code using https://github.com/PCextreme/cloudstack-php):
```php
// Not that I am sending the certificate and the
// private key content instead of the absolute path to the file
$client->uploadSslCert( [
'certificate' => file_get_contents('my.cert')),
'privatekey' => file_get_contents('cstest.key'),
'password' => 'test',
]);
````
<!-- You can also paste gist.github.com links for larger files -->
##### EXPECTED RESULTS
<!-- What did you expect to happen when running the steps above? -->
~~~
A certificate should be stored and listed in the table
~~~
##### ACTUAL RESULTS
<!-- What actually happened? -->
<!-- Paste verbatim command output between quotes below -->
~~~
A SQL exception is thrown trying to upload a SSL certificate.
````
DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@7a02a22a: INSERT INTO sslcerts (sslcerts.id, sslcerts.uuid, sslcerts.certificate, sslcerts.chain, sslcerts.key, sslcerts.password, sslcerts.account_id, sslcerts.domain_id, sslcerts.fingerprint) VALUES (null, _binary'eb111f4e-56df-4190-8702-c70e6d899d8c', _binary'-----BEGIN CERTIFICATE-----\nMIIDsTCCApmgAwIBAgIJANQsgM2iQR1JMA0GCSqGSIb3DQEBCwUAMG8xCzAJBgNV\nBAYTAkVTMQ8wDQYDVQQIDAZNYWRyaWQxDzANBgNVBAcMBk1hZHJpZDEcMBoGA1UE\nCgwTRGVmYXVsdCBDb21wYW55IEx0ZDEgMB4GA1UEAwwXbWFyYWJlc2kuam90ZWx1\nbHUuc3BhY2UwHhcNMTgxMjE4MDkwNDE1WhcNMTkxMjE4MDkwNDE1WjBvMQswCQYD\nVQQGEwJFUzEPMA0GA1UECAwGTWFkcmlkMQ8wDQYDVQQHDAZNYWRyaWQxHDAaBgNV\nBAoME0RlZmF1bHQgQ29tcGFueSBMdGQxIDAeBgNVBAMMF21hcmFiZXNpLmpvdGVs\ndWx1LnNwYWNlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4YpX1i+5\nv6vPHUQa3YN63hn+LxONyGjdx1XllC+rpPZM4C7/A3ywsU5QmyPBkTCYIqpeP8vT\nZL/lcv6+RV0PqXnUUzrZpSGOBL0boLPcyYgJErANMQJ8fO4dru9WsUXW12QjKXP7\notbxgrJqSDw1fUYIUTXMuckncAVPwTv82cSnLWO5HI3P02XkEHsZeDeVaF/0F4xA\nJZNjf+gOyBJxYYd3pRx82qUtcPz8tkRFkAgxzuM/JIz+ZMKkiJb4wJASteo43hbh\nL4pcszLiOqDFaLNJYOpLeG/R9xHWNORc212bYvxjaeNXeaRs1WW1MMxG4LVqv9us\nVuyAogwz/9S8BQIDAQABo1AwTjAdBgNVHQ4EFgQUbZPozHgoQRDqQExbMRKFqv6G\nSBcwHwYDVR0jBBgwFoAUbZPozHgoQRDqQExbMRKFqv6GSBcwDAYDVR0TBAUwAwEB\n/zANBgkqhkiG9w0BAQsFAAOCAQEAPNJPPRfnBNJih9rtI3p/fI0fQ60AcDMQLAwA\nRT+cAfpO2xO93aM1rhkBJ6+touTU6c0pYfr9sy10g6t6it8sRral+aYYuXlzbykV\nkFwyHAVetJUZnPc0Dljs4nQFyoe38FjGVNcY/+5A34DWmlg2YXurr05XXetpvkZ2\n4ElfPAtRA4DseLgjLhNWvn/4Q54PLKrFtFZU+u2+y8/u/Xk3jUVPzzXTs0HXta3U\nl1iTbK/JPvUN/C41MMmwGEV5G0TD7ulEbtoNysqdpRuOx3GCCbeyRqIbZXjWZ0Et\nSuEVuCt+0CkwMPCwnsr/SYXAJm/gd5RoS0DdyiRsh4dG6SvlUQ==\n-----END CERTIFICATE-----', null, _binary'ZrAwtQ+eJ6s1So2Wuwl0Yde9nBXsePuFKHNuXxp2w9H1yY2uFKQpmXdK9Donre76kUshK+294sEEo6oOzlwI0Eo7q9dKYN3p3nJNL0CnaGV8iH72YKdMxRlH0uLWdnc4gKdpO1bN67zv4w2srmO9RC7t7PScDiTj4ph0O2TBSAX9eGmY6m9HApNUcuGBrcZjNKRnp+UuOvqyUeBbyp4D+E5Anq6Aqw3nA/PuMQhBHotP+HZQO00KqwzvyqGwf9zbR7+Ci+xncXTipTo30Mnyu+FUUiMbObe5mONWO/t58qq7SJhTNTljsVhC/qGxHub0uua4URto7SiclXtoKW7yKpHKGrXqQINVTU0goBCa/KtdCWK6CG1ctOO249Z52mWi4C6CX23q7837+prIoMX5xLawuk2vIElZzYxDCiWaxFab8OfFh+Ir6J2UBW9A4YcdTw9PEUIbK01A1hKXXMeNvpToEnLuc6XW+Cw/3XTTVS4uESVgBFNgAoil5erqF/bayQ2UnLHxyIa/at072iqv764Y3Vsn6qKMrSi9Z8VFg20P3GhLWuG3/NKqDehOKw97WD1y6EGwy047hpguRV5orCaM1cNMtZZPOBu592F2H9v9LfJrchuLoiTuVUcfkkpreuJYErwcQtXLnjIRiUTRdIvgDsd/u8MnhEORItUR7TEvZemzbRxNRtR22ybYQt7vMW6bcK+j9jKYEqM85xak+oEtx1fIa6gxSR6MDgflIGFZEilaz3Ey0srpPfmkxGNkGT8CmM6ymEsKOs7/Yo4apG/uxIE9A8dFdOT1f6aP9fb4QRlyNqOc9plWjTWDkVW7MlcRbsCGPzvs9Al36ZFQg5W2TkEXfLYPLvZhCMo/lStnwe2ArgqeYtNXEFgzSR+IRjJlA1u1WtS7CU3azbcQD0Flq5Cak4WvUkEktaQzKPY+EbdIoAGfCDAukeDWgD/vbzsPTfygbVLAFCJfSOca2DELWcYALPbJtKEydDcCXaIZ4c1YzULTW8OiiCfFtdnU9A5wwXlYpKUXNvYK/mCRIGb9Vatnedm6yl9f5UkAXPtMDCS9LcPqeBofJ5AEAsQsvpreRd2YNRGw8mXtdBhGNuoVgu5sbtfvrQW/U9gXhZNIrltVfRcwdu2/YMY547mc7w3oZjvwDGXxCynuyg52pPebn9qHABN6iQo+6gTYVyOHF3MXmCMeMnHfaxYS6NZFR4er9yrAid6jNDTpVxVCs9Osxic/atWDG7lavOI+eCXe/DflLmrWGQM/12VSKanren/yD6CqwsYVE2kGzXE9sDbXdLtZH+dfghI1Bv/rZODcj7zfBj4TjHJQO2N6B2i4D2VLoK3xvMOBE3cMeFHxT64W3Hi7+sBdO7ohXIZmD8kGH6Kdct06yVf53gIIE9FaprnzYEKqdz7SM05xVFkbOjOX8cr4zz32WwRAvIp6k/jrnX7JwdwNO/gz6HijSOjRf0oADF8oX9/0ulVPKsm3D8XZxrVabT6YUiHfgKcwuof3Oet0yk3++qMwvZb3dsSh2bfPiZ/pgpqxXCMal9J8o/VABwr4ZPkvkvwbVAJKMkWFpAwc83YYINmrA+WFSkzex5XYYVMFAcn6C3FQ7Hno2z28QtTAkwQhpZdiE+qyZ3ArZRAGtPOjVawYKYNlP9/sFNk42/c65CXYHpEOeJXLQiwxVD9l7S6qz/6hPAuL3CPyWbYm8bKOdKdUg77JAuX5A1rzBpK4HNz4TgdTBEjhHQqJJec/yJHV/i6EeYOhNqSgK62XaTzGgmfnAj9xPuqTleoFJVEE30QH+7zj92iLXQGiMZzmX/1qZPbkBs3nIPXhE5/yEFItoDvHd0fEII6gyOlob3fqT7FYvXSYcvsWny+jXjctTJJvoesoeUHX+SI0KBOfFCfBogiZTcgZafTkPAAKcrpEK54yj0Fc4IuXJmLAGVFQY8iCzpa9E3fKyE0KTljD2ZyqInUmZ/+oHZmozxaGT479XhRk/qUWLRQdRF/jTdG8QvJ/xiwASIe9mza9jyj9NLH03qHrCxWUeplBtoF5gf74lYqaQJT23814RflSlgskLe6aYM+cXdNpqkeLFXMb2ensnm++RWatd0+q+IpaIgl+4Uzpa7MV84Ujm/9uQlK4Uq5qQG7ZX18kPhw+GsgIqm021nnu4S8JE1wXNnwaEJ/RAevVkqyymvcUlXFMtXxpeI56x9j6h3pfPDMH8F+GYUOJnk+NJdQWUyOXW9RA15M6iTHC0jysZW1fKgqqg/bm0jKKFN91UlKuU45hJquOvYZy0w==', null, 1056, 1050, _binary'56:D6:2E:0F:BC:F7:93:B7:BA:4F:29:6D:5C:23:43:D8:34:C8:69:6B:9D:62:63:2C:59:D1:3B:6F:43:46:FA:6A')
````
~~~
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services