Connect to AWS or S3 storage

stefano5885 Lv1Posted 05 Jul 2024 23:38

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'

stefano5885 has solved this question and earned 10 coins.

Posting a reply earns you 2 coins. An accepted reply earns you 20 coins and another 10 coins for replying within 10 minutes. (Expired) What is Coin?

Enter your mobile phone number and company name for better service. Go

Thank you @Enrico but the problem is MySql DB not Wasabi, Sangfor documentation is absolutely useless.
I want to use S3 Compatible Storage (or AWS S3)
Is this answer helpful?
vesogi7900 Lv2Posted 08 Jul 2024 11:43
  
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.
stefano5885 Lv1Posted 08 Jul 2024 11:55
  
This answer appears to have been written by AI…
Enrico Vanzetto Lv4Posted 08 Jul 2024 14:36
  
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.
stefano5885 Lv1Posted 08 Jul 2024 14:47
  
Thank you @Enrico but the problem is MySql DB not Wasabi, Sangfor documentation is absolutely useless.
I want to use S3 Compatible Storage (or AWS S3)
Shared by Author
NOSINFORMATICA Lv1Posted 08 Jul 2024 16:47
  
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?

I Can Help:

Change

Moderator on This Board

2
1
0

Started Topics

Followers

Follow

11
7
5

Started Topics

Followers

Follow

3
14
3

Started Topics

Followers

Follow

2
2
0

Started Topics

Followers

Follow

Board Leaders