Reading whmxfer.sqlite
Hey Guys,
I'm learning about the whmxfer.sqlite database kept in /var/cpanel/transfer_sessions. I'm only new to Sqlite so I apologize upfront.
I'm able to read data from the sessions table fine. But it appears there is more data in there that I can't find a way to get at.
For example:
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main /var/cpanel/transfer_sessions/whmxfer.sqlite
sqlite> .tables
sessions
sqlite> select * from sessions;
********copya20180626022507ukXznh9hk|copyacct|root|36857|2.3|****************|********|100|2018-06-26 02:25:07|2018-06-26 02:42:03
sqlite>
That's all I can get out of it. I believe there is a lot more in there because when I run:
$ strings /var/cpanel/transfer_sessions/whmxfer.sqlite
It shows user names, directories, file names.
Can someone tell me what commands I'm missing to see this other data that seems to be hidden?
-
Nevermind! I did $strings on the wrong file. The sqlite file with all the users and progress is in the session file itself. [root@server ~]# sqlite3 /var/cpanel/transfer_sessions/$(sqlite3 /var/cpanel/transfer_sessions/whmxfer.sqlite "select sessionid from sessions order by date(starttime) DESC limit 1;")/db.sqlite ".tables" AccountRemoteRoot queue session 0 -
Hi @plesk4lyf I'm happy to see you were able to find a resolution to your issue. Thanks for updating us! 0
Please sign in to leave a comment.
Comments
2 comments