Month: January 2018

PHP Conditional Expression Evaluation With TRUE and FALSE

PHP Conditional Expression Evaluation With TRUE and FALSE Conditional expressions (both if and while statements) are literal or boolean or numeric. Numeric expressions evaluate to true when they are non-zero – zero/0 is false. String expressions evaluate to TRUE when there is nonempty string.  A NULL value is evaluated as false. How do you assign …

PHP Conditional Expression Evaluation With TRUE and FALSE Read More »

E-Business Suite Pre-Install RPM (available for Oracle Linux 5, 6 and 7)

Per Oracle Support Doc ID: 761566.1 E-Business Suite Pre-Install RPM (available for Oracle Linux 5, 6 and 7) The E-Business Suite pre-install package (oracle-ebs-server-R12-preinstall) for Oracle Linux 5, 6 and 7 is available on the Oracle Unbreakable Linux Network (ULN, which requires a support contract) or from the Oracle public yum repository (under the ‘Add-ons’ channel) for these Oracle Linux …

E-Business Suite Pre-Install RPM (available for Oracle Linux 5, 6 and 7) Read More »

How to port redirect when your ISP blocks the default HTTP port 80

I am hosting a LAMP (Linux/Apached/MySQL/PHP) based wordpress site from my home office (VirtualBox based). To support the LAMP installation.  I use a service provided by noip.com called “Plus Managed DNS”.  noip.com supports all my DNS needs and a domain is registered thru them for my wordpress site.  noip.com also supplies DDNS for me as …

How to port redirect when your ISP blocks the default HTTP port 80 Read More »

Fun with PHP date function – In PHP set your time zone and display date and time in MySQL datetime format.

In PHP set your time zone and display date and time in MySQL datetime format. <?php # ‘YYYY-MM-DD HH:MM:SS is “Y-m-d H:i:s” # set the timezone to LA $fbo=date_default_timezone_set(‘America/Los_Angeles’); # show that the call to set the timezone worked echo “Timezone set? $fbo <br>”; $script_tz = date_default_timezone_get(); # MySQL datetime format $today = date(“Y-m-d H:i:s”); …

Fun with PHP date function – In PHP set your time zone and display date and time in MySQL datetime format. Read More »

Using rlwrap for rman and maybe sqlplus, RHEL, CentOS, Oracle Linux 6 & 7, and Amazon Linux 1, and 2

FYI newest verision of sqlplus installed with 12.2 has command recall built in – but not rman… and anything older and rman you want this… RLWrap Installation From EPEL Extra Packages for Enterprise Linux (or EPEL) a set of additional packages for Enterprise Linux, including, but not limited to, Red Hat Enterprise Linux (RHEL), CentOS …

Using rlwrap for rman and maybe sqlplus, RHEL, CentOS, Oracle Linux 6 & 7, and Amazon Linux 1, and 2 Read More »

MySQL defaults to autocommit

How do I know?  On a new install of WordPress with MySQL… MariaDB [wordpress]> show global variables like ‘autocommit’; +—————+——-+ | Variable_name | Value | +—————+——-+ | autocommit | ON | +—————+——-+ 1 row in set (0.00 sec) This variable is set at the session level as follows. Turn off autocommit: set autocommit = 0; …

MySQL defaults to autocommit Read More »

Where are MySQL datafiles stored on Linux?

By default they are in the sub-directories at or below: /var/lib/mysql For example here is a listing of the wordpress database stored in MySQL/MariaDB [root@lampcent7 wordpress]# pwd /var/lib/mysql/wordpress [root@lampcent7 wordpress]# ls -altr total 168 -rw-rw—-. 1 mysql mysql 65 Jan 18 10:57 db.opt drwxr-xr-x. 5 mysql mysql 182 Jan 18 15:25 .. -rw-rw—-. 1 mysql …

Where are MySQL datafiles stored on Linux? Read More »