Centova Technologies Forum

Centova Cast v3 => Bugs and issues => Topic started by: My Auto DJ on January 20, 2013, 12:32:38 pm

Title: Optimize database Error RC2
Post by: My Auto DJ on January 20, 2013, 12:32:38 pm
When clicking on the Optimize database link under Utilities I get a error

http://prntscr.com/pu2jy
Title: Re: Optimize database Error RC2
Post by: Centova - Steve B. on January 23, 2013, 01:38:12 pm
Hmm... if you open /usr/local/centovacast/etc/web.d/cc-interface.conf, do you have two stanzas that look like these?

Code: [Select]
# configure pubsub publisher location
location /publish {
...
}

# configure pubsub subscriber location
location /activity {
...
}

The error in the screenshot shows that nginx is reporting those locations as being missing... which shouldn't be possible, as the latest "stock" cc-interface.conf definitely includes them.

Title: Re: Optimize database Error RC2
Post by: My Auto DJ on January 24, 2013, 03:54:24 am
(1) I updated one server, went through everything to check for errors, when I clicked the Optimize Database Link I got the error
(2) Went to server 2, clicked the same link with no error
(3) Updated server 2 to RC2, went back to that link and it displayed the error only after the update
 

--- here is that section of  /usr/local/centovacast/etc/web.d/cc-interface.conf

<code>
   # configure pubsub publisher location
   location /publish {
         allow 127.0.0.1;
         deny all;

         set $push_channel_id $arg_id;
         push_publisher;

         push_store_messages on;
         push_message_timeout 15m;
         push_max_message_buffer_length 10;
   }

   # configure pubsub subscriber location
   location /activity {
         push_subscriber;

         push_subscriber_concurrency broadcast;
         push_authorized_channels_only on;
         set $push_channel_id $arg_id;
         default_type text/plain;
   }
</code>
Title: Re: Optimize database Error RC2
Post by: d walker on January 25, 2013, 04:55:38 am
Also getting error on my setup

See Screenshot
http://prntscr.com/qcp04 (http://prntscr.com/qcp04)

Dave
Title: Re: Optimize database Error RC2
Post by: Centova - Steve B. on January 27, 2013, 07:53:45 pm
Just an update to confirm that we've tracked this down... unfortunately it's a tricky one to properly fix as it will likely require patching nginx itself.  We should have an interim workaround for the next build though.