Author: Haas

Categories
Open Source OsX RabbitMq Solutions Web

RabbitMQ Server – Issue with High Sierra – Mac OS

macOS RabbitMq

After updating to High Sierra, I faced issues with starting rabbitmq-server.  The command gave the following error:

RabbitMQ 3.6.3. Copyright (C) 2007-2016 Pivotal Software, Inc.
## ## Licensed under the MPL. See http://www.rabbitmq.com/
## ##
########## Logs: /usr/local/var/log/rabbitmq/rabbit@localhost.log
###### ## /usr/local/var/log/rabbitmq/rabbit@localhost-sasl.log
##########
Starting broker...
completed with 10 plugins.
Assertion failed: (ctx), function digest_update, file /BuildRoot/Library/Caches/com.apple.xbs/Sources/boringssl/boringssl-109.20.5/apple/crypto/digests.c, line 49.
/usr/local/sbin/rabbitmq-server: line 236: 2681 Abort trap: 6 start_rabbitmq_server "$@"

I narrowed down the issue to a problem with Home Brew. I had installed rabbitmq via HomeBrew a while back and with the changes in the operating system rabbitmq was failing to start.

Running the following command gave the below error message:

$ brew update
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun
Error: /usr/local is not writable. You should change the ownership
and permissions of /usr/local back to your user account:
sudo chown -R $(whoami) /usr/local

How to fix RabbitMQ Server – Issue with High Sierra

  1. Reinstall Home Brew using the following command:
    ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
  2. Then run:
    brew update
  3. Then run:
    brew reinstall rabbitmq
  4. Once done you must  be able to run rabbitmq-server to get the server up and running.
Categories
SEO & Digital Marketing

Top 50 High DA Directory Submission Sites

best seo backlinks strategy

Update (2026): While automated web directories were popular a decade ago, search engines now treat low-quality directory links as spam. This guide has been completely rewritten to detail high-authority, ethical link-building strategies that actually move your organic rankings today.

In the early days of SEO, submitting your URL to hundreds of web directories was a quick way to build domain authority. Today, doing this can trigger algorithmic penalties from Google. Modern SEO requires earning high-quality contextual backlinks from real, high-traffic web properties.

Here is how to safely build high-authority backlinks that move the needle.

1. The Right Way to Leverage Web Directories

Are directory submissions completely dead? No, but their purpose has changed. You should only submit your site to local citations and core ecosystem directories.

These include:

  • Google Business Profile / Bing Places: Essential for any local or regional service entity.
  • Crunchbase / Product Hunt: Critical platforms if you are building a startup, app, or software product.
  • Clutch / G2: Essential review directories for agencies, B2B services, and enterprise software utilities.

2. Digital PR and the Skyscraper Technique

Instead of submitting your link to blank lists, find top-ranking content in your tech niche that contains broken or outdated outlinks. Reach out to the site editors, point out the broken source, and pitch your newly updated, comprehensive resource as a superior replacement.

3. Creating Data-Driven Link Baits

The easiest way to get natural links from major tech sites is to publish original, statistics-driven data sheets or cheat sheets. Writers and journalists constantly look for data points to link to as source material.

Quick Comparison: Legacy SEO vs. Modern Link Building

Strategy TypeLegacy Approach (Avoid)Modern Approach (Focus)
Directory UsageAutomated mass directory listsSelective Profile Lists (Crunchbase, Product Hunt)
Link ContextSidebar widgets or footer dropsContextual editorial links inside rich articles
Target MetricVolume of raw linking domainsHigh trust, high traffic relevance
Are directory submission sites still good for SEO?

For general SEO, generic web directory submissions are mostly obsolete and can act as spam signals. However, specialized profile directories like Crunchbase, Product Hunt, and Google Business Profile remain essential for local citations and branding.

What is the modern alternative to directory backlinks?

Modern link-building focuses on earning contextual links within high-quality content. Top strategies include Digital PR, broken link building, and creating data-driven assets or cheat sheets that journalists naturally cite as sources.

How do low-quality backlinks affect site rankings?

Google’s modern AI algorithms generally ignore low-quality automated links. However, if a domain excessively builds artificial directory or comment links, it can trigger algorithmic penalties that drop the site’s overall quality score.

Categories
Android Apps Device Open Source Solutions

Swift Key – Turn Off Keyboard Touch Vibration

SwiftKey

