Getting blank screen / error 500 instead of update wizard

[w-sky]

Hi there, I tried to upgrade our desperately outdated Revive 3.0.3 to Revive 4 exactly following the upgrade docs at https://www.revive-adserver.com/support/upgrading/

Copied the database, extrated the archive to a new folder ("revive4"), copied the configuration file to the new location, changed database info, and everything else.

But instead of the upgrade wizard I'm getting only an empty page (HTTP error 500) at www.my.domain/revive4 – the URL has changed to http://www.my.domain/revive4/www/admin/install.php but the screen is empty.

Also there was no error.log. The Revive installation is working fine otherwise, I checked this by removing the configuration file: the installtion wizard starts and I can enter the database info.

Anybody some idea?

This is www.my.domain.conf.php :

;<?php exit; ?>
;*** DO NOT REMOVE THE LINE ABOVE ***
 
[openads]
installed=1
requireSSL=
sslPort=443
 
[ui]
enabled=1
applicationName=
headerFilePath=
footerFilePath=
logoFilePath=
headerForegroundColor=
headerBackgroundColor=
headerActiveTabColor=
headerTextColor=
gzipCompression=1
combineAssets=1
dashboardEnabled=1
hideNavigator=
zoneLinkingStatistics=1
supportLink=
 
[database]
type=mysql
host=localhost
socket=
port=3306
username=XXX
password=XXX
name=XXX
persistent=
mysql4_compatibility=1
protocol=tcp
compress=
ssl=
capath=
ca=
 
[databaseCharset]
checkComplete=1
clientCharset=latin1
 
[databaseMysql]
statisticsSortBufferSize=
 
[databasePgsql]
schema=
 
[webpath]
admin="www.my.domain/openx/www/admin"
delivery="www.my.domain/openx/www/delivery"
deliverySSL="www.my.domain/openx/www/delivery"
images="www.my.domain/openx/www/images"
imagesSSL="www.my.domain/openx/www/images"
 
[file]
click="ck.php"
conversionvars="tv.php"
content="ac.php"
conversion="ti.php"
conversionjs="tjs.php"
flash="fl.js"
google="ag.php"
frame="afr.php"
image="ai.php"
js="ajs.php"
layer="al.php"
log="lg.php"
popup="apu.php"
view="avw.php"
xmlrpc="axmlrpc.php"
local="alocal.php"
frontcontroller="fc.php"
singlepagecall="spc.php"
spcjs="spcjs.php"
xmlrest="ax.php"
 
[store]
mode=0
webDir="/usr/home/public_html/openx/www/images"
ftpHost=
ftpPath=
ftpUsername=
ftpPassword=
ftpPassive=
 
[origin]
type=
host=
port=80
script="/www/delivery/dxmlrpc.php"
timeout=10
protocol=http
 
[allowedBanners]
sql=1
web=1
url=1
html=1
text=1
video=1
 
[delivery]
cacheExpire=3
cacheStorePlugin="deliveryCacheStore:oxCacheFile:oxCacheFile"
cachePath=
acls=1
aclsDirectSelection=1
obfuscate=
execPhp=1
ctDelimiter=__
chDelimiter=","
keywords=
cgiForceStatusHeader=
clicktracking=generic
ecpmSelectionRate="0.9"
enableControlOnPureCPM=1
 
[defaultBanner]
imageUrl=
 
[p3p]
policies=1
compactPolicy="CUR ADM OUR NOR STA NID"
policyLocation=
 
[graphs]
ttfDirectory=
ttfName=
 
[logging]
adRequests=1
adImpressions=1
adClicks=1
trackerImpressions=1
reverseLookup=
proxyLookup=
defaultImpressionConnectionWindow=
defaultClickConnectionWindow=
ignoreHosts=
ignoreUserAgents=
enforceUserAgents=
blockAdClicksWindow=5
 
