Codoforum related discussions
Importing from Kunena 3 error

Hello,
Upon initiating an import session from a remote Kunena 3 server got this error multiple times:

Importing categories and users...
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'hidden_ID_ivac'@'hidden_IP' (using password: YES) in /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php:47 Stack trace: #0 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php(47): PDO->__construct('mysql:host=mysq...', 'hidden_ID_ivac', 'hidden_password', Array) #1 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/MySqlConnector.php(20): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=mysq...', Array, Array) #2 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(59): Illuminate\Database\Connectors\MySqlConnector->connect(Array) #3 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(47): Illuminate\Database\Connectors\ConnectionFactory->createSingleConnect in /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php on line 47

Did i specify wrong connect data, or does remote server not allow connections?

Ir is is something wrong with the import function?

Thanks a lot.

Hello, Upon initiating an import session from a remote Kunena 3 server got this error multiple times: ```` Importing categories and users... Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user 'hidden_ID_ivac'@'hidden_IP' (using password: YES) in /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php:47 Stack trace: #0 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php(47): PDO->__construct('mysql:host=mysq...', 'hidden_ID_ivac', 'hidden_password', Array) #1 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/MySqlConnector.php(20): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=mysq...', Array, Array) #2 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(59): Illuminate\Database\Connectors\MySqlConnector->connect(Array) #3 /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/ConnectionFactory.php(47): Illuminate\Database\Connectors\ConnectionFactory->createSingleConnect in /home/hidden_ID/public_html/sys/vendor/illuminate/database/Illuminate/Database/Connectors/Connector.php on line 47 ```` Did i specify wrong connect data, or does remote server not allow connections? Ir is is something wrong with the import function? Thanks a lot.

The mysql user credentials you provided for import does not have access to the codoforum database.

The user should have read access to kunena database and write(create/update/delete) access to codoforum database

The mysql user credentials you provided for import does not have access to the codoforum database. The user should have read access to kunena database and write(create/update/delete) access to codoforum database
Necessity is the mother of all inventions!

Probably i have understood incorrectly which database credentials should be specified at the import wizard, those of local codoforum database, or those of remote database on a remote server to import data from?
5a5520cede5b4

Or probably i understood incorrectly the very essence of the import procedure. Can i import data from a remote database on a remote sever, or should it be a local database?

Probably i have understood incorrectly which database credentials should be specified at the import wizard, those of local codoforum database, or those of remote database on a remote server to import data from? ![5a5520cede5b4](serve/attachment&path=5a5520cede5b4) Or probably i understood incorrectly the very essence of the import procedure. Can i import data from a remote database on a remote sever, or should it be a local database?

Hi,

You can import it from a remote server but it depends on configurations.

You need to specify database credentials of kunena not codoforum here.

Hi, You can import it from a remote server but it depends on configurations. You need to specify database credentials of kunena not codoforum here.
Necessity is the mother of all inventions!

Hi, and thanks for reply.

I have solved database connection issue, indeed there was a problem connecting to remote database.

I have successfully imported data, with no error, bot it seems that the import session is complitely messing role permissions, and category permissions.

So after import the forum looks blank at front end, with no threads or posts.

This are permissions setting before import session:
5a5784f04b82c
5a5784f073c06
5a5784f077865

Then goes the successful import:
5a57850c70cdf

And this what role and categories permissions look like after import:
5a5785351a457
5a5785353a793
5a57853578897
5a57853519946

Any ideas?

Thanks!

Hi, and thanks for reply. I have solved database connection issue, indeed there was a problem connecting to remote database. I have successfully imported data, with no error, bot it seems that the import session is complitely messing role permissions, and category permissions. So after import the forum looks blank at front end, with no threads or posts. This are permissions setting before import session: ![5a5784f04b82c](serve/attachment&path=5a5784f04b82c) ![5a5784f073c06](serve/attachment&path=5a5784f073c06) ![5a5784f077865](serve/attachment&path=5a5784f077865) Then goes the successful import: ![5a57850c70cdf](serve/attachment&path=5a57850c70cdf) And this what role and categories permissions look like after import: ![5a5785351a457](serve/attachment&path=5a5785351a457) ![5a5785353a793](serve/attachment&path=5a5785353a793) ![5a57853578897](serve/attachment&path=5a57853578897) ![5a57853519946](serve/attachment&path=5a57853519946) Any ideas? Thanks!

Hi,

It might be because we had written the importer before the permission system was created.

We will have to test the import again.

Can you give us access to your codoforum backend/database ?

Hi, It might be because we had written the importer before the permission system was created. We will have to test the import again. Can you give us access to your codoforum backend/database ?
Necessity is the mother of all inventions!
197
5
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft