I am busy changing the world

Installing Xibo (1.7.9) is pretty simple if it's not going with PHP 7.0 because PHP7.0 completely gets rid of mysql_* functions. But for some reasons you have no choice and gotta use PHP 7. In my situation, It's a Ubuntu 16.04 server and PHP 7.015. So what you can do is to compile the mysql_* module yourself. 1. Clone the pecl module to extension directory of php cd /etc/php/7.0/mods-available git clone https://github.com/php/pecl-database-mysql mysql --recursive 2. Compile the source cd /etc/php/7.0/mods-available/mysql phpize ./configure make make install Note: to have phpize, you may need php7.0-dev installed. 3. Symlink the module into php extension directory ln -s /usr/lib/php/20151012/mysql.so /etc/php/7.0/mods-available/mysql.so 4. Modify php.ini to enable mysql extension nano /etc/php/7.0/fpm/php.ini ... extension=/etc/php/7.0/mods-available/mysql.so ... 5. Restart php sudo systemctl restart php7.0-fpm The res...

In the past, It was not easy to get the custom fields data from PowerSchool's Oracle database because of the way it architected and organized custom fields data (they are stored as views in Oracle). With the newer version of PowerSchool (v7.9 and above), you can create custom fields to the extension database table. You can even migrate all the legacy custom fields (students and teachers/ school staffs) to that new location. It makes my life much easier when I want to manipulate those custom fields data because from now on, all the students custom fields data will be stored in 1 place, and the same for teachers's custom fields. * Student custom fields data will be stored in U_STUDENTSUSERFIELDS table * Teacher custom fields data will be stored in U_SCHOOLSTAFFUSERFIELDS table For example, you can use this script (python, SQLAlchemy, cx_Oracle) to export students data from PowerSchool along with any custom fields data you want: PowerSchool DATABASE Connector:

To work with Oracle DBMS using PHP you need to install oci8 extension. 0. Install Oracle client instant: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html The Oracle instant client will be installed at  /usr/lib/oracle/12.1/client64 Export the ORACLE_HOME and  $LD_LIBRARY_PATH  environment variable: $ export ORACLE_HOME=/usr/lib/oracle/12.1/client64 $ export LD_LIBRARY_PATH=$ORACLE_HOME/lib Read my blog post about oracle 12c instant client at  http://iambusychangingtheworld.blogspot.com/2014/07/install-cxoracle-513-in-ubuntu-1404.html 1. Install php-pear (needed by pecl) and php5-dev: $ sudo apt-get install pear $ sudo apt-get install php5-dev 2. Install oci8 extension using pecl: $ sudo pecl install oci8 This will ask for Oracle Home Directory – give the path of the instant client: 'instantclient,/usr/lib/oracle/12.1/client64/lib' 3. Enable oci8 in php.ini: $ sudo echo "extension=oci8.so" >> /etc/php5/f...