Plesk 11.x / Linux :: Root Login To Backup All Database
Mar 12, 2015
Any way to backup every SQL Databases at once ?
At the moment i need to configure each subscription on my backup program to backup each sql database.
there is any way to set a login that back's up all the databases?
And for the ftp files?
View 1 Replies
ADVERTISEMENT
Apr 3, 2015
During the installation of Plesk, at first it used the root password, and then had me create an "admin" user.
When I log in using either I don't see any difference in the UI or options. Is there a difference or a reason to use one over the other?
Or is it just to give someone access to admin Plesk without giving them full root password of the server itself?
View 3 Replies
View Related
Feb 22, 2015
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)
View 3 Replies
View Related
Sep 6, 2014
I experienced an issue using an external backup repository on Plesk 12.0.18 machines using ftps. The ftp server uses ftps (explicit) connections.Plesk 11.5 works fine (and ordinary ftp client like Filezilla as well), Plesk 12 throws the following error when trying to add the server via the web interface:
Code:
Curl error: Login denied
Unencrypted connections will work. Plesk 11.5 machines (with the same settings) will work.
I've analyzed the problem and got so far: The backup manager tries to connect using "regular" transfer method + ssl, not ftp-ssl explicit.Is there a chance to force Plesk using explicit ftpes connections? Or is there another work around?Some additional infos about the (ftp) server: The ftp server is running ProFTP 1.3.4d, uses port 2000 for the control port and has a port range (2001 - 2100) for the passive connections.I tried to add the server using the address field of the gui IP:2000 and checkboxed "passive mode" and "ftps".
View 4 Replies
View Related
Feb 19, 2015
My OS is CentOS 5.8.
Plesk is 11.0.9.
Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:
<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">
[Code]...
View 4 Replies
View Related
Jun 16, 2014
why but autoupdate fails. It doesn't give a reason why it cant backup.
For line of log :
START pp11.5.30-bootstrapper-11.5.30-cos5.build115131216.11 installing AT Thu Mar 27 07:43:37 CET 2014
Last lines of log :
===> Upgrading database
Trying to start service mysqld... mysqld (pid 24610) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011005030
Version is OK, no need to create psa database.
Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
Trying to start psa...
**** Product prep-install for BASE failed.
***** problem report *****
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jun 17 04:04:48 CEST 2014
View 2 Replies
View Related
Feb 12, 2015
I'm new to Parallels Panel. I use version 11.0.9. I want to backup mysql database daily. First of all, what is the best way for daily database backup in plesk. I'm trying to do this in Scheduled Tasks and I use mysqldump command although I'm not sure.
I chose the time and day first and then I switched on the task. I typed the following command to Command line.
mysqldump -uusername -ppassword databasename | gzip -9 >/httpdocs/mydatabase.sql.gz
or
mysqldump -uusername -ppassword databasename >/httpdocs/mydatabase.sql.gz
This created only a blank file. When I use this without gzip, nothing changes.
1- Is mysqldump right command for database backup?
2- Should I define full path for mysqldump, gzip and database? If so, how can I find out the full path of mysqldump, gzip and my database? Because I can't see their locations in panel.
3- I can't see any error message. There is not any log file in httpdocs folder. Where does the log file exist?
4- It is weird but should the username be "database user" or should I write "root" ?
View 2 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Jul 27, 2014
I'm using Plesk 12.0.18 version with Windows 2012. I need to backup files to remote ftp server. Remote server configuration is Windows 2012 with IIS server. It works with ftp clients very well.
But, i have a problem about Personel FTP Repository. I open Personal FTP Repository Settings and write all boxes with true information about remote ftp server but it says "Transport error: unable to list directory: Curl error: Login denied".
Ftp server works fine with ftp clients and cpanel backups.
View 2 Replies
View Related
Nov 20, 2014
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
View 5 Replies
View Related
Dec 11, 2008
can not login root from SSH, LT suggest me to do KVM over IP
View 4 Replies
View Related
May 28, 2009
Is it possible to disable direct root login on Cpanel servers?
if yes, please how.
If not, what would be the best to do to secure 'root' account.
View 14 Replies
View Related
Oct 18, 2009
Meaning you can't use the user root to login to WHM.
Is that possible?
View 14 Replies
View Related
Jan 23, 2008
We have an internal server running Red Hat 8 or 9 that was taken offline at least 18 months ago. The guy who set up the box is long gone. Unfortunately with him went the root password. It wasn't a big deal until we realized there is some code we do want to get off of that box now that may be useful in a future project. In particular the database structure for one project. Is there any way to get access to this data or is it just lost?
View 3 Replies
View Related
Feb 28, 2014
when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,
View 6 Replies
View Related
Oct 24, 2009
im able to login to root via SU perfectly
One problem: All my old files and folders are owned by ROOT so that means my SU account named XXX cant edit/add/delete anything from my SFTP because of folder/file permission.
Is there anyway my SUDO(wheel) account can still edit these files own by ROOT?
View 3 Replies
View Related
Jun 3, 2009
Want to be notified instantly when someone logs into my server as root With date time & local IP address
View 12 Replies
View Related
Apr 16, 2008
login as: hen
hen@xx.xx.xx.xx's password:
Last login:
hen@root [~]# su -
Password:
su: incorrect password
I verified that root password is correct, but no matter how many times I tried, I can't su in
Where's my su permission
-rwxr-xr-x 1 root wheel 24060 Mar 22 2007 /bin/su*
here's inside /etc/group
wheel:x:10:root,hen
View 14 Replies
View Related
May 16, 2007
I tried to disable direct root login but had to struggle to find step-by-step instructions and have written the steps one needs to follow to disable direct root login.
This is an additional security measure where we prevent direct root logins and instead create a user to login and then use a command ‘su –‘ to gain root privileges.
The only risk in this procedure is that you may prevent root login but forget to add the user to the wheel group - effectively locking yourself out of the system.
Follow the steps below and you will not face a problem.
STEP 1: Let us create a user and add it to the wheel group.
For e.g. we want to create a user neonix and give him root privileges.
SSH into your server as root and follow the below commands to create a user.
groupadd neonix
useradd neonix –gneonix
passwd neonix
enteryouruserpasswordhere
verifyyouruserpasswordhere
// Please note -g in the second line
// You can replace neonix with any username of your choice.
STEP 2: Add user to wheel group.
Use your browser to Login to your WHM panel and click on Manage Wheel Group Users.
You will see the user you just added (neonix). Select the user and click ‘Add to group’.
You will see that the user has been added –
Users Currently in the wheel group root,neonix
You have successfully added a user to the 'wheel' group who will be able to 'su -' to root.
LOGOUT OF SSH
Before we disable root login, let us check if the user can login and su – to gain root privileges.
SSH into your server as 'neonix'
Login as: neonix
Password : enteryouruserpasswordhere
su –
password: enter root password here
You have successfully logged in and have root privileges. Now let us disable root login.
STEP 3: Disable Direct Root Login
(The below steps are from webhostgear.com)
1. Copy and paste this line to edit the file for SSH logins
pico -w /etc/ssh/sshd_config
2. Find the line
Protocol 2, 1
3. Uncomment it (Remove #) and change it to look like
Protocol 2
4. Next, find the line
PermitRootLogin yes
5. Uncomment it (Remove #) and make it look like PermitRootLogin no
6. Save the file Ctrl+X then Y then enter
7. Now you can restart SSH
/etc/rc.d/init.d/sshd restart
Now, no one will be able to login to root with out first logging in as 'neonix' and 'su -' to root, and you will be forcing the use of a more secure protocol.
Just make sure you remember both passwords!
View 14 Replies
View Related
Jun 17, 2013
Over the weekend, I upgraded from Plesk 10.3 to Plesk 11.5, using the updater in the control panel. Everything seemed to go well. However, this morning I've noticed that some, not all, email accounts are having trouble logging into the server to send and receive mail. Other accounts are working fine.Via POP, I get this error: -ERR Temporary problem, please try again later
Via SMTP, I get this error:
535 auth failure
I see this in the maillog:
Jun 17 07:15:05 [server] courier-pop3d: LOGIN FAILED, user=[username], ip=[::ffff:xxx.xxx.xxx.xxx]
Jun 17 07:15:05 [server] courier-pop3d: authentication error: Input/output error
And this... Jun 17 07:24:50 [server] smtp_auth: FAILED: [email address] - password incorrect from [host] [xxx.xxx.xxx.xxx]
I replaced the server name, username, host, and IP in the above.
Here are the steps I've tried so far.
- Changing the password using the control panel.
- Updating the number of daemons in authdaemonrc
- Restarting the services
View 3 Replies
View Related
Jun 27, 2014
I just upgraded my Plesk on Ubuntu (vServer) yesterday. But after the upgrade I couldn't login to the Panel anymore because all I get when I try to reach the panel (https://panel.examplesite.com:8443) is a white screen.
I rebooted the server and restarted the panel as well as Apache several times with no change.
View 10 Replies
View Related
Feb 16, 2015
I cannot login to Plesk server with admin credentials as it says Error: Access for administrator from address 'xx.xx.xx.xx' is restricted in accordance with IP Access restriction policy currently applied. Also I cannot SSH to server and it says connection refused.
View 2 Replies
View Related
Jun 26, 2014
I have VPS Server with Parallels Plesk 11.5.30 (64 bits) on OVH.ORG..Today i do Update to newest version via https://MY-IP:8447
Code: [URL] .....
Now i cant login to my server: [URL] ....
How can i repair it. I dont wanna install again Plesk Panel becouse i have a lot of configuration and email adress.All components like Apache Mysql, ftp works good, but i cant only login.
View 1 Replies
View Related
Mar 20, 2015
I cannot login server:8447
1. netstat -anp |grep 8447 = nothing
2. iptables -L Chain INPUT (policy ACCEPT) - empty; Chain FORWARD (policy ACCEPT) - empty; Chain OUTPUT (policy ACCEPT) - empty
This happened after the unsuccessful upgrade.
Code:
Execution failed.
Command: autoinstaller
Arguments: Array
(
[0] => --select-product-id
[1] => plesk
[2] => --select-release-current
[3] => --upgrade-installed-components
[4] => --include-components-from-class
[5] => vendor=parallels
[6] => --include-components-from-class
[7] => patched
[code]....
ERROR: Failed to download the package URL...transfer closed with 205 bytes remaining to read..Not all packages were installed.Please try installing packages again later.try installing the packages again.
View 9 Replies
View Related
Jun 8, 2015
It seems like I have got a lot of trouble with Plesk 12 on a CentOS 7 machine.
1. I could not install Plesk properly due to some drweb problem.
2. Than the smb configuration seems only to be implemented partly.
3. Suddenly FTP login is not possible anymore (503 Access denied)
And now even Apache is not running anymore!
Code:
Unable to generate the web server configuration file on the host <xxxxxxx.dyndns.org> because of the following errors:
Template_Exception: [Mon Jun 08 14:16:28.058302 2015] [so:warn] [pid 4230] AH01574: module actions_module is already loaded, skipping
[Mon Jun 08 14:16:28.063364 2015] [so:warn] [pid 4230] AH01574: module headers_module is already loaded, skipping
[Mon Jun 08 14:16:28.063957 2015] [so:warn] [pid 4230] AH01574: module logio_module is already loaded, skipping
[Mon Jun 08 14:16:28.066150 2015] [so:warn] [pid 4230] AH01574: module suexec_module is already loaded, skipping
httpd: Syntax error on line 357 of /etc/httpd/conf/httpd.conf: Syntax error on line 5 of /etc/httpd/conf.d
[code]....
View 1 Replies
View Related
May 26, 2014
my plesk server was running OK for the last 13 months and suddenly it breaks apart on its own and I cant make it work again. [URL]
Is there a way to backup database at this stage? How?
Planning to reformat my windows server. and start over.
View 1 Replies
View Related
May 31, 2015
Are some days that in the root of my server there is a folder without a name. I think it is fail2ban to create this folder? Only I have access to the server.
View 11 Replies
View Related
Jul 3, 2008
Currently I have a server that has direct root SSH access disabled (have to login as regular user then su to root), but I am currently working on setting up authentication via SSH keys, but I can't seem to get it working with direct root SSH access disabled? Is this normal, and if so is there anyway to work around it?
Basically I'd like to be able to authenticate both ways; both with SSH keys or by logging in as a regular user and su to root.
View 8 Replies
View Related
Aug 1, 2007
i can not login to my decated server by using root. the password is not correct.. becasue i did something wrong with my server. i used chmod 777 -R /public_hmtl and chown to modify my server. and i can not login anymore, LT asked me to reload my server, do i need to reload it?
View 6 Replies
View Related