The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

manual cpanel database edit

Discussion in 'cPanel Developers' started by oDesk, Aug 27, 2007.

  1. oDesk

    oDesk Member

    Joined:
    Aug 27, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    in older versions of Cpanel, i was able to browse the database which contains the packages data and users data too.

    now how i could navigate the database manually...
    does Cpanel use MySQL or SQLite... if SQLlite, which file does contain the data ?

    Thanks
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    cPanel/WHM does not support SQLite natively, it uses MySQL natively.

    If you need to manipulate packages or users via scripts, I'd recommend you use the XML-API or event hooks instead.
     
  3. oDesk

    oDesk Member

    Joined:
    Aug 27, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    David,
    thanks

    well, i need to build AHM(automated hosting script) but not let my developer interact with my file system directly using root account..


    i want him to develop in his local machine ? so..

    how he get the functions to work like listaccts();
    because i see that there is file which should be included into the script
    require '/usr/local/cpanel/Cpanel/Accounting.php.inc';
    in order for the script to work.

    how he could include it from his local machine while he still develop in his own!

    Thanks
     
  4. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    That's from our old WHM API. The XML-API is better suited for remote development and execution (not to mention supports far more functionality). All they will need is a remote access key to the server.

    You can find documentation for the XML-API on our website at:

    http://www.cPanel.net/plugins/devel

    For example, you would simply call https://IP:2087/xml-api/listaccts to list all accounts (authentication via user/pass or user/remote access key required).
     
  5. oDesk

    oDesk Member

    Joined:
    Aug 27, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
  6. oDesk

    oDesk Member

    Joined:
    Aug 27, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    oops, the above link i post seems not using XMLAPI right!
     
  7. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
  8. oDesk

    oDesk Member

    Joined:
    Aug 27, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    very nice
    i'll try it out

    thanks for your fast reply
     
Loading...

Share This Page