Swift Key is one of the best keyboards for Android and IOs. By default, its configured to enable vibration on key press (usually it takes the system defaults). If you are someone who dislikes this feature, here is a simple way to turn off keyboard touch vibration in it:

Steps to Disable Keyboard Touch Vibration in Swift Key:

  • Go to Home -> Settings -> Language & input

    Android Settings Page
    Android Settings Page
  • Tap on “Virtual Keyboard”
    Android Language & input
  • Locate “SwiftKey Keyboard” in the list and tap it
    Virtual Keyboard Menu
  • This will open the SwiftKey Settings… Tap on “Typing”
    Swiftkey Settings
  • Tap on “Sound & Vibration”
    Swiftkey Sound and Vibration Menu
  • Turn off “Keypress Vibration” & “Use the Android default vibration”
    Disable Vibration in SwiftKey
Categories
Laptop OsX Solutions

Open Apps From Unidentified Developers in Mac OS Sierra

Here is How to open applications that can’t be opened as they are from an ‘unidentified developer’ in Mac OS Sierra

How to Open Applications From Unidentified Developers in Mac OS Sierra

Opening a Specific App:

If you would like to allow just one specific application to run, use the following steps:

  1. Hold down the Control key and click the application icon.
  2. A contextual menu should appear – here Choose ‘Open’.
  3. A popup will appear asking you to confirm this action – Click the Open button.

Once you open the App is opened its stored as an exception in the settings and you can open it in future directly by double clicking it.

Allowing all Apps to Open(Works with some versions of Sierra):

If you would like to allow all applications from unidentified developers to run, use the following steps:

  1. Click on the “Apple” menu on the top left of your screen
  2. Select “System Preferences” option from the menu
  3. Choose ‘Security & Privacy’ from the System Preferences menu.
  4. Select ‘General’ from the tabs at the top of the Security & Privacy page.
  5. Click the ‘Lock icon’ at the bottom left of the window.
  6. Enter your administrative username and password and click Unlock
  7. Select ‘Anywhere’ from list of places to allow downloaded applications from. If this option does not show up in the window then you will have use the first method with each app.
  8. A popup window will appear asking you to confirm your selection. Click the Allow From Anywhere button.
Categories
Linux MySql Open Source Solutions

How to Rename Column in Mysql

rename column mysql

Modifying database schemas is a routine task, but the exact syntax to alter structural properties varies heavily across database versions. If you are trying to rename a column in MySQL, using the wrong command can lead to syntax errors or accidental data loss.

How you rename a column depends entirely on whether your environment runs modern MySQL 8.0+ engines or legacy MySQL 5.7 configurations.

Here is the exact syntax and production-ready code blocks to rename your database columns safely.

The Modern Way: MySQL 8.0+ (RENAME COLUMN)

If you are running MySQL 8.0 or newer, the development team introduced a native, simplified syntax. You no longer need to re-specify the entire data type definition just to change the column name.

SQL

ALTER TABLE table_name
RENAME COLUMN old_column_name TO new_column_name

Example: To change a column named user_pass to password inside a table called users:

SQL

ALTER TABLE users 
RENAME COLUMN user_pass TO password;

The Legacy Way: MySQL 5.7 and Older (CHANGE)

In older versions of MySQL, the RENAME COLUMN statement does not exist. Attempting to use it triggers a generic syntax error. Instead, you must use the CHANGE clause.

Crucially, you must explicitly re-state the complete data type definition along with any attributes (like NOT NULL or DEFAULT). Failing to include the data type will break the query.

SQL

ALTER TABLE table_name 
CHANGE old_column_name new_column_name DATA_TYPE CHARACTER_SET_ATTRIBUTES;

Example: To rename user_pass to password where the column data type is a VARCHAR(255) that cannot be null:

SQL

ALTER TABLE users 
CHANGE user_pass password VARCHAR(255) NOT NULL;

Warning: Be extremely careful when using CHANGE. If you accidentally specify a different data type definition during the rename step, MySQL will attempt to convert the underlying data, which can lead to truncated strings or corrupted records.

Can I rename multiple columns at once in MySQL?

Yes, in modern MySQL 8.0, you can chain operations within a single statement by separating them with commas. For example: ALTER TABLE users RENAME COLUMN old_a TO new_a, RENAME COLUMN old_b TO new_b;.

Why does MySQL rename column throw a syntax error?

This typically happens if you try to use the native RENAME COLUMN syntax on a server running an older version like MySQL 5.7. For legacy setups, you must use the ALTER TABLE CHANGE statement instead