MySQL Soap Server
Create a soap-server from a running mysql server!
A gsoap wrapper over the MySQL C API
  • What is MySQL Soap Server? MySQL Soap Server creates a soapserver from a running MySQL Database Server! You can run it as a standalone service or as cgi! When started MySQL Soap Server creates a webservice from any selected database which can by accessed by any programming lanuage that supports soap!
  • Isn`t that a security risk? That depends on how you start the soapserver and how you define the privileges in MySQL Database Server! You should create a webservice-user and limit the rights, but that actually depends on what you want to do!
  • Why should I do this? I dont know! Maybe you want to jump on the webservice hype by offering a webservice to your users. Or maybe you just want to share a sepecific table of your database! Maybe you want to share data on a different port then MySQL Database Server is running!

    Usage:
    console# ./mysqlsoapserver -h

    mysqlsoapserver Version 0.0.1 (c) 2006 Manfred Weber
    Usage: ./mysqlsoapserver [-h] [-V] [-P] [-l] [-w] [-m MODE] [-a AUTH] [-u USER] [-p PASSWD]

    -hprint this help and exit
    -Vprint version and exit
    -Pset port - default is 80
    -lenable logging and statistics
    -wenable wsdl mode - default is disabled
    -m MODErun as cgi - default is standalone
    -a AUTHset authorization mode: - default is disabled
    -B BACKLOGset maximum request backlog - default is 100
    -T MAX_THREADSset maximum size of threadpool - default is 10
    -Q MAX_QUEUEset maximum size of request queue - default is 1000
    -u USERset authorization user
    -p PASSWDset authorization password

    Example:
    ./mysqlsoapserver -P8080 -w -uwebservice -pwebservice
  • Creates a standalone soap-server on port 8080. Default encoding is wrapped-literal
  • Creates a WSDL-File of this service.
  • Like .NET Webservices the WSDL is available at http://dschini.org:8080?wsdl
  • Maps the webservice user privileges of the MySQL Database Server to this soap-service
    Licence:
    http://dev.dschini.org/mysqlsoapserver/COPYING

    What more?
    MySQL Soap Server is programmed in the C Programming language. To compile it you should know how to use the GNU Autotools. A simple ./configure,make should work. Please note that I am not a C-Expert. This tool works pretty well on my Suse 9.3 but I am pretty sure there are bugs. I did not really test it in other environments! If you like the idea of MySQL Soap Server and like to help developing or just fix bugs you are very much welcome! I take no warranty that this works at all or is stable! You are free to decide if you want to use this tool or not. I just thought I share this tool with you before it gets completely lost in my archive.

    Download
    You can download the MySQL Soap Server here

    More links
    My Blog   Dschini Games

    Manfred Weber
    http://manfred.dschini.org
    manfred.weber@gmail.com