Pixeldust Drupal Support Service

Help with new Aegir install

My server management company has installed Aegir using the BOA stack on Debian 10 on a VPS but we are having some challenges.

Issues with Adminer

When trying to import a 26MB gzipped db using the username/password/db details from the sites drushrc.php file I get a superuser error:

 /*!50003 CREATE*/   Error in query (1227): Access denied; you need (at least one of) the SUPER privilege(s) for this operation 541 queries executed OK

Can you help with what settings need to be fixed?

.

Drush won’t work for o1.ftp

When I log in as o1.ftp I get this when I run drush commands

o1.ftp:~$ drush status /usr/bin/sh: line 661: /usr/bin/sh: Argument list too long /usr/bin/sh: line 661: /usr/bin/sh: Success

But the sysadmin team is able to use drush. This is what they said:

... the drush command was executable if we login to the o1.ftp user as /bin/bash and use the full drush.php path. See below snippet.  o1.ftp@server:~/static/platforms$ php /opt/tools/drush/8/drush/drush.php status  PHP configuration      :  /opt/php74/lib/php.ini /home/o1.ftp/.drush/php.ini           PHP OS                 :  Linux                                                       Drush script           :  /opt/tools/drush/8/drush/drush.php                           Drush version          :  8.4.10                                                       Drush temp directory   :  /home/o1.ftp/.tmp                                           Drush configuration    :                                                               Drush alias files      :  /home/o1.ftp/.drush/devnew.siteurl.co.za.alias.drushrc.php  We have also tried restoring the MySQL database with the same command and it was successfully restored.

They have asked me to check the permissions of drush.php file and configuration. And is there anything else we should be checking?

This article was republished from its original source.
Call Us: 1(800)730-2416

Pixeldust is a 20-year-old web development agency specializing in Drupal and WordPress and working with clients all over the country. With our best in class capabilities, we work with small businesses and fortune 500 companies alike. Give us a call at 1(800)730-2416 and let’s talk about your project.

Let's Talk About a Project

FREE Drupal SEO Audit

Test your site below to see which issues need to be fixed. We will fix them and optimize your Drupal site 100% for Google and Bing. (Allow 30-60 seconds to gather data.)

Powered by

Help with new Aegir install

On-Site Drupal SEO Master Setup

We make sure your site is 100% optimized (and stays that way) for the best SEO results.

With Pixeldust On-site (or On-page) SEO we make changes to your site’s structure and performance to make it easier for search engines to see and understand your site’s content. Search engines use algorithms to rank sites by degrees of relevance. Our on-site optimization ensures your site is configured to provide information in a way that meets Google and Bing standards for optimal indexing.

This service includes:

  • Pathauto install and configuration for SEO-friendly URLs.
  • Meta Tags install and configuration with dynamic tokens for meta titles and descriptions for all content types.
  • Install and fix all issues on the SEO checklist module.
  • Install and configure XML sitemap module and submit sitemaps.
  • Install and configure Google Analytics Module.
  • Install and configure Yoast.
  • Install and configure the Advanced Aggregation module to improve performance by minifying and merging CSS and JS.
  • Install and configure Schema.org Metatag.
  • Configure robots.txt.
  • Google Search Console setup snd configuration.
  • Find & Fix H1 tags.
  • Find and fix duplicate/missing meta descriptions.
  • Find and fix duplicate title tags.
  • Improve title, meta tags, and site descriptions.
  • Optimize images for better search engine optimization. Automate where possible.
  • Find and fix the missing alt and title tag for all images. Automate where possible.
  • The project takes 1 week to complete.
MASTER YOUR DRUPAL SEO
Pixeldust and Pantheon Drupal Development
256