Plesk Automation :: All MySQL Databases Exposed At Reseller Level

May 22, 2014

I have 2 Nodes. Both of them are configured like this:

Node1: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller1
Node2: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller2

I log in as Reseller1 (clean login; not by switching from PPA Admin to Reseller1), create a Webspace and a Database. At that point I am able to see and create Databases on every Node, even on Reseller1 (Node1), which is set to restricted. I guess this behaviour is not intended, isn't it?

View 2 Replies


Plesk Automation :: Upgrade A Customer To Reseller?

Oct 30, 2012

We are migrating Plesk servers to PPA. Is it possible to upgrade a customer to reseller? Is it possible to move a subscription to another customer or reseller?

View 9 Replies View Related

Plesk Automation :: Reseller Hosting Clients Traffic Stats Not Updating

May 16, 2013

I have noticed that resellers traffic stats (looks like email) are not being updated and just show 0.

On the server that is for resellers I see there is a file in /usr/local/psa/var/log containing a file mail_traffic_pendings.dat with sender and recipient domain traffic. I presume this has to be processed to go into the database, but obviously it is not. How to debug this issue so that email stats get updated for clients.

View 2 Replies View Related

Plesk Automation :: Set User And Privileges From Mysql

Jul 3, 2014

I'd want to create a user and set custom privileges using the standard mysql-client, ie. create user and grant privileges, but I know that sometimes Plesk overwrites my config files for other services.

View 2 Replies View Related

Plesk Automation :: Prefix For MySQL / FTP And Email Accounts

Mar 14, 2014

I've configured PPA management, web server and a mysql database server. Now I want that if a customer add a mysql, ftp or mail account, that the names begins with a prefix that I've defined.

View 4 Replies View Related

Error 404/500 Not Found Traffic - How To Redirect From Reseller Level

Nov 14, 2008

I have multiple Cpanel accs and wish to apply for all clients an Error 404/500 page redirect to a custom page.

View 4 Replies View Related

Error 404/500 Not Found Traffic - How To Redirect From Reseller Level

Nov 14, 2008

Error 404/500 not found traffic - how to redirect from reseller level

I have multiple Cpanel accs and wish to apply for all clients an Error 404/500 page redirect to a custom page.

View 3 Replies View Related

Plesk Automation :: Update MySQL Version Database Node

Jun 6, 2015

Is it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?

View 3 Replies View Related

Plesk Automation :: Local Server Visible When Adding New MySQL Database

Mar 27, 2014

Somehow when customers add a new MySQL database they can select a Local MySQL server. It turns out this is the MySQL instance running on the CP server, can I somehow hide this server from the list?

View 1 Replies View Related

Plesk Automation :: MySQL Server Not Starting Anymore - Failed To Restart Service

Jun 5, 2014

What could I fix by trying to start mysql server, recieve following errors:

plesk interface:

Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start

from the console:

sudo service mysql start
start: Job failed to start

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:

[Code] ...

View 4 Replies View Related

How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only

Feb 11, 2008

I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.

Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.

how can I get these database files to fully work on a new server?

View 2 Replies View Related

Difference Between Level 1, Level 2 And Level 3 Tech Support

Oct 10, 2009

Is there any preset criteria for it like Level 1 includes a, b & c, Level 2 includes d, e & f and level includes x, y & z?

I know the difference in General but, I wanted a specific answer.

View 14 Replies View Related

Plesk Automation :: Error While Installing Automation During (Getting SELinux) Step

Jul 5, 2013

I am trying to install Automation, and I keep getting an error after the "Getting SELinux" step, here is a log of the process so far:

[INFO]: Checking current user privileges...
[INFO]: Checking critical environment requirements...
[INFO]: Determining OS parameters...
[INFO]: Detected OS: CentOS-5-x86_64
[INFO]: Getting SELinux state...
[ERROR]: Unexpected error: ''

[Code] ....

I have tried running the installation on a different server and the same issue came up...

View 19 Replies View Related

Plesk Automation :: Failure To Install Automation On Centos 6.5

Apr 4, 2015

I am installing plesk automation on centos 6.5 using this command on a fresh system

./ppa_installer --password some_password --admin_email some_email

and get the following error.

[LOGTEE]: Error Downloading Packages:
[LOGTEE]: libuuid-2.17.2-12.18.el6.i686: failure: Packages/libuuid-2.17.2-12.18.el6.i686.rpm from base: [Errno 256] No more mirrors to try.

Looks like some lib is not found in the mirrors.

View 1 Replies View Related

