{"action":"created","issue":{"url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191","labels_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191/labels{/name}","comments_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191/comments","events_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191/events","html_url":"https://github.com/volatilityfoundation/volatility/issues/191","id":59835255,"number":191,"title":"OverflowError: Python int too large to convert to SQLite INTEGER","user":{"login":"Sebastienbr","id":2241339,"avatar_url":"https://avatars.githubusercontent.com/u/2241339?v=3","gravatar_id":"","url":"https://api.github.com/users/Sebastienbr","html_url":"https://github.com/Sebastienbr","followers_url":"https://api.github.com/users/Sebastienbr/followers","following_url":"https://api.github.com/users/Sebastienbr/following{/other_user}","gists_url":"https://api.github.com/users/Sebastienbr/gists{/gist_id}","starred_url":"https://api.github.com/users/Sebastienbr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Sebastienbr/subscriptions","organizations_url":"https://api.github.com/users/Sebastienbr/orgs","repos_url":"https://api.github.com/users/Sebastienbr/repos","events_url":"https://api.github.com/users/Sebastienbr/events{/privacy}","received_events_url":"https://api.github.com/users/Sebastienbr/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-03-04T17:54:21Z","updated_at":"2015-03-04T20:14:50Z","closed_at":null,"body":"Seems there's a problem with long value (>0x7FFFFFFFFFFFFFFF) and sqlite...\r\n\r\nC:\\Volatility\\volatility-e9cbdcc6c7>python vol.py -f Win7-64.vmem --profile=Win7SP1x64 pslist --output=sqlite --output-file=test.sqlite\r\nVolatility Foundation Volatility Framework 2.4\r\nINSERT INTO PSList VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [1, 0, 18446738026408463152L, 'System', 4, 0, 81, 526, -1, 0, '2013-11-29 16:39:19 UTC+0000', '']\r\nTraceback (most recent call last):\r\n  File \"vol.py\", line 192, in <module>\r\n    main()\r\n  File \"vol.py\", line 183, in main\r\n    command.execute()\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\commands.py\", line 140, in execute\r\n    func(outfd, data)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\commands.py\", line 284, in render_sqlite\r\n    self._render(outfd, SqliteRenderer(self.__class__.__name__, self._config), data)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\commands.py\", line 269, in _render\r\n    renderer.render(outfd, output)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\sqlite.py\", line 44, in render\r\n    grid.visit(None, self._add_row, {None: 0})\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\__init__.py\", line 254, in visit\r\n    accumulator = self._visit(children, function, accumulator, sort_key)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\__init__.py\", line 261, in _visit\r\n    accumulator = function(n, accumulator)\r\n  File \"C:\\Volatility\\volatility-e9cbdcc6c7\\volatility\\renderers\\sqlite.py\", line 32, in _add_row\r\n    self._db.execute(insert, [accumulator[node], accumulator[node.parent]] + list(node.values))\r\n\r\n\r\nThanks!\r\n\r\nSebastien"},"comment":{"url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/comments/77236928","html_url":"https://github.com/volatilityfoundation/volatility/issues/191#issuecomment-77236928","issue_url":"https://api.github.com/repos/volatilityfoundation/volatility/issues/191","id":77236928,"user":{"login":"iMHLv2","id":1138663,"avatar_url":"https://avatars.githubusercontent.com/u/1138663?v=3","gravatar_id":"","url":"https://api.github.com/users/iMHLv2","html_url":"https://github.com/iMHLv2","followers_url":"https://api.github.com/users/iMHLv2/followers","following_url":"https://api.github.com/users/iMHLv2/following{/other_user}","gists_url":"https://api.github.com/users/iMHLv2/gists{/gist_id}","starred_url":"https://api.github.com/users/iMHLv2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iMHLv2/subscriptions","organizations_url":"https://api.github.com/users/iMHLv2/orgs","repos_url":"https://api.github.com/users/iMHLv2/repos","events_url":"https://api.github.com/users/iMHLv2/events{/privacy}","received_events_url":"https://api.github.com/users/iMHLv2/received_events","type":"User","site_admin":false},"created_at":"2015-03-04T20:14:50Z","updated_at":"2015-03-04T20:14:50Z","body":"Kind of...the schema defines the column as TEXT, but we don't call str() before inserting Address types, so it ends up trying to insert them as integers. For example from your debug output:\r\n\r\n```\r\n INSERT INTO PSList VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [1, 0, 18446738026408463152L, 'System', 4, 0, 81, 526, -1, 0, '2013-11-29 16:39:19 UTC+0000', '']\r\n```\r\n\r\nIf we wanted to explicitly store it as a string, we'd have to call str(18446738026408463152L) first rather than inserting 18446738026408463152L. "}}