Artifactory Error – Error 1071: Specified key was too long; max key length is 3072 bytes

Error

[root@localhost log]# more metadata-service.log | grep -i error
2021-08-13T05:50:35.245Z [jfmd ] [WARN ] [1b5644480c9d339f] [migrator.go:201               ] [main                ] - This error occurred when upgrading the database : 'Error 1071: Specified key was too long; max key length is 3072 bytes'.  [database]
2021-08-13T05:50:35.247Z [jfmd ] [ERROR] [1b5644480c9d339f] [migrator.go:194               ] [main                ] - Migration v038_file_targets.sql failed ! Rollback to latest successful migration. Err: Error 1071: Specified key was too long; max key length is 3072 bytes. Panic : <nil> [database]
2021-08-13T05:50:35.248Z [jfmd ] [PANIC] [1b5644480c9d339f] [application.go:89             ] [main                ] - Could not execute database migrations Error 1071: Specified key was too long; max key length is 3072 bytes

Solution

--------------------- THIS WORKED----------------------------
$ mysql -h localhost -u root -p
CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;
CREATE USER 'artifactory1'@'%' IDENTIFIED BY 'password';
GRANT ALL on artdb.* TO 'artifactory1'@'%';
FLUSH PRIVILEGES;
--------------------- THIS WORKED----------------------------

Some Troubleshooting Commands to Check this Error

SET GLOBAL default_storage_engine = 'InnoDB'
SET GLOBAL default_storage_engine = 'InnoDB';
USE <database>;
SHOW TABLE STATUS\G

ALTER TABLE md_database_migrations CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE md_database_migrations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER DATABASE artifactory CHARACTER SET utf8 COLLATE utf8_bin;
use artifactory;
ALTER TABLE md_database_migrations CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

Reference

  • https://confluence.atlassian.com/fisheye/migrating-to-mysql-960155589.html
  • https://www.jfrog.com/jira/si/jira.issueviews:issue-html/RTFACT-24896/RTFACT-24896.html

Artifcatory Command line Options of artifactory.sh

$ ./artifactory.sh -h
2021-08-13T05:06:51.966Z [shell] [INFO ] [] [systemYamlHelper.sh:521       ] [main] - Resolved .shared.database.type (mysql) from /opt/artifactory-pro-7.23.3/var/etc/system.yaml
2021-08-13T05:06:52.063Z [shell] [INFO ] [] [systemYamlHelper.sh:521       ] [main] - Resolved .shared.database.url (__sensitive_key_hidden___) from /opt/artifactory-pro-7.23.3/var/etc/system.yaml
2021-08-13T05:06:52.133Z [shell] [INFO ] [] [systemYamlHelper.sh:521       ] [main] - Resolved .shared.database.password (__sensitive_key_hidden___) from /opt/artifactory-pro-7.23.3/var/etc/system.yaml

././artifactory.sh - Script to manage artifactory services.

Usage: ././artifactory.sh

action: start|stop|restart|status|check|run|help

Note : If no action is passed, the services will be run in foreground.

XAMPP: Another web server is already running

Error

root@ip-172-31-3-238:/home/ubuntu# /opt/lampp/lampp start
Starting XAMPP for Linux 7.4.13-0...
XAMPP: Starting Apache...fail.
XAMPP:  Another web server is already running.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.

Solution 1

$ /opt/lampp/lampp stop
$ ps -eaf | grep lampp
$ ps -eaf | grep httpd
$ ps -eaf | grep apache
$ kill -9 500 5347 5386
$ /opt/lampp/lampp start

Or Solution 2

$ sudo service apache2 stop
$ ps -eaf | grep apache2
$ ps -eaf | grep httpd
$ sudo service apache2 status
$ sudo service mysql status
$ sudo service mysqld status
$ /opt/lampp/lampp start
$ /opt/lampp/lampp stop
$ /opt/lampp/lampp start

How to setup AWS Command line to Sync S3 Bucket in Windows?

Step 1 – Install AWS Command line

Download this file – https://awscli.amazonaws.com/AWSCLIV2.msi

Step 2 – Run following command

$ aws configure
AWS Access Key ID: <ENTER AWS ACCESS ID>
AWS Secret Access Key: <ENTER AWS ACCESS Key>
Default region name: ap-south-1
Default output format: 

Step 3 – Verify AWS configure and access

$ aws s3 ls

Step 4 – Create a empty directory where you want to sync S3 Bucket usign cmd.

$ cd d:/
$ mkdir aws-s3
$ cd aws-s3
$ start .

Step 5 – Create a 2 Bat file.

#pull.bat content
----------
aws s3 sync s3://<NameOfBucket> .

#push.bat content
----------
aws s3 sync . s3://<NameOfBucket>

Step 6 – Open cmd line and run pull.bat for pull the content

Step 7 – Open cmd line and run push.bat for push the content

JAVA Error: Source option 5 is no longer supported. Use 6 or later

