You can view a video tutorial on how to download and install My SQL server . This is free software . Unlike the video just install with default options. LaserQuote can also use MS SQL and Oracle . Extra charges apply for these options so please contact us if you prefer these options.
You can view a video tutorial on how to download and install My SQL server . This is free software . The video below runs trough the entire process .
Please leave the user-name as root and make note of the password you are using . Do not loose or forget this password as this will make it impossible to access your data .
Once MySQL is running as a service on your server you can now double click on the setup file you downloaded from Idronic.com . Please follow the default options all the way to the final screen . When prompted to select the database please choose MySql . At the end of the setup run LQ will ask you for the credentials of MySQL . These are user name "root" and the password you set in the earlier step .
The very last step of the install wizard will ask you to view the read me file and start the server . Please go ahead and do so . LQ will start loading , at the end of the start up you should see three green messages for all running processes indicated the server is ready :
Now you are ready to point your web browser ( Internet Explorer , Firefox , Safari , Chrome ) to the following address :
http://your.server.ip:8080/LaserQuote/logon.html
Your initial user-name is "admin" and password is "password" .
Use them to login . LQ will start the initial System Settings screen which requires data to be enter to allow LQ to function .Please fill in as per the exampled below using your company information and mail server details :
Click Create and proceed to the next screen where you can modify your personal details as the admin of the system , including your password . Select Save when your are done.
The process is now complete and you can start using LQ. LQ is currently running in full access demo mode for a period of 30 days . If you would like to continue using LQ beyond the 30 days mark then please purchase a licence by emailing us at [email protected] with your LQ Product ID number which can be found by selection the About button on the LQ configuration tool.
Once we receive this information we will send you your licence key which can be entered via the "Product Key" in the LaserQuote directory .
MySQL Procedures
LaserQuote makes use of stored procedures . These are pre-written instructions need it by MySQL to execute complex queries .Within the install directory you will find a folder called "Install" . Here you will find .SQL files called "Attachments" , "Parts" and "CostingperPart" .
For this procedure you can use any software designed to manage Mysql databases . This can also be the software of your choice to execute your MySQL backups .
Please view the following video which demonstrated the import procedure .
Idronic recommends Navicat . Navicat will also enable you to create a backup routine for your data .
