Problem with Toec Client export
-
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.