Skip to main content

Home/ BI-TAGS/ Group items tagged files

Rss Feed Group items tagged

cezarovidiu

Password Protection with .htaccess and .htpasswd - 0 views

  • .htaccess The .htaccess file is a simple text file placed in the directory you want the contents of the file to affect. The rules and configuration directives in the .htaccess file will be enforced on whatever directory it is in and all sub-directories as well. In order to password protect content, there are a few directives we must become familiar with. One of these directives in the .htaccess file ( the AuthUserFile directive ) tells the Apache web server where to look to find the username/password pairs. .htpasswd The .htpasswd file is the second part of the affair. The .htpasswd file is also a simple text file. Instead of directives, the .htpasswd file contains username/password pairs. The password will be stored in encrypted form and the username will be in plaintext.
  • There is a special program on a *nix machine that is designed to manipulate the .htpasswd file on your behalf. The name of this program is htpasswd.
  • The first way is to create a new .htpasswd file and add a username/password pair to the file. The second way is to add a username/password pair to an existing .htpasswd file.
  • ...1 more annotation...
  • To create a new .htpasswd file in /usr/uj/jurbanek/ with username john, the following command would be used. # '-c' stands for 'create'. Only to be used when creating a new .htpasswd file. # You will be prompted for the password you would like to use after entering the command below. htpasswd -c /usr/uj/jurbanek/.htpasswd john
cezarovidiu

Veeam Backup Free Edition for VMware and Hyper-V - 0 views

  •  
    "What's Inside Veeam Backup Free Edition contains useful utilities for day-to-day VM management: VeeamZIP: Backup a VM on-the-fly for operational, archival or portability purposes Instant File-Level Recovery: Restore individual guest files directly from a VeeamZIP backup NEW! Veeam Explorer™ for Microsoft Exchange: Get instant visibility into VeeamZIP backups of Exchange VMs for quick recovery of individual items (emails, contacts, notes, etc.) NEW! Veeam Explorer™ for SAN Snapshots: Restore individual VMs, guest files and Exchange items from SAN snapshots* File Manager: The easy way to manage VM and host files Quick Migration for VMware: Migrate a live VM to any host or datastore *Currently available for VMware only"
cezarovidiu

Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minu... - 0 views

  • Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)
  • APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).
cezarovidiu

EnablingUseOfApacheHtaccessFiles - Community Ubuntu Documentation - 0 views

  • Example Here is an example on how to prevent users from access the directory, password-protect a specific file and allow userse to view a specific file: AuthUserFile /your/path/.htpasswd AuthName "Authorization Required" AuthType Basic Order Allow,Deny <Files myfile1.html> Order Allow,Deny require valid-user </Files> <Files myfile2.html> Order Deny,Allow </Files>
  •  
    "Password-Protect a Directory With .htaccess"
cezarovidiu

- Process Type Plugin - SaveToDisk - 0 views

  • Save file to file system rather than into table
  •  
    Save file to file system rather than into table
cezarovidiu

SugarCRM - Install Settings - 0 views

  • 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.
  •  
    "memory_limit"
cezarovidiu