[maintenance]
autoMaintenance=false
timeLimitScripts=1800
operationInterval=60
blockAdImpressions=0
blockAdClicks=0
channelForecasting=
pruneCompletedCampaignsSummaryData=
pruneDataTables=1
ecpmCampaignLevels="9|8|7|6"
 
[priority]
instantUpdate=true
defaultClickRatio="0.005"
defaultConversionRatio="0.0001"
randmax=2147483647
 
[performanceStatistics]
defaultImpressionsThreshold=10000
defaultDaysIntervalThreshold=30
 
[table]
prefix=hajo_ox_
type=MYISAM
account_preference_assoc=account_preference_assoc
account_user_assoc=account_user_assoc
account_user_permission_assoc=account_user_permission_assoc
accounts=accounts
acls=acls
acls_channel=acls_channel
ad_category_assoc=ad_category_assoc
ad_zone_assoc=ad_zone_assoc
affiliates=affiliates
affiliates_extra=affiliates_extra
agency=agency
application_variable=application_variable
audit=audit
banners=banners
campaigns=campaigns
campaigns_trackers=campaigns_trackers
category=category
channel=channel
clients=clients
data_intermediate_ad=data_intermediate_ad
data_intermediate_ad_connection=data_intermediate_ad_connection
data_intermediate_ad_variable_value=data_intermediate_ad_variable_value
data_raw_ad_click=data_raw_ad_click
data_raw_ad_impression=data_raw_ad_impression
data_raw_ad_request=data_raw_ad_request
data_raw_tracker_impression=data_raw_tracker_impression
data_raw_tracker_variable_value=data_raw_tracker_variable_value
data_summary_ad_hourly=data_summary_ad_hourly
data_summary_ad_zone_assoc=data_summary_ad_zone_assoc
data_summary_channel_daily=data_summary_channel_daily
data_summary_zone_impression_history=data_summary_zone_impression_history
images=images
log_maintenance_forecasting=log_maintenance_forecasting
log_maintenance_priority=log_maintenance_priority
log_maintenance_statistics=log_maintenance_statistics
password_recovery=password_recovery
placement_zone_assoc=placement_zone_assoc
preferences=preferences
session=session
targetstats=targetstats
trackers=trackers
tracker_append=tracker_append
userlog=userlog
users=users
variables=variables
variable_publisher=variable_publisher
zones=zones
 
[email]
logOutgoing=1
headers=
qmailPatch=
fromName=
fromAddress="[email protected]"
fromCompany="Firma"
useManagerDetails=
 
[log]
enabled=
methodNames=
lineNumbers=
type=file
name="debug.php"
priority=3
ident=OX
paramsUsername=
paramsPassword=
fileMode=0644
 
[deliveryLog]
enabled=
name="delivery.log"
fileMode=0644
priority=6
 
[cookie]
permCookieSeconds=31536000
maxCookieSize=2048
 
[debug]
logfile=
production=1
sendErrorEmails=
emailSubject="Error from OpenX"
email="[email protected]"
emailAdminThreshold=3
errorOverride=1
showBacktrace=
disableSendEmails=
 
[var]
prefix=OA_
cookieTest=ct
cacheBuster=cb
channel=source
dest=oadest
logClick=log
n=n
params=oaparams
viewerId=OAID
viewerGeo=OAGEO
campaignId=campaignid
adId=bannerid
creativeId=cid
zoneId=zoneid
blockAd=OABLOCK
capAd=OACAP
sessionCapAd=OASCAP
blockCampaign=OACBLOCK
capCampaign=OACCAP
sessionCapCampaign=OASCCAP
blockZone=OAZBLOCK
capZone=OAZCAP
sessionCapZone=OASZCAP
vars=OAVARS
trackonly=trackonly
openads=openads
lastView=OXLIA
lastClick=OXLCA
blockLoggingClick=OXBLC
fallBack=oxfb
trace=OXTR
 
[lb]
enabled=
type=mysql
host=localhost
port=3306
username=
password=
name=
persistent=
 
