Plesk 12.x / Linux :: Unknown Database Atmail When Selecting Database

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


ADVERTISEMENT

Plesk 12.x / Linux :: Cannot Login - Unknown Database PSA

Feb 22, 2015

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)

View 3 Replies View Related

Plesk 11.x / Linux :: Upgrade From 11.0.9 To 11.5 Database Error - Unknown Columns

Sep 9, 2013

I just upgraded from 11.0.9 and i got the following error

ERROR: Zend_Db_Statement_Exception

Eine Ebene höher
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipAddress' in 'where clause'

A Google Search shows that under Windows there is dbupgrade.exe

Is there such a tool under Linux too??

View 4 Replies View Related

Plesk 12.x / Linux :: Possible To Reconstruct Psa Database

Aug 9, 2014

After upgrade 11.5 to 12, my panel works fine but nos subscription in the panel.Websites are working well...Is it possible to reconstruct the psa database (no backup :-( ) ?Some backups of psa database are done before the upgrade?

View 2 Replies View Related

Plesk 12.x / Linux :: Copy Database To Other Domain

Jul 7, 2015

Just updated to V12 and noticed you can't copy a database from one domain to another as easy as before. So doing any testing is much harder. Is this correct or am I missing something...

View 5 Replies View Related

Plesk 11.x / Linux :: Assign Database To Domain

Jul 20, 2014

I've created a database through SSH and give it a user so no problem.

But when i came back in Plesk Panel i don't see this database connected to the domain i want.

So how can i do to "indicate" my server this database must be going with this domain ?

View 1 Replies View Related

Plesk 11.x / Linux :: Clear SpamAssassin Database?

Sep 19, 2014

The SpamAssassin bayes database has become ineffective on one of our servers and we want to wipe it and start fresh - how to do this on Plesk 11.5.30?

View 1 Replies View Related

Plesk 12.x / Linux :: PHPMyAdmin Database Upload

Jul 2, 2015

We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.

View 4 Replies View Related

Plesk 11.x / Linux :: How To Get Mailbox Limits From Database

May 21, 2014

I have a script which checks the mailboxes of all clients to notify them when they're reaching capacity.

This does so by checking the psa database for their set limit and matching that to the maildirsize file within the user's Maildir directory.

After upgrading, though, my SQL query no longer works - it was:

Code:
SELECT clients.email as owner_email, domains.id, domains.name, Limits.value AS domain_quota, mail.mail_name, mail.mbox_quota from Limits, clients, domains, mail WHERE mail.postbox='true' AND limit_name = 'mbox_quota' AND domains.limits_id = Limits.id AND mail.dom_id = domains.id AND clients.id = domains.cl_id ORDER BY domains.name ASC

However, on closer inspection, all values in the domains table for limit_id are NULL.

Has this changed in 11.5? Is there an alternative way to quickly get all limits for domains?

View 4 Replies View Related

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 View Related

Plesk 12.x / Linux :: Database Cloning Message Keeps On Showing

Dec 30, 2014

When copy a database, plesk would copy it but hung at creating the db user, therefore, the database cloning message keeps on showing

Cloning the database xxxxxx to the database xxxxx. You will be notified of the progress by email (xxxxxxx).

*I checked if the database was copied, it showed it did but the user was not created for that newly copied one.

View 2 Replies View Related

Plesk 11.x / Linux :: Increase Import Database Size

May 4, 2015

I have a virtual server with CentOS 6.4 (Final) and Plesk 11.5.30 and I would like to increase the database size to import because right now it's only 2MB and I have to put online a website with 10MB.

View 5 Replies View Related

Plesk 12.x / Linux :: Installation With Dedicated Database Server

Jul 21, 2015

if I can install plesk panel with a dedicated database server... and how.

View 3 Replies View Related

Plesk 11.x / Linux :: Make New User And Give 1 Database Only

Apr 14, 2015

1 have to create a new user, for example "webmaster" with ftp access, plesk access and database access.

My problem is: after i make all, this user can see all database for this domain. Can i show him only 1 database (him database)? If yes, how i can do?

View 2 Replies View Related

Plesk 11.x / Linux :: Database Creation From Third Party Application?

Jun 17, 2014

Parallels Panel 11.0.9
Ubuntu 12.04.4 LTS
Apache/2.2.22 / Mysql 3.5.8.1

Is it possible to let Plesk allow database creation from another web application ?

For example, we would like to use this framework (codeigniter) method => this->dbforge->create_database('db_name')

ACTUAL RESULT =>

The method returns false but i'm unable to track it on the error logs.

EXPECTED RESULT =>

The method should returns TRUE

And thus the database should be created

Is it some task we should manage at Plesk or Apache level ?

View 7 Replies View Related

Plesk 12.x / Linux :: Database Copying Between Subscriptions Missing?

Jun 11, 2015

I've been happily copy databases between subscriptions in Plesk 11.5xx for years but having updated to 12 the feature no longer works.

In the copy database screen when the 'local MySQL server' option is selected in the drop down the 'Copy to existing database' radio button is disabled.

My service provider tells me this is a feature change.

View 2 Replies View Related

Plesk 12.x / Linux :: No Such User In Mail Authorization Database

Aug 4, 2014

After upgrading to plesk 12 over the weekend. None of my mail users can authenticate.I'm receiving quite a few error messages such as this for my ipmap users

authpsa[3822]: No such user 'bstewart@mwfbooks.com' in mail authorization database
courier-imapd: LOGIN FAILED, user=bstewart@mwfbooks.com, ip=[::ffff:69.176.116.106]

I've tried running mchk --with-spam command. But it hangs at the mail_auth_dump for several hours. Checking the cpu on that command and it is sitting idle.I've tried running the mail_auth_dump.worker manually and no better luck. Still nothing on the screen just hangs as if it's asleep.

View 3 Replies View Related

Plesk 12.x / Linux :: Database Copy Hanging In New Version

Dec 23, 2014

After the micro update, the database copy function started to hung even just for copying database with 4 tables with less than 10 rows of recrods. Although I followed the link below to remove the hung database copy and remove the unfinished database copied. URL....However, no successful database was copied at all even after the timeout was adjusted.

View 1 Replies View Related

Plesk 12.x / Linux :: Unable To Create New Database User

Jun 22, 2015

Connection to the database server failed: Unknown column 'plugin' in 'mysql.user'

View 1 Replies View Related

Plesk 12.x / Linux :: Importing Large Database To Phpmyadmin?

Feb 9, 2015

I'm on a VPS with Ubuntu 14.04 and Plesk 12 Web Admin Edition. I can't import a large (20 MB zipped) database dump to phpmyadmin because there is a 2MB file size limit. I suppose I have to change the server-wide PHP configuration (if I change the PHP settings for the domain nothing happens). Is there a way to change the global PHP settings via the Plesk panel?

View 2 Replies View Related

Plesk 12.x / Linux :: Error Creating Database From Client Account

Jul 14, 2015

My panel suddenly stop works to create databases from client account.This error shows:

Internal error.
PHP Notice: Undefined variable: dbType

From admin account there is no problem to create databases.I`ve run bootstrap.sh repair successfully but still not working.Plesk 12.0.18 #55 Ubuntu Linux 10.04

View 2 Replies View Related

Plesk 12.x / Linux :: Delete Subdomain Without Removing Files Or Database?

Aug 30, 2014

I cannot seem to find a conclusive answer to this. I use subdomains to create client websites then once they are in their own domains the subdomains still remain. Can I delete only the subdomain and leave all the files or at least leave the database since it is still connected to the new domain. Example below.

subdomain.example.com uses database1

newsite.com still uses database1

Is there a way to copy the database into the new domain?

View 1 Replies View Related

Plesk 12.x / Linux :: New Wordpress - Error Establishing Database Connection?

Oct 9, 2014

I just tested the WP creation feature of PP12 and I get the following error when I attempt to view the newly created CMS...

"Error establishing a database connection"

If I navigate to the database page and click webadmin, I can connect and see the WP database created. Everything works in phpMyAdmin.

Going to ../wordpress/wp_login.php returns the error.

View 3 Replies View Related

Plesk 11.x / Linux :: Error Adding Remote Database Server

May 9, 2014

PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Plesk 11.5, 11.5.30 Update #44, last updated at April 30, 2014 03:25 AM, Centos 6.5 (Final), Linux 64bit

PROBLEM DESCRIPTION
When I try to add an extra MySQL server, running on a different server, I always get an error that the user has no admin access. But the user I created does have admin access to the database.
The remote database is a MySQL 5.5 on a Linux Ubuntu 12.04 LTS server

STEPS TO REPRODUCE
Tools & Settings -> Database Servers -> Add Databases server

ACTUAL RESULT
Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'%' to database 'd536cedf97037e'

EXPECTED RESULT
A working database connection.

ANY ADDITIONAL INFORMATION
These queries are logged by MySQL:

140509 16:54:51 28 Connectadmin@10.1.0.162 as anonymous on
28 QuerySELECT VERSION()
28 Querycreate database `BUG115166_1374110215536CEC3816DD2` /*!40101 default charset=utf8 */
28 Querycreate database `bug115166_1374110215536cec3816dd2` /*!40101 default charset=utf8 */
28 Queryinsert into mysql.user (Host, User, Password) values ('%', 'bug115166_17546', password('BUG115166_1374110215536CEC3816DD2'))
28 QueryFLUSH PRIVILEGES

[Code] .....

If I just ignore this message, go to a subscription and create a database, then the database gets created just fine. It's just Plesk that thinks that something went wrong.

View 2 Replies View Related

Plesk 12.x / Linux :: CLI Database Server Settings - Access Control

Jun 10, 2015

i would like to change the access control for datebase users via CL: command: /usr/local/psa/bin/database --update-dbuser web1_presta -server localhost:3306 reply: The database user was successfully updated. examination: mysql> select host, user from mysql.user;

+-----------+------------------+
| host | user |
+-----------+------------------+
| % | web1_presta |
| localhost | web1_oxid |
| localhost | web1_presta |
| localhost | web1_shopware |
| localhost | web1_wp |
+-----------+------------------+

Only when using the GUI:
home -> Subscriptions -> Website & Domains -> Databases -> Users -> web1_wp -> Access control
-> from Allow remote connections from any host
-> to Allow local connections only

is also the user adjusted:
mysql> select host, user from mysql.user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| localhost | web1_oxid |
| localhost | web1_presta |
| localhost | web1_shopware |
| localhost | web1_wp |
+-----------+------------------+

View 2 Replies View Related

Plesk 11.x / Linux :: Failed To Execute Backup Of Mysql Database

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

Plesk 12.x / Linux :: Using Remote Database Server On Separate Installs?

Nov 24, 2014

Is it possible to use a remote database server on two or more Plesk installations without issue?

Plesk A (192.168.1.1):

Local MySQL (default)
Remote A MySQL (192.168.1.5)
Plesk B (192.168.1.2):

Local MySQL (default)
Remote A MySQL (192.168.1.5)

... etc etc. Is that possible? It'll allow me to create databases on the remote server from both/all the Plesk servers without conflict?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved