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!

Mysql::adddb

Discussion in 'cPanel Developers' started by Insy, May 23, 2010.

  1. Insy

    Insy Member

    Joined:
    Nov 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    France
    cPanel Access Level:
    Root Administrator
    Hello,

    As CPanel doesn't support the lmaximum size of databases, I would make one for my servers. The selected solution is moving databases directory into a subdirectory of the users folders. It must be writted in PHP or Python - the two languages I know.
    How to set this up? Code examples? Documentation pages?
    Thanks :)

    Simon
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Insy, May 23, 2010
    Last edited: May 25, 2010
  2. Insy

    Insy Member

    Joined:
    Nov 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    France
    cPanel Access Level:
    Root Administrator
    Bump. It's urgent ;)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelDavidN

    cPanelDavidN Integration Developer

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    1) I'm not sure what "lmaximum" is? Are you talking about the maximum characters for naming a database? or the maximum disk space that a MySQL database can grow? Maximum number of databases? Any details would help.

    2) Because I don't know what "lmaximum" is, I can offer you a valid solution. However I can tell you with certainty, no matter what you solution is, you will not be able to relocate MySQL databases in the various user directories. A single instance of the MySQL daemon, at least how cPanel and may other web hosting environments are configured, can't source multiple directories. If someone else knows how, I'd love to hear it because to my knowledge, it can't be done with a single occurrence of mysqld.

    Let me know what "lmaximum" means and I'd be glad to help if I can.

    Regards,
    -David
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Insy

    Insy Member

    Joined:
    Nov 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    France
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,563
    Likes Received:
    42
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    That article speaks of using Group quotas. cPanel doesn't provide support for Group quotas, you'll need to provide your own mechanisms for setting the Group quota when the User quota is modified.

    Also, that article has an erroneous command that if executed will result in MySQL owning the user's home directory.

    That article provides no commentary on the default setup of InnoDB, which a user can use to bypass the quota mechanisms described in the article.

    <speculation>
    Since you are placing the target of the symlink into a directory the user controls I hate to think about what malicious users may be able to do.</speculation>
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Insy

    Insy Member

    Joined:
    Nov 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    France
    cPanel Access Level:
    Root Administrator
    Okay... What is the best solution according to you?
     
    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