Jump to content

Recommended Posts

Hi Andew Hill,

We are Running revive in Google cloud Kubernets setup  and Installed revive and ad delivery works fine.Revive database running in separate instance.

Automaintenance not works, So we tried to run the http://{our reviveadserverurl}/maintenance/maintenance.php via browser.Its return the "An error occurred while accessing the database Due to a problem with the database Revive Adserver couldn't retrieve or store data."Except this maintenance page remaining page database connection works fine.We need to change anything in var/{adverserver}.conf.php.

Please support me to resolve this issue.

Link to post
Share on other sites
  • 1 year later...

Hi everyone, 

we got a similar issue.

We install 2 revive (5.2.0) in master-slave config:

OS: Ubuntu 18.04
PHP:  7.4.18 
NGINX : nginx/1.21.0
MYSQL: 5.7.34 (community) 

The master get his consolidation and works fine.
The Slave (Delivery Server).
Already configured de lb database in domain.conf.php pointing to master.
but in the minute that run's de revive/scripts/maintenance/maintenance-distributed.php we get the next error.

 

May 27 13:24:28 -0300 OX-60afc7bcbcb56 [emergency]  -111 :: MDB2_Error Object
(
    [error_message_prefix] =>
    [mode] => 1
    [level] => 1024
    [code] => -4
    [message] => MDB2 Error: not found
    [userinfo] => connect: [Error message: extension mysql is not compiled into PHP]
[Native code: 0]

    [backtrace] => Array
        (
            [0] => Array
                (
                    [file] => revive-adserver-5.2.0/lib/pear/MDB2.php
                    [line] => 960
                    [function] => __construct
                    [class] => PEAR_Error
                    [type] => ->
                    [args] => Array
                        (
                            [0] => MDB2 Error: not found
                            [1] => -4
                            [2] => 1
                            [3] =>
                            [4] => connect: [Error message: extension mysql is not compiled into PHP]

 

first we think was some php extension miss.

# php --ini |grep mysql
Additional .ini files parsed:      /etc/php/7.4/cli/conf.d/10-mysqlnd.ini,
/etc/php/7.4/cli/conf.d/20-mysqli.ini,
/etc/php/7.4/cli/conf.d/20-pdo_mysql.ini,

 

Then we think that mdb2 wasn't installed on server.

# apt list |grep mdb2

libmdb2/bionic,now 0.7.1-6 amd64 [installed]
php-mdb2/bionic,now 2.5.0b5-2 all [installed,automatic]
php-mdb2-driver-mysql/bionic,now 1.5.0b4-2 all [installed]

php-mdb2-driver-pgsql/bionic 1.5.0b4-2 all

 

If someone find one solution to this I would greatly appreciate it.

Cheers From Chile.
Daniel.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...