FROM ddkits/lamp:7

MAINTAINER Mutasem Elayyoub <melayyoub@outlook.com>

RUN apt-get update && apt-get install -y --force-yes \
php-pear libicu-dev curl git libmemcached-dev zlib1g-dev libncurses5-dev libfreetype6-dev libjpeg62-turbo-dev libmcrypt-dev libpng12-dev libpq-dev --no-install-recommends
RUN echo 'deb http://ftp.de.debian.org/debian stretch main' | sudo tee -a /etc/apt/sources.list
RUN echo 'deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main' | sudo tee -a /etc/apt/sources.list.d/pgdg.list

RUN sudo apt-key update &&\ 
	sudo apt-get update


RUN apt-get update && DEBIAN_FRONTEND=noninteractive apt-get install -y --force-yes php7.0-pgsql php7.0-zip php7.0-xml php7.0-readline php7.0-opcache php7.0-mysql php7.0-mcrypt php7.0-mbstring php7.0-json php7.0-intl php7.0-gd php7.0-fpm php7.0-curl php7.0-bcmath php7.0-cli libapache2-mod-php7.0 php7.0-common php7.0-pgsql

RUN docker-php-ext-install pdo pgsql pdo_pgsql zip mbstring
 
RUN docker-php-ext-install iconv mcrypt \
  && docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/ \
  && docker-php-ext-install gd \
  && docker-php-ext-install intl \
  && apt-get autoremove

RUN apt-key adv --keyserver hkp://p80.pool.sks-keyservers.net:80 --recv-keys B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8
RUN apt-get install -y --force-yes python-software-properties software-properties-common postgresql-9.6 postgresql-client-9.6 postgresql-contrib-9.6

COPY ./osdata.sql /osdata.sql
RUN chmod -R 777 /osdata.sql
USER postgres
RUN  /etc/init.d/postgresql start &&\
     psql --command "CREATE USER main WITH SUPERUSER PASSWORD 'main'; " &&\
	 psql --command "CREATE DATABASE main; " &&\
	 psql -U postgres main < /osdata.sql

RUN echo "host all  all    0.0.0.0/0  md5" >> /etc/postgresql/9.6/main/pg_hba.conf

RUN echo "listen_addresses='*'" >> /etc/postgresql/9.6/main/postgresql.conf

EXPOSE 5432

# Add VOLUMEs to allow backup of config, logs and databases
VOLUME  ["/etc/postgresql", "/var/log/postgresql", "/var/lib/postgresql"]

# Set the default command to run when starting the container

# /usr/lib/postgresql/9.6/bin/pg_ctl -D /var/lib/postgresql/9.6/main -l logfile start
CMD ["/usr/lib/postgresql/9.6/bin/postgres", "-D", "/var/lib/postgresql/9.6/main", "-c", "config_file=/etc/postgresql/9.6/main/postgresql.conf"]