Plesk Automation :: Automation Installer Breaks Yum In CentOS 6.6

Jan 29, 2015

On a clean install of CentOS 6.6 (Final) I did the following:

1. updated the /etc/hosts file to point my ip to the hostname

2. Open the ports in the iptables file.

3. ran the ppa_installer per the instructions on [URL] ....

The ppa_installer log says installed Successfully. However the following occurs:

1. Cannot browse to the url:8443, or any of the other variations (8080, 8880, https/http)

2. Yum installer is now broken (I replicated this twice). Yum will not run at all with the following error:

There was a problem importing one of the Python modules required to run yum. The error leading to this problem was: /usr/lib64/ file too short

Please install a package which provides this module, or verify that the module is installed correctly.It's possible that the above module doesn't match the

current version of Python, which is:
2.6.6 (r266:84292, Jan 22 2014, 09:42:36)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)]

I am now going to try Cent OS 6.4.. will report back.

View 8 Replies View Related

Export All MySQL Databases

Sep 24, 2008

I need to export all databases on my server to put it on my new server. Is there a quick and easy way to do that without doing the WHM transfer?

View 4 Replies View Related

Path For MySQL Databases

Oct 25, 2009

Just wanted to ask, which folder are the MySQL databases held in for Cpanel? Running CentOS 5 VPS.

View 7 Replies View Related

Visualizing MySQL Databases

Dec 14, 2008

I've recently been asked to do a lot of data extraction from a state that has about 20 databases, each with between 10 and 100 tables. I often find myself diagramming things out on paper to try to visualize how everything works together.

I wondered if there's a tool that would "draw" the tables, columns, and relationships? I hesitate to say this, but almost like how MS Access does it, but that runs on Linux and does MySQL. Is there such a thing? I know about phpMyAdmin and MySQL's Query Browser, but it's not what I'm looking for.

View 3 Replies View Related

Is There A Way To Search Through MySQL Databases

Mar 9, 2007

I am running a dedicated server with Debian, and I installed a community sofware that has a lot of mySQL entries, many of which need to be changed to fit my needs

However, it is very hard to know exactly where each value I need to change is stored. Is there a way to search all database tables for a specific value?

For example, one thing that is stored in the database is the site's title displayed in the browser's title bar. The sofware does not give me the option to change it, so I have to find where it is located in the database and change it myself, but it would be extremely time comsuming to check all tables one by one for any occurences of the current title.

View 10 Replies View Related

Are My MySQL Databases Hosed

Sep 14, 2007

My HD was failing. So ServerBeach quickly set me up with a fresh box with the dying drive installed as a secondary drive. (nice job guys)

I'm able to mount the secondary drive and browse/copy the files... but when I get to the most important files of all, the database binaries, my /var/lib dir looks like this:

[root@rosemary v2]# ls -l /mnt/dying/var/lib/
total 68
-rw-r--r-- 1 root root 2171 Sep 14 03:02 logrotate.status
drwxrwsr-x 6 root 41 4096 Oct 12 2005 mailman
drwxr-xr-x 2 root root 4096 Oct 12 2005 misc
?--------- ? ? ? ? ? mysql
drwxr-xr-x 4 root root 4096 Oct 12 2005 nfs
drwxr-xr-x 2 ntp ntp 4096 Sep 14 10:31 ntp
And if I try to cd into the dir, I get this:

[root@rosemary v2]# cd /mnt/dying/var/lib/mysql
-bash: cd: /mnt/dying/var/lib/mysql: Input/output error
I really *really* need this data!

Am I just totally S.O.L. ?

View 1 Replies View Related

Backup MySQL Databases On PC

Jul 20, 2007

I host with hostgator and I was wondering if there are any software programs or services, or even something in my cpanel that can automatically grab my MySQL databases and everything on my server and make a backup on my personal PC?

I know I can manually do this, but I would like something that automatically does it once a week or something to insure my clients data is always backed up.

View 2 Replies View Related

Backup And Restore Mysql Databases

May 10, 2008

I have a corrupted VPS, and have some mysql databases on it.

I want to backup databases and restore them on the new server.

Cpanel service is down on the vps and I cannot transfer accts.

Is it possible to do so ?

1- Zip or Tar the username folder in /home dir.

2- zip or tar the database name in /var/lib/mysql folder

Either by SSH or File manager trough HyperVM

Then transfer files some where safe...

When vps is rebuilt, restore the archives and databases to
the folders I have backed up before rebuilt.

