Title: Error "Not an executable object" while using direct connection to PostgreSQL · Issue #5576 · sqlmapproject/sqlmap · GitHub
Open Graph Title: Error "Not an executable object" while using direct connection to PostgreSQL · Issue #5576 · sqlmapproject/sqlmap
X Title: Error "Not an executable object" while using direct connection to PostgreSQL · Issue #5576 · sqlmapproject/sqlmap
Description: Describe the bug I'm using -d flag for direct connection for PostgreSQL sqlmap -d 'postgres://username:password@IP:5432/DB' -vvvvv and get the output below [INFO] connection to PostgreSQL server 'xxxxx' established [INFO] testing Postgre...
Open Graph Description: Describe the bug I'm using -d flag for direct connection for PostgreSQL sqlmap -d 'postgres://username:password@IP:5432/DB' -vvvvv and get the output below [INFO] connection to PostgreSQL server 'x...
X Description: Describe the bug I'm using -d flag for direct connection for PostgreSQL sqlmap -d 'postgres://username:password@IP:5432/DB' -vvvvv and get the output below [INFO] connection to PostgreS...
Opengraph URL: https://github.com/sqlmapproject/sqlmap/issues/5576
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error \"Not an executable object\" while using direct connection to PostgreSQL","articleBody":"**Describe the bug**\r\n\r\nI'm using `-d` flag for direct connection for PostgreSQL\r\n```bash\r\nsqlmap -d 'postgres://username:password@IP:5432/DB' -vvvvv\r\n```\r\nand get the output below\r\n```\r\n[INFO] connection to PostgreSQL server 'xxxxx' established\r\n[INFO] testing PostgreSQL\r\n[PAYLOAD] SELECT (CASE WHEN (CONVERT_TO('yEcP', QUOTE_IDENT(NULL)) IS NULL) THEN '1' ELSE '0' END)\r\n[TRAFFIC IN] Not an executable object: \"SELECT (CASE WHEN (CONVERT_TO('yEcP', QUOTE_IDENT(NULL)) IS NULL) THEN '1' ELSE '0' END)\"\r\n[WARNING] the back-end DBMS is not PostgreSQL\r\n```\r\n\r\nI traced the code and found it died here\r\n- lib/utils/timeout.py\r\n```python\r\nthread = InterruptableThread()\r\nthread.start()\r\nthread.join(duration)\r\n\r\n...\r\n\r\n def run(self):\r\n try:\r\n self.result = func(*(args or ()), **(kwargs or {}))\r\n self.timeout_state = TIMEOUT_STATE.NORMAL\r\n except Exception as ex:\r\n logger.log(CUSTOM_LOGGING.TRAFFIC_IN, ex)\r\n self.result = default\r\n self.timeout_state = TIMEOUT_STATE.EXCEPTION\r\n```\r\n\r\n**To Reproduce**\r\n\r\n**Expected behavior**\r\n\r\n**Screenshots**\r\n\r\n**Running environment:**\r\nRunning on SQLmap 1.7.11.2#dev\r\nTesting for PostgresSQL 9.1 , 9.5 , 9.11\r\n\r\n**Target details:**\r\n\r\n**Additional context**\r\n","author":{"url":"https://github.com/ktecv2000","@type":"Person","name":"ktecv2000"},"datePublished":"2023-11-30T10:23:16.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/5576/sqlmap/issues/5576"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:70248624-c4c6-be32-08db-79dc8ef552d0 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | CD36:225C45:CDC6DF:1169AFE:6A5A9ADC |
| html-safe-nonce | f18e5733acc0a7df5c3d0d59b56271bff4d6d9bd374cf79d95919e688fd4a6d3 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRDM2OjIyNUM0NTpDREM2REY6MTE2OUFGRTo2QTVBOUFEQyIsInZpc2l0b3JfaWQiOiIxMDIzNDY5NDg2OTg3NzEzMjQ0IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0= |
| visitor-hmac | 08d5be6f1115c3a0e4c924a255560a782d3d8a5913f5921dac14667aa3bace05 |
| hovercard-subject-tag | issue:2018326875 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlmapproject/sqlmap/5576/issue_layout |
| twitter:image | https://opengraph.githubassets.com/0297393ca95089ef88582289671b7a66896391d811a47d17d8bc79176857b1ee/sqlmapproject/sqlmap/issues/5576 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/0297393ca95089ef88582289671b7a66896391d811a47d17d8bc79176857b1ee/sqlmapproject/sqlmap/issues/5576 |
| og:image:alt | Describe the bug I'm using -d flag for direct connection for PostgreSQL sqlmap -d 'postgres://username:password@IP:5432/DB' -vvvvv and get the output below [INFO] connection to PostgreSQL server 'x... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | ktecv2000 |
| hostname | github.com |
| expected-hostname | github.com |
| None | 69f915f8d1f777c494e9106a13f148eaddfa8984cb86436e87809d42b400e544 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlmapproject/sqlmap git https://github.com/sqlmapproject/sqlmap.git |
| octolytics-dimension-user_id | 735289 |
| octolytics-dimension-user_login | sqlmapproject |
| octolytics-dimension-repository_id | 4793392 |
| octolytics-dimension-repository_nwo | sqlmapproject/sqlmap |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 4793392 |
| octolytics-dimension-repository_network_root_nwo | sqlmapproject/sqlmap |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | c9a4a89553add5a97cf9f034f0e1e7f1a66257c9 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width