Cannot Reinstall Openx Market, Tried Michal's Instructions Too Options

[Kaan]

Hi guys,

I'm struggling to reinstall the OpenX Market plugin but I continually get this error when I try to select the zip file and import via the Plugins screen within OpenX.

CODE

Failed to register schema version for oxMarket
Task failed _registerSchema
Failed to remove configuration settings for oxMarket
Task failed _unregisterSettings
Failed to install oxMarket
Failed to install plugins for package openXMarket
Failed to remove configuration settings for oxMarket
Task failed _unregisterSettings
Failed to uninstall oxMarket
Failed to enable plugin oxMarket for package openXMarket
Failed to disable plugin oxMarket for package openXMarket

I've followed these instructions without success.

http://forum.openx.org/index.php?showtopic=503427614

Any suggestions?

Running OpenX 2.8.1 with everything working except I had some trouble with the OpenX plugin after upgrading from 2.8.0 and now after uninstalling the plugin manually (following Michal's instructions), I cannot get it to reinstall.

[Mentor]

Hi Kaan,

You get the following error: 'Failed to register schema version for oxMarket'

Please make sure you have followed all steps of the manual Plugin uninstallation. It looks like you have not removed certain OpenX Market entries from OpenX database. That is why you get the error.

Please double check the Step 6 of the instruction: http://forum.openx.org/index.php?showtopic=503427614

[Kaan]

Hi Kaan,

You get the following error: 'Failed to register schema version for oxMarket'

Please make sure you have followed all steps of the manual Plugin uninstallation. It looks like you have not removed certain OpenX Market entries from OpenX database. That is why you get the error.

Please double check the Step 6 of the instruction: http://forum.openx.org/index.php?showtopic=503427614

Hi Michal,

I'll go through the steps again today and see if I missed anything. Will report back ASAP for you.

kk

[Kaan]

Hi Michal,

I can confirm that I followed all the steps within your instructions then restarted MySQL, lighttpd and my externally spawned FastCGI PHP processes to clear anything that might be lingering. I then downloaded openXMarket.zip from the OpenX installation I'm working on and attempted to upload and install it but I receive the same error.

CODE

Failed to write configuration settings
Task failed _registerSettings
Failed to remove configuration settings for oxMarket
Task failed _unregisterSettings
Failed to install oxMarket
Failed to install plugins for package openXMarket
Failed to remove configuration settings for oxMarket
Task failed _unregisterSettings
Failed to uninstall oxMarket
Failed to enable plugin oxMarket for package openXMarket
Failed to disable plugin oxMarket for package openXMarket

Reviewing what it's done, it appears to have correctly installed the plugin except for the database schema and the .conf.php file for this installation of OpenX.

I just checked the permissions on our .conf.php and found that it's been locked down. After changing the permissions on that file and trying to install the plugin again I now receive a the below error that that's missing a couple of lines.

CODE

Failed to register schema version for oxMarket
Task failed _registerSchema
Failed to install oxMarket
Failed to install plugins for package openXMarket
Failed to initialise table class for oxMarket
Failed to drop tables for oxMarket
Task failed _unregisterSchema
Failed to uninstall oxMarket

It looks like it's having trouble creating the relevant database tables, etc. is there anyway of providing more debugging information than this? The OpenX database user has all privileges on the table.

CODE

You are currently using OpenX v2.8.1 running on lighttpd 1.4.19, PHP 5.2.6-1+lenny3 and MySQL 5.0.51a-24+lenny1.

At this point, after fixing the .conf.php permissions issue, I can now see the OpenX Market plugin within the Plugins section of the OpenX installation but the relevant tables are still missing from the database. It appears as Enabled in the Plugins section but if I attempt to Disable it I receive the following error.

CODE

File not found
Failed to parse the plugin definitions contained in package openXMarket

I re-downloaded the OpenX 2.8.1 archive, extracted it and then diff'ed the openXMarket.zip on our installation and that fresh from the archive and they're identical.

Is it possible to manually recreate the tables as that seems to be the hinderence here. The tables we're using are MyISAM not InnoDB.

[Mentor]

Hi,

Have you followed the manual Market plugin uninstallation procedure once again just after the plugin installation failure when the config file was locked? Or did you unlock the file and try to install the plugin once again?

This information is very important for us.

[Kaan]

Hi,

Have you followed the manual Market plugin uninstallation procedure once again just after the plugin installation failure when the config file was locked? Or did you unlock the file and try to install the plugin once again?

This information is very important for us.

Hi Michal,

Most recently I unlocked the file, tried to install the plugin, completed the manul uninstall procedure and tried to install the plugin again without success. I have, however, tried the same steps with the config file locked a couple of days ago so it appears it happens in both situations.

I can go through the process once again in a specific way noting each step and the results, etc. if you that would help you. Let me know what you need me to do.

kk

[Mentor]

Hi,

Please follow once again the manual Market plugin uninstallation procedure, unlock the config file and try to install the Market plugin from 'openx/etc/plugins' once again using the OpenX user interface.

[Kaan]

Hi Michal,

I feel like an absolute idiot, I was sure that I'd done this correctly the past two or three times so I meticulously documented it for you to see if you could find the error and guess what? It worked.

Thanks for troubleshooting with me and apologies for the inconvenience! I'm not sure what I was doing wrong to be honest...

Step 1

CODE

us-ox-1:/var/www/network.alluremedia.com.au/docroot# rm -r plugins/deliveryAdRender/oxMarketDelivery plugins/maintenanceStatisticsTask/oxMarketMaintenance plugins/etc/oxMarket plugins/etc/oxMarketDelivery plugins/etc/oxMarketMaintenance www/admin/plugins/oxMarket
rm: cannot remove `plugins/deliveryAdRender/oxMarketDelivery': No such file or directory
rm: cannot remove `plugins/maintenanceStatisticsTask/oxMarketMaintenance': No such file or directory
rm: cannot remove `plugins/etc/oxMarket': No such file or directory
rm: cannot remove `plugins/etc/oxMarketDelivery': No such file or directory
rm: cannot remove `plugins/etc/oxMarketMaintenance': No such file or directory
rm: cannot remove `www/admin/plugins/oxMarket': No such file or directory

Step 2

CODE

us-ox-1:/var/www/network.alluremedia.com.au/docroot# rm plugins/etc/openXMarket.xml plugins/etc/openXMarket.readme.txt plugins/etc/openXMarket.uninstall.txt
rm: cannot remove `plugins/etc/openXMarket.xml': No such file or directory
rm: cannot remove `plugins/etc/openXMarket.readme.txt': No such file or directory
rm: cannot remove `plugins/etc/openXMarket.uninstall.txt': No such file or directory

Step 3

CODE

us-ox-1:/var/www/network.alluremedia.com.au/docroot# cd var/plugins/DataObjects/
us-ox-1:/var/www/network.alluremedia.com.au/docroot/var/plugins/DataObjects# rm Ext_market_assoc_data.php Ext_market_campaign_pref.php Ext_market_general_pref.php Ext_market_plugin_variable.php Ext_market_setting.php Ext_market_web_stats.php Ext_market_website_pref.php
rm: cannot remove `Ext_market_assoc_data.php': No such file or directory
rm: cannot remove `Ext_market_campaign_pref.php': No such file or directory
rm: cannot remove `Ext_market_general_pref.php': No such file or directory
rm: cannot remove `Ext_market_plugin_variable.php': No such file or directory
rm: cannot remove `Ext_market_setting.php': No such file or directory
rm: cannot remove `Ext_market_web_stats.php': No such file or directory
rm: cannot remove `Ext_market_website_pref.php': No such file or directory

Step 4

CODE

us-ox-1:/var/www/network.alluremedia.com.au/docroot/var/plugins/DataObjects# cat db_schema.ini
[data_bkt_a]
server_conv_id=129
server_ip=130
tracker_id=129
date_time=142
action_date_time=142
creative_id=129
zone_id=129
ip_address=130
action=1
window=1
status=1
[data_bkt_a__keys]
server_conv_id=K
server_ip=K
[data_bkt_a_var]
server_conv_id=129
server_ip=130
tracker_variable_id=129
value=34
date_time=142
[data_bkt_a_var__keys]
server_conv_id=K
server_ip=K
[data_bkt_c]
interval_start=142
creative_id=129
zone_id=129
count=1
[data_bkt_c__keys]
interval_start=K
creative_id=K
zone_id=K
[data_bkt_m]
interval_start=142
creative_id=129
zone_id=129
count=1
[data_bkt_m__keys]
interval_start=K
creative_id=K
zone_id=K
[data_bkt_r]
interval_start=142
creative_id=129
zone_id=129
count=1
[data_bkt_r__keys]
interval_start=K
creative_id=K
zone_id=K
us-ox-1:/var/www/network.alluremedia.com.au/docroot/var/plugins/DataObjects# cat db_schema.links.ini
us-ox-1:/var/www/network.alluremedia.com.au/docroot/var/plugins/DataObjects#

Step 5

CODE

us-ox-1:/var/www/network.alluremedia.com.au/docroot/var# cat network.alluremedia.com.au.conf.php | grep 'oxMarket'
us-ox-1:/var/www/network.alluremedia.com.au/docroot/var#

Step 6 - Tables have an oa_ prefix from OpenAds

CODE

us-ox-1:/var/www/network.alluremedia.com.au/docroot/var# mysql -u openx -p openx
Enter password:
Welcome to the MySQL monitor.  Commands end with; or \g.
Your MySQL connection id is 3369793
Server version: 5.0.51a-24+lenny1 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DROP TABLE oa_ext_market_assoc_data;
ERROR 1051 (42S02): Unknown table 'oa_ext_market_assoc_data'
mysql> DROP TABLE oa_ext_market_campaign_pref;
ERROR 1051 (42S02): Unknown table 'oa_ext_market_campaign_pref'
mysql> DROP TABLE oa_ext_market_general_pref;
ERROR 1051 (42S02): Unknown table 'oa_ext_market_general_pref'
mysql> DROP TABLE oa_ext_market_plugin_variable;
ERROR 1051 (42S02): Unknown table 'oa_ext_market_plugin_variable'
mysql> DROP TABLE oa_ext_market_setting;
ERROR 1051 (42S02): Unknown table 'oa_ext_market_setting'
mysql> DROP TABLE oa_ext_market_website_pref;
ERROR 1051 (42S02): Unknown table 'oa_ext_market_website_pref'
mysql> DROP TABLE oa_ext_market_web_stats;
ERROR 1051 (42S02): Unknown table 'ox_ext_market_web_stats'
mysql> DELETE FROM `oa_application_variable` WHERE name = 'tables_oxMarket';
Query OK, 0 rows affected (0.00 sec)
mysql> DELETE FROM `oa_application_variable` WHERE name = 'oxMarket_version';
Query OK, 0 rows affected (0.00 sec)
mysql> DELETE FROM `oa_application_variable` WHERE name = 'oxMarketMaintenance_version';
Query OK, 0 rows affected (0.00 sec)
mysql> DELETE FROM `oa_application_variable` WHERE name = 'oxMarketMaintenance_version';
Query OK, 0 rows affected (0.00 sec)
mysql> DELETE FROM `oa_application_variable` WHERE name = 'oxMarketDelivery_version';
Query OK, 0 rows affected (0.00 sec)

Step 7

CODE

us-ox-1:/var/www/network.alluremedia.com.au/docroot/var/cache# rm -rf ./*
us-ox-1:/var/www/network.alluremedia.com.au/docroot/var/cache#

Download OpenX Market plugin

CODE

kaank@caprica:~/Desktop$ wget http://network.alluremedia.com.au/etc/plugins/openXMarket.zip
--2009-06-25 11:11:45--  http://network.alluremedia.com.au/etc/plugins/openXMarket.zip
Resolving network.alluremedia.com.au... 67.19.81.186
Connecting to network.alluremedia.com.au|67.19.81.186|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 138188 (135K) [application/zip]
Saving to: `openXMarket.zip'

100%[============================================================================
=======================================>] 138,188      112K/s   in 1.2s    

2009-06-25 11:11:47 (112 KB/s) - `openXMarket.zip' saved [138188/138188]

kaank@caprica:~/Desktop$

[Mentor]

Hi,

I'm glad to hear that! If yo have any other problems please feel free to post on any forum.

[Dave B]

I have posted the fix at http://forum.openx.org/index.php?showtopic=503446351