Hi,

while re configuring a domain in plesk windows then solution is below:

1. Start> Run > cmd>

2.C:\net user geeksupp /add

3. C:\net localgroup psacln geeksupp /add

4. servermanager > configuration > Local users and Groups > user > properties > Add Local Path  to “C:\inetpub\vhosts\geek4support.com”.

Replace your username and domainname.

From MySQL Large Configuration.

MySQL Large Original


# The MySQL server
[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

After Optimization

# The MySQL server
[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

Other ideas…

mysql optimize

innodb_buffer_pool_instances = 2
reduced the number of max connections to 500 (which is still high)
syn error

adjusting /proc/sys/net/ipv4/tcp_max_syn_backlog

nf_conntrack: table full, dropping packet.

network and ulimit settings

number of connections in time_wait – how to contrl:

set both tcp_tw_recycle and lowered tcp_fin_timeout to 30

If a manual transfer is required (for mail content, a complete server after a crash, database moving, etc.), refer to the following sources:

112699 How to restore a Plesk installation on the new server after a disaster
3072 How do I restore Plesk from the hard disk drive if the Operating System is broken and the HDD with the old OS and Plesk is mounted in the new system?
1152 How to migrate Plesk data manually with Plesk Migration Manager
6518 How to migrate local database between Plesk servers manually (applicable for versions 8.x and 9.x)
6158 How to migrate Сalendar, Personal Address Book, and Horde Webmail preferences manually
5882 How to migrate Plesk and SiteBuilder content and retain Plesk and SiteBuilder integration (applicable for versions 8.x and 9.x)

Steps

How do I restore Parallels Plesk from a hard disk drive if the Operating System is broken and the HDD with the old installation is mounted to the new server?

Read More

[Tue Aug 18 16:28:04 2015] [error] [client 65.47.199.226] ModSecurity: Audit log: Failed to create subdirectories: /usr/local/apache/logs/modsec_audit/exclusi3/20150818/20150818-1628 (Read-only file system) [hostname "exclusivityllc.net"] [uri "/index.php"] [unique_id "VdOjZNg3iukAAFLEtGYAAAAH"]
If I disable mod security on the account, then I get Mod ruid errors

Disable mod security


[Tue Aug 18 16:29:49 2015] [error] [client 209.92.131.130] SecurityException in Application.cpp:186: Do not have root privileges. Executable not set-uid root?
[Tue Aug 18 16:29:49 2015] [error] [client 209.92.131.130] Premature end of script headers: index.php

I had to disable modsecurity and then uncheck “EXPERIMENTAL: Jail Apache Virtual Hosts using mod_ruid2 and cPanel® jailshell” enabled under the “Security” tab in “WHM >> Tweak Settings”.

I found one way to access the shared folder without giving the username and password.

We need to change the share folder protect settings in the machine where the folder has been shared.

Go to Control Panel > Network and sharing center > Change advanced sharing settings > Enable Turn Off password protect sharing option.

By doing the above settings we can access the shared folder without any username/password.

Go to Control Panel > Network and sharing center > Change advanced sharing settings > Enable Turn Off password protect sharing option.

By doing the above settings we can access the shared folder without any username/password.

You need to go to user accounts and enable Guest Account, its default disabled. Once you do this, you share any folder and add the guest account to the list of users who can accesss that specific folder, this also includes to Turn off password Protected Sharing in ‘Advanced Sharing Settings’.

After some more research, there are 2 final steps in sharing over network segments like this case. By default, Everyone does not include anonymous logins for permissions. Anonymous logins would be any user trying to access a share without a local username and password. The second step is the sharing and security policy which is defaulted to classic mode. Changed these in the gpedit console to:

1)enabled for everyone includes anonymous
2) guest mode for sharing and security model

Start > Administrative tools > Local Security Policy > Local Policy, Security Options.

Accounts: Guest account status Enabled
Network access: Let Everyone permissions apply to anonymous users Enabled
Network access: Sharing and Security model for local accounts – set to Guestonly – local users authenticate as guest

lpol

