Support for External Database like RDS

[adv4000]

Do you have any draft for support External Database and not use only local DB?
So it can be configured using parameter MYSQL_MISP_HOST in addition to MYSQL_MISP_PASSWORD

[ventz]

@adv4000 No, but it should be pretty easy for you add it:

Essentially modifying the init-db to include "host":

docker-misp/container/Dockerfile

Line 150 in d954df2

echo "#!/bin/bash" > /init-db ; \

And then adding a host like this:

docker-misp/container/Dockerfile

Line 137 in d954df2

RUN sed -i -e 's/db login/misp/g' /var/www/MISP/app/Config/database.php ; \

and here:

docker-misp/container/Dockerfile

Line 165 in d954df2

echo "sudo -u www-data -H sh -c \"mysql -u misp -p$MYSQL_MISP_PASSWORD misp < /var/www/MISP/INSTALL/MYSQL.sql\"" >> /init-db ; \

And (optionally) removing service here:

docker-misp/container/supervisord.conf

Line 15 in d954df2

[program:mysql]

[adv4000]

Thanks, working on it now...

[adv4000]

Into build.sh added:

    --build-arg MYSQL_MISP_USERNAME=adminuser \
    --build-arg MYSQL_MISP_PASSWORD=adminpass \
    --build-arg MYSQL_MISP_ENDPOINT=misp-mysql.xxx.us-west-2.rds.amazonaws.com \
    --build-arg MYSQL_MISP_DBNAME=mispdb \

Inside Dockerfile Added/Updated:

ARG MYSQL_MISP_USERNAME=demouser
ARG MYSQL_MISP_PASSWORD=demopass
ARG MYSQL_MISP_ENDPOINT=mysql-rds.us-west-2.rds.amazonaws.com
ARG MYSQL_MISP_DBNAME=mispdbdemo

RUN sed -i -e "s/misp/${MYSQL_MISP_DBNAME}/g"          /var/www/MISP/app/Config/database.php ; \
    sed -i -e "s/db login/${MYSQL_MISP_USERNAME}/g"    /var/www/MISP/app/Config/database.php ; \
    sed -i -e "s/db password/${MYSQL_MISP_PASSWORD}/g" /var/www/MISP/app/Config/database.php ; \
    sed -i -e "s/localhost/${MYSQL_MISP_ENDPOINT}/g"   /var/www/MISP/app/Config/database.php ; \
    echo "sudo -u www-data -H sh -c \"mysql -h ${MYSQL_MISP_ENDPOINT} -u ${MYSQL_MISP_USERNAME} -p$MYSQL_MISP_PASSWORD ${MYSQL_MISP_DBNAME} < /var/www/MISP/INSTALL/MYSQL.sql\"" >> /init-db ; \

And removed many lines with local db folder usage.
Seems like working fine :) Thanks!