i Install and Configer CSF , i mess up My VPS , and have no idea whts wrong.
Could Some 1 Give me the Config file PrConfiguered ,
My Vps Details .
Centos 5.3
512 mb
Hybervm + Kloxo .
No any other Firewall installed or Floods Filters..
its Clean Now waiting for Right Config File ..
This is Personal VPS no one will use ftp, or SSH, Kloxo ...
how can i edit iptables config file and update it?
because my server is under DDos attack.
I have placed a Content Management System on an Apache server using Cpanel and when I try to install I get messages about folders and files needing permission changes, then after installation some modules won't work because of wrong permissions. The solution to make everything work is to set all folders and files to 0777 but then that would just open up to insecurity. Also I can't set files to 0444 using an FTP client. It can only be done via Cpanel's file manager.
I install the same CMS on another hosting service with the same Apache/Cpanel config and it does not require any CHMOD. The app installs without errors and functions correctly with folders at 0755 and files at 0644.
It seems most shared hosting nowadays work as the latter statement so what could be the cause why the other hosting server require all the permission changes?
c:Apache24bin>openssl.exe
WARNING: can't open config file: c:/openssl-1.0.1e-X64/ssl/openssl.cnf
OpenSSL>
I got this message now for the second time:
Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainWebmail.php, error = Template_Exception: No data. file: /usr/local/psa/admin/plib/Template/Processor.php line: 28 code: 0 Previous error: Template_Variable_Exception: No data. file: /usr/local/psa/admin/plib/Template/Variable/AbstractCachedData.php line: 67 code: 0.
How can this happen and how to solve this?
How can I setup my control panel to update the Apache config file
View 4 Replies View RelatedI installed Plesk on a VPS running on Ubuntu 14.04. When I try to open phpMyAdmin the following error message appears:
You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said: cannot connect: invalid settings.
When I try to click on the setup script link another error message pops up:
Error in Processing Request
Error code: 404
Error text: Not Found
What do I have to do to make phpMyAdmin work?
I just want to use a server for file sharing, it will have nginx and that's it. I'm looking at centos, or freebsd, but I been using centos forever now and I'm not sure how to use freebsd, should I just stay with centos?
Do I tell my hosting provider to just install the OS and give me ssh action and that's it? Don't install any control panels or any other stuff? I want one domain and one subdomain on it though and ftp action.
I'm build Plesk Panel for Linux and Presence Builder, I don't want my user can upload their website to hosting via File Manager. How can I do it...
View 2 Replies View RelatedSay I have 2 websites and they all use file.php which is located on mainserver.com/file.php.
I want to use the file like this:
website1.com/file.php
website2.com/file.php
Server :
Code:
Intel C2Q Q9450
8196 MB DDR2 RAM
500 GB 7.200RPM
2000GB Transfer p/m
OS: CentOS 5.2
Code:
running a ipb forum site 2.3.4
current stats :
Our members have made a total of 245,827 posts
We have 14,673 registered members
Total number of topics is 75099
with atleast 150 members online + 200guests.
what would be the perfect my.cnf config for this kinda of a server? Im running litespeed.
I am trying to install a newer release of APC PHP cache on our server that runs RHES-4 and PHP 4.3.9
I installed version 3.0.14 some time ago and now cannot install the new v3.0.16. When I run ./configure I get this:
Quote:
[root@xxxx APC-3.0.16]# ./configure --enable-apc --enable-apc-mmap --with-apxs --with-php-config
configure: error: cannot run /bin/sh ./config.sub
The baffling thing is that I also cannot now reinstall 3.0.14 as it shows the same error.
I also get this error if I try to install XCache.
Rapidly growing error logs showing the same message
$ug-non-zts-20020429/ffmpeg.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20020429//usr/local/lib/php/extensions/no-debug-non-zts-20020429/ffmpeg.so: cannot open shared object file: No such file or directory in Unknown on line 0
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
root@server [~]# ls /usr/local/lib/php/extensions/no-debug-non-zts-20020429
./ ../ eaccelerator.so*
Using cpanel 11 / centos 4
i have a server with centos,
i need to edit the hidden file .htaccess from the file management tool of cpanel,
but the hidden files not shown,
ow can i modify the setting and let the files shown in the file management tool of cpanel?
How can we stop Plesk resetting the file permissions on a dll file that is found in
C:Program Files (x86)
??
Specifically,
we have a file, jmail.dll,
here
C:Program Files (x86)Dimacw3JMail
By default Plesk permissions are set to DENY for PSACLN.
But the JMail plugin cannot work with these permissions !
We change this to be ALLOW for READ & EXECUTE and DENY for WRITE.
And everything works fine.
But every time Plesk does an update it reverts it back !
This means that a number of our customers contact forms stop working !
I have tried to manually setup awstats on a website in Windows 2008 with IIS 7. The problem here is that I have to create two conf files for each website, one named awstats.sitename.conf and the other awstats.www.sitename.conf. If I don't do so, then awstats does not work on either www.sitename.com or sitename.com. I cannot update the stats or view it from the browser. I have a few Hosting controller servers in which awstats is used and I compared the conf file with them and there is no difference. I wonder what could be the issue.
View 1 Replies View Relatedi have a dedicated server without any daily, weekly, monthly backup.
please help me (Step by Step)to setup configuration my server to take backup every day within (some account) at (3 AM).
i mean setting for every day about some account (A,B,C...Z) at the 3 AM
I have a domain, ex: hangnguyen.com at godaddy, I changed nameserver to ns1.everydns.net, ns2.everydns.net, ns3.everydns.net .
Now I order a shared hosting at bluehost, I should change nameserver to ns1.bluehost.com, ns2.bluehost.com to make it works .
But I want keep the nameserver ns1.everydns.net ....
So how I config my domain in everydns control panel to let my domain work on bluehost?
Switching from Windows DNS to bind DNS. Slightly different as I have to learn the commands instead of using the GUI. Can you tell me if the below config is correct to run mydomain.net so people can access it from the web? It will also be acting as its own name servers. This is purely for external DNS. The private IPs will be changed to routable ones once its in the DC.
Have I missed anything or is that good enough for deployment to the live environment?
I have this in /etc/bind/zones/mydomain.net.db
; mydomain.net
$TTL 604800
@ IN SOA ns0.mydomain.net. admin.mydomain.net. (
2008012001 ; Serial
604800 ; Refresh
86400 ; Retry
2419200 ; Expire
604800); Negative Cache TTL
; nameservers
mydomain.net IN NS ns0.mydomain.net
mydomain.net IN NS ns1.mydomain.net
ns0 IN A 192.168.1.15
ns1 IN A 192.168.1.16
;mail
mail IN MX 10 mail
mail IN A 192.168.1.17
; web
IN A 192.168.1.17
www IN A 192.168.1.17
And in /etc/bind I have this in my named.conf.local file
# This is the zone definition for // mydomain.net //
zone "mydomain.net" {
type master;
file "/etc/bind/zones/mydomain.net.db";
};
I have had many dedicated servers in the past but other people managed to configure them up.
I basicly want to host somedomain.com and somedomain2.com on a windows server that is located on XX.XXX.XXX.XX
The server has apache and php installed, which is just what I need. I am having an hard time configuring the domains I want to use on the server in order to make em "work" on the server.
I've installed MRTG, but am having problems making the config file, all I want to do is monitor the in/out bandwidth (2 graphs) on my own server, has anyone got an example file they could paste here?
View 3 Replies View RelatedI am a newbie and now i am running a VPS account. I have some questions want to ask you
Where is the locate of phpMyAdmin?
I am running VPS server but get error when access to phpmyadmin.
Quote:
Wrong username/password. Access denied.
I created a user=root and passworld=xxx in my WHM.
How to find config.inc.php ?
- locate but error
Quote:
warning: locate: could not open database: /var/lib/slocate/slocate.db: No such file or directory
warning: You need to run the 'updatedb' command (as root) to create the database.
Please have a look at /etc/updatedb.conf to enable the daily cron job.
Does someone know a basic or well config for mysql 3.23. I dont need something fancy just something that isn't what i have now (defaults).
Here is my current config. It sucks right? I have mainly forum websites and its alreaydu eating all RAM.
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable=max_connections=300
set-variable=max_user_connections=10
set-variable=max_allowed_packet=1M
set-variable=thread_stack=128K
set-variable=key_buffer=128M
set-variable=table_cache=300
set-variable=record_buffer=8M
set-variable=back_log=100
set-variable=thread_cache_size=4
set-variable=sort_buffer=16M
set-variable=delayed_insert_timeout=150
set-variable=interactive_timeout=40
set-variable=wait_timeout=40
set-variable=connect_timeout=10
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I've decided to move from managed hosting to colocated hosting and I'm in a bit over my head as far designing the server configuration goes. I'm looking for assistance with setting up a fully redundant configuration with no SPOF (single point of failure).
The colo provider ensures full redundancy to the cabinet, terminating with two network drops from diverse bandwidth providers and HSRP. I need to eliminate all SPOFs inside the cabinet.
Some questions...
1) I'm thinking of using the Cisco 2960 Series switch as the in-cabinet distribution switch. I believe it supports HSRP. From my understanding, the switch will automatically failover from one uplink to the other in case of a network problem on one of the uplinks, and this will all be transparent to any servers connected to the switch. Is this correct?
2) However, this introduces the switch as SPOF. So, I believe what I need to do is ask the colo for a second pair of network drops and deploy a pair of 2960's. Then I would connect each server to both switches via separate NICs. Is this correct?
3) Finally, assuming I am on the right track here, I would like this to all be transparent and automatic with no human intervention required to recover from a switch failure. The servers will be running RHEL 4. How would I configure the network interfaces on the servers so that they can transparently use either (or both) of the switches? Is there some way to assign the same IP address to more than one interface? How does the OS keep from getting confused about where to send the traffic?
Thanks in advance for any insight. I would also be happy to hear recommendations for excellent network consultants that I could hire to design and implement this configuration for me.
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'] =?
$cfg['Servers'][$i]['controlpass'] =?
--------------------------------------------------
$cfg['Servers'][$i]['user'] =?
$cfg['Servers'][$i]['password'] =?
I'm having some SMTP server security issues. I am running Postfix on my Debian VPS and I am trying to disable Postfix from being publically used by anybody except those with webmail.
I read Postfix's configuration at Postfix.org, but I couldn't find anything that I thought to be relevent to this situation. Do any of you have suggestions or ways to fix this? Besides disabling e-mail all together?
As another detail, I'm running Postfix on its original config, not through a MySQL database config.
ive just upgraded to Apache 2.2.6 today and ive found a problem. Im trying a new way of doing mass virtual hosting using mod macro.
<Macro vhost $domain $path>
<VirtualHost *>
VirtualDocumentRoot "$path/Web/"
ServerName $domain.spkweb.com
ErrorDocument 404 "drive:/folder/404.php"
php_admin_value open_basedir "$path/Web/;$path/Temp/"
php_admin_value upload_tmp_dir "$path/Temp/"
<Directory "$path/Web/">
Options FollowSymLinks
AllowOverride all
Allow from all
</Directory>
</VirtualHost>
</Macro>
Use vhost DJSmithy "drive:/Hosting/DJSmithy"
Mostly it works fine but if there is a 404 then i get a 403 permission denied error instead of the error page. the folder that contains the error page does have a <directory> bit for it and i even tried adding it into the virtual host but i get the same result.
if the file does exist then it loads like normal
can anyone see any problems with my config or do i have to do something diff for 2.2.6?
Got a new box, Xeon 3060, 2GB memory, 2x250 SATA II drives. I have 1 mysql/php forum with about 60-70 users online and 1 multimedia download site.
the minimum configuration for Apache httpd.conf ? I just need a starting point to optimize.
I had to switch to Apache 2 from Lighttpd and I'm running into a little bit of trouble trying to make it handle all my traffic. I'm using the worker MPM module, which has the following default config:
Code:
<IfModule mpm_worker_module>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
I need Apache to be able to handle about 200-500 requests per second. I tried increasing ServerLimit and MaxClients but that didn't work very well.
I was wondering if anyone has a tried and tested suhosin config for an average webhosting box?
I tried the config on the webhostgear article and it caused a few problems with some sites. On my directadmin server I managed to do the patch and the extension. I was wanting to do the same on cpanel server. Has anyone done the patch as well with easyapache?
I figure you would have to go to where it saves the downloaded source and patch it then zip it back up.
I just went to a box for myself, and just realized that my ram is closing in on it's limit.
We have 1gb of ram, yet we have around 50MB left.
We run 2 forums, with around 200 concurrent to 2000 on peaks. ( Currently it's 200 concurrent. )
Just hoping somebody could take a look at my httpd.conf and my my.cnf to see if I should tweak anything.
Ran top shift+m, and find that alot of apache connections is using 5mb per process:
Code:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3173 apache 15 0 73672 51m 3924 S 0.0 5.1 0:56.63 httpd
4790 apache 15 0 73676 51m 3912 S 0.0 5.1 0:13.36 httpd
4980 apache 15 0 73672 51m 3908 S 0.0 5.1 0:08.21 httpd
3172 apache 15 0 69844 48m 3940 S 0.0 4.8 0:45.93 httpd
5096 apache 15 0 69872 48m 3896 S 0.0 4.8 0:06.21 httpd
4394 apache 15 0 68544 46m 3912 S 8.2 4.6 0:20.24 httpd
4256 apache 15 0 68540 46m 3912 S 0.0 4.6 0:30.12 httpd
3729 mysql 15 0 130m 35m 4968 S 2.0 3.5 147:49.81 mysqld
4003 psaadm 15 0 48212 34m 23m S 0.0 3.5 0:27.61 httpsd
1489 apache 15 0 53056 31m 3928 S 0.0 3.2 1:10.80 httpd
1538 apache 15 0 52692 31m 3928 S 0.0 3.1 1:15.86 httpd
1452 apache 15 0 52636 31m 3932 S 0.0 3.1 1:24.45 httpd
2098 apache 15 0 52576 31m 3976 S 0.0 3.1 1:10.90 httpd
1450 apache 15 0 52556 31m 3940 S 0.0 3.1 1:24.80 httpd
1457 apache 15 0 52484 31m 3964 S 0.0 3.1 1:22.13 httpd
1718 apache 16 0 52444 31m 3964 R 30.7 3.1 1:27.99 httpd
httpd.cnf ( Please tell me if I have missed anything out. )
Code:
#
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 60
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 10
##
## Server-Pool Size Regulation (MPM specific)
##
# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 2000
</IfModule>
# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
my.cnf:
Code:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqld]
max_allowed_packet=16M