There are also some accounts on a terminated vps that there is only an image of the vps available so, I only can tar files using a jailed shell account, move to the new vps and untar them.

how to do it and avoid database problems.

View 0 Replies View Related

MySQL Backup Multiple Databases

Feb 8, 2008

My site is databases driven and runs on around 15 mySQL databases. Im wanting to download a local copy of these databases daily, however, if i try and back them up via cPanel (on a WHM VPS) they give me blank files. Each databases is around 55mb and growing. I can back them up one by one via phpmyadmin, it just takes around 5 minutes per database. Meaning around 40 minutes per night..

Is there any solution for having a script downloading them automatically so i can download them via ftp? I've tried [url].htm but it gives me blank files.

View 10 Replies View Related

Backup MySQL Databases By Cron

Apr 1, 2007

how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working.

Change the commented variables in the following file and save it as


# This script will backup one or more mySQL databases
# and then optionally email them and/or FTP them

# This script will create a different backup file for each database by day of the week
# i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1)
# This is a trick so that you never have more than 7 days worth of backups on your FTP server.
# as the weeks rotate, the files from the same day of the prev week are overwritten.
#/bin/sh /home/user/directory/ > /dev/null
#===> site-specific variables - customize for your site

# List all of the MySQL databases that you want to backup in here,
# each seperated by a space
# If not run by root, only one db per script instance

# Directory where you want the backup files to be placed

# MySQL dump command, use the full path name here

# MySQL Username and password
userpassword=" --user=myuser --password=mypasswd"

# MySQL dump options
dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables"

# Unix Commands

# Send Backup? Would you like the backup emailed to you?
# Set to "y" if you do
subject="mySQL Backup"

#===> site-specific variables for FTP
# If you are keeping the backups in a subdir to your FTP root

#===> END site-specific variables - customize for your site

# Get the Day of the Week (0-6)
# This allows to save one backup for each day of the week
# Just alter the date command if you want to use a timestamp
DOW=`date +%w`

# Create our backup directory if not already there
mkdir -p ${backupdir}
if [ ! -d ${backupdir} ]
echo "Not a directory: ${backupdir}"
exit 1

# Dump all of our databases
echo "Dumping MySQL Databases"
for database in $databases
$mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql

# Compress all of our backup files
echo "Compressing Dump Files"
for database in $databases
rm -f ${backupdir}/${DOW}-${database}.sql.gz
$gzip ${backupdir}/${DOW}-${database}.sql

# Send the backups via email
if [ $sendbackup = "y" ]
for database in $databases
$uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu
$mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu

# FTP it to the off-site server
echo "FTP file to $ftpserver FTP server"
if [ $ftpbackup = "y" ]
for database in $databases
echo "==> ${backupdir}/${DOW}-${database}.sql.gz"
ftp -n $ftpserver <<EOF
user $ftpuser $ftppasswd
cd $ftpdir
lcd ${backupdir}
put ${DOW}-${database}.sql.gz

# And we're done
ls -l ${backupdir}
echo "Dump Complete!"
Upload to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone .

You should chmod the file to 777:

chmod 777
If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory:

If you don't have dos2unix installed, you can install it using yum if you have that:

yum install dos2unix
If you don't have yum, get it here.

You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command:

Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is:


View 2 Replies View Related

How To Get Copy Of All Mysql Databases Into Individual Tar.gz Files

Mar 26, 2009

I'm trying to use the "mysqldump" command to get a copy of all databases on the server...

but I need each database to go into a "databaseXYZ.tar.gz" file.

Does anyone know how to do this? So far, I can only get all the databases into a single file. But I need each database to have its own file.

View 4 Replies View Related

How To Check Which Mysql Databases Cause Server Load

Jul 30, 2007

How can i check (using SSH) which databases/users cause server load to mysql ?

I've tried "mysqladmin proc stat" but it shows just the current. How can i get stats of the last 24 hours for example ?

I've also seen slow connections stats. What is the command to check more detailed report of the slow connections; which databases caused it etc', in the last 24 hours for example as well.

View 4 Replies View Related

How To Automatically Check And Repair Mysql Databases And Tables

Jul 16, 2009

I have cPanle shared account.

Is there a way to automatically check and repair mysql databases and tables, that can be scheduled as cron job?

View 9 Replies View Related

Configuring Server To Handle Both MySQL And MS Access Databases

Mar 24, 2008

Since I have never worked on the server end of things I had a quick question for all you web hosting gurus.

Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time?

I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right?

If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access.

Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.

View 10 Replies View Related

Copyrights 2005-15, All rights reserved