{"action":"created","issue":{"url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/1170","labels_url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/1170/labels{/name}","comments_url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/1170/comments","events_url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/1170/events","html_url":"https://github.com/sqlmapproject/sqlmap/issues/1170","id":58365950,"number":1170,"title":"File write on PostgreSQL 9.1.15 fails","user":{"login":"inquisb","id":675322,"avatar_url":"https://avatars.githubusercontent.com/u/675322?v=3","gravatar_id":"","url":"https://api.github.com/users/inquisb","html_url":"https://github.com/inquisb","followers_url":"https://api.github.com/users/inquisb/followers","following_url":"https://api.github.com/users/inquisb/following{/other_user}","gists_url":"https://api.github.com/users/inquisb/gists{/gist_id}","starred_url":"https://api.github.com/users/inquisb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/inquisb/subscriptions","organizations_url":"https://api.github.com/users/inquisb/orgs","repos_url":"https://api.github.com/users/inquisb/repos","events_url":"https://api.github.com/users/inquisb/events{/privacy}","received_events_url":"https://api.github.com/users/inquisb/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sqlmapproject/sqlmap/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/sqlmapproject/sqlmap/labels/high","name":"high","color":"e102d8"},{"url":"https://api.github.com/repos/sqlmapproject/sqlmap/labels/takeover","name":"takeover","color":"d7e102"}],"state":"closed","locked":false,"assignee":{"login":"stamparm","id":921555,"avatar_url":"https://avatars.githubusercontent.com/u/921555?v=3","gravatar_id":"","url":"https://api.github.com/users/stamparm","html_url":"https://github.com/stamparm","followers_url":"https://api.github.com/users/stamparm/followers","following_url":"https://api.github.com/users/stamparm/following{/other_user}","gists_url":"https://api.github.com/users/stamparm/gists{/gist_id}","starred_url":"https://api.github.com/users/stamparm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stamparm/subscriptions","organizations_url":"https://api.github.com/users/stamparm/orgs","repos_url":"https://api.github.com/users/stamparm/repos","events_url":"https://api.github.com/users/stamparm/events{/privacy}","received_events_url":"https://api.github.com/users/stamparm/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/sqlmapproject/sqlmap/milestones/1","html_url":"https://github.com/sqlmapproject/sqlmap/milestones/1.0","labels_url":"https://api.github.com/repos/sqlmapproject/sqlmap/milestones/1/labels","id":137260,"number":1,"title":"1.0","description":"","creator":{"login":"inquisb","id":675322,"avatar_url":"https://avatars.githubusercontent.com/u/675322?v=3","gravatar_id":"","url":"https://api.github.com/users/inquisb","html_url":"https://github.com/inquisb","followers_url":"https://api.github.com/users/inquisb/followers","following_url":"https://api.github.com/users/inquisb/following{/other_user}","gists_url":"https://api.github.com/users/inquisb/gists{/gist_id}","starred_url":"https://api.github.com/users/inquisb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/inquisb/subscriptions","organizations_url":"https://api.github.com/users/inquisb/orgs","repos_url":"https://api.github.com/users/inquisb/repos","events_url":"https://api.github.com/users/inquisb/events{/privacy}","received_events_url":"https://api.github.com/users/inquisb/received_events","type":"User","site_admin":false},"open_issues":12,"closed_issues":571,"state":"open","created_at":"2012-06-26T14:08:56Z","updated_at":"2015-07-24T12:56:51Z","due_on":"2015-04-12T23:00:00Z","closed_at":null},"comments":18,"created_at":"2015-02-20T15:15:56Z","updated_at":"2015-07-24T14:49:00Z","closed_at":"2015-07-24T12:56:51Z","body":"File write operations (hence takeover) fails on PostgreSQL 9.1.5 with an error on lo_export():\r\n```\r\n[20:47:01] [PAYLOAD] 1;SELECT lo_export(2008, '/tmp/test123.txt')--\r\n[20:47:01] [WARNING] parsed DBMS error message: 'ERROR:  pg_largeobject entry for OID 2008, page 0 has invalid data field size 2378'\r\n```\r\n\r\nThis happens also if connected as `postgres` with psql to the database locally. Same statements worked on PostgreSQL 9.1.11.\r\n\r\nCheck documentation on http://www.postgresql.org/docs/9.1/static/catalog-pg-largeobject.html."},"comment":{"url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/comments/124547244","html_url":"https://github.com/sqlmapproject/sqlmap/issues/1170#issuecomment-124547244","issue_url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/1170","id":124547244,"user":{"login":"Kamulha","id":13439987,"avatar_url":"https://avatars.githubusercontent.com/u/13439987?v=3","gravatar_id":"","url":"https://api.github.com/users/Kamulha","html_url":"https://github.com/Kamulha","followers_url":"https://api.github.com/users/Kamulha/followers","following_url":"https://api.github.com/users/Kamulha/following{/other_user}","gists_url":"https://api.github.com/users/Kamulha/gists{/gist_id}","starred_url":"https://api.github.com/users/Kamulha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kamulha/subscriptions","organizations_url":"https://api.github.com/users/Kamulha/orgs","repos_url":"https://api.github.com/users/Kamulha/repos","events_url":"https://api.github.com/users/Kamulha/events{/privacy}","received_events_url":"https://api.github.com/users/Kamulha/received_events","type":"User","site_admin":false},"created_at":"2015-07-24T14:49:00Z","updated_at":"2015-07-24T14:49:00Z","body":"I concatenated the two files you linked me in one file (with the right credentials) and I tried to upload it with --file-write; it says the right file size when it checks the file (as you said file size check is broken), but if I go on the page with my browser there's a 404 error: the file hasn't been uploaded.\r\nAfter, I tried to use --file-read to read the file that should have been uploaded, but there isn't any output, so I tried to read a file that exists on the server and SQLMap retrieved it successfully.\r\nThis is why I think there's a problem with --file-write :wink: "}}