I need to tune the mysql and apache server for the comparatively busy webserver. My scenario is like this.
1. The Web request is around 2000 request at a time or more. 2. Each web request will generate one mysql query. 3. The query to database is all read. 4. This server load will be at peak for around 3-4 hours after that the load will subside. As the task will be published, around 300,000 will be viewing the page.
5 quad servers are deployed, load is balanced via DNS but performance is not as expected. Centos 5.5 is used as OS. Top command shows The mysql process is around 185%!
fedora 12 with php 5.3.1 + apache is installed on the server
I needed a FFMPEG + MENCODER + FFMPEG-PHP setup , so I have installed all of the necessary libraries/codecs along with ffmpeg , mencoder and ffmpeg-php
I've added ffmpeg-php (ffmpeg.so) module to php.ini and restarted httpd
But ffmpeg was not showing up in phpinfo() so I grepped : php -i | grep ffmpeg for some clues and got this warning PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/ffmpeg.so' - /usr/lib/php/modules/ffmpeg.so: undefined symbol: php_gd_gdImageSetPixel in Unknown on line 0
That error explains why ffmpeg is not loading
Obviously something to do with GD library , so I've researched on the net , and found that some users suggest loading the GD module before FFMPEG module.
I gave it a try and added this at the end of php.ini: Code: [gd] ;loading gd extension=gd.so [ffmpeg] ;loading ffmpeg extension=ffmpeg.so ...but still same error when greping phpinfo()
Squeeze's latest update has upgraded my kernel from 2.6.32-3-686 to 2.6.32-5-686.My wireless stopped working and then I realised that I had to rebuild the wifi modules. I had followed this earlier.URL...For this new kernel, which I step of the process should I repeat? Rebuild module? Or just do a modprobe?
I'm trying to enable the rewrite module in apache, to enabled the module I followed the last entry in the fist page this thread:[URL]...When I restart the apache all works fine, so I supose it's enabled
Now I create .htaccess in my apache folder (/home/user/apache), and I write this:
Code: RewriteEngine On RewriteRule ^link([^/]*).html$ test.php?link=$1 [L] And I try to execute this: ./.htaccess, I have this mistakes: Code: ./.htaccess: 1: RewriteEngine: not found ./.htaccess: 2: Syntax error: "(" unexpected What are I doing wrong?
how to trigger a script when an email is received to update my mySQL database. I do not want to physically send the message to the script, I just want the script to execute and to under execute under a specific mail account.
I thought of setting up a cron job at first, but decided going down that approach would be a huge waste of resources. What method would you recommend?
I was trying to install MySQLbd (a module for python to connect and access MySQL) I followed these steps for installation[URL].. but while I am getting some installation errors. When I try to run $ python set.py build I am getting the following errors (I removed few errors as I can post more than 10000 characters here)
It seems that I really don't know how to update/reinstall a new library for my DigiKam.Since there is no .deb package, I would like to install Libraw-0.8.5 from source code (URL...) and it happens that I just don't know what to do.Please, help me to install this library so I can finally process the files from my new camera.
I ran the automatic update today and it requested a restart afterwards. After the restart, I don't have any icons on my desktop, can't open windows other than the terminal. If I try to run software from the terminal, I get the following error.
/lib/libgcc_s.so.1: version 'GCC_4.2.0' not found (required by /usr/lib/libstdc++.so.6) /lib/libgcc_s.so.1: version 'GCC_3.3' not found (required by /usr/lib/libstdc++.so.6)
I have seen "just removed the library with an issue" or recreate the links or try to reinstall. I am running fedora 12.
The Payment Card Institute (PCI) is requiring our site to upgrade to the latest versions of Apache, Mysql, OpenSSL, and PHP to fix known bugs that can compromise securityI can build all these from source, but when I do "make install" they don't mimic at all what is installed (directory format, files, etc) when I do apt-get install (of whatever old versions are in the dist).How can I find out how the packages are build via configure/make so that I can replicate the files, directory structure, etc, just with the current versions.
I need to get the libstdc++.so.5 library ( on a computer with Fedora 8 and don't wonder why it's so ancient,-there is a good reason for it) but I don't have Internet access from that computer, so I can't get to the online repo's.
However, I do still have the installation disk, and I'm typing this from a computer (SuSE 10) that is half a meter from the Fedora box.
I tried the "ADD/REMOVE Software" option on the menu, but it keeps on looking for the online repo and then if it doesn't get it, it fails.
Is it possible to get this library from the installation disk. How? Could I download the single package from the online repo onto the SuSE machine and then move it to the Fedora machine? How do I then tell the Fedora machine to "incorporate" it.
since the release of the 220.127.116.11-127 kernel a couple of days ago I can't use my wireless adapter (rt2870 based) since there isn't a kmod-rt2870 package released for this kernel.Normaly I found that the kmod package was available the same day as the kernel. Does anyone know why there is such a delay this time? Or if there is a workaround
in the directory of /var/log , i see some directory like apache2 , apt , gdm , i wonder does all these folders was made under the syslogd ? i mean do these utilities use syslogd to log their messages or they use their own systems , for example apache use syslog or use its own library?
after I do all new installation and before i do PHP update my browser can show me apache default page but after update PHP to 5.2.0 I can't even see the default page and always give me Problem loading page and I have 3-4 times reinstall my server which i need to do this as mail serer locally. Here are the version for my php and apache on my server currently :Apache[root@localhost local]# httpd -vServer version: Apache/2.2.14 (Unix)Server built: Oct 14 2009 13:19:18
I have Apache Server working online under Fedora Core 6. But before I installed and configured everything, I've been testing in Fedora 12. The problem surges here, when I start the httpd service, every supuse 404 action on a web browser, takes me to localhost. I mean, if I enter google.com, no error, just goes to localhost, http://asdasd, no error, gives back localhost. I used to ignore the problem 'cause I thought it was a problem on my apache, but when I installed the Server on the Fedora Core 6 machine, I found that I have the same problem there. Of course, it only occurs when I am browsing through the same machine that has httpd started. Does anyone know how to change that??
Summary: Does a discrepancy between MySQL client library 5.0.x and MySQL server of 5.1.50 cause "inconsistent behavior", as reported by phpMyAdmin? The longer version: Windows Sysadmin taking the plunge into Linux. I tried to spare you all the rookie questions and did a fair bit of reading. I'm rather happy I was able to get CentOS 5.5 installed and running, configured iptables, got the kernel updated, Apache, MySQL and PHP installed. Then upgraded PHP to 5.2 after I figured out how repos and priorities work.
I got phpMyAdmin installed and running, then decided to upgrade from 2.11 to 3.3.7 but it keeps complaining that my MySQL client libraries are something like 5.0.63, while my server is 5.1.50, and this may cause "inconsistent behavior" or something of the like. So, feeling industrious, I decided to find an updated client.
But it wouldn't let me install it as it conflicted with the default mysql-server installation. I also couldn't remove just the old client, to update to a newer one. So I blew away everything mysql on my server and installed the above client
and that server file. I'm assuming I'm missing dependencies now as phpMyAdmin claims it can't load the mysql extension. Attempting to 'yum' php-mysql tried to install 'mysql' as a dependency, which immediately conflicted with the files I'd installed. At this point I'm wondering if I'm closing in on successfully installing a version that phpMyAdmin doesn't complain about, or if I should even care that it is complaining and just go back to all the repo versions of everything.
# rpm -e MySQL-shared-community-5.1.50-1.rhel5.i386.rpm error: package MySQL-shared-community-5.1.50-1.rhel5.i386.rpm is not installed
I have logged in today and update manager reminds me of an update with linx-backports-module-2.6.31-14-generic. However my current kernel has been updated a while ago and is now 2.6.31-17. That obviously is more recent that that backport version. What should i do? By the way that update is from a PPA repository other that the default. I am wondering the update manager has no way to tell which kernel version i have at all? Should i actually go ahead with the installation?
I want to connect to MySQL Database installed on RHEL 5 using perl v 5.8.8.The available DBD perl drivers installed on my machine are:DBM, ExampleP, File, Pg, Proxy, Sponge..I downloaded DBD-mysql-2.1012 and tried installing DBD again but got the following error:Can't exec "mysql_config": No such file or directory at Makefile.PL line 167.readline() on closed filehandle PIPE at Makefile.PL line 169.On searching I found that I need to install libz-devel prior to installing driver for MySQL for Perl.
I have installed CENTOS 5.3 on my machine and am running the new version of Subversion which comes bundled with Apache. I noticed in the httpd.conf file there is no module for PHP which is a problem. How do I install the PHP module for APACHE in Centos 5.3?
I am having no luck configuring ProFTPd on a Debian Lenny production server we use to host our MySQL databases and a few websites. I had originally set it up so I could login and manage our internal sites, but I have the need to allow a few clients in to access their sites that we host. I am trying to root the users in their site directory, which would be "/sites/www.whatever.com/".
It just hit me while typing this. Is it possible to create a user without a shell to prevent login via SSH and set the home folder to /sites/whatever instead of /home/username? That would allow me to continue operating with my current configuration and root them in their site while preventing SSH logins.