Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Web Hosting


Advertisements:




SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Update Server Without Updating Mysql And Apache


i would like to update my CentOS Linux 5 but i don't want to update mysql and apache i need to use mysql 4. When i entered yum update i can see Total download size: 245 M i can see mysql i386 5.0.45-7.el5 base 4.1 M

how can update my server without updating mysql and apache


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Mysql Insert/Update Makes Apache Go Crazy
I run a wordpress blog with apache2+mysql5+php5 in a Debian vps with 1024mb ram (plus swap).

When you read the website everything works quick and smooth, but when you have to add data to the database (edit posts, write posts, write comments) something weird happens.
monitoring the system with the top and I see that, for example, as soon as an article has been posted (already got the "article posted" message in the page) the free ram goes suddenly down (some seconds) from 800mb to 0. Swapping starts and the website stops responding. in the meanwhile cpu "wa" goes high (90%++).

Typing ps aux I can see that is not mysql process's fault, actually it seems more that it's apache to cause this ram hogging, in fact an apache restart brings back tons of free ram.

this is my current my.cnf:

Code:
client]
port= 3306
socket= /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket= /var/run/mysqld/mysqld.sock
nice= 0

[mysqld]
#
# * Basic Settings
#
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket= /var/run/mysqld/mysqld.sock
port= 3306
basedir= /usr
datadir= /var/lib/mysql
tmpdir= /tmp
language= /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address= 127.0.0.1
#
# * Fine Tuning
#

myisam_sort_buffer_size=64M
max_connect_errors=20
connect_timeout=15
interactive_timeout=100

join_buffer_size=1M
sort_buffer_size=1M
read_buffer_size=1M
bulk_insert_buffer_size=16M

key_buffer= 64M
max_allowed_packet= 16M
thread_stack= 128K
thread_cache_size= 8
max_connections = 600
table_cache = 256
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
#server-id= 1
#log_bin= /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
#expire_logs_days= 10
#max_binlog_size = 100M
#binlog_do_db= include_database_name
#binlog_ignore_db= include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

View Replies!   View Related
POP Server Error After Apache Update
I run a dedicated server with WHM/cPanel (10.8.0).

I was recently supposed to update the Apache installation to add a module, but instead of clicking "load previous config" I clicked on "start build" by mistake. This brought the installation back to default.

I waited till the build was finished and then added all the modules I could remember having installed earlier. This made Apache not wanting to start. I went back to the default and then recompiled apache over and over again, adding 1 o 2 modules every time. Apache booted up fine, but for some reason my mail is suddenly acting up.

I keep getting the following error on one of my domain in my client:

Code:
Unable to connect to POP server mail.example.com.
Error sending password: -ERR Maildir invalid (no 'cur' directory)
When I click OK, I get:

Code:
Unable to connect to POP server mail.example.com.
Error sending password: Operation now in progress
I have a couple of other accounts in the mail client. None of them are receiving mails, even though I can see that there are new mails present in the mailbox via webmail.

My exim is configured to use mbox as far as I know. So I don't understand why I'm getting an invalid maildir message.

View Replies!   View Related
Server Update, Too Many Apache Processes But Low Load
I have 2 almost similar webservers:

debian 3.2, P4 3GHZ, 1 Gb ram, kernel 2.6, apache2, php4

Initial apache2.conf:

Code:
Timeout 4
KeepAlive Off
KeepAliveTimeout 2
ServerLimit 1500

<IfModule prefork.c>
StartServers 10
MinSpareServers 10
MaxSpareServers 15
MaxClients 1500
MaxRequestsPerChild 3000
</IfModule>

I update the sources.list on server 1 to mirrors of the new debian 4 etc . I run apt-get update and apt-get dist-upgrade . A whole bunch of things get updated (it was long time ago that I did this anyway). After some troubles with /boot/grub/menu.lst the server boots ok, and everything is well. This server used to have loads of 15-25 at peak times, but after the update its running very smooth with loads of 2-3 at the same peak times. I dont know why exactly, as I noticed updates in OS , kernel version (from 2.6.8x to 2.6.18) , apache2 , php (4.4.4-8+etch1) , and I also needed to update eaccelerator from 0.94 to 0.95 .

A few days later I update server 2. Everything seems to go the same, although the kernel version stays at 2.6.8-3-686. I dont think kernel version at start was exactly same at server 1. But the new php version is the same as server 1, and everything else looks the same too.

But when peak times are coming up, this server starts to have troubles. It is quickly rising to total of 200-300 processes , while server 1 always stays stable at 60-70.

Server 2 also reacts slow if I click somewhere on the site. It takes 5-10 seconds to show a new page. However the load stays pretty low at 1-2 . I see no big cpu usage and also no big memory usage. I have the impression that this server 2 is somehow wasting a lot of apache processes and is making things hard for itself without a real reason.

