Frequently Asked Questions

NodeActa Server Instalation

Install NodeActa Server on Linux

Prepare Linux environment with required dependencies:

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.

Install NodeActa server:

sudo dpkg -i nodeacta.server.x64.deb

Install and Configure MySQL Database Server

To install MySQL Server on Linux call:

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;

Failed loading driver for NASYSTEM

Error: Can't connect to local server through socket '/tmp/mysql.sock`

[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

Error: Plugin caching_sha2_password could not be loaded: ...

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;

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.

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

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.