Reset Admin Password in Prestashop

I’ve lost the password for my localhost install, and I didn’t have a SMTP server available. So, I can’t recover my lost password. After some googling, I found a solution that I post in here, Open the setting.inc.php (located in config folder) Copy the _COOKIE_KEY_ value Use SQL tool (PHPMyAdmin or Toad for MySQL) In [...]

Tranparent Pentaho Dialog in Pentaho Administration Console

I am glad to know that the latest edition Pentaho BI Server – Community Edition today, 3.9.0, have a new visual interface (check and download the latest Pentaho BI server from sourceforge.net). Here the screenshot on Pentaho User Console (PUC), But Pentaho Administration Console (PAC) not updated, even now pentaho dialog box display transparently when [...]

Oracle RMAN Backup Script In Oracle Linux

This is rman.sh And this is RMAN configuration,

Oracle Database in Oracle Linux Cannot Start / Open

Today I mess around with the Oracle database that can not start and open. I get some error messages from various places such as alert.log, sqlplus, rman. These errors are, I have do this step : 1. replace the  current spfile with the old one 2. startup with pfile 3. restore and recover database using [...]

Oracle Parameter optimizer_index_cost_adj Performance

From Oracle Documentation, Default value 100 Modifiable ALTER SESSION, ALTER SYSTEM Range of values 1 to 10000 OPTIMIZER_INDEX_COST_ADJ lets you tune optimizer behavior for access path selection to be more or less index friendly—that is, to make the optimizer more or less prone to selecting an index access path over a full table scan. The [...]

Oracle Parameter db_block_checksum Performance

From Oracle Documentation, Default value TYPICAL Modifiable ALTER SYSTEM Range of values OFF | TYPICAL | FULL DB_BLOCK_CHECKSUM determines whether DBWn and the direct loader will calculate a checksum (a number calculated from all the bytes stored in the block) and store it in the cache header of every data block when writing it to [...]

Cannot Compile Oracle Function ORA-04021

I was get this error when I alter and compile one function ORA-04021: timeout occurred while waiting to lock object First try, I use this query to find what cause this error SELECT p.spid “Thread”, s.sid “SID-Top Sessions”, SUBSTR (s.osuser, 1, 15) “OS User”, SUBSTR (s.program, 1, 25) “Program Running”, s.username FROM v$process p, v$session [...]

How To See Oracle Database Parameter

You can run this sql to see Oracle Database Parameter : SELECT name, value, isdefault default_value, description, isses_modifiable session_modifiable, issys_modifiable system_modifiable, isdeprecated deprecated, update_comment FROM v$parameter ORDER BY name ISDEFAULT Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE) ISSES_MODIFIABLE Indicates whether [...]

Create Oracle Schedule Backup Script on Oracle Linux :

create backup directory for USERME CREATE OR REPLACE DIRECTORY BCK_DIR AS ‘/home/oracle/bck’; GRANT READ, WRITE ON DIRECTORY SYS.BCK_DIR TO EXP_FULL_DATABASE; GRANT READ, WRITE ON DIRECTORY SYS.BCK_DIR TO IMP_FULL_DATABASE; using vi to create script #!/bin/bash clear #echo “Hello, linux world from pandazen world.” echo “backup pandazen data with script on Oracle Linux” NOW=$(date +”%Y%m%d”) FILE=”pandazen$NOW” echo [...]

Oracle Fine-Grained Auditing (Oracle FGA)

Today my first time using Oracle Fine-Grained Auditing. Why do I need to use Oracle Fine-Grained Auditing? This is because there is a table that is accessed by many procedures, triggers and packages. So that in case of deletion, I can not track from which the “DELETE” order came from. I’ve tried using a trigger [...]

Cancel Oracle Trigger to Execute The Commands