When I check the seperate mysql database server, I also notice a lot of processes.

Around 200-250 whereas it used to be 40-60. Sometimes this adds up so hard, that all webservers are blocked because mysql has too much processes. When I check the mysql connections, I see a few dozen things like 'unauthen ip:port Connect login' just hanging. All of them have the ip of webserver 2. Those extra apache processes are somehow hanging on to the mysql server without really doing something.

I dont know what is happening, but this server is underperforming very badly now. I managed to limit the problem by drastically lowering ServerLimit and MaxClients on webserver 2 , but this is no real solution. The server is still slow, at least now its not bringing down the others.

My question : what should I check for now ? I noticed a different structure in the conf files in debian etch, maybe something new has a bad influence on my old conf files? Is there something wrong with the combination of kernel+php version? I have no idea, please point me in the right direction so I can learn from this.

View Replies!   View Related
Php Not Updating After Php Update On Centos
im trying to update my php version to 5.2+ so i can run phpmyadmin on my server. Ive tried two different methods both produced same results. First method was to download libxml2-2.7.3 and then do ./configure, make,etc then i download php, ./configure, make install, etc. At first i had to yum install make, then a c complier cause make and ./configure didnt work before that. After everything seemed to work fine until the end when it said you may have found a bug on php would you like to submit it? So obviously the php version didnt update at all.

Next i tried adding a repo that already contained php-5.2.5 and then yum install php since centos only seems to support regular yum install up to php version 5.1.6. i did rpm and installed php and thought sweet ive updated php. Ran php -v and i am still running php version 5.1.6.

View Replies!   View Related
[Cpanel::Mysql]: Not Updating Privileges
On a cPanel server, running RHEL 4 I got the following error (from cpanel logs) while associating an user with a DB from the cPanel admin:

Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa4a8768)') called at /usr/local/cpanel/bin/mysqladmin line 88
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268

In fact, from cPanel interface all privileges are added OK, but the MySQL itself is not connecting at all due to this error.

I already tried:

/scripts/mysqlup --force
/scripts/upcp --force
/usr/bin/mysql_fix_privilege_tables -u root --password=PASSWORD

View Replies!   View Related
Apache Do Not Update
i enable Mbstrings and Soap in easyapache in Cpanel.
after 24 hours i restart my server and some things get eror.

tmp folder become read only.

easy apache give below eror :

Code:
Died at /var/cpanel/perl/easy/Cpanel/Easy/Utils/BackGround.pm line 40.
and all site have eror for tmp and mysql.
i change tmp folder but some eror don't solved.

Code:
Can't create/write to file '/tmp/#sql_1f42_0.MYI' (Errcode: 30) SQL=SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt FROM jos_menu AS m LEFT JOIN jos_menu AS p ON p.parent = m.id WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0' GROUP BY m.id ORDER BY m.parent, m.ordering
Warning: Invalid argument supplied for foreach() in /home/music/public_html/modules/mod_tpmenu/tpmenu/dropdown/menu.php on line 127

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /home/music/public_html/modules/mod_tpmenu/tpmenu/dropdown/menu.php on line 150

this is mount command :

Code:
/dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw,usrquota)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
/dev/sda1 on /boot type ext3 (rw)
tmpfs on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
/usr/tmpDSK on /tmp type ext3 (rw,noexec,nosuid,loop=/dev/loop0)
and this is fstabs :

Code:
/dev/VolGroup00/LogVol00 / ext3 defaults,usrquota 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
/usr/tmpDSK /tmp ext3 defaults,noauto 0 0

View Replies!   View Related
Apache And MySQL For New Server
I just got a new box, can someone tell me the recommend values for Apache and MySQL config? It's a Xeon 3060, 2GB of memory, 2x250GB SATAII. I have a few static sites and a high traffic mysql/php forum with ~600,000 posts and about 60 members active in 15 minute intervals.

View Replies!   View Related
Cant Access Apache Update In WHM
Can't access apache update in WHM I get an http 500 error page.

View Replies!   View Related
Update Apache And Php In Plesk
How can I update my apache and php to latest version in PLESK?

I need to install GD and Zend Optimizer too.

View Replies!   View Related
Apache Update Problems (yum)
Just started running a new VPS and have tried to update apache through WHM and I get this error :

Checking Update System........Your operating system's rpm update method (yum) was not able to locate the glibc package. This is an indication of an improper setup. You must correct this error before you can proceed.

Someone told me to check out yum so I ran a command that he told me too and got this output :

