Results 1 to 1 of 1

Thread: Zucker Reports on replicated copy db

  1. #1
    mvngti is offline Sugar Community Member
    Join Date
    Oct 2007
    Location
    South Africa
    Posts
    510

    Default Zucker Reports on replicated copy db

    I just built a logic hook that makes ZuckerReports' java reports run against a replicated copy of the DB, thus freeing up resources on the live DB.
    I figured this is worth sharing!

    1. Add a parameter 'report_host_name' to sugar_config in config_override.php
    2. Create an after_retrieve logic hook on the ZuckerReportTemplate module with this in it.


    PHP Code:
    if (isset($sugar_config['report_host_name']))
    {
             
    $sugar_config['dbconfig']['db_host_name'] = $sugar_config['report_host_name'];

    By the time Zucker reads the config and build the java cmd file it reads the modified config and points the java at the replication slave!
    Last edited by mvngti; 2010-11-17 at 08:04 AM. Reason: Typo
    --


    Marnus van Niekerk

    There are only 10 types of people in the world
    those who can read binary and those who don't

    Modules:
    CE Teams - Upgrade safe teams module for Community Edition
    FieldACL - Field Level Access Control for Community Edition
    EditLogicHooks - Create and edit Logic Hooks from the Admin GUI
    FlexibleChartDashlet - Display any data in a Dashlet Chart
    DocumentThumbnails - Thumbnails for Documents module

    Many questions can be answered by reading the Developers Manual

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. i reports + zucker reports error
    By sidh211 in forum Developer Help
    Replies: 8
    Last Post: 2010-07-07, 09:27 AM
  2. How to integrate the Jasper/I reports/ Zucker reports with SugarCE 5.5
    By rishikeshms in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2009-12-03, 04:03 AM
  3. Replies: 2
    Last Post: 2007-11-26, 10:52 AM
  4. Replies: 0
    Last Post: 2007-04-10, 06:18 PM
  5. Replies: 0
    Last Post: 2007-02-26, 03:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •