MySQL database not appearing in cPanel but exists in the server

If a database exists but is not displayed in cPanel it likely is not being tracked by the db mapping system.




Check to see if database is listed in user.yaml by running the following command:
#cat /var/cpanel/databases/user.yaml 




If the result is as follows : 

No databases tracked:

root@server [~]# cat /var/cpanel/databases/tacct.yaml

---

MYSQL:

dbs: {}

dbusers: {}

Follow the below steps : 




To map missing databases and users run the following:

#/usr/local/cpanel/bin/dbmaptool cpanelusername --type mysql --databasename

#/usr/local/cpanel/bin/dbmaptool cpanelusername --type mysql –databaseuser

#/usr/local/cpanel/bin/dbmaptool cpanelusername --type mysql –databasename cpanelusername_databaseuser

After the above steps are executed check with the following command if the database has been mapped in the db mapping system.

#cat /var/cpanel/databases/abc.yaml

The result should be as follows : 

---

MYSQL:

dbs:

tacct_testdb: IP Address

dbusers: {}

owner: tacct

server: IP Address

Unable to create directory uploads/2013/12. Is its parent directory writable by the server?

Unable to create directory uploads/2013/12. Is its parent directory writable by the server ? Error while uploading the image under media in the WordPress admin panel.

Login to the WordPress admin panel

Go to Settings >> Media

Change the path to wp-content/uploads

The issue will be resolved.




If it did not resolve the issue , you can try changing the folder permission for the folders wp-content and wp-content/uploads to 777 in the cPanel .

How to check if the cron job is executed or not ?

Cron-related messages, including success and failure, are logged to /var/log/cron .

You can also take a look at /var/log/messages and watch the email account listed in /root/.forward as that is where cron error reports would usually show up.




The cron job path for the domain : /var/spool/cron/username

Removing the mysqladmin root password for the MySQL

First stop the MySQL service by running the following command in the SSH

/etc/init.d/mysql stop

After that run the following command

mysqld_safe --skip-grant-tables &

After this the MySQL admin password will be removed and you can

directly access the MySQL with out the password.

Setting the magic_quotes_gpc=off to install the Joomla

Login to the server of the account as a root.

Set the magic_quotes_gpc=off in the file /usr/local/lib/php.ini

For the shared server :
You can try creating the php.ini in the root document folder in the File Manager >> Public_html and add the code magic_quotes_gpc=off 

Warning: mkdir() [function.mkdir]: Permission denied in DrupalLocalStreamWrapper->mkdir()

Drupal is giving the following error while uploading the themes:

Warning: mkdir() [function.mkdir]: Permission denied in DrupalLocalStreamWrapper->mkdir() (line 639 of /home/username/public_html/includes/stream_wrappers.inc). 
•bootstrap-7.x-2.1 (1).zip does not contain any .info files. 

Try With the Following Solution :

• Change the file permission for the /sites/default/ to 777
• Create the folder called /temps/ in the /home/username/public_html provide the file permission for the /temps/ as 777
• Login to the drupal admin panel >>Go to Configuration >> Media >> File System. Change the Temporary directory path to the following :
  home/username/public_html/temps
• Then save the settings. 
  
   

The sub domain abc.domain.com is not working showing the >> server not found error

The sub domain abc.domain.com is not working showing the >> server not found error . 

Check if the sub domain is created by going to cPanel >> Subdomains, If the sub domain is created and it is pointed to the correct root document folder and try with following step to resolve the issue 

You will have to enable the rewritebase rule in the Apache. Since there is no RewriteBase enabled for the sub domain 

You can also add the following code in the .htacess directly. 

<IfModule mod_rewrite.c>

RewriteEngine On

# RewriteBase /folder_path/

RewriteBase /