Dancing and Wrestling with Oracle APEX: Apex and FusionCharts (or There be dragons at t... - 0 views

  • All of which led me to FusionCharts, which is a brilliant set of flash charts and widgets.
  • All I had to do was figure out how to integrate it into my app. First I had to write a function to extract the data I needed from my database and output it as correctly-formatted XML. That bit was easy so I won't bore you with it.
  • Next I uploaded the Flash (SWF) file for my chart into my workspace. (Tell me something: when you upload an image to your application using Apex's image uploader you refer to it by pointing at # APP_IMAGES#, so how do you think you'd refer to a file you've uploaded using Apex's file uploader? #APP_FILES#? Wrong! Illogically, all files uploaded into your application should be pointed at using the #APP_IMAGES# substitution string.)Finally, I created a dynamic PL/SQL content region outputting the necessary wrapper tags for my Flash movie (which I copied from the FusionCharts examples), pointing it to my uploaded swf file and feeding it the XML from my database function (which I call in "before regions" page process).
cezarovidiu

How to migrate Liferay portal from one windows machine to other? - Stack Overflow - 0 views

  •  
    "These are the steps that I have followed and able to migrate the Liferay successfully: Take the backup of Liferay files and database from first windows machine. Install the same version of Liferay (Say Liferay 5.2.3) on second windows machine. Shut down Liferay. Import the database on new system. Add portal-ext.properties with relevant entries. (e.g Datbase Name, User Name , Pasword etc) Add \liferay-portal-5.2.3\data\document_library files from old machine. Start the tomcat. It will automtically do the rest. NOTE: In the above method I have not deployed Theme and custom plugins etc, you have to deploy Theme and custom plugins also that are used on old system."
cezarovidiu

Moving Sugar to Another Server - SugarCRM Support Site - 0 views

    • cezarovidiu
       
      japtone   Senior Member Join Date Nov 2010 Posts 49  Re: Transferring SugarCRM to a new server If you're using Linux try to have the same version of PHP, Apache, and DB (MySQL for instance) in order to avoid compatibility issues. In your production server tar up the sugarcrm root directory, transfer it to the new server and untar wherever your new root directory will be.  Next take a db dump of your database, transfer it to the new server and do a restore. Make sure apache is configured on the new server to point to the root of sugarcrm and start it up.  Make sure to modify config.php to account for any change in paths and hostname.  that's what I've found to be the easiest way to 'clone' sugar.
  • 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
  • ...5 more annotations...
  • Copy Filesystem Copy all your files to the new server.  This can be done simply by locating the root directory on your old instance and copy and pasting it to the new server location.
  • Import Database Import the mysql database into the new server.  Here's how you would restore your custback.sql file to the Customers database. mysql -u sadmin -p pass21 Customers < custback.sql Here's the general format you would follow: mysql -u [username] -p [password] [database_to_restore] < [backupfile]
  • Check Files and Permissions Check Config.php Open <sugarroot/config.php> and make sure that all settings still apply to the new server, such as: array ( 'db_host_name' => 'localhost', 'db_user_name' => 'root', 'db_password' => 'PASSWORD', 'db_name' => 'DATABASE_NAME', 'db_type' => 'mysql', ), 'site_url' =>, etc...
  • Check htaccess Open <sugarroot/.htaccess> and ensure that the new server URLs are used correctly.
  • Check Permissions Check that the permissions are correct on the new server. That is the entire custom and cache directories (and all the sub directories) in addition to the config.php file are owned and writable by the user that runs the application on the server.
cezarovidiu

Oracle Apex Thoughts.: How to send an email from apex 4.2 and 11g XE - 0 views

  •  
    "How to send an email from apex 4.2 and 11g XE To accomplish sending an email from your Oracle Apex application using oracle database 11g r2, you must use the new DBMS_NETWORK_ACL_ADMIN package to grant connect privileges to any host for the APEX_040200 database user. To start things off, begin by installing a free mail server emulator in your development environment. I used Melon 1.0 that can be downloaded from http://www.softpedia.com/get/Internet/Servers/E-mail-Servers/Viktor-Melon.shtml. After unpacking the archive just place the folder anywhere in your file system. The sample mails sent will be stored in the .Melon sub directory. Secondly connect to the database as sys user and run the following script: DECLARE   ACL_PATH  VARCHAR2(4000); BEGIN   -- Look for the ACL currently assigned to 'localhost' and give APEX_040200   -- the "connect" privilege if APEX_040200 does not have the privilege yet.   SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS    WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;      IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',      'connect') IS NULL THEN       DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,      'APEX_040200', TRUE, 'connect');   END IF;   EXCEPTION   -- When no ACL has been assigned to 'localhost'.   WHEN NO_DATA_FOUND THEN   DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml',     'ACL that lets users to connect to localhost',     'APEX_040200', TRUE, 'connect');   dbms_network_acl_admin.assign_acl('local-access-users.xml','localhost'); end; The third step is to set the smtp settings in Apex. 1.    Log in to Oracle Application Express Administration Services. If your setup uses the embedded PL/SQL gateway, go to: http://hostname:port/apex/apex_admin 2.    Click Manage Instance. 3.    Under Instance Settings, click Instance Settings. 4.    Under Email, enter the following: 1.    SMTP Host Address - Defines the server
cezarovidiu

Setting Up a Server Linux article - 0 views

  • Installing and Configuring Apache
  • apt-get install apache2
  • etc/init.d/apache2 start|stop|restart|reload|force-reload apacheclt start|stop|restart|...
  • ...19 more annotations...
  • Apache2's configuration files, by default, are in /etc/apache2/.
  • apache2.conf is where the main configuration is
  • it used to be httpd.conf, so don't be fooled.
  • Installing and Configuring MySQL
  • apt-get install mysql-server-5.0
  • /etc/init.d/mysql start|stop|restart|reload|force-reload|status
  • To first start working with this database, the root password must be set. The word root does not apply to the system's root, but to the database administrator, however, it can be the same person. So let's set it and log in: mysqladmin -u root password 'thepassword' mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 10 to server version: 5.0.20a-Debian_1-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
  • /etc/mysql/my.cnf
  • apt-get install php5
  • Installing and Configuring PHP
  • Now, add support for MySQL: apt-get install php5-mysql
  • Just like for Apache and MySQL, extra packages will have to be install as well: apache2-mpm-prefork, libapache2-mod-php5 and php5-common.
  • The configuration file for PHP is located in /etc/php5/apache2/php.ini
  • every time you modify it, Apache must be restarted.
  • /var/www/information.php
  • Installing and Configuring Postfix
  • The default configuration files are in /etc/postfix, we will only use main.cf
  • apt-get install php5-cli php-pear php5-ldap php5-imap php5-gd php5-mhash php5-odbc php5-ps
  • I also like to add some more packages for PHP, such as CLI, Pear, LDAP, IMAP, GD, mhash, ODBC and PostScript:
cezarovidiu

Connecting Infobright and Talend - 1 views

  • 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.
cezarovidiu

How to restrict access to web pages with apache web server - IRC-IT - Teamwork at Jacob... - 0 views

  • In this article we explain how you can utilize the apache authentication to restrict access to you website or parts of your website.
  • You have to create the files .htaccess and .htpasswd. These files are protected by the server software so you can not download or view them with your web browser.
cezarovidiu

Oracle Public Yum Server - 0 views

  • # cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-el5.repo
  • Open the yum configuration file in a text editor Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base] Change enabled=0 to enabled=1
cezarovidiu

OBIEE 11G configuration's Maximum Limits | OBIEE by Shiva Molabanti - 0 views

  • OBIEE 11G configuration’s Maximum Limits
  • Be careful when you are setting the Cache attribute values. For implementations under significant stress increase this value to 1000 or a higher value as mentioned below. The main factor that affects its size is the memory consumption. Maximum range of Global Cache storage size (in Megabytes) to use when BI Server cache is enabled – 9,999 Maximum number of cache entries; used to tune cache performance – 99,999 Maximum size (in Megabytes) for individual server cache entries – 9,999 Data Display/Download: The Maximum no.of rows that we can set to display/download in the Table/Pivot views. But keep in mind OBIEE is NOT meant to be a tool to extract huge amounts of information. Maximum number of rows of data to include in Table views – 9,999,999 Maximum number of rows of data to include in delivered emails – 9,999,999 Maximum number of rows to export to excel – 9,999,999
  • In OBIEE 11G, The instanceconfig.xml file stores the OBI PS configuration settings. Many configuration settings are available in EM and those should be controlled within EM only unless if we disabled centralConfigurationEnabled option. If any particular setting is not available in EM then we should make changes directly in instanceconfig.xml file. There are many situations where we need to change the default OBI configuration settings to a new value.
cezarovidiu

Installing Hadoop for Fedora & Oracle Linux(Single Node Cluster) | accretion infinity - 0 views

  • Hadoop is a framework written in Java for running applications on large clusters of commodity hardware and incorporates features similar to those of the Google File System (GFS) and of the Map Reduce computing paradigm. Hadoop’s HDFS is a highly fault-tolerant distributed file system and, like Hadoop in general, designed to be deployed on low-cost hardware. It provides high throughput access to application data and is suitable for applications that have large data sets.
  • Some of the Hadoop projects we will talk about are: HDFS : A distributed filesystem that runs on large clusters of commodity machines. Map Reduce: A distributed data processing model and execution environment that runs on large clusters of commodity machines. Pig: A data flow language and execution environment for exploring very large datasets. Pig runs on HDFS and MapReduce clusters. HBase: A distributed, column-oriented database. HBase uses HDFS for its underlying storage, and supports both batch-style computations using MapReduce and point queries (random reads). ZooKeeper: A distributed, highly available coordination service. ZooKeeper provides primitives such as distributed locks that can be used for building distributed applications. Oozie: Oozie is a workflow scheduler system to manage Apache Hadoop jobs.
  • Oracle Linux as the operating system and Hadoop 1.1.2 or 1.2.0
cezarovidiu

Rittman Mead Consulting - The Changing World of Business Intelligence - 0 views

  • Schema on write This is the traditional approach for Business Intelligence. A model, often dimensional, is built as part of the design process. This model is an abstraction of the complexity of the underlying systems, put in business terms. The purpose of the model is to allow the business users to interrogate the data in a way they understand.
  • The model is instantiated through physical database tables and the date is loaded through an ETL (extract, transform and load) process that takes data from one or more source systems and transforms it to fit the model, then loads it into the model.
  • The key thing is that the model is determined before the data is finally written and the users are very much guided or driven by the model in how they query the data and what results they can get from the system. The designer must anticipate the queries and requests in advance of the user asking the questions.
  • ...3 more annotations...
  • Schema on read Schema on read works on a different principle and is more common in the Big Data world. The data is not transformed in any way when it is stored, the data store acts as a big bucket. The modelling of the data only occurs when the data is read. Map/Reduce is the clearest example, the mapping is the understanding of the data structure. Hadoop is a large distributed file system, which is very good at storing large volumes of data, this is potential. It is only the mapping of this data that provides value, this is done when the data is read, not written.
  • New World Order So whereas Business Intelligence used to always be driven by the model, the ETL process to populate the model and the reporting tool to query the model, there is now an approach where the data is collected its raw form, and advanced statistical or analytical tools are used to interrogate the data. An example of one such tool is R.
  • The driver for which approach to use is often driven by what the user wants to find out. If the question is clearly formed and the sources of data that are required to answer it well understood, for example how many units of a product have we sold, then the traditional schema on write approach is best.
1 - 20 of 30 Next ›
Showing 20 items per page