HowTO: Compiles CQ for Linux with MySQL

  • Howto compile CQ with mysql for Linux
    tested with the 1.4.13 and 1.4.14beta


    1. Extract source
    2. Extract jped


    3. write create script


    g++ -DUNIX -DNATIVE_ENDIAN=1 -DNOINTJPEG -DUSEMYSQL total.cxx -o dgate -lpthread -L/usr/lib/mysql -lmysqlclient



    changes in the source


    4. => odbci.hpp:61
    VOR 61:#include "C:\mysql-5.0.22-win32\include\mysql.h"
    NACH 61:#include "/usr/include/mysql/mysql.h"



    6. change de dicom.sql.postgres to dicom.sql


    7. configigure dicom.ini
    # Host, database, username and password for postgres server
    SQLHost = localhost
    SQLServer = conquest
    Username = conquestuser
    Password = ypurmysqlpass
    MySQL = 1

  • Hi, thanks for your job.
    Which linux distribution have you used?
    Because on my Debian etch, , I got many errors and warnings.
    I found that the folder /usr/lib/mysql doesn't exist as well as the file /usr/include/mysql/mysql.h .


    Also, i wondered if these operations need to be made before or after using maklinux?


    Thanks again.

  • Why not writing a complete tutorial to install conquest on linux with a mysql db ?


    HERE IS HOW IT WORKS for me on Debian ETCH


    Required:
    - create a DB called "conquest" with phpmyadmin
    - install libmysqlclientdev: apt-get install libmysqlclient-dev
    - install sudo
    - install G++
    - Check /usr/lib/cgi-bin/ exists and is enabled in apache2.conf


    In shell:
    wget path_to_ftp/conquestlinuxXXXX.zip //Get remote files
    wget path_to_ftp/jpegsuplinuxXXXX.zip
    unzip conquestlinuxXXXX.zip // unzip all files
    unzip jpegsuplinuxXXXX.zip -d conquest
    cd conquest
    chmod 777 dcmdjpeg
    chmod 777 dcmcjpeg


    Edit maklinux and replace its content with:

    Code
    g++ -DUNIX -DNATIVE_ENDIAN=1 -DNOINTJPEG -DUSEMYSQL total.cxx -o dgate -lpthread -L/usr/lib/mysql -lmysqlclientpkill -9 dgatesleep 0.2ssudo cp dgate /usr/lib/cgi-bin/dgate.htmlsudo cp dgate /usr/lib/cgi-binsudo cp dicom.sql /usr/lib/cgi-binsudo cp dicom.ini /usr/lib/cgi-bin


    In shell:
    chmod 777 maklinux
    chmod 777 dgate


    Edit ODBCI.hpp
    Replace at line 59
    #include "C:\mysql-5.0.22-win32\include\mysql.h"
    By: include "/usr/include/mysql/mysql.h"
    And
    Replace at line 105
    # include <mysql>
    By: include "/usr/include/mysql/mysql.h"


    Modify dicom.ini

    Code
    # Host, database, username and password for postgres server
    SQLHost = localhost
    SQLServer = conquest
    Username = login
    Password = password
    MySQL = 1


    TO FINISH:
    ./dgate -v -r //regenerate the database
    ./dgate -v //Run the server


    I'm waiting for your help to edit this tuto[/code]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!