Fix warning #1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: GitHub CI PHP 7.1 Postgres | |
| on: | |
| push: | |
| branches: | |
| - develop | |
| - 1* | |
| - 2* | |
| pull_request: | |
| types: [opened] | |
| permissions: | |
| contents: read | |
| jobs: | |
| github_ci_php71_pgsql: | |
| runs-on: ubuntu-latest | |
| services: | |
| mysql: | |
| image: mysql:5.7 | |
| env: | |
| MYSQL_ROOT_PASSWORD: password | |
| ports: | |
| - 32574:3306 | |
| postgres: | |
| image: postgres | |
| env: | |
| POSTGRES_PASSWORD: postgres | |
| POSTGRES_USER: postgres | |
| POSTGRES_DB: postgres | |
| # Set health checks to wait until postgres has started | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| ports: | |
| - 5432:5432 | |
| steps: | |
| # git clone dolibarr into GITHUB_WORKSPACE = /home/runner/work/dolibarr/dolibarr | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 1 | |
| - name: Version PHP | |
| run: | | |
| php -i | head - | |
| - name: Install packages for PHP 7.1 | |
| run: | | |
| sudo composer self-update 2.2.18 | |
| sudo chmod -R a+rwx /home/runner | |
| composer -n config -g vendor-dir htdocs/includes | |
| sudo add-apt-repository -y ppa:ondrej/php | |
| sudo apt-get update | |
| sudo apt-get install -y pgloader memcached | |
| sudo apt install apache2 php7.1 php7.1-cli php7.1-curl php7.1-mysql php7.1-pgsql php7.1-gd php7.1-imap php7.1-intl php7.1-ldap php7.1-xml php7.1-mbstring php7.1-xml php7.1-zip libapache2-mod-php7.1 | |
| sudo update-alternatives --set php /usr/bin/php7.1 | |
| php -i | head - | |
| cd $GITHUB_WORKSPACE | |
| ls $GITHUB_WORKSPACE | |
| composer -n require --ignore-platform-reqs phpunit/phpunit ^7.5 \ | |
| php-parallel-lint/php-parallel-lint ^1 \ | |
| php-parallel-lint/php-console-highlighter ^0 \ | |
| php-parallel-lint/php-var-dump-check ~0.4 \ | |
| squizlabs/php_codesniffer ^3 | |
| #For php7.3 | |
| #composer -n require phpunit/phpunit ^7.5 \ | |
| # php-parallel-lint/php-parallel-lint ^1.2 \ | |
| # php-parallel-lint/php-console-highlighter ^0 \ | |
| # php-parallel-lint/php-var-dump-check ~0.4 \ | |
| # squizlabs/php_codesniffer ^3 | |
| sudo rm -fr htdocs/includes/phpunit/php-code-coverage/src/Report/Html | |
| - name: Adding path of binaries tools installed by composer to the PATH | |
| run: | | |
| export PATH="$GITHUB_WORKSPACE/htdocs/includes/bin:$PATH" | |
| echo $PATH | |
| # We must have a directory bin created by the previous composer call | |
| ls $GITHUB_WORKSPACE/htdocs/includes/bin | |
| - name: Version information | |
| run: | | |
| composer -V | |
| # Check Parallel-lint version | |
| echo "Parallel-lint version" | |
| htdocs/includes/bin/parallel-lint -V | |
| # Check PHP CodeSniffer version | |
| echo "PHPCS version" | |
| htdocs/includes/bin/phpcs --version | head - | |
| htdocs/includes/bin/phpcs -i | head - | |
| # Check PHP Vardump check version | |
| echo "PHP Vardump check version" | |
| htdocs/includes/bin/var-dump-check --version | |
| # Check PHPUnit version | |
| echo "PHPUnit version" | |
| htdocs/includes/bin/phpunit --version | head - | |
| # Check Apache version | |
| echo "Apache version" | |
| apache2 -v | head - | |
| # Check Database | |
| echo "Database version" | |
| mysql --version | head - | |
| psql --version | |
| echo "Check pgloader version" | |
| pgloader --version | |
| - name: Create database | |
| run: | | |
| pwd | |
| echo GITHUB_WORKSPACE = $GITHUB_WORKSPACE | |
| sudo apt-get install -y mysql-client | |
| mysql --version | head - | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -e "SELECT VERSION();" | head - | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -e "SHOW DATABASES" | |
| echo "Drop and create database" | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -e 'DROP DATABASE IF EXISTS travis;' | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -e "CREATE DATABASE IF NOT EXISTS travis CHARACTER SET = 'utf8';" | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -e "CREATE USER 'travis'@'127.0.0.1' IDENTIFIED BY 'password';" | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -e 'GRANT ALL PRIVILEGES ON travis.* TO [email protected];' | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -e 'FLUSH PRIVILEGES;' | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -D travis < dev/initdemo/mysqldump_dolibarr_3.5.0.sql | |
| mysql --host 127.0.0.1 --port 32574 -uroot -ppassword -D travis -e "UPDATE llx_const set value = '0666' WHERE name = 'MAIN_UMASK';" | |
| #psql -c 'create database travis;' -U postgres | |
| #psql travis < dev/initdemo/mysqldump_dolibarr_3.5.0.sql | |
| #pgloader mysql://root:[email protected]:32574/dolibarr_src postgresql://dolibarrowner:[email protected]/dolibarr_dest | |
| ps fauxww | grep postgres | |
| ls /etc/postgresql/14/main/ | |
| sudo chmod -R a+rwx /etc/postgresql/14/main/pg_hba.conf | |
| sudo sed -i -e '/local.*peer/s/postgres/all/' -e 's/peer\|md5/trust/g' /etc/postgresql/14/main/pg_hba.conf | |
| sudo cat /etc/postgresql/14/main/pg_hba.conf | |
| sudo /etc/init.d/postgresql restart | |
| psql postgresql://postgres:[email protected]:5432 -l -A | |
| psql postgresql://postgres:[email protected]:5432 -c 'create database travis;' | |
| sudo mkdir -p /tmp/pgloader | |
| sudo chmod -R a+rwx /tmp/pgloader/ | |
| echo sudo pgloader mysql://root:[email protected]:32574/travis postgresql://postgres:[email protected]:5432/travis | |
| sudo pgloader mysql://root:[email protected]:32574/travis postgresql://postgres:[email protected]:5432/travis | |
| echo 'ALTER SEQUENCE llx_accountingaccount_rowid_seq RENAME TO llx_accounting_account_rowid_seq' | psql postgresql://postgres:[email protected]:5432/travis | |
| echo 'ALTER SEQUENCE llx_accounting_account_rowid_seq RESTART WITH 1000001;' | psql postgresql://postgres:[email protected]:5432/travis | |
| # Create pgsql compatibility functions | |
| psql postgresql://postgres:[email protected]:5432/travis < htdocs/install/pgsql/functions/functions.sql | |
| - name: Generate Dolibarr conf file | |
| run: | | |
| export CONF_FILE=$GITHUB_WORKSPACE/htdocs/conf/conf.php | |
| echo "Setting up Dolibarr $CONF_FILE" | |
| echo '<?php' > $CONF_FILE | |
| echo '$'dolibarr_main_url_root=\'http://127.0.0.1\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_document_root=\'/var/www/html\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_data_root=\'/var/www/html/documents\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_db_host=\'127.0.0.1\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_db_name=\'travis\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_db_user=\'root\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_db_pass=\'password\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_instance_unique_id=\'travis1234567890\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_db_type=\'mysqli\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_db_port=\'32574\'';' >> $CONF_FILE | |
| echo '$'dolibarr_main_authentication=\'dolibarr\'';' >> $CONF_FILE | |
| cat $CONF_FILE | |
| - name: Generate install.forced.php file to test installation | |
| run: | | |
| export INSTALL_FORCED_FILE=$GITHUB_WORKSPACE/htdocs/install/install.forced.php | |
| echo "Setting up Dolibarr $INSTALL_FORCED_FILE to test installation" | |
| # Ensure we catch errors | |
| set +e | |
| echo '<?php' > $INSTALL_FORCED_FILE | |
| echo '$'force_install_noedit=2';' >> $INSTALL_FORCED_FILE | |
| #echo '$'force_install_type=\'mysqli\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_type=\'pgsql\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_dbserver=\'127.0.0.1\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_database=\'travis\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_databaselogin=\'root\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_databasepass=\'password\'';' >> $INSTALL_FORCED_FILE | |
| #echo '$'force_install_port=\'32574\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_port=\'5432\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_prefix=\'llx_\'';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_createdatabase=false';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_createuser=false';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_mainforcehttps=false';' >> $INSTALL_FORCED_FILE | |
| echo '$'force_install_main_data_root=\'/var/www/html\'';' >> $INSTALL_FORCED_FILE | |
| cat $INSTALL_FORCED_FILE | |
| - name: Create document directory | |
| run: | | |
| echo "Create documents directory and set permissions" | |
| # and admin/temp subdirectory needed for unit tests | |
| sudo mkdir -p /var/www/html/documents/admin/temp | |
| sudo chmod -R a+rwx /var/www/html/documents | |
| sudo echo "***** First line of dolibarr.log" > /var/www/html/documents/dolibarr.log | |
| sudo chmod a+rwx /var/www/html/documents/dolibarr.log | |
| - name: Copy app into /var/www | |
| run: | | |
| sudo cp -r $GITHUB_WORKSPACE/htdocs/. /var/www/html | |
| sudo mv /var/www/html/index.html /var/www/html/index.disabled.html | |
| sudo ln -fs /var/www/html /var/www/htdocs | |
| sudo cp -r $GITHUB_WORKSPACE/test/. /var/www/test | |
| sudo cp -r $GITHUB_WORKSPACE/dev/. /var/www/dev | |
| sudo cp -r $GITHUB_WORKSPACE/scripts/. /var/www/scripts | |
| - name: Setup Apache | |
| run: | | |
| pwd | |
| whoami | |
| # install apache web server | |
| a2query -s | |
| a2query -m | |
| ls /etc/apache2/sites-available | |
| #sudo cp -f $GITHUB_WORKSPACE/build/travis-ci/apache-githubaction.conf /etc/apache2/sites-available/000-default.conf | |
| #sudo sed -e "s?%GITHUB_WORKSPACE%?$(pwd)?g" --in-place /etc/apache2/sites-available/000-default.conf | |
| a2ensite 000-default | |
| a2enmod php7.1 | |
| ls /etc/apache2/sites-enabled | |
| sudo adduser $(whoami) www-data | |
| sudo adduser $(whoami) root | |
| sudo adduser root www-data | |
| sudo chown -R www-data:www-data /etc/apache2/sites-available/ | |
| sudo chmod -R 777 /etc/apache2/sites-available/ | |
| sudo chown -R www-data:www-data /var/www/html/ | |
| ls -l /var/www/html | |
| #ls -l /var/www/html/conf | |
| #ls -l /var/www/html/install/ | |
| set +e | |
| sudo cat /etc/apache2/sites-enabled/000-default.conf | |
| sudo service apache2 restart | |
| curl -I localhost | |
| - name: Chech Apache availability | |
| run: | | |
| echo "Checking webserver availability by a wget -O - --debug http://127.0.0.1" | |
| # Ensure we stop on error with set -e | |
| set +e | |
| ls /var/log/apache2 | |
| #wget -O - --debug http://127.0.0.1/robots.txt | |
| # The wget should return a page with line '<meta name="generator" content="Dolibarr installer"> | |
| wget -O - --debug http://127.0.0.1 > $GITHUB_WORKSPACE/test.html 2>&1 | |
| head -n 200 $GITHUB_WORKSPACE/test.html | |
| echo Logs are... | |
| #sudo cat /tmp/install.log | |
| sudo cat /var/log/apache2/access.log | |
| sudo cat /var/log/apache2/error.log | |
| sudo cat /var/log/apache2/other_vhosts_access.log | |
| set +e | |
| - name: Upgrading Dolibarr | |
| run: | | |
| # Ensure we catch errors. Set this to +e if you want to go to the end to see log files. | |
| set -e | |
| sudo chmod -R a+rwx $GITHUB_WORKSPACE | |
| sudo chmod -R a+rwx /var/www | |
| ls -l /var/www | |
| cd /var/www/html/install | |
| echo Execute upgrade, upgrade2 and step5 for each major version | |
| php upgrade.php 3.5.0 3.6.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade350360.log | |
| php upgrade2.php 3.5.0 3.6.0 > $GITHUB_WORKSPACE/upgrade350360-2.log | |
| php step5.php 3.5.0 3.6.0 > $GITHUB_WORKSPACE/upgrade350360-3.log | |
| php upgrade.php 3.6.0 3.7.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade360370.log | |
| php upgrade2.php 3.6.0 3.7.0 > $GITHUB_WORKSPACE/upgrade360370-2.log | |
| php step5.php 3.6.0 3.7.0 > $GITHUB_WORKSPACE/upgrade360370-3.log | |
| php upgrade.php 3.7.0 3.8.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade370380.log | |
| php upgrade2.php 3.7.0 3.8.0 > $GITHUB_WORKSPACE/upgrade370380-2.log | |
| php step5.php 3.7.0 3.8.0 > $GITHUB_WORKSPACE/upgrade370380-3.log | |
| php upgrade.php 3.8.0 3.9.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade380390.log | |
| php upgrade2.php 3.8.0 3.9.0 > $GITHUB_WORKSPACE/upgrade380390-2.log | |
| php step5.php 3.8.0 3.9.0 > $GITHUB_WORKSPACE/upgrade380390-3.log | |
| php upgrade.php 3.9.0 4.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade390400.log | |
| php upgrade2.php 3.9.0 4.0.0 > $GITHUB_WORKSPACE/upgrade390400-2.log | |
| php step5.php 3.9.0 4.0.0 > $GITHUB_WORKSPACE/upgrade390400-3.log | |
| php upgrade.php 4.0.0 5.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade400500.log | |
| php upgrade2.php 4.0.0 5.0.0 > $GITHUB_WORKSPACE/upgrade400500-2.log | |
| php step5.php 4.0.0 5.0.0 > $GITHUB_WORKSPACE/upgrade400500-3.log | |
| php upgrade.php 5.0.0 6.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade500600.log | |
| php upgrade2.php 5.0.0 6.0.0 > $GITHUB_WORKSPACE/upgrade500600-2.log | |
| php step5.php 5.0.0 6.0.0 > $GITHUB_WORKSPACE/upgrade500600-3.log | |
| php upgrade.php 6.0.0 7.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade600700.log | |
| php upgrade2.php 6.0.0 7.0.0 > $GITHUB_WORKSPACE/upgrade600700-2.log | |
| php step5.php 6.0.0 7.0.0 > $GITHUB_WORKSPACE/upgrade600700-3.log | |
| php upgrade.php 7.0.0 8.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade700800.log | |
| php upgrade2.php 7.0.0 8.0.0 > $GITHUB_WORKSPACE/upgrade700800-2.log | |
| php step5.php 7.0.0 8.0.0 > $GITHUB_WORKSPACE/upgrade700800-3.log | |
| php upgrade.php 8.0.0 9.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade800900.log | |
| php upgrade2.php 8.0.0 9.0.0 > $GITHUB_WORKSPACE/upgrade800900-2.log | |
| php step5.php 8.0.0 9.0.0 > $GITHUB_WORKSPACE/upgrade800900-3.log | |
| php upgrade.php 9.0.0 10.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade9001000.log | |
| php upgrade2.php 9.0.0 10.0.0 > $GITHUB_WORKSPACE/upgrade9001000-2.log | |
| php step5.php 9.0.0 10.0.0 > $GITHUB_WORKSPACE/upgrade9001000-3.log | |
| php upgrade.php 10.0.0 11.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade10001100.log | |
| php upgrade2.php 10.0.0 11.0.0 > $GITHUB_WORKSPACE/upgrade10001100-2.log | |
| php step5.php 10.0.0 11.0.0 > $GITHUB_WORKSPACE/upgrade10001100-3.log | |
| php upgrade.php 11.0.0 12.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade11001200.log | |
| php upgrade2.php 11.0.0 12.0.0 > $GITHUB_WORKSPACE/upgrade11001200-2.log | |
| php step5.php 11.0.0 12.0.0 > $GITHUB_WORKSPACE/upgrade11001200-3.log | |
| php upgrade.php 12.0.0 13.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade12001300.log | |
| php upgrade2.php 12.0.0 13.0.0 > $GITHUB_WORKSPACE/upgrade12001300-2.log | |
| php step5.php 12.0.0 13.0.0 > $GITHUB_WORKSPACE/upgrade12001300-3.log | |
| php upgrade.php 13.0.0 14.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade13001400.log | |
| php upgrade2.php 13.0.0 14.0.0 > $GITHUB_WORKSPACE/upgrade13001400-2.log | |
| php step5.php 13.0.0 14.0.0 > $GITHUB_WORKSPACE/upgrade13001400-3.log | |
| php upgrade.php 14.0.0 15.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade14001500.log | |
| php upgrade2.php 14.0.0 15.0.0 > $GITHUB_WORKSPACE/upgrade14001500-2.log | |
| php step5.php 14.0.0 15.0.0 > $GITHUB_WORKSPACE/upgrade14001500-3.log | |
| php upgrade.php 15.0.0 16.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade15001600.log | |
| php upgrade2.php 15.0.0 16.0.0 > $GITHUB_WORKSPACE/upgrade15001600-2.log | |
| php step5.php 15.0.0 16.0.0 > $GITHUB_WORKSPACE/upgrade15001600-3.log | |
| php upgrade.php 16.0.0 17.0.0 ignoredbversion > $GITHUB_WORKSPACE/upgrade16001700.log | |
| php upgrade2.php 16.0.0 17.0.0 > $GITHUB_WORKSPACE/upgrade16001700-2.log | |
| php step5.php 16.0.0 17.0.0 > $GITHUB_WORKSPACE/upgrade16001700-3.log | |
| - name: Result of migration scripts | |
| if: always() | |
| run: | | |
| ls -alrt $GITHUB_WORKSPACE/ | |
| echo Show content of last file | |
| cat "$(ls -rt $GITHUB_WORKSPACE/ | tail -n1)" | |
| - name: Enabling new modules | |
| run: | | |
| # Enable modules not enabled into original dump | |
| set -e | |
| cd /var/www/html/install | |
| php upgrade2.php 0.0.0 0.0.0 MAIN_MODULE_API,MAIN_MODULE_ProductBatch,MAIN_MODULE_SupplierProposal,MAIN_MODULE_STRIPE,MAIN_MODULE_ExpenseReport > $GITHUB_WORKSPACE/enablemodule.log | |
| php upgrade2.php 0.0.0 0.0.0 MAIN_MODULE_WEBSITE,MAIN_MODULE_TICKET,MAIN_MODULE_ACCOUNTING,MAIN_MODULE_MRP >> $GITHUB_WORKSPACE/enablemodule.log | |
| php upgrade2.php 0.0.0 0.0.0 MAIN_MODULE_RECEPTION,MAIN_MODULE_RECRUITMENT >> $GITHUB_WORKSPACE/enablemodule.log | |
| php upgrade2.php 0.0.0 0.0.0 MAIN_MODULE_KnowledgeManagement,MAIN_MODULE_EventOrganization,MAIN_MODULE_PARTNERSHIP >> $GITHUB_WORKSPACE/enablemodule.log | |
| php upgrade2.php 0.0.0 0.0.0 MAIN_MODULE_EmailCollector >> $GITHUB_WORKSPACE/enablemodule.log | |
| echo $? | |
| cd - | |
| - name: Result of enabling modules scripts | |
| if: always() | |
| run: | | |
| echo Show content of enablemodule.log file | |
| cat $GITHUB_WORKSPACE/enablemodule.log | |
| - name: Unit testing | |
| run: | | |
| # Ensure we catch errors. Set this to +e instead of -e if you want to go to the end to see dolibarr.log file. | |
| set -e | |
| cd /var/www/html | |
| sudo chmod -R a+rwx /var/www/html/documents | |
| includes/bin/phpunit -d memory_limit=-1 -c /var/www/test/phpunit/phpunittest.xml /var/www/test/phpunit/AllTests.php | |
| phpunitresult=$? | |
| echo "Phpunit return code = $phpunitresult" | |
| set +e | |