{"id":68,"date":"2010-05-13T16:00:00","date_gmt":"2010-05-13T21:00:00","guid":{"rendered":"http:\/\/blogs.wp.stage.cpanel.net\/2010\/05\/more_details_about_db_mapping\/"},"modified":"2010-05-13T16:00:00","modified_gmt":"2010-05-13T21:00:00","slug":"more_details_about_db_mapping","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/","title":{"rendered":"More Details About DB Mapping"},"content":{"rendered":"<p>As mentioned in <a href=\"http:\/\/blog.cpanel.net\/a_general_overview_of_database_mapping\/\"> <em>A General Overview of Database Mapping<\/em><\/a> , DB Mapping is available with the launch of cPanel 11.25.1. Let\u2019s recap what DB Mapping is and then we can chew on the details:<\/p>\n<ul>\n<li>DB Mapping is core code in 11.25.1<\/li>\n<li>DB Mapping exposes DB Prefixing behaviors<\/li>\n<li>DB Mapping provides an interface for importing non-cPanel accounts<\/li>\n<\/ul>\n<p><!--more--><\/p>\n<p><strong>Core Code<\/strong><br \/>\nDB Mapping is coded directly into cPanel. This includes modifications to our binary code base as well as the Perl Cpanel modules. We\u2019ve packed in more methods and dynamic code paths that allow cPanel to function in a forward-capable mode. We have chosen to use new models in our instantiated objects that expose new functionalities and at the same time can be rendered into the 11.25.0 user model.<\/p>\n<p>This new functionality is, well new, and can\u2019t always be converted to an old convention. For example, account transfers benefit tremendously from DB Mapping functionality, yet are bound to coding practicalities. Products of a new, complex code base cannot be manipulated to work in an older code base; something new can only exist in the environment for which it was designed. To put it simply, DB Mapping features are not 100% backwards compatible.<\/p>\n<p><strong>DB Prefixing<\/strong><br \/>\nPrefixing database resources is a very common practice in web hosting environments. In cPanel versions prior to 11.25.1, any database resource created by a user receives a prefix, <em>$username_<\/em>. In 11.25.1, the DB Mapping code allows the cPanel admin to turn this prefixing requirement\/implementation off. DB Mapping decouples the textual name of the resource from the account name and stores the information separately.<\/p>\n<p>Mapping occurs regardless of whether Prefixing is <em>On<\/em> or <em>Off<\/em>. You can find the Prefix toggle in the <em>SQL Services<\/em> section of WHM. Again, mapping is embedded in the core of cPanel which provides an easy way for cPanel admins to <em>Opt-Out<\/em> of the Prefix paradigm. Prefixing is <em>On<\/em> by default in 11.25.1 and the cPanel interface will continue to behave and render identical to previous versions.<\/p>\n<p>If you turn Prefixing <em>Off<\/em> you <strong>cannot<\/strong> turn it back on. Additionally, you will not be able to downgrade to a cPanel version that does not have DB Mapping, e.g. 11.25.0 and below. Disabling Prefixing is a one way street.<\/p>\n<p>The mapping is stored in a YAML file in <em>\/var\/cpanel\/databases\/<\/em> as <em>$username.yaml<\/em>. These YAML files are system files and should be respected as such, e.g., manual manipulation is discouraged and can have unintended consequence. The files should be edited indirectly via the SQL cPanel interfaces or related API calls. If you find that database resources are not mapped as expected, <a href=\"http:\/\/cpanel.net\/support\/\">cPanel Support<\/a> can help you resolve the issue.<\/p>\n<p><strong>Non-cPanel Transfers<\/strong><br \/>\ncPanel strives to make account migration as seamless as possible. You can imagine how daunting a task that is when you consider the number of other web hosting environments available and the variety between them. DB Mapping abstracts cPanel accounts and database resource ownership. This allows cPanel to import any account-database relationship from a non-cPanel account and keep all attached resources intact, without any manipulation*.<\/p>\n<p>If a non-cPanel account is transferred to cPanel 11.25.1, it will utilize the DB Mapping feature set. This is great because the account is essentially mirrored in the cPanel host system. However, this also means that the migrated account is dependent on DB Mapping. Once you transfer a non-cPanel account, your system is not a candidate for downgrade. This is the same logic as disabling Prefixing: your accounts require the DB Mapping feature set.<\/p>\n<p>For transferred accounts, the migrated account is permitted an account username up to 16 characters long, a primary database username that is different than the account username, and databases that have an arbitrary prefix**.<\/p>\n<p>If your transferred account has an extremely long username, and you have not disabled Prefixing, you may find that there is inadequate character length for new database resources. For example, if the non-cPanel account has a name like <em>accountlongname<\/em> and you have Prefixing <em>On<\/em>, then all database resources will start with <em>accountlongname_<\/em>. <em>accountlongname_<\/em> is 16 characters long. MySQL imposes a 16-character limit on database usernames and thus the account would not be able to create database virtusers in cPanel. DB Mapping is very flexible, but ultimately must operate within the confines of the MySQL sub-system. It\u2019s a caveat, but not one that an informed administrator should be surprised by.<\/p>\n<p>Long username functionality for non-cPanel transfers should be available immediately in the EDGE release of 11.25.1. Our <a href=\"http:\/\/cpanel.net\/cpanel-whm\/migrate-cpanel\/\">Migration Support Services<\/a> are available to you and at the ready as needed.<\/p>\n<p><strong>API and Other Tidbits<\/strong><br \/>\nWhen making API calls, specifically the functions in the <em>Mysql<\/em> module, some diligence may be required on the developer\u2019s part. For instance, <em>adddb<\/em> takes one parameter, the <em>$dbname<\/em>. In 11.25.0, <em>$dbname<\/em> is automatically prefixed with <em>$username_<\/em> by cPanel. The <em>$username<\/em> prefix is determined by the <em>$user<\/em> parameter required by all API1 calls. In 11.25.1, <em>$dbname<\/em> will <strong>not<\/strong> be prefixed <strong>if<\/strong> Prefixing is <em>Off<\/em>. The value of <em>$dbname<\/em> is taken literally by cPanel. The chance for database name collision is increased, but like before, is not fatal. If a collision occurs, you will receive an error and will need to choose a different database name.<\/p>\n<p>Likewise, when you call <em>adduserdb<\/em>, which modifies a vituser\u2019s privileges for a database, as the developer you need to know if Prefixing is <em>On<\/em> or <em>Off<\/em>. <em>adduserdb<\/em> needs the literal database name in 11.25.1. The same call in 11.25.0 will assume <em>$username_<\/em> if it is not present in <em>$dbname<\/em>.<\/p>\n<p>New accounts created in 11.25.1, that aren\u2019t transfer related, can also have a primary database username that differs from the account username if Prefixing is <em>Off<\/em>. Just keep in mind that if you create such an account, it is not feasible to move it to a cPanel system whose version is less than 11.25.1. Again, any account made with Prefixing disabled cannot be transferred to a cPanel version below 11.25.1; doubly so for any account who\u2019s primary database username differs from the cPanel account username.<\/p>\n<p><strong>More Information<\/strong><br \/>\nDB Mapping is a powerful feature set. It opens a lot of possibilities for cPanel administrators and end users. These blog posts can only cover the concepts though. You can expect detailed information in the 11.25.1 Release Notes as well as a white paper on DB Mapping. Both are forthcoming so stay tuned.<\/p>\n<p>Have fun with DB Mapping and post your comments and questions on our <a href=\"http:\/\/forums.cpanel.net\/cpanel-developers.html\">Developer Discussion Forum<\/a>!<\/p>\n<p><em>*Not withstanding some core OS and sub-system limitations, like user group name length, or MySQL database user name length.<\/em><\/p>\n<p><em>**The usual restriction applies that any resource name cannot conflict with an existing, identically-named resource on the host system.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As mentioned in A General Overview of Database Mapping , DB Mapping is available with the launch of cPanel 11.25.1. Let\u2019s recap what DB Mapping is and then we can chew on the details: DB Mapping is core code in 11.25.1 DB Mapping exposes DB Prefixing behaviors DB Mapping provides an interface for importing non-cPanel [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[49],"tags":[],"class_list":["post-68","post","type-post","status-publish","format-standard","hentry","category-products"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>More Details About DB Mapping | cPanel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"More Details About DB Mapping | cPanel\" \/>\n<meta property=\"og:description\" content=\"As mentioned in A General Overview of Database Mapping , DB Mapping is available with the launch of cPanel 11.25.1. Let\u2019s recap what DB Mapping is and then we can chew on the details: DB Mapping is core code in 11.25.1 DB Mapping exposes DB Prefixing behaviors DB Mapping provides an interface for importing non-cPanel [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/\" \/>\n<meta property=\"og:site_name\" content=\"cPanel\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cpanel\/\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-13T21:00:00+00:00\" \/>\n<meta name=\"author\" content=\"cPanel Community\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cPanel\" \/>\n<meta name=\"twitter:site\" content=\"@cPanel\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"cPanel Community\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/\",\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/\",\"name\":\"More Details About DB Mapping | cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\"},\"datePublished\":\"2010-05-13T21:00:00+00:00\",\"dateModified\":\"2010-05-13T21:00:00+00:00\",\"author\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\"},\"breadcrumb\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devel.www.cpanel.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"More Details About DB Mapping\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\",\"url\":\"https:\/\/devel.www.cpanel.net\/\",\"name\":\"cPanel\",\"description\":\"Hosting Platform of Choices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devel.www.cpanel.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\",\"name\":\"cPanel Community\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"caption\":\"cPanel Community\"},\"description\":\"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.\",\"sameAs\":[\"https:\/\/cpanel.net\"],\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"More Details About DB Mapping | cPanel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/","og_locale":"en_US","og_type":"article","og_title":"More Details About DB Mapping | cPanel","og_description":"As mentioned in A General Overview of Database Mapping , DB Mapping is available with the launch of cPanel 11.25.1. Let\u2019s recap what DB Mapping is and then we can chew on the details: DB Mapping is core code in 11.25.1 DB Mapping exposes DB Prefixing behaviors DB Mapping provides an interface for importing non-cPanel [&hellip;]","og_url":"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/","og_site_name":"cPanel","article_publisher":"https:\/\/www.facebook.com\/cpanel\/","article_published_time":"2010-05-13T21:00:00+00:00","author":"cPanel Community","twitter_card":"summary_large_image","twitter_creator":"@cPanel","twitter_site":"@cPanel","twitter_misc":{"Written by":"cPanel Community","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/","url":"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/","name":"More Details About DB Mapping | cPanel","isPartOf":{"@id":"https:\/\/devel.www.cpanel.net\/#website"},"datePublished":"2010-05-13T21:00:00+00:00","dateModified":"2010-05-13T21:00:00+00:00","author":{"@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8"},"breadcrumb":{"@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devel.www.cpanel.net\/blog\/products\/more_details_about_db_mapping\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devel.www.cpanel.net\/"},{"@type":"ListItem","position":2,"name":"More Details About DB Mapping"}]},{"@type":"WebSite","@id":"https:\/\/devel.www.cpanel.net\/#website","url":"https:\/\/devel.www.cpanel.net\/","name":"cPanel","description":"Hosting Platform of Choices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devel.www.cpanel.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8","name":"cPanel Community","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","caption":"cPanel Community"},"description":"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.","sameAs":["https:\/\/cpanel.net"],"url":"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/68"}],"collection":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":0,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"wp:attachment":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}