November 28th 2015 Posted at Databases
Comments Off on My Lamp Experience
Lets share my experience as a LAMP professional and how i enjoyed setting up application server for my company as an individual team member. It was difficult to start with a big corporate project. But due to my prior experience on PHP and MySQL based open source software, it was easy for me. On the CENTOS 5 platform, we already had PHP 5 but i installed PHP 4 as CGI so that i can run my both type of applications.It was just like installing php 4 from php.net and then compiling it with lot of additional extensions. After the compilation process, we have linked the PHP 4 scripts to run as cgi script using php 4 interpreter. Then there was MySQL 5 already running on port number 3307, what i did, installed mysql 4 on the another port number 3306, making some modifications in my.cnf, confIguration file for MySQL. There was some issue while installation, as mysql service was starting and then stopping in the presence of another mysql running on the same server. But at the end, it was some user and group permissions issue, that was blocking the service to run. But at last i have completed Dual Installation of PHP and MySQL on the LAMP Server. Then installed phpmyadmin to manage mysql server by putting appropriate securities inside the phpmyadmin default configuration file. Uploaded source code for website and customized it according to my organizations need. But after the hard work of three to four months i was successful in setting it up with some advance automation and syncronization scripts running on it. Developed an advanced Support Ticketing system on the LAMP platform, customized the platform according to the needs of support application, testing scripts on the LAMP, testing scripts integration with the mail server, testing scripts integration with MySQL database, it took around 8-9 months. Finally i got a support ticketing system, where customers can register themselves and can track their issues. Engineers can reply to their questions.The communication done on Microsoft Outlook can be seen and tracked on MySQL database, Administrator can get reports of the service provided by engineers and Non-Resolved Issues can be escalated to main support server at different location.It was a great success for me to develop such transparent support system and one of the big projects i have completed on LAMP.
Puneet verma is web consultant with more than 4 years experience in Telecom & Networking, ECommerce Industry.You can connect to him on skype id: puneet6565 OR mail him at firstname.lastname@example.org. He is currently running www.extranetworld.com and a green blog www.greentechdelhi.com .