Hi, I want to cancel the trigger of a table that does not work if the logic condition is not met. So as if I want the trigger to rollback (for example = cancel delete in before-delete trigger). At first, the trigger like this : CREATE OR REPLACE TRIGGER MIS.TRIG01_TABLE_A BEFORE DELETE ON PANDAZEN.TABLE_A REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN INSERT INTO PANDAZEN.TABLE_B SELECT [...]

NetBeans 7.0 Get CORBA and OMG

I use NetBeans IDE 7.0 running the default GlassFish Server 3.1 from the NetBeans installation file. I got this error : WARNING: IOP00010002: Unknown user exception thrown by the server – exception: java.lang.NullPointerException; message: null org.omg.CORBA.UNKNOWN: WARNING: IOP00010002: Unknown user exception thrown by the server – exception: java.lang.NullPointerException; message: null vmcid: OMG minor code: 2 [...]

the quick red fox jumps over the pink rabbit and seen by the brown dog

This is a continuation of the post previous post “the quick red fox jumps over the pink rabbit”. After I saw that at PandaZen’s QR Code, there is a brown dog, so I edit the QR Code. And here the old and new PandaZen’s QR Code.

Error regsvr32 TortoiseSVNSCC.dll

<a href="”> [ Read More → ]

PHP error – Unable to initialize module API=20060613 – 20090626

My PHP on Apache error.log show this message : PHP Warning: PHP Startup: java: Unable to initialize module\nModule compiled with module API=20060613\nPHP compiled with module API=20090626\nThese options need to match\n in Unknown on line 0 The solution : uncommented 2 lines in php.ini, ;extension=D:\oss\php-5.3.6\ext\php_java.dll ;extension=D:\oss\php-5.3.6\php5servlet.dll then restart apache, and the message disappear ^_^

Pentaho – Steel Wheels – Analysis – Market Analysis By Year Error

When I click Market Analysis By Year on Steel Wheels | Analysis, I got this error message : Error Occurred While getting Resultset An error occurred while rendering Pivot.jsp. Please see the log for details. So the solution I found : 1. use “Pentaho Schema Workbench” 2. open “steelwheels.mondrian.xml” on “D:\pentaho\pentaho-solutions\steel-wheels\analysis” 3. fix all invalid [...]

Tomcat – Pentaho : ‘docbase’ did not find a matching property

I’ve been using Pentaho “biserver-ce-3.8.0-stable” run on Tomcat 7. But everytime I start Tomcat, show some message like this: May 11, 2011 3:02:13 PM org.apache.catalina.startup.SetContextPropertiesRule begin WARNING: [SetContextPropertiesRule]{Context} Setting property ‘docbase’ to ‘webapps/pentaho/’ did not find a matching property. So to get rid of this warning message, I delete docbase=”webapps/pentaho/” from <Context path=”/pentaho” docbase=”webapps/pentaho/”> in [...]

Netbeans 7 – “Cannot locate java installation in specified jdkhome:”

I’ve installed previous versions of jdk1.6.0_17, and then after installing netbeans 7, I upgrade jdk to version jdk1.6.0_25. Now, everytime I start Netbeans, it always show me this message : Cannot locate java installation in specified jdkhome: C:\Program Files\Java\jdk1.6.0_17 Do you want to try to use default version? If I click “Yes”, the next time [...]

Warning On Startup Tomcat – Pentaho

Whenever I start Tomcat to work with Pentaho, I always got like this warning error : May 11, 2011 1:50:48 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role> The solution is to add <security-role> to ” tomcat\webapps\pentaho\WEB-INF\web.xml”,after the <security-constraint> tag. <security-role> <description>security role assignment for [...]

Pentaho User Console Login Bug on Firefox 4

After I simply login, I get this error message Error generating XUL: Failed to parse: <?xml version=”1.0″ encoding=”UTF-8″?> <?xml-stylesheet href=”chrome://global/skin/” type=”text/css”?> <window width=”400″ hei The temporary solution I found is to use firefox addon Remote Xul Manager, after installation, restart firefox and then add pentaho-host to the list of “Domains with remote XUL permission”. I [...]