Problem with Toec Client export
-
You must not regenerate certificates or nothing will be able to checkin. They will automatically work with the old ones since they are embedded in the database, just need to reinstall the CA and INT on the server. Correct that you can't change IP. Ideally you should be using a FQDN so you don't need to worry about IPs changing.
-
@theopenem_admin Thank you for your reply.
I have followed the steps but in ClientApi.log I have the following error:
2024-07-01 15:49:21,490 [9] ERROR Toems_Service.Entity.ServiceCertificate Could Not Validate Certificate: CN=24cd4c16-8bab-4e21-9ff7-dda7531a4df7, O=Casa Corp
2024-07-01 15:49:21,490 [9] ERROR Toems_Service.Entity.ServiceCertificate Could not find the required object. -
Did install the certs on the new server?
-
@theopenem_admin Yes, I have exported the certificates from my old server.
And I installed them on the new server which has the same name and ip address. -
I would just export them from the web interface like a typical install.
-
This is what I'm doing at step 9.
-
@chavi and @theopenem_admin Hi,
If I export from the Web UI of the new server.
It generates a bad certificate.
So I imported the certificates from the old server.
Certificate.txt -
Difficult to say, guessing database didn't export or import correctly or dbencryption key is wrong.
-
@theopenem_admin
I recovered the dbencryption key from the old server.
And for the database dump I used the following parameters:
--events --routines --triggers
And I also retrieved the ComServerUniqueId of the old server. -
@chavi and @theopenem_admin I forgot to specify when importing on the new server, I got the error set --binary-mode to 1 and to solve the problem I saved the sql file in utf8.
Maybe that's the problem - any ideas? -
In my case, I haven't used any extra mysql dump or restore parameters, simply the shortest possible commands:
mysqldump -u root -p theopenem > theopenem_dump.sql mysql -u root -p theopenem < theopenem_dump.sqlThe dump created this way is UTF8 by default. And it worked without issues.
-
@chavi Thank you Chavi for your reply.
I successfully installed my config on my new server.
The problem was the mysql export.