Step 2

sharing1

Step 3

share2

Step 3

share3

This should be able to access the share now without any prompt for user or password.

# Example MySQL config file for large systems.
#
# This is for a large system with memory = 512M where the system runs mainly
# MySQL.
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id       = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;

#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 256M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout


Linux Shortcuts

Find Plesk Password on older plesk versions. Login via ssh as root and run the following command:


# /usr/local/psa/bin/admin --show-password

Show encrypted admin password:


# cat /etc/psa/.psa.shadow

Show Plesk MySQL password


# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

Show processlist


# mysqladmin -u admin -p`cat /etc/psa/.psa.shadow` processlist

Export Plesk database


# mysqldump  -u admin -p`cat /etc/psa/.psa.shadow` database > /tmp/database.sql

Import Plesk database
# mysql -u admin -p`cat /etc/psa/.psa.shadow` database < /tmp/database.sql Email Commands [bash] /usr/local/psa/admin/bin/mailqueuemng -s tail -50 /usr/local/psa/var/log/maillog tail -50 /var/log/maillog tail -50 /var/log/exim_mainlog [/bash] RAM [bash] # curl -s http://dev.patlathem.com/mem.txt | python [/bash] Windows Shortcuts [bash] cd %plesk_bin% plesksrvclient -get [/bash] [bash] rdesktop -g 1024x768 -P IPaddress -u administrator rdesktop ipaddress -g 1024x768 [/bash] [bash] # mysql -uroot -p status Uptime: 68730 Threads: 378 Questions: 459474 Slow queries: 0 Opens: 17283 Flush tables: 15 Open tables: 201 Queries per second avg: 6.685 [/bash] [bash] # mysqladmin -uroot -p processlist Enter password: +----+------+-----------+----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+----+---------+------+-------+------------------+ | 13 | root | localhost | | Query | 0 | init | show processlist | +----+------+-----------+----+---------+------+-------+------------------+ [/bash]

Getting error for Plesk auto installer on Ubuntu 12 Trusty:


Reading package lists...
W: GPG error: http://autoinstall.plesk.com trusty InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 227C38D6AF741DEB
W: GPG error: http://autoinstall.plesk.com trusty InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 227C38D6AF741DEB
W: GPG error: http://autoinstall.plesk.com trusty InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 227C38D6AF741DEB
W: GPG error: http://autoinstall.plesk.com trusty InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 227C38D6AF741DEB
W: GPG error: http://autoinstall.plesk.com trusty InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 227C38D6AF741DEB
Gathering information about installed license key...
Checking whether the package dependencies are resolved.
E: Unable to correct problems, you have held broken packages.
---X--- `apt-get` output ---------------------
Reading package lists...
Building dependency tree...
Reading state information...
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
plesk-base : Depends: sw-engine (>= 2.13.9) but it is not going to be installed
plesk-core : Depends: libmyodbc but it is not installable
Depends: pigz but it is not installable
plesk-php56-dba : Depends: libdb5.1 but it is not installable
plesk-php56-imap : Depends: libc-client2007e but it is not installable
plesk-php56-mcrypt : Depends: libmcrypt4 but it is not installable
plesk-service-node-utilities : Depends: libxml-dumper-perl but it is not installable
Depends: sysv-rc-conf but it is not installable
pp12.0.18-bootstrapper : Depends: sw-engine (>= 2.0) but it is not going to be installed
psa-courier-imap : Depends: libdb5.1 but it is not installable
Depends: libssl0.9.8 but it is not installable
psa-php5-configurator : Depends: php5-imap but it is not installable
psa-updates : Depends: sw-engine (>= 2.13.12) but it is not going to be installed

Check following:

1. /etc/apt/sources.list

2. uncomment the deb repos listed as universal/multiverse

3. re-run apt-get update

4. re-run plesk installer

I have also noticed that it tends to give an error about the hostname as well, which I resolved by temporarily setting the hostname to pretty much anything, such as newserver.

Other Information: http://forum.odin.com/threads/plesk-autoinstaller-gpg-error.332686/