• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Resolved mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead

D

Dagalidis

New Pleskian
Server operating system version
Ubuntu 20.04.6 LTS
Plesk version and microupdate number
Plesk Obsidian 18.0.72 Web Pro Edition
Last Night Upgraded to latest Mariadb 11.4.7 version and to the latest Plesk Obsidian 18.0.72 version

Prior to that I've Installed Varnish varnishmng.sh to test it on my Domains.
All worked fine and enabled / Disabled Varnish on Domains and Subdomains for testing.

The problems started when Upgraded to latest Mariadb 11.4.7 version and to the latest Plesk Obsidian 18.0.72 version
Since then all domains and Subdomains configuration messed up with apache2 Configurations and all webpages went on redirection loop.

Now is impossible to use varnishmng.sh to enable or disable varnish cache on domains withour errors >> mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead

varnish-status.jpg
As you see above the Varnish is working but if I disable cache on domains they become unreachable as you see below..

page-problems.jpg
Also I can't use Nginx as proxy because I get almost the same issue.

Now the BIG Question....

How can I fix this mess ?
How can I reconfigure all domains

I tried to restore a Backup before the Update but not Working

Below is an example of Configuration from a Domain from Webserver Configurations Troubleshooter

Code: 
#ATTENTION!
#
#DO NOT MODIFY THIS FILE BECAUSE IT WAS GENERATED AUTOMATICALLY,
#SO ALL YOUR CHANGES WILL BE LOST THE NEXT TIME THE FILE IS GENERATED.
#IF YOU REQUIRE TO APPLY CUSTOM MODIFICATIONS, PERFORM THEM IN THE FOLLOWING FILES:
#/var/www/vhosts/system/xiaomi-miui.gr/conf/vhost.conf
#/var/www/vhosts/system/xiaomi-miui.gr/conf/vhost_ssl.conf
<IfModule mod_ssl.c>

    <VirtualHost 127.0.0.1:7081 >
        ServerName "xiaomi-miui.gr"
        ServerAlias "www.xiaomi-miui.gr"
        ServerAlias "ipv6.xiaomi-miui.gr"
        ServerAlias "ipv4.xiaomi-miui.gr"
        ServerAlias "default-144-76-112-214"
        UseCanonicalName Off

        CustomLog /var/www/vhosts/system/xiaomi-miui.gr/logs/access_ssl_log plesklog
        ErrorLog "/var/www/vhosts/system/xiaomi-miui.gr/logs/error_log"

        DocumentRoot "/var/www/vhosts/xiaomi-miui.gr/xiaomi-miui.gr"

        <IfModule mod_suexec.c>
            SuexecUserGroup "dagalidis_xiaomi" "psacln"
        </IfModule>

        <IfModule mod_userdir.c>
            UserDir "/var/www/vhosts/xiaomi-miui.gr/web_users/*"
        </IfModule>

        <IfModule mod_sysenv.c>
            SetSysEnv PP_VHOST_ID "b2c371c4-83b3-4ebd-8935-eca0628dc676"
        </IfModule>

        ScriptAlias "/cgi-bin/" "/var/www/vhosts/xiaomi-miui.gr/xiaomi-miui.gr/cgi-bin/"

        Alias "/plesk-stat" "/var/www/vhosts/system/xiaomi-miui.gr/statistics"
        <Location  /plesk-stat/>
            Options +Indexes
        </Location>
        <Location  /plesk-stat/logs/>
            Require valid-user
        </Location>
        Alias /webstat /var/www/vhosts/system/xiaomi-miui.gr/statistics/webstat
        Alias /webstat-ssl /var/www/vhosts/system/xiaomi-miui.gr/statistics/webstat-ssl
        Alias /ftpstat /var/www/vhosts/system/xiaomi-miui.gr/statistics/ftpstat
        Alias /anon_ftpstat /var/www/vhosts/system/xiaomi-miui.gr/statistics/anon_ftpstat
        Alias /awstats-icon /usr/share/awstats/icon

        SSLEngine on
        SSLVerifyClient none
        SSLCertificateFile /opt/psa/var/certificates/scfx3vLr1

        TimeOut 3000
        <Directory /var/www/vhosts/xiaomi-miui.gr/xiaomi-miui.gr>

            <IfModule mod_python.c>
                <Files ~ (\.py$)>
                    SetHandler python-program
                    PythonHandler mod_python.cgihandler
                </Files>
            </IfModule>
            <IfModule mod_fcgid.c>
                <Files ~ (\.fcgi$)>
                    SetHandler fcgid-script
                    Options +ExecCGI
                </Files>
            </IfModule>
            <IfModule mod_proxy_fcgi.c>
                ProxyFCGISetEnvIf "true" SERVER_ADDR "144.76.112.214"
                <Files ~ (\.php$)>
                    SetHandler proxy:unix:/var/www/vhosts/system/xiaomi-miui.gr/php-fpm.sock|fcgi://127.0.0.1:9000
                </Files>
            </IfModule>

            SSLRequireSSL

            Options -Includes +ExecCGI

        </Directory>

        <Directory /var/www/vhosts/xiaomi-miui.gr/web_users>

            <IfModule mod_php4.c>
                php_admin_flag engine off
            </IfModule>

            <IfModule mod_php5.c>
                php_admin_flag engine off
            </IfModule>

            <IfModule mod_php7.c>
                php_admin_flag engine off
            </IfModule>

        </Directory>

        Alias /error_docs /var/www/vhosts/xiaomi-miui.gr/error_docs
        ErrorDocument 400 /error_docs/bad_request.html
        ErrorDocument 401 /error_docs/unauthorized.html
        ErrorDocument 403 /error_docs/forbidden.html
        ErrorDocument 404 /error_docs/not_found.html
        ErrorDocument 500 /error_docs/internal_server_error.html
        ErrorDocument 405 /error_docs/method_not_allowed.html
        ErrorDocument 406 /error_docs/not_acceptable.html
        ErrorDocument 407 /error_docs/proxy_authentication_required.html
        ErrorDocument 412 /error_docs/precondition_failed.html
        ErrorDocument 414 /error_docs/request_uri_too_long.html
        ErrorDocument 415 /error_docs/unsupported_media_type.html
        ErrorDocument 501 /error_docs/not_implemented.html
        ErrorDocument 502 /error_docs/bad_gateway.html
        ErrorDocument 503 /error_docs/maintenance.html

        DirectoryIndex "index.html" "index.cgi" "index.pl" "index.php" "index.xhtml" "index.htm" "index.shtml"

        Include "/var/www/vhosts/system/xiaomi-miui.gr/conf/vhost_ssl.conf"

        <Directory /var/www/vhosts/xiaomi-miui.gr>
            Options -FollowSymLinks
            AllowOverride AuthConfig FileInfo Indexes Limit Options=Indexes,SymLinksIfOwnerMatch,MultiViews,ExecCGI,Includes,IncludesNOEXEC
        </Directory>

        #extension sslit begin

        #extension sslit end

        #extension letsencrypt begin
        Alias /.well-known/acme-challenge "/var/www/vhosts/default/htdocs/.well-known/acme-challenge"

        <Location /.well-known/acme-challenge/>
            # Require all granted
            Order Deny,Allow
            Allow from all
            Satisfy any
        </Location>

        <LocationMatch "^/.well-known/acme-challenge/(.*/|)\.">
            # Require all denied
            Order Allow,Deny
            Deny from all
        </LocationMatch>
        #extension letsencrypt end

        #extension wp-toolkit begin

        #extension wp-toolkit end

        #extension sectigo begin
        AliasMatch "^/.well-known/pki-validation/(?!fileauth.txt)$" "/var/www/vhosts/default/htdocs/.well-known/pki-validation/$1"

        <Location /.well-known/pki-validation/>
            # Require all granted
            Order Deny,Allow
            Allow from all
            Satisfy any
        </Location>

        <LocationMatch "^/.well-known/pki-validation/(.*/|)\.">
            # Require all denied
            Order Allow,Deny
            Deny from all
        </LocationMatch>
        #extension sectigo end
    </VirtualHost>

