Audi-1 / sqli-labs

SQLI labs to test error based, Blind boolean based, Time based.
5.28k stars 1.52k forks source link

error when accessing http://localhost/sqli-labs/sql-connections/setup-db.php #5

Closed januspatrick closed 10 years ago

januspatrick commented 10 years ago

EX of Code error:

                                          Welcome    Dhakkan

SETTING UP THE DATABASE SCHEMA AND POPULATING DATA IN TABLES:

";} else {echo "[*]...................Error purging database: " . mysql_error(); echo "

";} //Creating new database security $sql="CREATE database security CHARACTER S, ET gbk "; if (mysql_query($sql)) {echo "[*]...................Creating New database successfully";echo "

";} else {echo "[*]...................Error creating database: " . mysql_error();echo "

blah, blah, blah, blah

Ive tried to reinstall this twice with the same error when clicking on the Setup/reset Database. Im using current version of Ubuntu. Apache2 has been installed and works. Same with mysql.

File location: /var/www/sqli-labs/

Any suggestions?

Audi-1 commented 10 years ago

This issue seems to be unique to you because i tested it and it works fine. May be it is being affected because of the way how you copy it. Did u try cloning the repo using Git commands. Generally this happens when the code in the file is not getting interpreted as intended. I am not a programer by heart but saw some issues with unbalanced HTML TAGS. updated the file, so you should not have any issue. Else you can copy the SQL strings manually and paste them into mysql editor to get the database populated manually line by line.

a0xnirudh commented 9 years ago

@januspatrick The above mentioned issue seems to exist on normal Ubuntu versions because I personally tried it on 2 different machines and end up with the above error state. Since the sqli-labs are optimized to work with Kali linux, it will be best if users can install Kali in virtual box and then you can do the same in kali after you start apache2 and mysql services (You have to do this manually since they will not be started by default when kali boots up.). After that if you don't like to work on virtual box (like me), you can set a host only adapter in virtual box configuration which will assign a particular ip address to your kali machine, something like 192.168.xx.xx.

Once this is done, you can access the sqli-labs from the host machine by going to 192.168.xx.xx/sqli-labs .

Here is an old tutorial I have written about setting up host only adapter in virtual box: http://goo.gl/wYrMS2

@Audi-1 I am not sure why it happens in Ubuntu varients (I am still not sure if it happens on every ubuntu varients but its happening for me and my friends machine) but I will take a detail look into it and will try to fix it.

Sqli-labs is an extremly wonderful job from your side ..

HanwGeek commented 6 years ago

I encountered with the same problem on Ubuntu16.04+php5.6. And I guess it's about system code format. With the command 'locale', my format is UTF-8.

parteeksingh005 commented 6 years ago

SETTING UP THE DATABASE SCHEMA AND POPULATING DATA IN TABLES: Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\sqli1\sql-connections\setup-db.php:29 Stack trace: #0 {main} thrown in C:\xampp\htdocs\sqli1\sql-connections\setup-db.php on line 29

unable to setup datbase in XAMMP gettinh this error someone help me with this issue .

ankitb458 commented 4 years ago

SETTING UP THE DATABASE SCHEMA AND POPULATING DATA IN TABLES: Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\sqli1\sql-connections\setup-db.php:29 Stack trace: #0 {main} thrown in C:\xampp\htdocs\sqli1\sql-connections\setup-db.php on line 29

unable to setup datbase in XAMMP gettinh this error someone help me with this issue .

ArrowShot commented 4 years ago

SETTING UP THE DATABASE SCHEMA AND POPULATING DATA IN TABLES: Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\sqli1\sql-connections\setup-db.php:29 Stack trace: #0 {main} thrown in C:\xampp\htdocs\sqli1\sql-connections\setup-db.php on line 29

unable to setup datbase in XAMMP gettinh this error someone help me with this issue .

are u find solution

tou-min commented 2 weeks ago
                                          Welcome    Dhakkan

/var/www/sqli-labs/

I have solved the problem. I encountered this issue when using a Windows 10 virtual machine. Apache did not use PHP correctly to load this file, resulting in the. php file being displayed as plain text