[sync]
checkForUpdates=1
shareStack=
 
[oacSync]
protocol=https
host="sync.revive-adserver.com"
path="/xmlrpc.php"
httpPort=80
httpsPort=443
 
[authentication]
type=internal
deleteUnverifiedUsersAfter=2419200
 
[geotargeting]
type=
showUnavailable=
 
[pluginPaths]
packages="/plugins/etc/"
plugins="/plugins/"
admin="/www/admin/plugins/"
var="/var/plugins/"
 
[pluginUpdatesServer]
protocol=http
host="code.openx.org"
path="/openx/plugin-updates"
httpPort=80
 
[pluginSettings]
enableOnInstall=1
useMergedFunctions=1
 
[plugins]
openXBannerTypes=1
openXDeliveryLimitations=1
openX3rdPartyServers=1
openXReports=1
openXDeliveryCacheStore=1
openXMaxMindGeoIP=1
openXInvocationTags=1
openXDeliveryLog=1
openXVideoAds=1
 
[pluginGroupComponents]
oxHtml=1
oxText=1
Client=1
Geo=1
Site=1
Time=1
ox3rdPartyServers=1
oxReportsStandard=1
oxReportsAdmin=1
oxCacheFile=1
oxMemcached=1
oxMaxMindGeoIP=1
oxInvocationTags=1
oxDeliveryDataPrepare=1
oxLogClick=1
oxLogConversion=1
oxLogImpression=1
oxLogRequest=1
vastInlineBannerTypeHtml=1
vastOverlayBannerTypeHtml=1
oxLogVast=1
vastServeVideoPlayer=1
videoReport=1
 
[audit]
enabled=1
enabledForZoneLinking=
 
[install]
marketPcHost="https://pc.openx.com"
marketPcApiHost="https://api.pc.openx.com"
fallbackPcApiHost="http://api.pc.openx.com"
marketPublicApiUrl="api/public/v2"
marketCaptchaUrl="https://pc.openx.com/api/captcha"
publisherSupportEmail="[email protected]"
 
[Client]
sniff=1
 
[deliveryHooks]
cacheStore="deliveryCacheStore:oxCacheFile:oxCacheFile|deliveryCacheStore:oxMemcached:oxMemcached"
cacheRetrieve="deliveryCacheStore:oxCacheFile:oxCacheFile|deliveryCacheStore:oxMemcached:oxMemcached"
postInit="deliveryLimitations:Client:initClientData"
logImpressionVast="deliveryLog:oxLogVast:logImpressionVast"
preLog="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryDataPrepare:oxDeliveryDataPrepare:dataPageInfo|deliveryDataPrepare:oxDeliveryDataPrepare:dataUserAgent"
logClick="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryLog:oxLogClick:logClick"
logConversion="deliveryLog:oxLogConversion:logConversion"
logConversionVariable="deliveryLog:oxLogConversion:logConversionVariable"
logImpression="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryLog:oxLogImpression:logImpression"
logRequest="deliveryDataPrepare:oxDeliveryDataPrepare:dataCommon|deliveryLog:oxLogRequest:logRequest"
 
[oxCacheFile]
cachePath=
 
[oxMemcached]
memcachedServers=
memcachedExpireTime=
 
[oxMaxMindGeoIP]
geoipCountryLocation=
geoipRegionLocation=
geoipCityLocation=
geoipAreaLocation=
geoipDmaLocation=
geoipOrgLocation=
geoipIspLocation=
geoipNetspeedLocation=
 
[oxInvocationTags]
isAllowedAdframe=1
isAllowedAdjs=1
isAllowedAdlayer=1
isAllowedAdview=0
isAllowedAdviewnocookies=1
isAllowedLocal=1
isAllowedPopup=0
isAllowedXmlrpc=0
 
