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
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.
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
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
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.
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.
I've been running my website for years and now yesterday I update 2 files, the same way I always do, and when I try to load them in a browser I get:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
The log says this:
[my ip] - - [17/Jan/2015:00:07:55 -0500] "GET /site/index.php HTTP/1.1" 404 - "-" [my agent string]
Permissions are 644, same as for the other files. I haven't encountered anything like this before and am totally stumped.
Last week I have updated the apache from 2.4.6 to 2.4.9 version in Win 2008, 64-bit server. There was no openSSL and update was successful. Later I did the update in QA with openSSL and again the updte was successfully completed. Apache services was running fine and everything looked nice.
When I did the same update in the prd where openSSL is also there, it failed to start the service.
steps to update the apache from 2.4.6 to 2.4.9
----------------------------------------------
1> stop the apache services
2> Take the backup by copying original Apache installation directory and rename it . (eg I:Program Files (x86)Apache Software FoundationApache2.2 to Apache2.2_old)
3> Unzip the latest binaries to the temp directory
4> Copy the following files apachebin , apachemodules to the Apache Inst Directory ( I:Program Files (x86)Apache Software FoundationApache2.2)
5> start the apache service
----------------------------------------------------
QA and PRD both has enabled openSSL but it was prd where we got the issue , and the apache services couldnt be started. We have had to revert the change. Find the error log in the apache directory
--------------------------
[Tue Jun 24 21:12:12.665632 2014] [ssl:emerg] [pid 3336:tid 320] AH02561: Failed to configure certificate
RGWEB58V.brotherdc.eu:443:0, check G:/Program Files (x86)/Apache Software Foundation/Apache2.2/conf/server.crt
[Tue Jun 24 21:12:12.665632 2014] [ssl:emerg] [pid 3336:tid 320] SSL Library Error: error:0906D06C:PEM
routines:PEM_read_bio:no start line (Expecting: CERTIFICATE) -- Bad file contents or format - or even just a
forgotten SSLCertificateKeyFile? [Tue Jun 24 21:12:12.665632 2014] [ssl:emerg] [pid 3336:tid 320] SSL Library Error: error:140AD009:SSL
routines:SSL_CTX_use_certificate_file:PEM lib
---------------------------------------
I read somewhere that there is bug in 2.4.9 as this version breaks the openSSL.
Also read on this forum that someone resolved the issu by changing the server certificate from DER to PEM.
In my apache conf file I redirect http to https requests like this:
Code:
# Redirect all requests to https
<VirtualHost *:80>
ServerName www.mypage.de
Redirect permanent / https://www.mypage.de/
</VirtualHost>
This worked just fine until yesterday, when I have updated to Apache 2.4 and disabled SSL 3 by doing this:
Code:
# Disable SSL 3 due to the POODLE vulnerability
SSLProtocol all -SSLv2 -SSLv3
Now, if I call any http URL, the server does not respond. If I explicitly call a https URL it works.
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 1 Replies View RelatedRecently 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?
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 ....
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
We have change IP from NS server in Plesk.Why can we force refresh named.conf (for all domains) ? Informations stay with old IP.We can force one domain when we change an information in the DNS and we validate. But Hown can we change all domains?
Example:
Old
> NS server1.com (x.x.x.1)
New
> NS server1.com (x.x.x.2)
[code]....
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
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 ....
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?
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
I am using Parallels panel 11.5.30 Update #44 on CentOS 6.5 (64bit version) located on VPS. What is the easiest way to update:
- PHP 5.3.3 to PHP 5.5.12 (current stable version) and
- MySQL 5.1.73 to MySQL 5.6.18 (current stable version).
Is it possible to update these from Plesk's control panel?
Is it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?
View 3 Replies View RelatedAfter installing Plesk 12.0.18 Update 43 on windows when I try to connect to Plesk Panel (https://myurl.com:8443/) I get error:
ERROR: PleskMainDBException: Host '127.0.0.1' is not allowed to connect to this MySQL server (db.php:435)
I tried to reset mysql admin password as described in article - with no luck : [URL] .....
I even tried to reset password:
%plesk_bin%plesksrvclient -set "newpassword" true
Again I get "Faild to connect to database: Host '127.0.01' is not allowed to connect to this mySQL server
All websites that uses mySql works but Plesk Panel is dead?