When I specify log rotation settings for domain xyz.com in Plesk panel I expect them to be saved in /etc/logrotate.d/xyz.com file, at least this is the expected behaviour according to Plesk12 Admin Guide: [URL] ....
Apparently, it doesn't happen and I don't have xyz.com file in /etc/logrotate.d/
Log rotation doesn't seem to work either, at least it doesn't work for error.log
I read somewhere that log rotation feature has to be specially enabled in Plesk but I couldn't find specifics anywhere.
I'm running Plesk 12. I install it today, using the ISO which parallels provides, which includes centos 6.5 and preinstalled Plesk 12 in my vps. Then I logged in plesk, and I did everything it wants. Then I upgraded my php, to php 5.4.36 according to the manual that Paralells provides, and then I tried to increase the max upload file size for phpmyadmin. I have edited my /usr/local/psa/admin/conf/php.ini file and tried to restart using with 3 different ways using terminal:
1st: service sw-cp-server restart 2st: /etc/init.d/psa stop /etc/init.d/psa start 3st: reboot (which rebooted all the vps)
My php.ini file is:
short_open_tag = On y2k_compliance = Off output_buffering = Off max_execution_time = 600 max_input_time = 600 memory_limit = 256M max_file_uploads = 99999 max_input_vars = 2000
[Code] ....
However, when I'm trying to import a 31mb sql file, I always get that error, and only some of my tables are being imported:
#1153 - Got a packet bigger than 'max_allowed_packet' bytes
I am runing ubuntu server 64bit with plesk v.11.5.30, phpmyadmin v.4:3.4.10.1-1.
When i try to acces phpmyadmin from : myserverIP/phpmyadmin - it gives me 500 error.
When I try to acces phpmyadmin from: mydomainserver/phpmyadmin - it saves file at login into the disk instead login. I was going through different threads on the web to solve that problem but no success at all.
I have real basic knowledge about webservers, phpmyadmin and mysql server. I am runing my first cloud server just few days.
There is no possibility to access preconfigured phpmyadmin from plesk according that thread: link So what for do I need plesk?
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
I have a problem when i config config.inc.php file in my WHM . I don't know why share accounts can access to phpMyAdmin or create your database from cpanel .
This is a part of config.inc.php file
Quote:
/** * Disable the default warning that is displayed on the DB Details Structure page if * any of the required Tables for the relationfeatures could not be found */ $cfg['PmaNoRelation_DisableWarning'] = FALSE;
/** * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If * at least one server configuration uses 'cookie' auth_type, enter here a * passphrase that will be used by blowfish. The maximum length seems to be 46 * characters. */ $cfg['blowfish_secret'] = '';
/** * Server(s) configuration */ $i = 0; // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use // $cfg['Servers'][0]. You can disable a server config entry by setting host // to ''. If you want more than one server, just copy following section // (including $i incrementation) serveral times. There is no need to define // full server array, just define values you need to change. $i++; $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket $cfg['Servers'][$i]['ssl'] = false; // Use SSL for connecting to MySQL server? $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli') $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection // (requires PHP >= 4.3.0) $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" // and "mysql/db" tables). // The controluser is also // used for all relational // features (pmadb) $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie) $cfg['Servers'][$i]['user'] = ''; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) $cfg['Servers'][$i]['SignonSession'] = ''; // Session to use for 'signon' auth method $cfg['Servers'][$i]['SignonURL'] = ''; // URL where to redirect user to login for 'signon' auth method $cfg['Servers'][$i]['LogoutURL'] = ''; // URL where to redirect user after logout $cfg['Servers'][$i]['nopassword'] = FALSE; // Whether to try to connect without password $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only // this db is displayed in left frame // It may also be an array of db-names, where sorting order is relevant. $cfg['Servers'][$i]['hide_db'] = ''; // Database name to be hidden from listings $cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features // (see scripts/create_tables.sql) // - leave blank for no support // DEFAULT: 'phpmyadmin' $cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table // - leave blank for no bookmark support // DEFAULT: 'pma_bookmark' $cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) // - leave blank for no relation-links support // DEFAULT: 'pma_relation' $cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields // - leave blank for no display fields support // DEFAULT: 'pma_table_info' $cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema // - leave blank for no PDF schema support // DEFAULT: 'pma_table_coords' $cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf // - leave blank if you don't want to use this // DEFAULT: 'pma_pdf_pages' $cfg['Servers'][$i]['column_info'] = ''; // table to store column information // - leave blank for no column comments/mime types // DEFAULT: 'pma_column_info' $cfg['Servers'][$i]['history'] = ''; // table to store SQL history // - leave blank for no SQL query history // DEFAULT: 'pma_history' $cfg['Servers'][$i]['designer_coords'] = ''; // table to store the coordinates for Designer // - leave blank for no Designer feature // DEFAULT: 'pma_designer_coords' $cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables // are up to date. This prevents compatibility // checks and thereby increases performance. $cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login $cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults = array();
// If you have more than one server configured, you can set $cfg['ServerDefault'] // to any one of them to autoconnect to that server when phpMyAdmin is started, // or set it to 0 to be given a list of servers without logging in // If you have only one server configured, $cfg['ServerDefault'] *MUST* be // set to that server. $cfg['ServerDefault'] = 1; // Default server (0 = no default server)
/** * Other core phpMyAdmin settings */ $cfg['MaxDbList'] = 100; // maximum number of db's displayed in left frame and databaes list $cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto') $cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database $cfg['ForceSSL'] = FALSE; // whether to force using https $cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit) $cfg['MemoryLimit'] = 0; // maximum allocated bytes (0 for no limit) $cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show // locked tables (since MySQL 3.23.30) $cfg['ShowSQL'] = TRUE; // show SQL queries as run $cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users $cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE' $cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not $cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds) $cfg['LoginCookieStore'] = 0; // how long login cookie should be stored (in seconds) $cfg['LoginCookieDeleteAll'] = TRUE; // whether to delete all login cookies on logout $cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature // or not $cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries // even if one of the queries failed $cfg['VerboseMultiSubmit'] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on // multiple-statement queries. See the libraries/import.php file for // hardcoded defaults on how many queries a statement may contain! $cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth
// Left frame setup $cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the // current tables in the left frame. $cfg['LeftFrameDBTree'] = TRUE; // turn the select-based light menu into a tree $cfg['LeftFrameDBSeparator'] = '_'; // the separator to sub-tree the select-based light menu tree $cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes // to split/nest tables into multiple categories $cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting // up tables by the above Separator $cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame $cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments $cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_structure) instead of // table/db names. Setting ShowTooltipAliasTB to 'nested' will only // use the Aliases for nested descriptors, not the table itself.
$cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame $cfg['LeftLogoLink'] = 'main.php'; // where should logo link point to // (can also contain an external URL) $cfg['LeftLogoLinkWindow'] = 'main'; // whether to open the linked page // in the main window ('main') // or in a new window ('new') $cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame $cfg['DisplayServersList'] = FALSE; // server choice as links $cfg['DisplayDatabasesList'] = FALSE; // database choice in light as links
// In the main frame, at startup... $cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in // the pages about database details and table // properties $cfg['ShowPhpInfo'] = FALSE; // show php info link $cfg['ShowServerInfo'] = TRUE; // show MySQL server information $cfg['ShowChgPassword'] = FALSE; // show change password link $cfg['ShowCreateDb'] = TRUE; // show create database form $cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)
Some questions -------------------------------------------------- $cfg['Servers'][$i]['controluser'] =?
After my HDD crashed, I replaced it and installed Plesk 12.0.18 but not some options are missing from the panel.I'm missing this functionality: Send from domain IP addresses and use domain names in SMTP greeting
Also now after the restoration of the backups in /var/www/vhosts/<DOMAIIN_NAME>/logs/There are no logs, but they are present in /var/www/ vhosts/ system/<DOMAIIN_NAME>/logs/Before they were symlinked to the first directory.all my domains with a dedicated IP are being sent from my main IP, and they are being marked as spam because of SPF.
After restore (without any errors) some of my files are missing from one particular domain. The files are present in the backup however, they just don't restore. In this case it is a Wordpress installation and the complete wp-content folder did not restore one one of the domains.
We have a problem migrating from 11.0.9 to a different server running 12.0.18. Our Plesk 11 server is running great since years ago. We have 3 resellers there, say reseller1 with 17 domains, reseller2 with 13 domains and reseller3 with 250 domains.
First, we executed a complete server migration with: /usr/local/psa/bin/migrate -m -host xxx.xxx.xxx.xxx -password xxxxxx -ip-mapping /root/migration-mapping.txt -skip-license -replace-existing-objects true
The process ran properly, but in the end we've found reseller1 and reseller2 were NOT migrated. No errors were reported tho.
While investigating this issue we have found:
1) "/usr/local/psa/bin/migrate --list-resellers" returns only reseller3. So it looks like reseller1 and reseller2 are not "seen" by the migrate utility.
2) /usr/local/psa/bin/migrate -mr reseller1 returns: Migration started at: 2015-06-03 04:21:11 The following clients not exist: reseller1
3) /usr/local/psa/bin/migrate --list-subscriptions returns the 250 subscriptions of reseller3, but no single mention to reseller1 and reseller2 subscriptions.
In short, reseller1 and reseller2 are invisible for the migration utility. Both missing resellers are ok, enabled and active in our Plesk 11 server.
We are now stuck on the migration process and wondering if this could be a bug in the migrate utility? or some inconsistence in our Plesk 11?
Recently i installed the latest Multiple PHP functionality for Plesk and assigned PHP version 5.6 to a subdomain (for example demo.mywebsite.com) and i installed a Wordpress. So i thought i would try something out by installing a custom standalone version of phpmyadmin (version 4.4.1.1) and when i load the setup i ran into the following issue on the index.php page:
Code: Warning in ./libraries/session.inc.php#101 session_start(): open(/var/lib/php/sessions/sess_dubv0rqju6bejfplkgcsl98qsonviukg, O_RDWR) failed: No such file or directory (2) Backtrace ./libraries/session.inc.php#101: session_start() ./libraries/common.inc.php#352: require(./libraries/session.inc.php) ./phpinfo.php#12: require_once(./libraries/common.inc.php) note 1. Due to privacy i have called domain 'demo.mywesite.com' and subfolder 'root'
I'm missing files that the existing crontab requires. There are results on Google for it, but since the parallels' forum upgrade, all the Google links are dead...
The missing crons in question are:
/bin/sh: /usr/local/psa/libexec/modules/watchdog/cp/clean-events: No such file or directory /bin/sh: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats: No such file or directory /bin/sh: /usr/local/psa/libexec/modules/watchdog/cp/clean-sysstats: No such file or directoryClick to expand...
I have updated from 11.5 to 12.0 mostly in order to use Fail2Ban.
I have also installed a new Plesk 12 license key to make sure that the license allows Fail2Ban. It says now that Fail2Ban is "On". But I can not find the menu entry to get to the Fail2Ban configuration. It is simply not there... (it is supposed to be in the Securitiy menu in the Tools and Settings section...)
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.
After a migration I did this weekend I mis a couple of the migrated domains in the subscription list. The domains are working great, but I cannot find them in Plesk.
I got this errors in the migration manager:
Info: The password was generated for user 'Domain Administrator (domain.com)'. New password is 'GA66QgQ'
Warning: Execution of /opt/psa/admin/plib/api-cli/user.php --create domain.com -owner admin -guid cfa43606-e8b0-444c-a005-660984840498 -cname Domain Administrator (domain.com) -passwd '' -status disabled -domain-admin true -email '' -external-email true -role Domain Administrator (domain.com) -country NL -legacy-user false -subscription-name domain.com -ignore-nonexistent-options failed with return code 1. Stderr is Error during user creation: Owner with id 1 has not subscription with id 69
Warning: domain "domain.com" Execution of /opt/psa/admin/bin/backup_restore_helper --restore-legacy-dlu domain.com -dlu-info /opt/psa/PMM/tmp/deployer_legacy_dluIrjcWa -ignore-nonexistent-options failed with return code 1. Stderr is Unable to create Account object: Account: unable to select: no such row in the tableClick to expand...
I just upgraded from Plesk 11.x to 12.0.18 and was eager to try the new sieve functions. I used the normal Plesk Updates/Upgrades tool to change the imap server from Courier to Dovecot. However, Dovecot will not start. It gives an error about /etc/dovecot/private/ssl-cert-and-key.pem missing.
I made a backup of my website with plesk backup manager on an external FTP, now I want to restore this backup on a new server which isn't using plesk, for test purposes. I've downloaded the backup (which is in .tar) on my PC, and extracted all files firstly from the general .tar archive, then the user_data from .tgz. Then to extract all the databases (they were in a folder "databases" after I've extracted the general .tar file), I extracted them from database_name_145536536.tgz, then from database_name_145536536.tar, so that now I've a series of "database_name_145536536" files. (145536536 are some example numbers).
I'm interested in restoring both files and mysql databases.
To restore the files, I can simply use the extracted files from the user_data archive.
To restore the mysql databases, I tried to do "mysql -p -u username database_name < file" and everything seemed to work fine.
Is this process ok? Is it 100% safe and sure or I could face some bugs?
At some point, not sure when, PHPMyAdmin's (as accessed through the admin panel by clicking on a customer, manage hosting, databases, etc) permissions have changed such that I cannot view, edit or add MySQL routines/procedures. This appears to have occurred system-wide, though I have not checked every database on the server.
Is there a fix to get the permissions set so that I can make these changes again?
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.
Migrating accounts to a fresh Plesk 12 installation task fails with the following error: Perhaps /usr/local/psa/admin/bin/deployer application missing, has incorrect permissions or unexpectedly terminated
Fresh install of Plesk 12.0.18 MU42 on CentOS 7.1. Tried to reinstall, same problem.
