| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 14 online users. » 0 Member(s) | 14 Guest(s)
|
|
|
| Customize Dashboard |
|
Posted by: bob.alexander - 11-25-2025, 11:06 PM - Forum: NodeActa Application Center
- No Replies
|
 |
Dashboard (your welcome app) is of course just another app in NodeActa system and therefore you have the full control over it.
You can find it at System Apps->Dashboard.
To customize Dashboard app, open it first in MS Code (see here how).
Let's imagine you want to add the latest company news to the Dashboard.
First you will create a document class NEWS in the system where you will persist your 'news' (see here how add a document class).
Of course, you will have to create a new app for filling NEWS class (see here how to create app to query document class).
Now, to display 'the news' on the Dashboard, you can for example add a RecordsView and populate it with the latest news.
First, using MS Code, in the index.mjs file of the Dashboard app find the line:
this.showDashboardCheck = new AttributesView(this);
Just above that line add the following (asuming you used 'CompanyNews' as JavaScript name for NEWS document class):
this.newsView = new RecordsView(this);
this.newsView.options.header = false;
this.newsView.options.multiline = true;
this.newsView.align = Align.Client;
this.newsView.fields = [CompanyNews.content];
this.newsView.source = CompanyNews.orderBy(CompanyNews.createdOn, SortOrder.Desc).limit(10).select();
Of course, do not forget to upload the app to the server so other users can use your new Dashboard.
You can do that using Commands->Save All command in the main menu of NodeActa Application Center or in MS Code using Uppload Changes button (see here).
|
|
|
| Failed loading driver for SYSTEM database |
|
Posted by: bob.alexander - 11-23-2025, 07:14 PM - Forum: Installation & Configuration
- No Replies
|
 |
Loading database driver might fail for multiple reasons:
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.
|
|
|
| Install NodeActa Server on Linux |
|
Posted by: bob.alexander - 11-23-2025, 06:48 PM - Forum: Installation & Configuration
- No Replies
|
 |
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.
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
|
|
|
| Install and Configure MySQL Database Server |
|
Posted by: boban - 11-23-2025, 06:42 PM - Forum: Installation & Configuration
- No Replies
|
 |
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;
|
|
|
|