sieteunoseis/cucm-sql-editor repository overview

⁠Cisco CUCM SQL Editor

A NodeJS web application to edit SQL queries and run again Cisco CUCM database. Results are returned to a web-based spreadsheet that can be download to CSV if needed.

Administrative XML (AXL) information can be found at: Administrative XML (AXL) Reference⁠.

⁠Getting Started

These instructions will cover usage information and for the docker container

⁠Prerequisities

In order to run this container you'll need docker installed.

• Windows⁠
• OS X⁠
• Linux⁠

⁠Usage

⁠Container Parameters

Start container with exposed ports and mounted volume.

docker run -d -p 3000:3000 --name cucm-sql-editor --restart=always --env-file=.env -v cucm-sql-data:/app/data sieteunoseis/cucm-sql-editor:latest

How to get a shell started in the container

docker run sieteunoseis/cucm-sql-editor:latest sh

⁠Environment Variables

• NODE_ENV - Used for production or development
• CUCM_HOSTNAME - Hostname of CUCM publisher
• CUCM_USERNAME - AXL username
• CUCM_PASSWORD - AXL password
• CUCM_VERSION - CUCM version

⁠Volumes

• /app/data - File storage location for saved queries. Mount to host volume to access and edit .sql files on host machine.

⁠Built With

• NodeJS 18

⁠Find Us

• GitHub⁠

⁠Versioning

We use SemVer⁠ for versioning. For the versions available, see the tags on this repository⁠.

⁠Authors

• Jeremy Worden - AutomateBuilders⁠

⁠License

This project is licensed under the MIT License - see the LICENSE.md⁠ file for details.

⁠Acknowledgments

• Developers of strong-soap⁠