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.
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.
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
I was disappointed to discover how difficult it is to set up PHP, MySQL and virtual hosts on my MacBook Pro. I finally hired a computer science student to do it for me - but even he screwed it up.
Then I discovered a preconfigured packaged called MAMP. I downloaded the free version and now have Apache, PHP, MySQL and phpMyAdmin up and running. That still leaves the biggest obstacle of all - creating virtual hosts.
I checked out the MAMP Pro version ($50) at [url]and read "You can set up many virtual hosts."
That doesn't make sense to me; shouldn't you be able to set up many virtual hosts even with the free version of MAMP? Or does MAMP somehow make it EASIER to create virtual hosts, and the Pro version simply allows you to make many of these simplified virtual hosts? If MAMP Pro does indeed make it easy to create virtual hosts, then I'll purchase it immediately.
I'd be interested in other comments about MAMP. Unfortunately, its support forums are awfully lame; that's why I decided to post my questions here.
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.
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.
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.)
I've got a server that was running Apache 2.0/PHP 5.2.5 & MysQL 5.0 just fine, however I needed to upgrade to a newer version of MySQL.
So I uninstalled MySQL 5.0 and installed MySQL 5.1, copied the MySQLlibs over, and recompiled Apache/PHP with easyupdate. Apache & MysQL both start/run fine without errors, however PHP files don't load. Just get black pages (HTML works fine obviously).
I went ahead and updated to Apache 2.2 & PHP 5.2.6 while I was at it, but that doesn't change things. I'm not sure why uninstalling MysQL & reinstalling would break any dependencies, but looks like thats the case. Perhaps I need to reinstall some libraries?
Or would it be easier just to reinstall Apache/PHP entirely? I have no data.
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.
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.
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.
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?
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.
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
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
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.
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:
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
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.
I'm running a comic site on a dedicated linux box that has weekly releases. When a new release comes out I'll typically get 4000-5000 unique hits an hour. The problems started when I set up a MySQL download logging system, that would query and display the file names when the user loads the site, and update +1 when they download a comic. Yesterday after a release, the site became very slow to access, and after about 20 seconds you'd connect and be able to browse freely at nice speeds but if you went idle you'd have to wait about 20 seconds to connect again. The other domains on the server were running fine, and I could access my whm fine as well, the server load was 0.10 or lower.
I'm assuming there's a max connection limit somewhere either on the mysql or apache side that's restricting the site from handling the load it's getting. I've poked around google and researched it a bit but couldn't really find much. I don't have an enormous amount of time to invest in this because it's just a hobby so I'd appreciate any help one of you could offer!
I currently have one server a Dual Xeon 5130 2GHZ (woodcrest) 2GB Ram. Running cPanel/WHM
Now I run a website that is VERY PHP & MySQL Intensive and MySQL is ALWAYS the top of the process list, hogging a ton of usage. It's getting to the point where the site is needed a second server and I know there's a few options; but I'm not sure which one would be the best.
They way I see it my two options are getting a 2nd server and setting up the two to do load balancing, or getting a 2nd server and setting one up for just Apache and the Other for MySQL and using the 2nd as a remote SQL server.
If I do the Apache on a seperate server would I need such a powerful server? And if I also would want to upgrade this server along with getting a 2nd server would I be better of upgrading to 4GB of RAM or upgrading the processors?
Are there particular version of mysql or apache that are best suited when you want to utilize a multi-core/multi-cpu system? For example, we are currently using apache 1.3 and am not sure if it has the inherent ability to use multiple cpus to its benefit.
Or would the fact that it spawns child processes take advantage as the processes will be spawned on the different CPUs?
I have one bare server and installed everything myself. however, I found apache, mysqld can not automatically start after reboot, may I know how to enable them to automatically start after reboot?
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.
# 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 #
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
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code: Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2 However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
