chicks

# Need to install data studio for JDBC driver:
http://www.ibm.com/developerworks/downloads/im/data/

# Also
http://www-01.ibm.com/support/docview.wss?uid=swg27016878

# Data Studio:
https://iwm.dhe.ibm.com/sdfdl/v2/regs2/rderwin0/capilano/Xa.2/Xb.YZuqrdMh2VbH5-oLrjMnzn14lxn0Ys0mc2jXWvchDw/Xc.IBMIM_win32.exe/Xd./Xf.LPr.D1vc/Xg.7454885/Xi.swg-iim-ws/XY.regsrvs/XZ.QQrR8mvCDmR69vL4xEDDQMs63O8/IBMIM_win32.exe
https://iwm.dhe.ibm.com/sdfdl/v2/regs2/rderwin0/capilano/Xa.2/Xb.YZuqrdMh2VbH5-oLrjMnzn14lxn0Ys0mc2jXtNC0zA/Xc.IBMIM_linux.zip/Xd./Xf.LPr.D1vc/Xg.7454885/Xi.swg-iim-ws/XY.regsrvs/XZ.cwd8ycc8-C2b5c8AsVsDZ9c7HfM/IBMIM_linux.zip

chicks

find . \( \! -user apache -o \! -group apache \) -print0 | xargs -0 -r chown apache:apache
find . -type d \! -perm 2770 -print0 | xargs -0 -r chmod 2770
find . -type f \! -perm  660 -print0 | xargs -0 -r chmod 660

chicks

        $sql = "SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='%s' AND engine='MyISAM' AND table_name NOT IN (SELECT table_name FROM INFORMATION_SCHEMA.statistics WHERE index_type='FULLTEXT' AND table_schema='%s')";
        $result = $db->query(sprintf($sql,
                mysql_escape_string($instance->getName()),
                mysql_escape_string($instance->getName())
        ));
        while ($row = $db->fetch_array($result)) {
                $tables[] = $row[0];
        }

        foreach ($tables as $table) {

chicks

for t in $(mysql -NBA -D <database_name> -e 'show tables') 
do 
    echo "DUMPING TABLE: $t"
    mysqldump <database_name> $t | gzip > <some_dir>/$t.sql.gz
done

chicks

<?php

//sugarcrm/custom/Extension/modules/KBContents/Ext/Vardefs/vardefs.php

$dictionary['KBContent']['indices'] = array(
    array('name' => 'kbcontentspk', 'type' => 'primary', 'fields' => array('id')),
    array('name' => 'fts_unique_idx', 'type' => 'unique', 'fields' => array('kb_index')),
    //array('name' => '', 'type' => 'fulltext', 'fields' => array('kbdocument_body'), 'db' => 'mysql'),
    //array('name' => 'kbcontentsftk', 'type' => 'fulltext', 'fields' => array('kbdocument_body'), 'db' => 'ibm_db2', 'options' => 'UPDATE FREQUENCY D(*) H(*) M(0, 5, 10, 15, 20, 25, 30, 35, 40, 45, 50, 55) UPDATE MINIMUM 1', 'message_locale' => 'en_US'), // Update the TS index every 5 minutes if only 1 record was updated
    //array('name' => 'kbcontentsftk', 'type' => 'fulltext', 'fields' => array('kbdocument_body'), 'db' => 'oci8', 'indextype' => 'CTXSYS.CONTEXT', 'parameters' => 'sync (on commit)'),

chicks

#!/bin/bash
# chkconfig: 2345 90 90
# description: Cognos Business Intelligence
### BEGIN INIT INFO
# Provides: cognos
# Required-Start: network
# Required-Stop: network
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Description: Start the program

chicks

# Checkout the right git repo
git clone [email protected]:sugarcrm/cognos.git
git checkout -b master origin/master

# Setup Apache proxy for cognos proxy
Add this to /etc/httpd/conf.d/cognos.conf
<VirtualHost *:80>
  ServerName cognos.sugarcrmdemo.com

  ProxyRequests Off

chicks

UPDATE contacts_cstm SET lead_score_rank_c =
 ELT(1 + FLOOR(RAND()*5), 'Inquiry', 'Prospect', 'Marketing Qualified', 'Sales Accepted', 'Sales Qualified');
 
UPDATE contacts_cstm SET engagement_score_rank_c =
 ELT(1 + FLOOR(RAND()*3), 'Passive', 'Active', 'Engaged');
 

chicks

client.init();
client.url('http://localhost:8888/s721');
client.waitUntilVisible('a[name="login_button"]', function(err, res) {});
client.setValue('input[name="username"]', 'admin');
client.setValue('input[name="password"]', 'letmein');
client.click('a[name="login_button"]');
client.waitUntilVisible('#tutorial-controls');
client.click('a[title=Done]');
client.waitUntilVisible('button.close')

chicks

<?php
//-----------------------------------------------------------------------------
if(!defined('sugarEntry'))define('sugarEntry', true);
require_once('include/entryPoint.php');
//-----------------------------------------------------------------------------
$db = DBManagerFactory::getInstance();

//-- TEMPLATE = birgit 
$query = "SELECT id from users where user_name='birgit'";
$result = $db->query($query, true,"Error fetching birgit: ");