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


ADVERTISEMENT

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 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 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 :: 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

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 11.x / Linux :: Importing To MySQL Database - Maximum Execution Time

Nov 5, 2014

I have this error when i put import to mysql database

Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<script></script><p>ERROR: Maximum execution time of 300 seconds exceeded (Util.' at line 244

I have in domain > doemainname >
max_execution_time
Standaard
Geef een aangepaste waarde op 0

and insert in
usr/local/psa/admin/htdocs/domains/databases/phpmyadmin in the file config.sample.inc.php following command
$cfg['ExecTimeLimit'] = 70000;

but it will not work...

View 2 Replies View Related

Plesk 11.x / Linux :: Autoupdate Fails ERROR While Trying To Backup MySQL Database

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

Plesk 11.x / Linux :: Constant Unable To Connect To Database While Upgrading / Repairing

Aug 11, 2014

I had Plesk 10 installed on my openSUSE system (was a low version, maybe 11 or less) and then decided to upgrade to 11.5. So I did distribution upgrades to openSUSE 12.3 and everything went smoothly, except for some services like mysql and php. So I used Plesk autoinstaller to fix the php error and edited an outdated line in mysql configuration and both services ran smoothly!

Then I downloaded Plesk autoinstaller and ran the autoinstaller, but was surprised by this error message:

===> Checking for previous installation ... found.
ERR (3) [panel]: Error during product key mode determination, details: Unable to connect to database: ; trace: #0 /usr/local/psa/admin/plib/functions.php(2821): isPpaKeyRequired()
#1 /usr/local/psa/admin/plib/common_func.php3(11): require_once('/usr/local/psa/...')
#2 /usr/local/psa/admin/plib/api-common/cu.php(5): require_once('/usr/local/psa/...')
#3 /usr/local/psa/admin/sbin/httpdmng(8): include_once('/usr/local/psa/...')
#4 (main)

Unable to connect to database:

- My MySQL version is: 5.5.33 openSUSE package
- I did run mysql_upgrade with my admin username and password (password from: /etc/psa/.psa.shadow) and it worked successfully and fixed all of the errors, I did so after running the auto installer first, but then ran the installer again and the problem was still there
- I can access my web page, but it still doesn't connect to MySQL either.

I believe this is a problem with MySQL, but how can I make sure or detect what exactly the problem is

View 3 Replies View Related







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