Group items tagged

Installing and Configuring Apache

apt-get install apache2

etc/init.d/apache2 start|stop|restart|reload|force-reload apacheclt start|stop|restart|...

mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql

Extract the Database

memory_limit - Recommended setting: 512M or higher. The memory_limit parameter mainly comes into play when executing large transactions such as mass update, export and import. If this setting is too low when trying to perform one of these actions, the end user will encounter a fatal error and the process will not complete. upload_max_filesize and post_max_size - Recommended setting: 30M or higher. Both of these settings work in conjunction with each other when uploading files through SugarCRM which includes future upgrades as well as document and note attachments. Please note that there is also a setting in the application which can limit file upload file size for end users so the settings in PHP should be high enough to allow any future upgrade files to be loaded without error. max_execution_time = Recommended setting: 300. This setting controls how long a PHP process will remain active. It is important to set this parameter to a value that will allow for large requests to complete if necessary but also will not hamper performance of the server if running too long.

In regards to PHP setup, the following parameters should be set with values as indicated:

Maximum upload size Admin > System Settings 30000000 (~30 MB) The 'Maximum upload size' controls the maximum file size your users can upload into Sugar. This setting should not exceed the post_max_size and upload_max_filesize parameters in your PHP configuration.

These instructions assume that you have Infobright installed and running.   First and foremost, download Talend.  In this example, we will download Talend Open Source Data Integrator v5.0. (http://www.talend.com/download.php)  Once fully installed, download the Talend/Infobright Connector.  Ensure you download the right connector; instructions are on the download page (http://www.infobright.org/Downloads/Contributed-Software/) If you download Talend 4.0+, you’ll want the latest connector For older versions of Talend, you’ll want the 3.7 connector and lower. Once downloaded, perform the following actions: [For Windows] Copy the infobright_jni([_32|_64])bit.dll to C:\Windows\infobright_jni.dll Copy the zipped “tInfobrightOutput” directory to this directory: [Install Root of Talend] \plugins\org.talend.designer.components.localprovider_5.0.1.r74687\components\tInfobrightOutput Copy “infobright-core-3.4.jar” to [Install Root of Talend]\lib\java Running Talend in Windows If using Windows, run talend as Administrator.  If you don’t, you will see odd “Access Denied” or “Accesse Refuse” error messages when trying to use the connector.

You need to do some work on these instructions. Version 5 is not like version 4. You must run Talend 5 before the “lib\java\” folder appears.  Once it does appear, it no longer contains the .jar files like version 4; just a file “index.xml” that you have to edit to point to the infobright jar file in the components folder.

Secure VPN Connection terminated locally by the client. Reason 442: Failed to enable Virtual Adapter

HKLM\SYSTEM\CurrentControlSet\Services\CVirtA

regedit

phplist is the world's most popular open source email campaign manager. phplist is free to download, install and use, and is easy to integrate with any website. phplist is downloaded more than 10,000 times per month.

Support for Windows Terminal Server

But just as those forms of collaboration out-paced phone calls (of which I am still keen on), inter-company envelope exchanges, and hand-written letters, collaboration in applications will seek to become the new social collaboration successor

Summary: Check Search whole cells and uncheck Regular expressions

By the end of 2013, 72% of business executives will have tablets as their main means of consuming an Organization’s KPI’s and other analytics, scorecarding, etc

Although Roambi, and Microstrategy seem to be doing all of the right things with Mobile BI, there are several major BI Vendors that are not or there is simply room for improvement.  Also on the topic of Mobile BI, one of the barriers of 2012 was the concern for securing Mobile BI within an organization.  There has been a rise of solutions but no true standardization.  Oracle has produced their Mobile Security Tool Kit for Oracle BI and we will dive into that very soon as well (have Mac OS, will travel).

We hope this year to compare Oracle Endeca along with QlikView, and Spotfire to break apart the vendor specific functionality and give rise to insights on how to form successful solutions to the overall problem of self-service analysis of Big Data and traditional Data Warehouse data.