Still trying to copy data from audit-consolidator into IRIS Cloud SQL
Within IRIS I defined a task to export audit data every day.
I provide some sample files in my GitHub repo.
I wrote ObjectScript code to import all files into otw.audit.consolidator class.
I want to use Python SQLAlchemy, pandas and sqlalchemy-iris (created by Dmitry Maslenikov) to copy consolidated audit data from my consolidator class in my IRIS container to my InterSystems Cloud SQL deployment.
I updated my Dockerfile to pip3 install sqlalchemy-iris and pandas (dataframes).
docker-compose build –no-cache in my personal AWS took 700 seconds.
docker-compose up-d starts audit-consolidator container.
I found an error in docker logs:
Unable to find/open file iris-main.log in current directory /home/irisowner/irisdev
Comments
I fixed the error running audit-consolidator in AWS by adjusting directory permissions. irisowner did not have write permissions on /home/irisowner/irisdev directory until I ran "chmod 777 ."