Traceback (most recent call last):
File "/usr/bin/yum", line 29, in ?
yummain.main(sys.argv[1:])
File "/usr/share/yum-cli/yummain.py", line 94, in main
result, resultmsgs = base.doCommands()
File "/usr/share/yum-cli/cli.py", line 381, in doCommands
return self.yum_cli_commands[self.basecmd].doCommand(self, self.basecmd, self.extcmds)
File "/usr/share/yum-cli/yumcommands.py", line 150, in doCommand
return base.updatePkgs(extcmds)
File "/usr/share/yum-cli/cli.py", line 672, in updatePkgs
self.doRepoSetup()
File "/usr/share/yum-cli/cli.py", line 109, in doRepoSetup
self.doSackSetup(thisrepo=thisrepo)
File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 338, in doSackSetup
self.repos.populateSack(which=repos)
File "/usr/lib/python2.4/site-packages/yum/repos.py", line 200, in populateSack
sack.populate(repo, with, callback, cacheonly)
File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 91, in populate
dobj = repo.cacheHandler.getPrimary(xml, csum)
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 100, in getPrimary
return self._getbase(location, checksum, 'primary')
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 93, in _getbase
self.updateSqliteCache(db, parser, checksum, metadatatype)
File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 382, in updateSqliteCache
cur.execute("DELETE FROM "+table+ " where pkgKey in %s" % delpkgs)
File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 244, in execute
self.rs = self.con.db.execute(SQL)
_sqlite.DatabaseError: unable to open database file

Its the database error that worries me, can anyone help me out with how to fix this?

Running WHM 11.2.0 cPanel 11.11.0-S16999

CENTOS Enterprise 5 i686 - WHM X v3.1.0

View Replies!   View Related
Update MySql Via FTP
Recently one customer asked if he could upload his MySql database to subfolder in his root and have MySql pick it up from there instead from default location.

This sounds crazy, but request is legitimate, and I was wondering what could be done to enable this user update MySql db this way, or what would be the closest alternative?

View Replies!   View Related
Error When Trying To Run Apache Update (cPanel)
I got a new server online today with a fresh installation of centos and cPanel:

WHM 11.15.0 cPanel 11.18.1-R20683
CENTOS Enterprise 5 i686 on standard - WHM X v3.1.0

