Brain Log

Install Oracle Instant Client and SDK Step 1 Download the latest Oracle Instant Client and SDK from the Oracle website (Yeah, fuck you Oracle, you need to create an account to download the files). http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html Look for instantclient-basic-linux.x64-12.2.0.1.0.zip and instantclient-sdk-linux.x64-12.2.0.1.0.zip. Step 2 Create a new folder to store the Oracle Instant Client files on your machine. mkdir /opt/oracle And move your files to /opt/oracle. Step 3 Extract the files cd /opt/oracle unzip instantclient-basic-linux.x64-12.2.0.1.0.zip unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip Step 4 Next, we need to symlink the .so files. ln -s /opt/oracle/instantclient_12_2/libclntsh.so.12.2 /opt/oracle/instantclient_12_2/libclntsh.so ln -s /opt/oracle/instantclient_12_2/libocci.so.12.2 /opt/oracle/instantclient_12_2/libocci.so Step 5 Now lets add the folder to the ldconfig's config folder. echo /opt/oracl

The  sessions  parameter is derived from the  processes  parameter and changes accordingly when you change the number of max processes. See the  Oracle docs  for further info. To get only the info about the sessions: select current_utilization , limit_value from v $ resource_limit where resource_name = 'sessions' ; CURRENT_UTILIZATION LIMIT_VALUE ------------------- ----------- 110 792 Try this to show info about both: select resource_name , current_utilization , max_utilization , limit_value from v $ resource_limit where resource_name in ( 'sessions' , 'processes' ); RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE ------------- ------------------- --------------- ----------- processes 96 309 500 sessions 104 323 792

Hey yow first, we login has root. and enable mod_ssl a2enmod ssl service apache2 restart Next, we can install python2.7-dev and Git echo "deb http://us.archive.ubuntu.com/ubuntu/ precise-updates main restricted" | sudo tee -a /etc/apt/sources.list.d/precise-updates.list sudo apt-get update sudo apt-get install python2.7-dev git we can installed the letsencrypt client: git clone --branch 0.30.x https://github.com/letsencrypt/letsencrypt cd letsencrypt we can shut down Apache – there is probably a better way, but on a low-traffic test server/domain, that’s entirely okay for me. I then requested a new certificate and started Apache up again. service apache2 stop ./letsencrypt-auto certonly --no-self-upgrade --standalone -d example.com -d www.example.com  service apache2 start Don't forget to add --no-self-upgrade to your renew cron job. Now we went into the config file of virtual host and changed things around a bit. I am sure that

Target WSGI script '/etc/ckan/datapusher.wsgi' can not be loaded as Python module. Exception occurred processing WSGI script '/etc/ckan/datapusher.wsgi'. Traceback (most recent call last): File "/etc/ckan/datapusher.wsgi", line 8, in import ckanserviceprovider.web as web File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/ckanserviceprovider/web.py", line 13, in <mod $ import flask.ext.login as flogin ImportError: No module named ext.login You have to check if the modules Flask and Flask_login are installed and if necessary install them: pip uninstall flask (if is installed in other version) pip install flask == 0.12 pip install flask-login then you have to check the file /ckanserviceprovider/web.py (possible path): /usr/lib/ckan/datapusher/lib/python2.7/site-packages/ckanserviceprovider/web.py and replace: import flask.ext.login as flogin with: import flask_login as flogin because flask.ext.login is obsolete final

First Prerequirements are a working apache2 and php7.2 (Ubuntu 18.04) environment. Download the basic (like instantclient-basic-linux.x64-12.2.0.1.0.zip) and the SDK (instantclient-sdk-linux.x64-12.2.0.1.0.zip) package from the Oracle Website  http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html Upload both files to your web server, you can use WinSCP for it Unzip both files on a server, in my case, you will get a new folder named "instantclient_12_2" 4a. Create a destination folder mkdir /opt/oracle 4b. Move and rename the instantclient folder mv instantclient_12_2 /opt/oracle/instantclient 4c. Change rights on the folder chown -R root:www-data /opt/oracle Check if you have the required packages for installing OCI8 apt install php7.2-dev php-pear build-essential libaio1 Create necessary soft links ln -s /opt/oracle/instantclient/libclntsh.so.12.1 /opt/oracle/instantclient/libclntsh.s

mysql> SHOW create FUNCTION kode_level\G; *************************** 1. row ***************************             Function: kode_level             sql_mode: NO_AUTO_VALUE_ON_ZERO      Create Function: CREATE DEFINER=`lakip2016`@`localhost` FUNCTION `kode_level`(`pkode` VARCHAR(50), `pdelimiter` CHAR, `pLevel` INT) RETURNS varchar(255) CHARSET latin1     DETERMINISTIC     SQL SECURITY INVOKER BEGIN DECLARE hasil VARCHAR(255);   SET hasil = SUBSTRING_INDEX(pkode, '.',pLevel);   RETURN hasil; END character_set_client: utf8 collation_connection: utf8_general_ci   Database Collation: latin1_swedish_ci 1 row in set (0.00 sec)

$ ssh -nNT -R 4000:localhost:3000 user@server.com The above command sets up an ssh tunnel between your machine and the server, and forwards all traffic from localhost:3000 (on your machine) to localhost:4000 (in the context of the server). So now you can connect to the locally running service on port 3000 on the server on port 4000. This trick is very useful because it allows you to be able to expose a locally running service through your server to others on the internet without having to deploy it / setup on the server.