thecry/i-mscp-keyhelp-migration

Import i-MSCP to Keyhelp

i-mscp-keyhelp-migration's Issues

I got index out of range when I ready to transfer to keyhelp

Hello,
When I transfer from imscp to keyhelp.
I got error message.

Found domain: horizoninn.com.tw
Get i-MSCP domain dns data
Traceback (most recent call last):
File "/root/i-mscp-keyhelp-migration/./i-mscp_keyhelp_migration.py", line 194, in
while not imscpInputData.getImscpUserWebData(input("Enter the i-MSCP user name (first domain): "), client):
File "/root/i-mscp-keyhelp-migration/_imscp.py", line 165, in getImscpUserWebData
self.__getImscpDomainDns(self.imscpData['iUsernameDomainId'], self.imscpData['iUsernameDomainIdna'],
File "/root/i-mscp-keyhelp-migration/_imscp.py", line 614, in __getImscpDomainDns
self.imscpDnsEntries[index]['iDomainDnsEntryTTL'] = DomainDnsEntriesData[1].rstrip()
IndexError: list index out of range

What's this problem?

00_private

das erstellen des Verzeichnis 00_private geschiet nicht und wird auch nicht gesynct

Could migration to keyhelp not change database name and db username?

Hello,
I found it's migration to keyhelp will auto create database and create db username.But it's will auto change it's name.
origin db name is keo_db.The auto create database is db2_keo_db.
Could use origin database name to create it?

Run script will get error

Hello
I use i-mscp-keyhelp-migration on keyhelp 24 version.
It's will get error message.

`Unknown exception: q must be exactly 160, 224, or 256 bits long
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/paramiko/transport.py", line 2109, in run
handler(self.auth_handler, m)
File "/usr/lib/python3/dist-packages/paramiko/auth_handler.py", line 298, in _parse_service_accept
sig = self.private_key.sign_ssh_data(blob)
File "/usr/lib/python3/dist-packages/paramiko/dsskey.py", line 108, in sign_ssh_data
key = dsa.DSAPrivateNumbers(
File "/usr/lib/python3/dist-packages/cryptography/hazmat/primitives/asymmetric/dsa.py", line 250, in private_key
return backend.load_dsa_private_numbers(self)
File "/usr/lib/python3/dist-packages/cryptography/hazmat/backends/openssl/backend.py", line 853, in load_dsa_private_numbers
dsa._check_dsa_private_numbers(numbers)
File "/usr/lib/python3/dist-packages/cryptography/hazmat/primitives/asymmetric/dsa.py", line 147, in _check_dsa_private_numbers
_check_dsa_parameters(parameters)
File "/usr/lib/python3/dist-packages/cryptography/hazmat/primitives/asymmetric/dsa.py", line 139, in _check_dsa_parameters
raise ValueError("q must be exactly 160, 224, or 256 bits long")
ValueError: q must be exactly 160, 224, or 256 bits long

Traceback (most recent call last):
File "/root/i-mscp-keyhelp-migration/./i-mscp_keyhelp_migration.py", line 193, in
imscpInputData.getImscpMySqlCredentials(client)
File "/root/i-mscp-keyhelp-migration/_imscp.py", line 57, in getImscpMySqlCredentials
client.connect(imscpServerFqdn, port=imscpSshPort, username=imscpSshUsername,
File "/usr/lib/python3/dist-packages/paramiko/client.py", line 435, in connect
self._auth(
File "/usr/lib/python3/dist-packages/paramiko/client.py", line 680, in _auth
self._transport.auth_publickey(username, key)
File "/usr/lib/python3/dist-packages/paramiko/transport.py", line 1580, in auth_publickey
return self.auth_handler.wait_for_response(my_event)
File "/usr/lib/python3/dist-packages/paramiko/auth_handler.py", line 236, in wait_for_response
raise e
File "/usr/lib/python3/dist-packages/paramiko/transport.py", line 2109, in run
handler(self.auth_handler, m)
File "/usr/lib/python3/dist-packages/paramiko/auth_handler.py", line 298, in _parse_service_accept
sig = self.private_key.sign_ssh_data(blob)
File "/usr/lib/python3/dist-packages/paramiko/dsskey.py", line 108, in sign_ssh_data
key = dsa.DSAPrivateNumbers(
File "/usr/lib/python3/dist-packages/cryptography/hazmat/primitives/asymmetric/dsa.py", line 250, in private_key
return backend.load_dsa_private_numbers(self)
File "/usr/lib/python3/dist-packages/cryptography/hazmat/backends/openssl/backend.py", line 853, in load_dsa_private_numbers
dsa._check_dsa_private_numbers(numbers)
File "/usr/lib/python3/dist-packages/cryptography/hazmat/primitives/asymmetric/dsa.py", line 147, in _check_dsa_private_numbers
_check_dsa_parameters(parameters)
File "/usr/lib/python3/dist-packages/cryptography/hazmat/primitives/asymmetric/dsa.py", line 139, in _check_dsa_parameters
raise ValueError("q must be exactly 160, 224, or 256 bits long")
ValueError: q must be exactly 160, 224, or 256 bits long`

Could fix it?

Contacts with polish characters

Hello,

If there are any contacts with name or vcard in roundcube database with one of polish national characters "ó", the roundcube contacts checking procedure ends with:

Traceback (most recent call last):
  File "/root/i-mscp-keyhelp-migration/./i-mscp_keyhelp_migration.py", line 194, in <module>
    while not imscpInputData.getImscpUserWebData(input("Enter the i-MSCP user name (first domain): "), client):
  File "/root/i-mscp-keyhelp-migration/_imscp.py", line 174, in getImscpUserWebData
    self.__getImscpDomainEmailaddresses(self.imscpData['iUsernameDomainId'],
  File "/root/i-mscp-keyhelp-migration/_imscp.py", line 998, in __getImscpDomainEmailaddresses
    self.__getImscpRoundcubeUsers(client, self.imscpDomainEmailAddressNormal[index]['iEmailAddress'])
  File "/root/i-mscp-keyhelp-migration/_imscp.py", line 1474, in __getImscpRoundcubeUsers
    self.__getImscpRoundcubeContacts(self.imscpRoundcubeUsers[index]['rUserId'], client)
  File "/root/i-mscp-keyhelp-migration/_imscp.py", line 1577, in __getImscpRoundcubeContacts
    for line in stdout:
  File "/usr/lib/python3/dist-packages/paramiko/file.py", line 125, in __next__
    line = self.readline()
  File "/usr/lib/python3/dist-packages/paramiko/file.py", line 334, in readline
    return line if self._flags & self.FLAG_BINARY else u(line)
  File "/usr/lib/python3/dist-packages/paramiko/py3compat.py", line 161, in u
    return s.decode(encoding)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf3 in position 120: invalid continuation byte

If I remove those manually, it works correctly.

Edit: The same is happening if there is any "ó" letter in any identity or user-related data in roundcube db.

Even if I fix "ó" it becomes an error with other polish symbols later, when inserting identity or contacts to database.

btw. Great job anyway. Except this one it is working perfectly!

migration failed.

I has setup configure done.But I got error message when I run.

`root@panel:~/i-mscp-keyhelp-migration# ./i-mscp_keyhelp_migration.py
Starting migration i-MSCP to KeyHelp

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 594, in urlopen
chunked=chunked)
File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 350, in _make_request
self._validate_conn(conn)
File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 837, in validate_conn
conn.connect()
File "/usr/lib/python3/dist-packages/urllib3/connection.py", line 337, in connect
ssl_context=context)
File "/usr/lib/python3/dist-packages/urllib3/util/ssl.py", line 327, in ssl_wrap_socket
return context.wrap_socket(sock, server_hostname=server_hostname)
File "/usr/lib/python3.5/ssl.py", line 385, in wrap_socket
_context=self)
File "/usr/lib/python3.5/ssl.py", line 760, in init
self.do_handshake()
File "/usr/lib/python3.5/ssl.py", line 996, in do_handshake
self._sslobj.do_handshake()
File "/usr/lib/python3.5/ssl.py", line 641, in do_handshake
self._sslobj.do_handshake()
ssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:720)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/requests/adapters.py", line 423, in send
timeout=timeout
File "/usr/lib/python3/dist-packages/urllib3/connectionpool.py", line 624, in urlopen
raise SSLError(e)
requests.packages.urllib3.exceptions.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:720)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "./i-mscp_keyhelp_migration.py", line 103, in
verify=apiServerFqdnVerify)
File "/usr/lib/python3/dist-packages/requests/api.py", line 70, in get
return request('get', url, params=params, **kwargs)
File "/usr/lib/python3/dist-packages/requests/api.py", line 56, in request
return session.request(method=method, url=url, **kwargs)
File "/usr/lib/python3/dist-packages/requests/sessions.py", line 488, in request
resp = self.send(prep, **send_kwargs)
File "/usr/lib/python3/dist-packages/requests/sessions.py", line 609, in send
r = adapter.send(request, **kwargs)
File "/usr/lib/python3/dist-packages/requests/adapters.py", line 497, in send
raise SSLError(e, request=request)
requests.exceptions.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:720)`