[oxMarket]
marketHost="https://pc.openx.com"
marketPcApiHost="https://api.pc.openx.com"
fallbackPcApiHost="http://api.pc.openx.com"
marketXmlRpcUrl="api/xml-rpc"
marketPublicApiUrl="api/public/v2"
marketCustomContentUrl="market/content"
marketMenuUrl="market/index/menu"
defaultFloorPrice="0.10"
marketAccountIdParamName=pa
marketWelcomeUrl="market/index/welcome"
marketCaptchaUrl="https://pc.openx.com/api/captcha"
openXTermsUrl="http://www.openx.org/terms"
openXPrivacyUrl="http://www.openx.org/privacy"
dictionaryCacheLifeTime=86400
multipleAccountsMode=0
separateImportStatsScript=0
allowSkipAccountsInImportStats=1
maxSkippingPeriodInDays=7
adSizesPreviewUrl="http://www.openx.org/preview-ad-sizes"
 
[oxMarketDelivery]
brokerHost="bid.openx.net"
 
[openXWorkflow]
adSizesPreviewUrl="http://www.openx.org/preview-ad-sizes"
marketHost="https://pc.openx.com"
marketPcApiHost="https://api.pc.openx.com"
fallbackPcApiHost="http://api.pc.openx.com"
marketCustomContentUrl="market/content"
 
[vastOverlayBannerTypeHtml]
isVastOverlayAsTextEnabled=1
isVastOverlayAsSwfEnabled=1
isVastOverlayAsImageEnabled=1
isVastOverlayAsHtmlEnabled=1
 
[vastServeVideoPlayer]
isAutoPlayOfVideoInOpenXAdminToolEnabled=0
 
[trim]
1=
	

Edited November 3, 2016 by w-sky

[Erik Geurts]

When a 500 error occurs, Apache (or whatever webserver software you use) will log the cause of that error. I recommend reviewing the error log or discussing this with your hosting provider or sysadmin. Once the cause of the error has been fixed, you should be good to go again.

[w-sky]

I'm not getting access to the Apache or PHP logs, but I can activate PHP error reporting on my server.

This is what I get, it says the error is a dl() call. dl() has been disabled by default since PHP 5.3: as refered on the php documentation: http://php.net/manual/en/function.dl.php

Must I enable it?

Fatal error: Uncaught Error: Call to undefined function dl() in /public_html/revive4/lib/pear/PEAR.php:758
Stack trace:
#0 /public_html/revive4/lib/pear/MDB2/Driver/mysql.php(400): PEAR->loadExtension('mysql')
#1 /public_html/revive4/lib/OA/DB.php(196): MDB2_Driver_mysql->connect()
#2 /public_html/revive4/lib/OA/DB/Table.php(86): OA_DB::singleton()
#3 /public_html/revive4/lib/OA/DB/Table.php(74): OA_DB_Table->_getDbConnection()
#4 /public_html/revive4/lib/OA/Upgrade/Upgrade.php(129): OA_DB_Table->__construct()
#5 /public_html/revive4/lib/OX/Admin/UI/Install/InstallController.php(119): OA_Upgrade->__construct()
#6 /public_html/revive4/lib/OX/Admin/UI/Install/InstallController.php(93): OX_Admin_UI_Install_InstallController->initUpgrader()
#7 /public_html/revive4/lib/OX/Admin/UI/Controller/BaseController.php(81): OX_Admin_UI_Install_InstallController->init()
#8 /public_html/revive4/www/admin/install.php(41): OX_Admin_UI_Controller_BaseC in /public_html/revive4/lib/pear/PEAR.php on line 758
	

Edited November 7, 2016 by w-sky

[Ian]

which PHP version do you run ?

[w-sky]

PHP 7.0.12. But I had the same problem with 5.6.

Edited November 7, 2016 by w-sky

[Ian]

Try editing your config file in the "var/" folder.

Change :

The part which says "mysql" to "mysqli" at the following section :

 

[database]
type=mysql

[w-sky]

Thanks, that helped! The upgrade wizard is running…

[Ian]

Cool!