ajin

wget http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL-7
wget https://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-10.noarch.rpm

rpm --import RPM-GPG-KEY-EPEL-7
yum localinstall epel-release-7-10.noarch.rpm
yum install 389-ds-base 389-admin

yum install ldapjdk

wget https://dl.fedoraproject.org/pub/epel/7/x86_64/i/idm-console-framework-1.1.17-1.el7.noarch.rpm

ajin

#!/bin/bash

## Reconnect Synology VPN
## Written by Ian Harrier
## Based on https://forum.synology.com/enu/viewtopic.php?f=241&t=65444
## From: https://blog.harrier.us/reconnecting-a-failed-vpn-connection-on-synology-dsm-6/

###
# Process config files
###

ajin

declare
    l_access_granted number := 0;
    l_status varchar2(10);
    l_message varchar2(254);
    l_mac varchar2(254);
    l_key varchar2(254);
begin
    l_mac := :muid;
    l_key := :kuid;
    

ajin

create or replace TRIGGER  "BIU_<TABLE_NAME>" 
  before insert or update on "<TABLE_NAME>"               
  for each row  
begin
    if inserting and :new.id is null then
        select "<TABLE_NAME>_ID_SEQ".nextval into :NEW."ID" from sys.dual; 
    end if; 
  
    if inserting then
        :new.created_by := nvl(apex_application.g_user,USER);

ajin

/**
* Get parameter from the URL HTTP query string
*
* @param p_attribute Specifies the name of the variable in the HTTP query string to retrieve
* @return value
*/
function at_get_env_parameter (p_attribute in varchar2) return varchar2  as
    p_regex varchar2(254) := '=([^&]*)';
    p_result varchar2(254);
    l_query_strings varchar2(254):= owa_util.get_cgi_env('QUERY_STRING');

ajin

begin
  dbms_network_acl_admin.create_acl (
    acl => 'smtp-permissions.xml',
    description => 'Permissions for smtp',
    principal => 'APEX_050000',
    is_grant => true,
    privilege => 'connect');
  commit;
end;
/

ajin

select 'alter user "'||username||'" account unlock;' || chr(10) ||
 'alter user "'||username||'" identified by values ''temp'';' || chr(10) ||
'alter user "'||username||'" identified by values '''||extract(xmltype(dbms_metadata.get_xml('USER',username)),'//USER_T/PASSWORD/text()').getStringVal()||''';' old_password 
from dba_users
where account_status != 'OPEN';

ajin

/* ========================================================================
 * Ratchet: push.js v2.0.2
 * http://goratchet.com/components#push
 * ========================================================================
 * inspired by @defunkt's jquery.pjax.js
 * Copyright 2014 Connor Sears
 * Licensed under MIT (https://github.com/twbs/ratchet/blob/master/LICENSE)
 * ======================================================================== */

/* global _gaq: true */