Error:

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project chat: Compilation failure: Compilation failure:
[ERROR] Source option 5 is no longer supported. Use 6 or later.
[ERROR] Target option 1.5 is no longer supported. Use 1.6 or later.
[ERROR] -> [Help 1]
[ERROR]

Solution

<properties>
     <maven.compiler.source>1.8</maven.compiler.source>
     <maven.compiler.target>1.8</maven.compiler.target>
</properties>

Artifactory Error: file does not exist – var/etc/security/master.key

Error

$ more router-service.log
2021-08-09T06:28:34.562Z [jfrou] [INFO ] [12eb5f8f306fefda] [security_keys.go:149          ]
 [main                ] - Master key is missing. Pending for 110 seconds with 2m0s timeout
2021-08-09T06:28:39.564Z [jfrou] [INFO ] [12eb5f8f306fefda] [security_keys.go:149          ]
 [main                ] - Master key is missing. Pending for 115 seconds with 2m0s timeout
2021-08-09T06:28:44.300Z [jfrou] [FATAL] [12eb5f8f306fefda] [bootstrap.go:98               ]
 [main                ] - Failed resolving master key: failed resolving 'shared.security.mas
terKey' key; file does not exist: /opt/artifactory-pro-7.21.5/var/etc/security/master.key
[root@localhost log]#
$ more metadata-service.log
2021-08-09T06:28:44.543Z [jfmd ] [PANIC] [74b40f69b408f150] [keys.go:22                    ]
 [main                ] - Failed resolving master key: failed resolving 'shared.security.mas
terKey' key; file does not exist: /opt/artifactory-pro-7.21.5/var/etc/security/master.key
goroutine 1 [running]:
runtime/debug.Stack(0x17575f8, 0x4, 0xc000245f01)
        /src/runtime/debug/stack.go:24 +0x9f
jfrog.com/jfrog-go-commons/v7/pkg/log.(*standardLogger).Panicfc(0xc0005c5980, 0x1b1e760, 0xc
000276c60, 0xc000245f40, 0x9b, 0xc000031d98, 0x0, 0x1)
        goroot/pkg/mod/jfrog.com/jfrog-go-commons/v7@v7.21.2-m007/pkg/log/standard_logger.go
:85 +0x9e
jfrog.com/metadata/v7/services/common.MustResolveSecurityKeys(0x1b1e760, 0xc000276c60, 0x1b27070, 0xc00055b8b0
, 0x1b32910, 0xc0005c5980)
        jfrog.com/metadata/v7@v7.21.4/services/common/keys.go:22 +0x1c2
main.main()
        jfrog.com/metadata/v7@v7.21.4/metadata.go:30 +0x3b1
 [init]
$ more event-service.log
    ] - Master key is missing. Pending for 115 seconds with 2m0s timeout [startup]
2021-08-09T06:28:44.736Z [jfevt] [FATAL] [773058374c55a614] [bootstrap.go:115              ] [main
    ] - Failed resolving master key: failed resolving 'shared.security.masterKey' key; file does not exist: /o
pt/artifactory-pro-7.21.5/var/etc/security/master.key [startup]

Solution

Installed New version of Artifactory and it should solve the issues.

Azure Error with Vmware Tanzu: did not find Azure Usage with name ‘cores

Error


{"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.","details":[{"code":"VMExtensionProvisioningError","message":"VM has reported a failure when processing extension 'initbootstrap'. Error message: \"Enable failed: failed to execute command: command terminated with exit status=1\n[stdout]\n\n[stderr]\nuseradd: user 'rajesh' already exists\npioneer: error: \n###QUOTACHECK###\ndid not find Azure Usage with name 'cores'%!(EXTRA <nil>)\n---\n, try --help\n\"\r\n\r\nMore information on troubleshooting is available at https://aka.ms/VMExtensionCSELinuxTroubleshoot "}]}
{
    "status": "Failed",
    "error": {
        "code": "VMExtensionProvisioningError",
        "message": "VM has reported a failure when processing extension 'initbootstrap'. Error message: \"Enable failed: failed to execute command: command terminated with exit status=1\n[stdout]\n\n[stderr]\nuseradd: user 'rajesh' already exists\npioneer: error: \n###QUOTACHECK###\ndid not find Azure Usage with name 'cores'%!(EXTRA <nil>)\n---\n, try --help\n\"\r\n\r\nMore information on troubleshooting is available at https://aka.ms/VMExtensionCSELinuxTroubleshoot "
    }
}

The 5 Best Online Paraphrasing Tools to Rephrase Text

Paraphrasing – concept  

Paraphrasing is the process of transforming ordinary written information into a more extraordinary and impactful version. It keeps the essence and soul of the original writer’s message, but with the addition of powerful characters who completely alter the content’s outlook.

Not everyone can claim to be a legendary author. Writing extensive and engaging marketing content is a challenge for most individuals. This is where paraphrasing makes a difference.

It elevates a standard piece of material with a significant message into a completely new look with a guarantee of excellence.