I have done the initial setup (ip's nameservers etc..) but when I try and run apache update I get the following:

Premature end of script headers: /usr/local/cpanel/whostmgr/docroot/cgi/easyapache.pl: Please check /usr/local/cpanel/logs/error_log for the exact error.

I look in the log file but it just repeatse the above error and doesnt supply any additional info.

View Replies!   View Related
CPanel Just Setup, Doesn't Want To Update Mysql
I finally broke down and just got a cPanel license to fix my multiple account problems, and had it installed... But now I have a problem that I can't seem to fix - MySql won't update to 4.1.21, its stuck at 4.1.18 which means I can't use PHP 5+... I can't update to MySQL 5.0+ because my databases (Which I have yet to move over) are 4.1 and should probably stay 4.1 until I know for sure it won't break anything.

Does anyone know whats going on and how I can fix this? I've tried "/scripts/mysqlup" and "/scripts/upcp --force", as well as Apache update in WHM, and manual cPanel update in WHM.

Heres what it says when I use mysqlup:

Quote:

MySQL Setup Script Version 7.0
This is the MySQL installer for OS FreeBSD
mysql-client-4.1 (4.1.18_1) is already installed.
mysql-server-4.1 (4.1.18_2) is already installed.
Install Complete

View Replies!   View Related
Used Apache Update/some PHP Scripts No Longer Working
Having some issues here, I used Apache Update to install WHMCS as I didn't have Curl installed. Well had some issues using the username and password as it couldn't connect to the database, my modernbill and phpnuke scripts still work but some other scripts like joomla, some shopping cart software, and other MYSQL scripts are not working.

I've run test scripts to see if I can connect to the database, got the following error with the PHP test script

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'data_invoice'@'localhost' (using password: YES) in /home/data/public_html/test2.php on line 4
I cannot connect to the database because:Access denied for user 'data_invoice'@'localhost' (using password: YES)

Also attempted it in SSH and getting a similar error that access is denied. Username and password are correct. I believe I upgraded PHP which my guess is what caused this. I've searched the forum for a few solutions and I had the problem in the past which I fixed it, but it's been a while.

View Replies!   View Related
Apache 2.2 / Php 5 Update: Calling Files Behind Root
With my old Apache 1 and PHP4 I was able to pull files from behind the public_html using a php file without any problems. Is there a reason why this does not work with Apache 2.2 and PHP5?

the piece of coding below is what grabs the image. Right now i'm just seeing a red X for each image.

PHP Code:

        if ($private == 1) {
        header("Content-type: image/jpeg"); 
        $im = imagecreatefromjpeg('/home/site1/private/' . $type . '/' . $mid . '-' . $iid . '.jpg'); 
        imagecolorallocate($im, 255, 255, 255);
        imagejpeg($im); 
        imagedestroy($im);
        } 

View Replies!   View Related
Apache Won't Start And MYSQL Optimization Server Experts
Can anyone recommend a Apached and MYSQL optimization expert? I just some optimization done on mysql and apache upgraded... but pache wouldn't restart with the following entries:

MinSpareThreads 25
MaxSpareThreads 35
ThreadsPerChild 25

if i remove above then it starts... but my CPU spikes and I am getting a ton of errors emailed to me:

Invalid SQL:
SELECT COUNT(DISTINCT(userid)) AS count FROM vb_session WHERE vb_session.userid>0 AND vb_session.lastactivity>1245294346;

MySQL Error : Out of memory (Needed 8388580 bytes)
Error Number : 5
Request Date : Wednesday, June 17th 2009 @ 09:39:06 PM
Error Date : Wednesday, June 17th 2009 @ 09:39:06 PM

Its constantly complaining about this same query and i thought i removed all of the vbulletin options...

i am pulling my hair out... cuz my server isn't swapping, ther are 0ver 8GBs in cache.... but my CPU goes up


Here is original problem thread...

[url]

2nd post has recommended config... and my subsequent probs

View Replies!   View Related
Apache + MYSQL Optimization For High End Server
I have a fairly high end server in which I have installed SIM. SIM is restarting Apache up to 10 times a day, presumably due to high load causing un-availability.

On restart, Apache / MYSQL is stable until the load / mem usage begins to climb then it is restarted again. Here are my 'load' stats for today:

Load for today
High (2:18am): 4.63
Low (3:30am): 1.20
Mean: 1.84
Latest: 1.61

Mem usage for today
High (1:36am): 9,192.9 MB
Low (1:48am): 7,995.7 MB
Mean: 8,683.1 MB
Latest: 8,781.7 MB

I have seen it using 20GB RAM before.

I have tried to follow various optimisation guides but these seem tailored to less powerful servers.

The web application I run on this server is almost entirely MYSQL based, with thousands of DB calls a day. Across the entire system I probably get 200,000 bot hits per day or even more. At peak times search engine bots are literally hammering the server.

My server specs are:

# Processor: Quad-Core Xeon Processor * 8
# CPU Speed: 3Ghz
# RAM: 32 GB DDR2
# HDD: 36 GB 15k Raptor X2 + 1TB Sata
# OS: 32Bit CentOS

Changes / optimisation of the actual application is not possible.

My configuration files are:

My.cnf ....

View Replies!   View Related
Can I Setup My Control Panel To Update The Apache Config File
How can I setup my control panel to update the Apache config file

View Replies!   View Related
Updating Server - Coreutil And FindUtils Stuck
I am trying to the update my PHP/Apache via Cpanel and Cpanel is stopping because Yum is failing to update two dependencies.

--> Running transaction check
---> Package findutils.i386 1:4.2.27-5.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved ....

View Replies!   View Related
Updating Access Databases On Local Web Server
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases.

The two errors I get are:

Operation must use an updateable query.

or

Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. (they are not read only!)

Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?

View Replies!   View Related
How Kernel Updating And Ssh And Anther Software In The My New Server
i have buy a server todag and i need to now who icant

how kernel updating and ssh and anther software in the my new server

View Replies!   View Related
Recompile Apache :: Your Operating System's Rpm Update Method (yum) Was Not ..
i tried recompile Apache to install

--curl
--curl ssl
--mcrypt

by running /scripts/easyapache

then i get the error below. Can anyone help me out? i really dont know what todo here.

Checking Update System........Your operating system's rpm update method (yum) was not able to locate the glibc package. This is an indication of an improper set up. You must correct this error before you can proceed.

View Replies!   View Related
How To Update More Than One Server
I am with 13 servers in the planet. It would like to know it has as it updates them in a way simpler that I am doing. I update 1 for 1.

View Replies!   View Related
WHM Server Time Does Not Update
In WHM I'm trying to sync the server time with the time server. It displays the new time but it doesn't actually apply the new time to the server.

Also via ssh when I run

rdate -s rdate.cpanel.net

it says

rdate: rdate: could not set system time: Operation not permitted

I'm on a virtuozzo VPS.

View Replies!   View Related
Apache Mysql Autentification
I am attempting to configure mod_auth_mysql on Mandriva linux. It seems that database is set well since if I attempt to log as a valid user with invalid password, the logs says "user xxx password mismatch. Thus it reads the database OK. If I provide correct password I got configuration error screen and log message "no Authn provider configured, configuration error: could not check access".

But I set AuthMySQLAuthoritative ON !!

I spend the full afternoon with this and I will be more then gratefull for some help.

Vaclav

<Directory /var/www/html/test>
AuthName "Awstats"
AuthType Basic
AuthMySQLUser apache
AuthMySQLHost localhost
AuthMySQLEnable On
AuthMySQLPassword xxxxx
AuthMySQLDB apache
AuthMySQLUserTable mysql_auth
AuthMySQLNameField username
AuthMySQLPasswordField passwd
AuthMySQLPwEncryption none
AuthMySQLAuthoritative On
require valid-user
</Directory>

LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule mime_module modules/mod_mime.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule info_module modules/mod_info.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule imagemap_module modules/mod_imagemap.so
LoadModule actions_module modules/mod_actions.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule cgi_module modules/mod_cgi.so
LoadModule env_module modules/mod_env.so
mod_auth_mysql is in extramodules

View Replies!   View Related
NFS With MySQL / Apache
i am setting up a new load balanced cluster for the first time. It is turning out pretty well so far, I was wondering if you guys see any future problems with this setup. So far it is working well.

I have one server that is the dedicated network file server. Then two others that mount the file system from the NFS.

I have mysql and apache installed on both servers. They both share the NFS mount using read and write privs. I haven't put a load on the setup yet, but I was under the assumption that this couldn't be done with MySQL, but it seems to be working great. If this does work out, it seems MySQL would be scaled just as easy as apache. Everysite in the system could be setup to use localhost which would be the same server it is served up with apache.

View Replies!   View Related
(mysql/php/apache)
I recently have got a VPS and it needs optimizing. Please would someone look at my specs and help me set some good values for a website that runs a fairly small forum.

Plesk 8.1.1
Guaranteed RAM 384MB
Maximum RAM 768MB
RedHat Enterprise 4 AS
MySQL 4
PHP 4
Apache2

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

skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
httpd.conf

Code:
ServerTokens OS
ServerRoot "/etc/httpd"
PidFile run/httpd.pid
Timeout 120
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15

<IfModule prefork.c>
StartServers 2
MinSpareServers 1
MaxSpareServers 5
ServerLimit 10
MaxClients 10
MaxRequestsPerChild 4000
</IfModule>

<IfModule worker.c>
StartServers 2
MaxClients 10
MinSpareThreads 1
MaxSpareThreads 4
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>

Listen 80

LoadModule access_module modules/mod_access.so
LoadModule auth_module modules/mod_auth.so
LoadModule auth_anon_module modules/mod_auth_anon.so
LoadModule auth_dbm_module modules/mod_auth_dbm.so
LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule ldap_module modules/mod_ldap.so
LoadModule auth_ldap_module modules/mod_auth_ldap.so
LoadModule include_module modules/mod_include.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule env_module modules/mod_env.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule expires_module modules/mod_expires.so
LoadModule deflate_module modules/mod_deflate.so
LoadModule headers_module modules/mod_headers.so
LoadModule usertrack_module modules/mod_usertrack.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule mime_module modules/mod_mime.so
LoadModule dav_module modules/mod_dav.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule asis_module modules/mod_asis.so
LoadModule info_module modules/mod_info.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule vhost_alias_module modules/mod_vhost_alias.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule imap_module modules/mod_imap.so
LoadModule actions_module modules/mod_actions.so
LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule cache_module modules/mod_cache.so
LoadModule suexec_module modules/mod_suexec.so
LoadModule disk_cache_module modules/mod_disk_cache.so
LoadModule file_cache_module modules/mod_file_cache.so
LoadModule mem_cache_module modules/mod_mem_cache.so
LoadModule cgi_module modules/mod_cgi.so

Include conf.d/*.conf

User apache
Group apache

ServerAdmin root@localhost

UseCanonicalName Off

DocumentRoot "/var/www/html"

<Directory />
Options FollowSymLinks
AllowOverride None
</Directory>

<Directory "/var/www/html">
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>

View Replies!   View Related
Two Servers One For Apache And One For Mysql
we plan to buy one server for apashe and one for mysql.

So first server will handle apache + cpanel + exim
Dual Processor Dual Core Xeon 5140 - 2.33GHz (Woodcrest) - 2 x 4MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES

second will handle only mysql
Dual Processor Quad Core Xeon 5345 - 2.33GHz (Clovertown) - 2 x 8MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES

Server will be used for forums about 4000, 5000 Simultaneous users.

View Replies!   View Related
How Do I Update Awstats Software On A CPanel Server
I would like to know if Awstats (the software itself, not the data) is updated automatically on cPanel based servers?

If not, is there a way to update it manually?

View Replies!   View Related
Parallels Timeline Update: Windows2008 Server
We wanted to pass along some information that we received from Parallels today. They are planning on releasing a supported Windows2008 Server package for Virtuozzo "in Q3 of this year".

View Replies!   View Related
Server Software Package Update Strategy
when I do "yum update" at my centos 5 box, I saw over 40 packages needed to be updated.

For example, there's minor version update for MySQL 5.

so I am wondering how to determine which packages are absolutely needed.

My box is used to serve web applications. I just want to make sure that it's secure.

View Replies!   View Related
Apache And Mysql Going Down Every Half Hour
I am facing an very typical problem, when I start apache and mysql both my site works good for half and hour or so then start getting slower and slower to load and after sometime becomes completely inactive. Then i have to restart both mysql and apache to get my site back.

When sites became inactive I have to restart only apache to see it back.Restarting only mysql dont help at that time.

Apache runs without any problem when running alone .(mysql stoped.)

View Replies!   View Related
What Sites Are Best For MySQL/Apache Optimization
I just switched to a new server - I went from a Dual Opteron 248 with 3GB of RAM to a Dual Clovertown with 4GB of RAM. Yet, despite having mild traffic right now, my load is rather high and my memory usage is like 80% (which is ridiculous, since that would mean I would be maxing out on the old box).

For some reason, my servers usually lose access when I get around 400 people on TEXT-BASED, non-MySQL pages? How is that possible? I have really solid servers, yet people running basic Pentiums with 1 or 2GB never run into this issue.

Is there any good, cheap site that would be able to properly optimize mySQL and Apache to lower the load and figure out why the memory usage is so high? Platinum Server Management never really got this done, so even though they're great for other support issues, please don't recommend them.

View Replies!   View Related
Uprgade Apache, Mysql, Php
I am running a few sites (business with modernbill, vbulletin forums) and wish to upgrade to...

apache 2
mysql 5
php 5 w/ phpsuexec

Any warnings on upgrading on a production server to apache 2 and mysql 5?

View Replies!   View Related
Fantastico Updating?
I recently had Fantastico update issues, my fantistico was giving me errors such as "This feature is currently not availabel, please contact your host." lol

I tried lodging a CRON job to do the update ...but waited 72 hours and nothing ! lol

Later i found our that the Fantastico licensing server was down for a while lol

Any one had this issue lately ... ?

View Replies!   View Related
Updating My Security
I'm trying to figure out which security measures to apply to my new server. I last tweaked security on a web server four years ago, and it seems like these days cPanel does automatically much that I did manually before. CSF seems to help with a lot of the rest.

I know chrooted BIND was all the rage, for example, four years ago, but now I can hardly find mention of it. Is it still worth it?

also, thoughts on changing the SSH port? Is that really worth it? I presume that means users would manually have to specify the SSH port every time they wished to connect...

View Replies!   View Related
Bandmin Is Not Updating
I have just got the new server adn I tried to check bandwidth usage via 'Bandmin' but it seems like not updating because its all 0,

Last updated Fri Feb 2 21:00:04 2007

Ip Possible Domain(s) Transfer in gig Transfer in meg Transfer in kbit/s Transfer in kb/s Transfer in mbit/s
Total in 0.000000 0 0.000000 0.000000 0.000000

View Replies!   View Related
What Is A Kernel And When Does It Need Updating
What exactly is a kernel and when will we need to ask the server management to update it? Read quite a few posts here indicating that kernel's were vulnerable to security issues. Still trying to learn all the to do's for hosting websites on a dedicated server.

View Replies!   View Related
Stats Not Updating
root@server [/scripts]# ./runweblogs username
Log checker loaded ok..
==> WARNING: The configured processor count does not match the
==> actual processor count (4)! Running log analysis programs
==> on this system may cause excessive load! You should set "extracpus"
==> to "0" in /var/cpanel/cpanel.config if this is not ok.
==> cPanel Log Daemon version 22.2
==> Shared RRDTOOL support enabled
==> Starting cpbandwd (bandwidth monitoring for IMAP/POP)
cpbandwd is already running.
Processing eldred...
Run Logs domain: domain.com BW Limit: 262144000000 Domains: [save.domain.com save.info store.domain.com]

Stats are not updating for this account. I ran this twice, keeps getting stuck at this line forever..

Run Logs domain: domain.com BW Limit: 262144000000 Domains: [save.domain.com save.info store.domain.com]

View Replies!   View Related
Apache/MySQL Hosting In 2 Locations -tutorial?
I'd like to have the ability to offer hosting in two geographical and network diverse locations for both Apache and MySQL. Two entirely different instances, with different everything. ie: high avail to the max. Obviously the MySQL part is harder due to the dynamic nature.

I can appreciate the technical aspects of the question - such as data needing to replicate to 2 locations, dealing with static versus dynamic data, etc. In short, there's a few ways this could be done.

I've not been able to find a guide in my Google searches, but I'm sure this is something that has been setup before.

If you're someone with experience in having had set this up, perhaps it would be easiest if we just speak directly and work something out, either via payment or giving you a dedicated server on my network. My AIM name is IGSOBEHELPER.

Please note that I am hoping to start a technical discussion about this, hence I am not posting the message in the employment section. I hope this is not off topic because of this.

View Replies!   View Related
Apache: Load Vhosts From MySQL Database
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down

View Replies!   View Related
Best Apache/php/mysql Version Combo
What will be best combo of those 3 which is main core for running almost any web server.Presently i have latest mysql,apache and php installed,but some people says how that is not good beacuse newest version arenot tested yet well enough.

View Replies!   View Related
Do I Need Separate Apache & Mysql Servers Etc
here's my current setup has my stuff running on 2 separate "self contained" servers (eg; each runs their own apache/php/mysql):

Main site/server:
content: mostly static content (no mysql, very little php). currently has about 4tb/m traffic. in the summer it could push up to 6tb/m
hardware: P4 2.8ghz. 1gb ram. this server has no problem handling the load. only problem is bandwidth (i have to get it off the current host)

Forums site/server:
content: running vBulletin. currently 400-500 peak (probably jump to 800 peak this summer) users active per 15 mins.
hardware: 64bit dual Opteron 242. 4gb ram. it's absolutely griding that to a halt at peak times. it acts like 4gb memery isn't enough (it will run fine then eat through most of the 4gb. grind to a halt, then recover) personally i think it was setup/configured wrong but i've had multiple people look at it and nobody can find anything wrong in the apache/mysql settings.

What I want to know:
what type of server setup should I start migrating to? should I keep both parts of the site separate? eg; main site on one server, forums on another server(s)?

what i've sorta been looking into is 3-server setup.
(server1) main apache/php server. probably on unmetered (honestly don't think i'll find anything else that offers high enough traffic). run the main site and the vB php from here
(server2) dedicated mysql 'read only' server (server3) dedicated mysql 'write only' server.

and have mysql read/write synced and have all 3 servers networked directly together. i have a friend running a single mysql driven site using this setup and it works really well for him.

is this overkill for me? should the current dual Opteron be able to handle the forums and i just need to hire someone smarter, or is there some other setup that would work better for me? i'm tight so i want to go cheap as possible, but I also realize i need room for summer traffic expansion that always hits us.

View Replies!   View Related
Compiling Apache/PHP/Mysql Under X86_64
I'm wondering if there are special notes on compiling sever softwares under x86_64 (CentOS 4.4 64bit, Pentium D)? Are there any specific flags for extra optimizations? Or the regular "./configure" will compile things in x86_64 by default?

View Replies!   View Related
[mailconfigupdate] Unable To Automatically Update The Mailer Config On SERVER
I've added this:

# Added for me
hostlist privaterelay_hosts = lsearch;/etc/privaterelay

And changed this:

accept hosts = +relay_hosts

Into this:

accept hosts = +relay_hosts +privaterelay_hosts

within the Exim Advanced configuration editor. Cause I wish to allow a relay without authentification.

This morning, I've got this:

cPanel was unable to automatically merge your Exim configuration with the new settings that shipped with the build you have installed (11.23.6-RELEASE_27698) because you have a custom ACL configuration which cannot be automatically configured.

To avoid any mail downtime, we thought it was best to leave your previous configuration intact until the new configuration can be properly installed. In order to complete this configuration update, you will need to manually merge your configuration with the new
configuration settings. Please follow the steps below to complete this update:

1. Enter the Advanced Configuration Editor

2. Notate any custom changes you have made in the ACL section. You may also which to make a copy of /etc/exim.conf.local and /etc/exim.conf.localopts as custom settings are contained in these files.

3. Click the 'Reset ACL Config to Defaults' button.

4. Reinstall your advanced custom settings.

Until you manually complete this update, automatic spam filtering may have been rendered inoperable to prevent any mail loss. (This generally only applied is you were upgrading from cPanel 10.x)

Current Config Version: unknown
New Config Version: 4.900000

What can I do to prevent this ? Cause last time, all mail was receiving a 550 (SMTP Protocol Returned a Permanent Error 550 Sender verify failed) which is pretty bad...

View Replies!   View Related
Awstats Not Updating Frequently Enough
My Awstats is updating every other day and I would like it to up date daily.

I am in my third month of hosting and in about first 2 months, Awstats would update every day.

I have searched and read where it is possible to get Awstats to update manualy but it seems that my scenario isn't the same as everyone else's.

I am accessing my Awstats through CPanel and there is no way that I see to modify when Awstats updates.

View Replies!   View Related
Updating Mod_Security Rules
How can I update mod_security rules in Cpanel/WHM server from gotroot.com?

View Replies!   View Related
Updating Httpd-devel
We have dedicated server (Cpanel installed) in that I would like to install the mod_evasive for disabling the DOS attack. So that I have followed the below url

[url]

In that httpd-devel asked to update.
# up2date install httpd-devel*

When I update the httpd-devel I got message like

The following Packages were marked to be skipped by your configuration:

Name Version Rel Reason
-------------------------------------------------------------------------------
httpd-devel 2.0.52 38.ent.2Pkg name/pattern

The following wildcards did not match any packages:
httpd-devel*

So that I have removed the pkg-skip list from up2date command

# vi /etc/sysconfig/rhn/up2date

and tryied to update

# up2date install httpd-devel*

Later I am getting the following message.

Fetching Obsoletes list for channel: rhel-i386-es-4...

Fetching Obsoletes list for channel: rhel-i386-es-4-extras...

Fetching rpm headers...
########################################

Name Version Rel
----------------------------------------------------------
httpd-devel 2.0.52 38.ent.2 i386

An error has occurred:
xmlrpclib.Fault

View Replies!   View Related
Webpage Not Updating On My Network
I was developing a website on my friend's server.

Due to some DNS problems we couldn't figure out how to resolve, I decided to just go commercial and bought a Dreamhost package.

I updated the nameservers and the DNS has since propagated. At work today, starting with the fresh, new root, I installed vbulletin and started configuring my website checking my progress live.

However, I get home and I go to my URL and it's still the same as it was when my website was hosted on my friend's server. With a DNS and WHOIS check, the nameservers definately propagated correctly. The FTP contents are the way they were at work. I've cleared all my cache and private data. However I STILL see the old "revert" of what my website USED to contain.

I called up a friend to go to my website and he says it's displaying what it should and verified that it's just on my side. How can I resolve this?

I've reset my router and modem and computer and cleared every temp and cache I know about.

View Replies!   View Related
Auto Updating Postfix
I have searched the whole forum for help on this but couldnt find anything.

I have postfix running on a backup mx server for a plesk box. The backup mx does a very good job of reducing spam and virus to my plesk box thanks to mailscanner.

The problem i have now is i have to manually update postfix transport and relay_recipients file everytime a new domain is created in plesk. Do any one know how i can create a custom script that will pull domain information from my plesk box and will update postfix on the backup mx server. Maybe a website with information that can help.
i can always set a cron to run the postmap command to update the tables but i will need to update the respective files (transport, relay_recipients) first.

View Replies!   View Related
MRTG Stats Updating
I have the following setup in cron for my MRTG stats:

0,10,20,30,40,50 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/bandwidth.cfg
0,11,21,31,41,51 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/cpu.cfg
0,12,22,32,42,52 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/cpu-temp.cfg
0,13,23,33,43,53 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/ping.cfg
0,15,25,35,45,55 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/memory.cfg
0,16,26,36,46,56 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/newconns.cfg
0,17,27,37,47,57 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/estabcons.cfg
0,18,28,38,48,58 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/ping2.cfg

But I'm not sure how much power it actually takes to generate theses MRTG stats... The server is a Celeron D 2.8Ghz, 512Mb ATA soft raid system. Do you think that I should update the stats less frequently to decrease the server usage?

View Replies!   View Related
MRTG Stats Updating
I have the following setup in cron for my MRTG stats:

0,10,20,30,40,50 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/bandwidth.cfg
0,11,21,31,41,51 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/cpu.cfg
0,12,22,32,42,52 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/cpu-temp.cfg
0,13,23,33,43,53 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/ping.cfg
0,15,25,35,45,55 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/memory.cfg
0,16,26,36,46,56 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/newconns.cfg
0,17,27,37,47,57 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/estabcons.cfg
0,18,28,38,48,58 * * * * env LANG=C ../../mrtg-2/bin/mrtg ../...stats/ping2.cfg

But I'm not sure how much power it actually takes to generate theses MRTG stats... The server is a Celeron D 2.8Ghz, 512Mb ATA soft raid system. Do you think that I should update the stats less frequently to decrease the server usage?

View Replies!   View Related
CPanel Shows Wrong Versions Of Apache And MySQL
I've a small reseller account with cPanel with 5 sites. After transfering to other host (full cPanel backup of old sites, restoring on new host) cPanel of 2 sites still displays the version number of the old host, the other 3 sites are correct.

CP1: correct - CP2: wrong

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved