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!

Questions

Discussion in 'cPanel Developers' started by S P E E D, Jun 13, 2011.

  1. S P E E D

    S P E E D Member

    Joined:
    Jun 13, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    Hello
    Can create a database and add user , Change Permissions to Directories and add Password Protect to Directories by useing php ?

    if yes , how ?
    Note I am not root user
     
    #1 S P E E D, Jun 13, 2011
    Last edited: Jun 13, 2011
  2. fi77i

    fi77i Well-Known Member

    Joined:
    Aug 20, 2008
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Uruguay
    cPanel Access Level:
    Root Administrator
    I do not understand very well what you want. But if you are trying to create a db with users on it change perms and set password protected directories you can do it using you panel.

    Check the documentation here:

    MySQL Databases
    File Manager
    Password Protect Directories

    Hope this info can help you.

    Cya.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 fi77i, Jun 13, 2011
  3. S P E E D

    S P E E D Member

    Joined:
    Jun 13, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    i want do it , by php not cpanel
     
    #3 S P E E D, Jun 13, 2011
  4. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Hi SPEED,

    If you're trying to make an application, script, or web application on your site, you should probably use the PHP XML-API client class to make cPanel API calls (documentation for using the XML/JSON-API interface for cPanel APIs).

    If you're writing a cPanel Plugin or an application that lives within a cPanel theme directory, you can use LivePHP to make cPanel API calls

    fi77i is referencing the API calls that you will use when requesting cPanel to perform the manipulations that you mention.

    There should be plenty of forum threads related to using the XML-API client class for MySQL database management. There's also a blog article that discusses using the XML-API client class in a script (note, the article link to the full example is broke, but you can find the full example it here)

    Regards,
    -DavidN
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelDavidN, Jun 14, 2011
  5. S P E E D

    S P E E D Member

    Joined:
    Jun 13, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    yes , i trying to make an application php can add db and user
    but Question can use PHP XML-API client class and i don't have root access
     
    #5 S P E E D, Jun 14, 2011
  6. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Yes, you can use the cPanel account password. When authenticating as a cPanel user, you need to use port 2083 (ssl) or 2082 (non-ssl).

    PHP:
    <?php
    include "xmlapi.php";

    $ip = 'my.domain.com';
    $user = 'dave';
    $user_pass = 'secret!';

    $xmlapi = new xmlapi($ip);
    $xmlapi->password_auth($user,$user_pass);
    $xmlapi->set_port('2083');

    $xmlapi->set_debug(1);  //for debugging

    $cp_account = $user;

    $args = array(
            'cptest',
    );

    /**
     * This call will create the 'dave_cptest' database because we're working
     * against the 'dave' account.
     */
    $result = $xmlapi->api1_query($cp_account, 'Mysql','adddb',$args);
    ?>
    Regards,
    -DavidN
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelDavidN, Jun 15, 2011
  7. S P E E D

    S P E E D Member

    Joined:
    Jun 13, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    nice , but i want add user to db , and i have another Question

    can change Permissions to file or folder ?
     
    #7 S P E E D, Jun 15, 2011
  8. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Yes, you can add a user to a database too. You will first need to create the user with Mysql::adduser. Then you can give that user privileges to the database with Mysql::adduserdb.

    You can change file permission with the API2 Fileman::fileop call. This works for files within your home directory. You cannot change file ownership with an API call.

    -DavidN
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelDavidN, Jun 16, 2011
    Last edited: Jun 16, 2011
  9. S P E E D

    S P E E D Member

    Joined:
    Jun 13, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    hi ,
    i used this code but see error apper



    Warning: file_get_contents() [function.file-get-contents]: SSL: The operation completed successfully. in C:\xampp\htdocs\xmlapi.php on line 737

    Warning: file_get_contents() [function.file-get-contents]: SSL: The operation completed successfully. in C:\xampp\htdocs\xmlapi.php on line 737

    Warning: file_get_contents() [function.file-get-contents]: SSL: The operation completed successfully. in C:\xampp\htdocs\xmlapi.php on line 737

    Warning: file_get_contents() [function.file-get-contents]: SSL: The operation completed successfully. in C:\xampp\htdocs\xmlapi.php on line 737

    PHP:
    <?php

    /**
     * @author PHPDes7
     * @copyright 2011
     */

    include("xmlapi.php");
    $host = "xxx.com";
    $cpuser = "cpuser";
    $cppass = "cppass";
    $db_name ="dbname";
    $db_user="dbuser";
    $db_pass="dbpassword";

    $xmlapi = new xmlapi($host);
    $xmlapi->set_port(2083);
    $xmlapi->password_auth($cpuser,$cppass);
    $xmlapi->set_debug(1);
    //create database
    print $xmlapi->api1_query($cpuser, "Mysql", "adddb", $db_name);
    //create user
    print $xmlapi->api1_query($cpuser, "Mysql", "adduser", array('user' => $db_user,'pass'=> $db_pass));
    //add user to database
    $xmlapi->api1_query($cpuser, "Mysql", "adduserdb", array(
                            'db' => $db_name,
                            'user'=> $db_user,
                            'SELECT INSERT UPDATE CREATE DELETE ALTER DROP'));  

    ?>
     
    #9 S P E E D, Jun 24, 2011
  10. TopCatHost

    TopCatHost Member

    Joined:
    Jun 27, 2011
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Passaic N.J. USA
    cPanel Access Level:
    Root Administrator
    Hello,

    MY Questions Or Request for Advise:

    I am relatively new to using C-panel and WHM (and later soon WHMPHP). I noticed that as a reseller I fet the following warning:
    Warning! You are logged in with the reseller or root password.

    I am basically wondering what I need to be worried about, naturally I have some ideas. I have logged in a "A Reseller" however I do have some of my own domains and websites to migrate over. I currently have access to a standard reseller, a master reseller and an Alpha reseller.

    I imagine that the migration of the websites might be more difficult with the standard reseller, however all the real functions get carried in C-panel it seems. I have set up name servers and and the domains will not be transferred.

    The entire tar archive for about 30 or so domains with about 15 small (mostly WordPress) websites is about 3 Gigabyte and then apparently there is another homedir which is about another GB.

    Just a simple overview of the migration, and can it be done using file manager or is FTP much better. Is there an order to do things, such as mysql databases 1st then files etc.
     
    #10 TopCatHost, Jun 28, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Questions
  1. Gareth-AWD

    cPanel git with version 72 questions

    Gareth-AWD, Jun 13, 2018 at 3:28 AM, in forum: General Discussion
    Replies:
    3
    Views:
    56
    cPanelKenneth
    Jun 14, 2018 at 10:57 AM
  2. Nuno Filipe Bexiga

    Setting Up Personal Server Questions

    Nuno Filipe Bexiga, Jun 5, 2018, in forum: General Discussion
    Replies:
    6
    Views:
    49
    Nuno Filipe Bexiga
    Jun 5, 2018
  3. Sunlander

    Setting up cronjob questions

    Sunlander, May 28, 2018, in forum: General Discussion
    Replies:
    28
    Views:
    265
    rpvw
    Jun 10, 2018
  4. Spork Schivago

    Questions About Two-Factor Authentication

    Spork Schivago, May 25, 2018, in forum: Security
    Replies:
    8
    Views:
    122
    Spork Schivago
    Jun 9, 2018
  5. meeven

    Questions about enabling mod_security

    meeven, May 22, 2018, in forum: Security
    Replies:
    2
    Views:
    104
    meeven
    Jun 2, 2018

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.
    Accept Learn More...
    Dismiss Notice