Using paraphrase tools can provide you with a plethora of advantages. They’re great at:

 • Incorporating great vocabulary and depth into the rewritten content

• Finding mistakes and rewriting them correctly

 • Giving your old content a new and unique style that’ll be more appropriate and likeable for the reader and conveys your message properly

 • The writing is to the point and not boring or unwanted lengthy and meaningless Copying and pasting is now considered a felony. So you may acquire a unique and up-to-date version of your marketing content by using paraphrase tools.

Following is the list of top 5 paraphrasing tools that can help you rewrite the content

1.    Quillbot.com

If you’re looking for the most cutting-edge artificial intelligence to improve your content, quillbot.com is the way to go.

It employs artificial intelligence algorithms to transform ordinary information into exceptional content for your users to work with.

It’s effortless, and you’ll end up with excellent content that has a fresh lease on life.

All you have to do is copy the content, and your old content will be fresh new and ready to post in seconds.

When you look into this rewriter, you’ll notice that it has three modes.

• Fluency

It’s the quickest and most straightforward rewriter. It will paraphrase the altered words and display them in strong green text. It only takes a few seconds, and the stuff produced is rather straightforward.

• Standard

Instead of using unique terms, you’ll see a lot of synonyms here. Your article will be free of plagiarism and significantly better than the original.

• Creative

This is the most advanced and creative version of your original written work, as the name implies. Your paper has all of the applications of artificial intelligence, and it is the finest of them all.

As previously stated, QuillBot is free to use, especially for casual writing. The free version has a 700-character restriction for the summarizer, three word flipper options, three writing modes, two sentences processed at once, Google Chrome and Doc extensions, and a 5000-character limit.

The Premium account is great for assignments that require a lot of time.

It has a 10,000-character limit for the paraphraser, a 25,000-character limit for the summarizer, 7 writing modes, 4-word flipper choices, comparison modes, 15 sentences processed at once, and more. Formal, creative plus, shorten, and expand are among the premium modes.

2.    Editpad.org

You don’t have much experience and your content is rather simple. This application is the best thing on the Web for learning and spicing up stuff for the reader and user.

Students mastering the art of rewriting are most likely to employ this paraphrasing tool. Editpad.org is a website that can help you improve your writing skills.

You’ll notice that every line and word has modified to create a unique and better content while maintaining the same level of significance.

The nicest part about this rewriter is that all of its functions are available for free; there is no need to download an app or wait for membership. Simply enter your information and select an option to see your desired modifications in a matter of seconds.

Editpad.org has all of the tools you’d expect, such as plagiarism detection.

Because there is no language restriction in our paraphrase tool, you can change a wide range of information and formats. DOCS, TXT, and PDF files are all ready in a matter of seconds.

It ensures that your data is completely secure. As a result, your data are in the capable hands of rewriters.

3.    Spin writer

This Spin rewriter is your best friend, especially if you want to keep the integrity and meaning of your marketing copy while launching a new firm. You provide data, and the rephrase tool allows you to spin the material and create a new one with the same meaning but a greater impact.

This article rewriter is an old dog that has evolved, and the current version is significantly improved and useful to millions of users who want their work to be suitable for public consumption.

Spin rewriter has a plethora of resources at its disposal. It not only employs artificial intelligence (AI), but also English as a second language (ENL) to complete the task.

You can access this rewriter at any moment via the Internet. This paraphrase rewriter is not only useful for marketing, but also for high-class bloggers, writers, and students. It’s also highly user-friendly, and your work is completed in the blink of an eye.

It’s a fantastic paraphrase tool for your articles that you may use anywhere for free.

4.    Prepostseo

The first and most significant feature of our prepostseo article rewriter is that it is completely free. That’s fantastic, especially because there are no official registration requirements.

Many content writers, students, and Web gurus use our article rewriter to create distinctive articles instead of boring simple text.

You can use our article rewriter to rephrase your marketing material and gain all of the benefits.

For your convenience, there are four options available.

• Easy

• Advanced

• Fluent

• Creative

This paraphrase tool is incredibly easy to use. You can place your material on the left and select your preferred paraphrase mode, and in a matter of seconds, you’ll have content that’s both distinctive and simply written to your specifications.

The most impressive aspect of this prepostseo article rewriter is that it provides you with different language options rather than limiting you to native English.

The number of formats is limitless. You can select the one that best matches your marketing blogs.

It is not required that you implement all of the modifications it makes. You will see the improved words highlighted, and you can choose whether or not to modify them. You have complete control over your writing.

5.    Paraphrase online

This rephrasing tool is great to transform the content into new outlook. Your old thoughts will be turned into new version without changing any meaningfulness

You can put the old text into left side and can easily get it rephrased. It is very easy to use and pretty straight forward to work with. from professionals to simple students can use it. It is a very beneficial re phaser

Conclusion

We have given you the whole inside into the rephasing and top 5 tools. Now you can use them and they will make your life easier