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.

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:
    1
    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
     
    #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:
    1
    Location:
    France
    cPanel Access Level:
    Root Administrator
    Bump. It's urgent ;)
     
  3. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    1
    Trophy Points:
    18
    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
     
  4. Insy

    Insy Member

    Joined:
    Nov 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    France
    cPanel Access Level:
    Root Administrator
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    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>
     
  6. Insy

    Insy Member

    Joined:
    Nov 29, 2008
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    France
    cPanel Access Level:
    Root Administrator
    Okay... What is the best solution according to you?
     
Loading...

Share This Page