</IfModule>

<VirtualHost 127.0.0.1:7080 >
    ServerName "xiaomi-miui.gr"
    ServerAlias "www.xiaomi-miui.gr"
    ServerAlias "ipv6.xiaomi-miui.gr"
    ServerAlias "ipv4.xiaomi-miui.gr"
    ServerAlias "default-144-76-112-214"
    UseCanonicalName Off

    CustomLog /var/www/vhosts/system/xiaomi-miui.gr/logs/access_log plesklog
    ErrorLog "/var/www/vhosts/system/xiaomi-miui.gr/logs/error_log"

    Include "/var/www/vhosts/system/xiaomi-miui.gr/conf/vhost.conf"

    <IfModule mod_rewrite.c>
        RewriteEngine On
        RewriteCond %{HTTPS} off
        RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L,QSA]
    </IfModule>
</VirtualHost>

You can see the problem on links below...

1. https://xiaomi-miui.gr
2. https://forums.xiaomi-miui.gr

I managed somehow to make domains UP, but the problem remains and the pages dropped in Redirection loop randomly.

I don't know if is possible to force reinstallation on latest Plesk Update without losing data and Configurations of all of 31 domains and Subdomains.

Any help is welcome - My head will explode soon LOL

Dimitris
 
To solve the warning:
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
Click to expand...
Try to edit the varnishmng.sh script and replace mysql with mariadb on line 19 so the function looks like:
Bash: 
function sqlQuery(){ # Handling PSA queries with this one.
    MYSQL_PWD=$MYSQL_PASSWORD mariadb -Ns -uadmin -D psa -e "$@"
}

I am not sure if that will solve all your issues. But this will get rid of the mysql warning you're getting.
 
Last edited:
Don't Ask how I did it - because I really don't know - but right now all my domains (and 31 subdomains) are up and running.

I'm afraid to change anything on Configurations or to Remove Varnish.
Time to take a cup of coffee and deep breaths - thanks god, my nightmare (thank you Plesk) ended..
 
You must log in or register to reply here.

Similar threads

J.Wick
Let's Encrypt Directives Left Over in NGINX.conf when moving to other SSL options.
Replies
6
Views
4K
scsa20
scsa20
D
Input How to run Magento 2 on Plesk Obsidian 18 without Docker
Replies
8
Views
8K
Isolde
I
P
Issue pki-validation nginx and sectigo issue
Replies
2
Views
5K
jmcouillard
J
TimReeves
Resolved Webmail - PHP not working, file downloaded not executed
Replies
2
Views
3K
aslotta
aslotta
U
Issue Error message ID 19494#0, 5467#0 and ModSecurity
Replies
3
Views
4K
Peter Debik
P
Back
Top