DEV Community: Takdirul Islam Shishir

cPanel UAPI Operations for Creating Subdomains, MySQL Databases, and File Operations

Takdirul Islam Shishir — Thu, 14 Mar 2024 19:05:10 +0000

Introduction

the cPanel User API (UAPI) stands out as a powerful interface for automating tasks and streamlining administrative operations. In this guide, we will delve into the practical usage of cPanel UAPI for creating subdomains, MySQL databases, and file operations.

UAPI Documentation

Managing Subdomains

Subdomains are indispensable for organizing and structuring websites within a domain. With cPanel UAPI, creating subdomains becomes a breeze. The following command snippet demonstrates how to create a subdomain:

uapi SubDomain addsubdomain domain=subdomain domain=example.com rootdomain=example.com dir=public_html/subdomain

Simply replace subdomain with your desired subdomain name and example.com with your domain. Additionally, adjust the directory path (dir) as needed to reflect your hosting environment's structure.

Managing MySQL Databases

MySQL databases are the backbone of many web applications, storing crucial data and enabling dynamic content generation. Leveraging cPanel UAPI, you can effortlessly create MySQL databases and users with tailored privileges. Let's break down the process into two steps:

Creating a MySQL Database:

uapi --user=username Mysql create_database name=mydatabase

Replace username with your actual username and mydatabase with the desired name for your MySQL database.

Creating a MySQL User and Granting Privileges:

uapi --user=username Mysql create_user name=myuser password=mypassword
uapi --user=username Mysql set_privileges_on_database user=myuser database=mydatabase privileges=ALL_PRIVILEGES

Substitute username, myuser, mypassword, and mydatabase with your specific values. These commands will establish a MySQL user with all privileges on the designated database.

File Operations

Efficiently managing files and directories is essential for maintaining a well-organized web hosting environment. With cPanel UAPI, you can perform file operations seamlessly. Let's explore two common tasks:

Moving Files:

uapi Fileman move_file source_file=public_html/oldfile.txt destination_file=public_html/newfile.txt

Replace source_file and destination_file paths as necessary. This command facilitates the relocation of files within your hosting space.

Moving Directories:

uapi Fileman move_dir source_dir=public_html/oldfolder destination_dir=public_html/newfolder

Similar to moving files, this command relocates entire directories along with their contents, promoting efficient organization.

Additional Tips:

While cPanel UAPI offers robust functionality, certain tasks may be better suited for direct execution via shell commands, especially for bulk operations. For instance, moving or copying files can be accomplished using standard bash commands like mv and cp:

# Move all files from source directory to destination directory
mv /path/to/source/* /path/to/destination/

# Copy all files from source directory to destination directory
cp -r /path/to/source/* /path/to/destination/

These commands provide flexibility and efficiency, particularly for complex file management tasks.

Author can talk :3

In retrospect, I realize there may have been oversights in the documentation review. I apologize for any mistakes . Thank you for your understanding and feedback.

Need Personal Support?

We provide custom solutions and support. Contact US at https://solution.omega.ac

Simple Guide to Deploying Your Vite React App on Cpanel for Beginners

Takdirul Islam Shishir — Thu, 02 Nov 2023 08:08:54 +0000

Step 1: Specify Your Site's URL in Vite Config

First off, we need to tell your Vite React app where it's going to be published on the internet. In your Vite project, there’s a file named vite.config.js. Open this file and add a base property under export default defineConfig. This is where your site's URL will go. It should look something like this:

export default defineConfig({
  base: 'http://myvitereactapp.com/',
  // ... other config settings
})

Step 2: Prepare Your App for Deployment

Now, let's get your app ready to go live. This step converts your project into a form that's more efficient for web browsers and usually it compresses your all CSS and JavaScript codes to make it more faster. Open your project's terminal, and run yarn install to make sure all dependencies are up to date. After that, execute yarn build. This will create a dist folder in your project, holding the production-ready version of your app.

Step 3: Zip the `dist` folder

Zip/ Compress your dist folder, use any compressor tool to zip your dist folder. Usually people uses (WinZip, 7zip, etc.) .

Step 4: Upload Your App to File Manager.

Login in to the control panel or cPanel, and look for the File Manageror you can use the search bar at the top to find the file manager. Inside the File Manager, you should see a folder named public_html. This is where your react build source code will go.

Step 5: Uploading `dist.zip` to `public_html`

Click on upload button at the top of File Manager then Select the dist.zip file from your source code folder, then upload them directly into the public_html folder on your cpanel.

Step 6: Extract Your Zip file

After uploading the dist.zip file you have to extract the zip file, click on to the zip button and click on to the extract button.

Step 7: Set Up Redirects for SPA

Vite React apps are usually single-page applications (SPAs), and they require special handling of page requests. In the public_html folder on your host, create a file called .htaccess. Paste in the following configuration to manage redirects:

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteBase /
  RewriteRule ^index\.html$ - [L]
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteCond %{REQUEST_FILENAME} !-d
  RewriteCond %{REQUEST_FILENAME} !-l
  RewriteRule . /index.html [L]
</IfModule>

Now save the .htaccess file.

CASE CLOSED !

You've successfully deployed your Vite React Application! Visit your web address, and you should see your app shining back at you from the web. Congrats on bringing your project to the world!

Need Personal Support?

We provide custom solutions and support. Contact US at https://solution.omega.ac

DEV Community: Takdirul Islam Shishir

cPanel UAPI Operations for Creating Subdomains, MySQL Databases, and File Operations

Author can talk :3

Need Personal Support?

Simple Guide to Deploying Your Vite React App on Cpanel for Beginners

Step 1: Specify Your Site's URL in Vite Config

Step 2: Prepare Your App for Deployment

Step 3: Zip the dist folder

Step 4: Upload Your App to File Manager.

Step 5: Uploading dist.zip to public_html

Step 6: Extract Your Zip file

Step 7: Set Up Redirects for SPA

CASE CLOSED !

Need Personal Support?

Step 3: Zip the `dist` folder

Step 5: Uploading `dist.zip` to `public_html`