Connect to AWS or S3 storage

Connect to AWS or S3 storage

On Sangfor HCI 6.10 when i try to configure NEW DATASTORE based on S3 or AWS i need to configure an MySql Database.

I've create a new blank DB named "sangfor2".

When Sangfor does the connection test it looks for a table called "jfs_setting" and immediately throws a connection error.

Does anyone have any idea where I can find the script to populate the database correctly?

Or any official documents about this?

There are also problems with daylight saving time (but that concerns the connection to compatible S3 storage)

Thank you

Best regards

2024-07-05T15:24:26.967476Z        91 Connect   sangfor2@192.168.249.235 on sangfor5 using SSL/TLS

2024-07-05T15:24:26.969238Z        91 Prepare   SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB')

2024-07-05T15:24:26.969544Z        91 Execute   SELECT `TABLE_NAME`, `ENGINE`, `AUTO_INCREMENT`, `TABLE_COMMENT` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='sangfor5' AND (`ENGINE`='MyISAM' OR `ENGINE` = 'InnoDB' OR `ENGINE` = 'TokuDB')

2024-07-05T15:24:26.970523Z        91 Close stmt

2024-07-05T15:24:26.970726Z        91 Query     CREATE TABLE IF NOT EXISTS `sangfor_testing` (`id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL, `name` VARCHAR(255) NULL)

2024-07-05T15:24:26.983018Z        91 Query     SELECT 1

2024-07-05T15:24:26.984489Z        91 Prepare   INSERT INTO `sangfor_testing` (`name`) VALUES (?)

2024-07-05T15:24:26.984690Z        91 Execute   INSERT INTO `sangfor_testing` (`name`) VALUES ('sangfor')

2024-07-05T15:24:26.986358Z        91 Close stmt

2024-07-05T15:24:26.986764Z        91 Prepare   SELECT `id`, `name` FROM `sangfor_testing` WHERE `id`=? AND `name`=? LIMIT 1

2024-07-05T15:24:26.986940Z        91 Execute   SELECT `id`, `name` FROM `sangfor_testing` WHERE `id`=1 AND `name`='sangfor' LIMIT 1

2024-07-05T15:24:26.987466Z        91 Close stmt

2024-07-05T15:24:26.987831Z        91 Prepare   DELETE FROM `sangfor_testing` WHERE `id`=? AND `name`=?

2024-07-05T15:24:26.987991Z        91 Execute   DELETE FROM `sangfor_testing` WHERE `id`=1 AND `name`='sangfor'

2024-07-05T15:24:26.990630Z        91 Close stmt

2024-07-05T15:24:26.990828Z        91 Query     START TRANSACTION

2024-07-05T15:24:26.991092Z        91 Query     DROP TABLE IF EXISTS `sangfor_testing`

2024-07-05T15:24:26.997555Z        91 Query     COMMIT

2024-07-05T15:24:27.005537Z        92 Connect   sangfor2@192.168.249.235 on sangfor5 using SSL/TLS

2024-07-05T15:24:27.006324Z        92 Query     SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

2024-07-05T15:24:27.006630Z        92 Query     START TRANSACTION READ ONLY

2024-07-05T15:24:27.007933Z        92 Prepare   SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`=? and `TABLE_NAME`=?

2024-07-05T15:24:27.008147Z        92 Execute   SELECT `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='sangfor5' and `TABLE_NAME`='jfs_setting'

Same here, the support tell us that we need to have the sangfor cloud Platform enabled before use this feature (S3 backup).
Have find an alternative solutions?

Hi, i tried to configure a Wasabi Storage last month. A Wasabi bucket serves as a storage container for objects, which can be files or data, within Wasabi’s cloud storage service. This service bears similarity to Amazon S3. Each bucket has the capacity to store an unlimited quantity of objects and can be set up with distinct permissions and policies for data management. Buckets are the primary storage entities in Wasabi, aiding in data organization and access control.

For setting up an S3 or Wasabi bucket in Elasticsearch version 6.10, navigate to Other Datastore -> Object Storage -> select Wasabi. Here, you need to input the name of your S3 or Wasabi bucket in the “Database” field. This field should be filled with the precise name of the S3 or Wasabi bucket where you plan to store your data. It is essential to have your Wasabi access key, secret key, and the accurate endpoint URL correctly set up in the respective fields to create a connection.

This answer appears to have been written by AI…

It looks like you’re encountering an issue with the database configuration for Sangfor HCI when trying to connect to AWS or S3 storage. Here are a few steps and resources that might help:

Database Script: You need a script to create the necessary tables, including jfs_setting. Unfortunately, I couldn’t find a specific script online. However, you can reach out to Sangfor support for the exact script or guidance. They should be able to provide you with the necessary SQL commands to set up your database correctly.
Official Documentation: For detailed steps and troubleshooting, refer to the Sangfor HCI User Manual. This manual should have the necessary information on setting up and configuring your datastore.
Daylight Saving Time Issue: The issue with daylight saving time (DST) can be tricky. Ensure that your NTP server and timezone settings are correctly configured. You might find some useful tips in the Sangfor community forums.