Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Reading whmxfer.sqlite

Discussion in 'Database Discussion' started by plesk4lyf, Jul 4, 2018.

  1. plesk4lyf

    plesk4lyf Member
    PartnerNOC

    Joined:
    May 21, 2018
    Messages:
    12
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Sydney
    cPanel Access Level:
    Root Administrator
    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?
     
  2. plesk4lyf

    plesk4lyf Member
    PartnerNOC

    Joined:
    May 21, 2018
    Messages:
    12
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Sydney
    cPanel Access Level:
    Root Administrator
    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
     
  3. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,748
    Likes Received:
    187
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @plesk4lyf

    I'm happy to see you were able to find a resolution to your issue. Thanks for updating us!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice