Re: [sqlmap-users] Database command issue

[Miroslav S. <mir...@gm...>]

Hi.

This is a general error when (user's) Oracle environment is not properly
being set. I'll make a minor patch to warn an user about it (avoiding this
kind of crashes).

Maybe you can find some interesting info at: [1], [2], [3].

Kind regards,
Miroslav Stampar

[1] http://comments.gmane.org/gmane.comp.python.db.cx-oracle/2357
[2] https://forums.oracle.com/thread/1111594
[3]
http://stackoverflow.com/questions/13589683/interfaceerror-unable-to-acquire-oracle-environment-handle-oracle-home-is-corr


On Fri, Aug 9, 2013 at 8:45 PM, rkas solutions <rka...@gm...>wrote:

> Hi
>
> I am using SQLMAP recent build
> sqlmap version: 1.0-dev
> Python version: 2.7.5
>
> --dbms=Oracle and --dbs works fine. It retrieves all schemas/ databases
> from Oracle. But, -D, -T, -C and related database data retrieval commands
> are not producing results.
>
> [14:25:29] [WARNING] the SQL query provided does not return any output
> [14:25:29] [WARNING] in case of continuous data retrieval problems you are
> advis
> ed to try a switch '--no-cast' or switch '--hex'
> [14:25:29] [ERROR] unable to retrieve the table names for any database
> do you want to use common table existence check? [y/N/q] y
> [14:25:55] [INFO] checking table existence using items from
> 'C:\sqlmap\txt\commo
> n-tables.txt'
> [14:25:55] [INFO] adding words used on web page to the check list
> please enter number of threads? [Enter for 1 (current)] 10
> [14:26:01] [INFO] starting 10 threads
> [14:26:10] [WARNING] no table(s) found
> No tables found
> [14:26:10] [INFO] fetched data logged to text files under
> 'C:\sqlmap\output\localhost'
>
> Is there anything I need to setup to make these commands work. Also,
> python sqlmap.py -d "oracle://user:pasword@IP:port/DB" does not work. No
> results and it throws below error.
>
> Technique: DIRECT
> Back-end DBMS: Oracle (identified)
> Traceback (most recent call last):
>   File "sqlmap.py", line 95, in main
>     start()
>   File "C:\sqlmap\lib\controller\controller.py", line 248, in start
>     action()
>   File "C:\sqlmap\lib\controller\action.py", line 32, in action
>     setHandler()
>   File "C:\sqlmap\lib\controller\handler.py", line 96, in setHandler
>     conf.dbmsConnector.connect()
>   File "C:\sqlmap\plugins\dbms\oracle\connector.py", line 43, in connect
>     self.connector = cx_Oracle.connect(dsn=self.__dsn, user=self.user,
> password=
> self.password, mode=cx_Oracle.SYSDBA)
> InterfaceError: Unable to acquire Oracle environment handle
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> sqlmap-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlmap-users
>
>


-- 
Miroslav Stampar
http://about.me/stamparm