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'

By solving this question, you may help 554 user(s).

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

stefano5885 Lv1Posted 08 Jul 2024 11:55
  
This answer appears to have been written by AI…
Enrico Vanzetto Lv3Posted 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)
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

3
4
3

Started Topics

Followers

Follow

2
2
0

Started Topics

Followers

Follow

0
1
0

Started Topics

Followers

Follow

Board Leaders