Install Instruction

1. Ensure you are running Oracle APEX version 4.2 or higher
2. Ensure target schema associated to your workspace has following privileges:
   • CREATE MATERIALIZED VIEW
   • CREATE INDEXTYPE
   • CREATE PROCEDURE
   • CREATE SEQUENCE
   • CREATE SYNONYM
   • CREATE TABLE
   • CREATE TRIGGER
   • CREATE VIEW
   • CREATE JOB
3. Unzip and extract all files
4. Access your target Workspace
5. Select the Application Builder
6. Import and install blog_admin.sql to workspace.
7. Import and installing blog_reader.sql and select install supporting objects.

Blog admin application default user and password is admin/admin.

If blog reader application default alias BLOG is reserved in your instance

1. Edit blog reader Application Definition and change Application Alias.
2. Navigate to SQL Workshop > SQL Commands and run
   begin
blog_install.blog_install.update_param_data;
end;
/
3. Run blog admin application and login.
4. Navigate to Publish > Files
5. Find file style.min.css and download it to your PC.
6. Edit file and replace all occurrences of "f?p=BLOG" with "f?p=<app_id>",
   where <app_id> is your blog reader application id.</app_id></app_id>
7. In blog admin application edit files record where style.min.css is stored.
8. Press "Browse" button and select edited CSS file from your PC.
9. Upload new file by pressing "Apply Changes".

Geolocate IP Addresses

Oracle Application Express schema need ACL to access http://api.hostip.info for geolocate IP addresses.
To create ACL run as SYS user script hostip info acl.sql from install files.

You can disable geolocate IP addresses by running in SQL Workshop
begin
blog_log.update_country_job(true);
end;
/

Advanced

By default blog theme files are served from database.
It is recommended copy the files of the directory "server" on the web server.
Then change from blog admin application preference "Theme location" to relative URL of that directory.