https://nodeacta.com/forum/ Sat, 18 Apr 2026 09:14:24 +0000 MyBB https://nodeacta.com/forum/showthread.php?tid=3 Sun, 23 Nov 2025 19:14:02 +0000 bob.alexander]]> https://nodeacta.com/forum/showthread.php?tid=3
1. [MySQL] Can't connect to local server through socket '/tmp/mysql.sock'

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that your MySQL server's socket variable is different from what the MySQL driver expects.
You can check socket value with SHOW VARIABLES LIKE 'socket';

Solution:
Run in terminal:
     sudo grep -R socket /etc/mysql/* /etc/init/*mysql*

This command will return the list of config files where socket is configured.
You might also get a line like #socket = /var/run/mysqld/mysqld.sock.
This means that socket valiable is undefined and it defaults to /var/run/mysqld/mysqld.sock, which is not correct for NodeActa setup.
Please change this line to socket = /tmp/mysql.sock.
In the file with [mysqld] section ensure you have also section [client] like:

      [client]
      socket = /tmp/mysql.sock

Finally, to restart mysql server call:
      sudo systemctl restart mysql

2. Error: Plugin caching_sha2_password could not be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that your MySQL server's plugin caching_sha2_password.so is missing or cannot be loaded.

Solution 1:
Please contact your administrator to ensure that the required caching_sha2_password.so library is available on your MySQL server system. It might happen that your system has caching_sha2_password.so.1 or similar, then you can simply create a symbolic link named caching_sha2_password.so.

Solution 2:
Change your MySQL user authentication plugin with:
      ALTER USER 'USERNAME'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MYPASSWORD';

You can check user's current authentication plugin with SELECT host, user, plugin FROM mysql.user;

If this was a fresh install of MySQL server, to initialize root user you should call sudo mysql_secure_installation and follow instructions.

To change root password call:
      ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;

To create a new user dedicated to NodeActa server call:
      CREATE USER 'NODEACTA'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;
      GRANT ALL PRIVILEGES ON *.* TO 'NODEACTA'@'localhost' WITH GRANT OPTION;
      FLUSH PRIVILEGES;

3. Oracle Error: Function: dpiContext_createWithParams, Action: load library, Message: DPI-1047: Cannot locate a 64-bit Oracle Client library: libclntsh.so: cannot open shared object file: No such file or director.

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that NodeActa server cannot find Oracle Client libraries. It might be that Oracle Client is not instaled or its installation location is not added to the PATH evnironment variable. Make sure that LD_LIBRARY_PATH variable exists too.

4. Oracle Error: Function: dpiPool_acquireConnection, Action: get session, Message: ORA-12541: Cannot connect. No listener at host 127.0.0.1 port 1521.

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that NodeActa server cannot connect to Oracle database.

Solution:
Update NodeActa server configuration to use the correct Oracle connection parameters.
In this case, the database host was likely left at the default value of 'localhost' during installation, whereas the intended Oracle database resides at a different address or the Oracle server does not permit local connections.]]>
1. [MySQL] Can't connect to local server through socket '/tmp/mysql.sock'

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that your MySQL server's socket variable is different from what the MySQL driver expects.
You can check socket value with SHOW VARIABLES LIKE 'socket';

Solution:
Run in terminal:
     sudo grep -R socket /etc/mysql/* /etc/init/*mysql*

This command will return the list of config files where socket is configured.
You might also get a line like #socket = /var/run/mysqld/mysqld.sock.
This means that socket valiable is undefined and it defaults to /var/run/mysqld/mysqld.sock, which is not correct for NodeActa setup.
Please change this line to socket = /tmp/mysql.sock.
In the file with [mysqld] section ensure you have also section [client] like:

      [client]
      socket = /tmp/mysql.sock

Finally, to restart mysql server call:
      sudo systemctl restart mysql

2. Error: Plugin caching_sha2_password could not be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that your MySQL server's plugin caching_sha2_password.so is missing or cannot be loaded.

Solution 1:
Please contact your administrator to ensure that the required caching_sha2_password.so library is available on your MySQL server system. It might happen that your system has caching_sha2_password.so.1 or similar, then you can simply create a symbolic link named caching_sha2_password.so.

Solution 2:
Change your MySQL user authentication plugin with:
      ALTER USER 'USERNAME'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MYPASSWORD';

You can check user's current authentication plugin with SELECT host, user, plugin FROM mysql.user;

If this was a fresh install of MySQL server, to initialize root user you should call sudo mysql_secure_installation and follow instructions.

To change root password call:
      ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;

To create a new user dedicated to NodeActa server call:
      CREATE USER 'NODEACTA'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;
      GRANT ALL PRIVILEGES ON *.* TO 'NODEACTA'@'localhost' WITH GRANT OPTION;
      FLUSH PRIVILEGES;

3. Oracle Error: Function: dpiContext_createWithParams, Action: load library, Message: DPI-1047: Cannot locate a 64-bit Oracle Client library: libclntsh.so: cannot open shared object file: No such file or director.

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that NodeActa server cannot find Oracle Client libraries. It might be that Oracle Client is not instaled or its installation location is not added to the PATH evnironment variable. Make sure that LD_LIBRARY_PATH variable exists too.

4. Oracle Error: Function: dpiPool_acquireConnection, Action: get session, Message: ORA-12541: Cannot connect. No listener at host 127.0.0.1 port 1521.

While installing or running NodeActa server on Unix systems, you may encounter this error.
This indicates that NodeActa server cannot connect to Oracle database.

Solution:
Update NodeActa server configuration to use the correct Oracle connection parameters.
In this case, the database host was likely left at the default value of 'localhost' during installation, whereas the intended Oracle database resides at a different address or the Oracle server does not permit local connections.]]> https://nodeacta.com/forum/showthread.php?tid=2 Sun, 23 Nov 2025 18:48:05 +0000 bob.alexander]]> https://nodeacta.com/forum/showthread.php?tid=2       sudo apt update
      sudo apt install -y wget unzip libtommath-dev libicu-dev systemd libaio1

Depending on the platform, libaio1 may not be available. In such cases, libaio1t64 should be available as an alternative.
If you install NodeActa server using the default settings, the setup will download and install the Firebird 5.0 database server.
If you prefer to use Oracle or MySQL as your primary database, you will need to choose the database type during the setup process.
Important: The setup will not automatically install Oracle or MySQL servers. However, for Oracle, it will download and install the latest Oracle Instant Client.

If you are updating NodeActa binaries over existing installation, please call:
      systemctl stop nodeacta.service

Install NodeActa server:
      sudo dpkg -i nodeacta.server.x64.deb]]>       sudo apt update
      sudo apt install -y wget unzip libtommath-dev libicu-dev systemd libaio1

Depending on the platform, libaio1 may not be available. In such cases, libaio1t64 should be available as an alternative.
If you install NodeActa server using the default settings, the setup will download and install the Firebird 5.0 database server.
If you prefer to use Oracle or MySQL as your primary database, you will need to choose the database type during the setup process.
Important: The setup will not automatically install Oracle or MySQL servers. However, for Oracle, it will download and install the latest Oracle Instant Client.

If you are updating NodeActa binaries over existing installation, please call:
      systemctl stop nodeacta.service

Install NodeActa server:
      sudo dpkg -i nodeacta.server.x64.deb]]> https://nodeacta.com/forum/showthread.php?tid=1 Sun, 23 Nov 2025 18:42:12 +0000 boban]]> https://nodeacta.com/forum/showthread.php?tid=1       sudo apt install mysql-server-8.0
      sudo mysql_secure_installation

If mysql_secure_installation does not offer to set root password, you can call:
      sudo mysql 
      ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;

To create a new user dedicated to NodeActa server call:
      sudo mysql 
      CREATE USER 'NODEACTA'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;
      GRANT ALL PRIVILEGES ON *.* TO 'NODEACTA'@'localhost' WITH GRANT OPTION;
      FLUSH PRIVILEGES;]]>       sudo apt install mysql-server-8.0
      sudo mysql_secure_installation

If mysql_secure_installation does not offer to set root password, you can call:
      sudo mysql 
      ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;

To create a new user dedicated to NodeActa server call:
      sudo mysql 
      CREATE USER 'NODEACTA'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;
      GRANT ALL PRIVILEGES ON *.* TO 'NODEACTA'@'localhost' WITH GRANT OPTION;
      FLUSH PRIVILEGES;]]>