Re: MySQL Error: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
Vincent Hoffman wrote: If you havent already, you could try increasing the per process memory limit as per examples in http://unix.derkeiler.com/Mailing-Lists/FreeBSD/hackers/2008-05/msg00258.html (man tuning also says a bit about these tuneables but doesnt have the examples that post does) Vince Hi Vince, Thanks for the advice. We have already raised the memory limits: kern.maxdsiz="1843M" # 1.8GB kern.dfldsiz="1843M" # 1.8GB Any other ideas? - Sam ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
MySQL Error: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
Hello, The error message: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug Our website started getting this error several weeks ago (when we increased the number of application server machines connecting to the database from 5 to 7. It seems to happen anywhere from every 2 days to once a week, there does not seem to be a consistent pattern. Our CPU utilization, memory utilization, and number of HTTP Requests seem to be at "normal" (they are no where closed to being maxed out). When this error happens we CAN log onto the server with the MySQL database, but I CAN NOT use the mysql client to connect to the mysql database (localhost connection as root) - it reports the error mentioned above. The way we temporarily solve the problem is to restart one of our web servers. Here is our technology stack: Web Servers: 7, Each server has: 4 Gb of Memory on each server FreeBSD 6.2-RELEASE-p9 2.4 GHz CPU Apache 2.2 Webware for Python Python 2.5 DB Servers: One Master, Two Read Only (replication) 4 GB of Memory on each server FreeBSD 6.3-RELEASE-p3 FreeBSD 6.3-RELEASE-p3 MySQL 5.0.1 We have tried bumping up our number of max allowed connections (up to 1000) on MySQL and kern.ssize to 512Mb for FreeBSD. That did not help. The max connections usually hovers ~300, so it does not even get close to the 1000 we have set. Finally the last place that we have looked is the openfiles, it is set at 20,000 for the whole system, with 14K per process on the FreeBSD operating system. Here are some relevent items from my.cnf: - set-variable = max_connections=1000 - set-variable = key_buffer_size=384M - set-variable = read_buffer_size=64M - set-variable = read_rnd_buffer_size=32M - set-variable = thread_cache_size=20 Any help would be much appreciated. Thanks - Sam Nilsson ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Cheap FreeBSD hosting?
Scott I. Remick wrote: Well it seems my "perfect" FreeBSD webhost, which had great service, great features, and a great support community has been sold-out to a large webhost consolidation company with a reputation for ruining every company they buy. They'll also be switching from FreeBSD to Linux. Since I desire to "eat my own dogfood" and continue to have my sites and pages "Powered by FreeBSD" I am back in the market looking for a new webhost. Currently I pay about $8/month for 12GB of storage, 300GB of bandwidth/month, and 5 MySQL databases. I need at least 4 databases (preferably more), and currently average 200-300MB/month transfer (although I peaked last year one month at 6GB for the month, but that's rare). I currently use 2.5GB but my space needs will gradually increase. I'd like to find a comparable plan at a webhost that uses FreeBSD servers. Pair is out of my league. I've had bad previous experience with iPowerWeb. Any others? iweb.ca a canadian company has good deals on dedicated servers. mine has been up since i got it which makes 129 days now. there have been no network interruptions that i've been aware of in that time. i don't know how their shared hosting plans work though... - Sam ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: New logo, new look
Marc G. Fournier wrote:
Is there a reason why both the old and new logos cannot be used in
tandem? I'd rather leave the old one up on my web site, since,
personally, I like it better ... I understand the argument for a 'new
logo', but, quite frankly, after looking at the new one, I'm surprised
the same arguments (being associated with a demon) isn't still being
made, since the new one *still* gives that same connotation ...
My preference is to keep using the old logo ("Beastie") on my web site,
and I imagine there are others that feel the same way ... are we going
to be "shunned" as a result? I would hope not ...
I'm not really on one side or another on this, but it occurs to me that
a lot of people may be missing a subtle distinction. From what I
understand "Beastie" is a mascot and not a logo although he may have
been used in place of a logo since there was no logo previously. The
addition of a logo should allow FreeBSD to appear more professional. The
new logo should be complementary to Beastie and live along side it.
Peace
- Sam
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: bruteforce not restarting pf?
Dave wrote: Checking my bruteforce table ;i see 163.13.111.172/32 in it, so it was added, but i don't get why future connections were permitted unless pf was not restarted or informed about the updated table. which table are you checking? the in-memory table that pf uses or the on-disk table? are you saying that the ip is inserted into the text file but that it doesn't get added to the firewall? the way my setup works, bruteforceblocker.pl updates the text file *and* runs pfctl to update the firewall since AFAIK, the firewall doesn't watch the text file for changes. Make sure that you edit the settings in the bruteforceblocker.pl script itself. For instance, if your firewall table (the one in memory) isn't getting updated, make sure that you have the $pfctl variable setup correctly. - Sam ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Release vs Stable vs Current
Ansar Mohammed wrote: Has the terminology for "production ready" FreeBSD changed? Is FreeBSD Release now considered Stable? I don't think so, no. "Stable" refers to the branch of development from which Production releases are made. Right now that is the FreeBSD 6 branch. Future point releases of FreeBSD 6 will be made from the Stable branch until the time that FreeBSD 6 becomes a legacy release. - Sam ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: suPHP - secure/reliable?
jonas wrote: I'd be really intrested to hear some few details about installation through the ports. From what I saw in the FastCGI documentation you need to do some strange configuration changes to your httpd.conf, so that .php files are properly passed to the FastCGI handler and that they'll be executed under the correct user. Could you share a quick overview what you did to get this up and running, apart from makeing install? Thanks! Sure. Here is the basic method that I used to build apache2 with suexec, fastcgi, and php5. These instructions come from my notes, so there are probably some mistakes and typos. Setting this stuff up is a process: -- Install Ports: Edit /usr/local/etc/pkgtools.conf. Add the following to the MAKE_ARGS section: 'www/apache2*' => 'WITH_SUEXEC=yes SUEXEC_DOCROOT=/usr/local/www SUEXEC_USERDIR=public_html', 'www/mod_fastcgi*' => 'WITH_APACHE2=yes', 'www/php5-cgi*' => 'WITH_FASTCGI=yes', $ portupgrade -pNi www/apache2 $ portupgrade -pNi www/mod_fastcgi $ portupgrade -pNi www/php5-cgi -- Setup Apache: Add the following to the /usr/local/etc/apache2/httpd.conf - global section FastCgiIpcDir /usr/local/fastcgi-ipc FastCgiWrapper sbin/suexec Edit any virtual hosts in httpd.conf following this example: ServerName virtual-domain.tld DocumentRoot /usr/local/www/virtual/virtual-domain.tld/public_html ... SuexecUserGroup username groupname # alternatively # SuexecUserGroup #userid #groupid AddHandler php-fastcgi .php Alias /cgi-bin/ /usr/local/www/virtual/virtual-domain.tld/cgi-bin/ SetHandler fastcgi-script Options ExecCGI Action php-fastcgi /cgi-bin/php AddType application/x-httpd-php .php Other Apache Config Issues In order for php to work with this setup, each virtual host must have its own cgi-bin directory. * The cgi-bin directory must be owned by the customer's uid and gid (from /etc/passwd). * All cgi scripts must be owned by the customer's uid/gid. * The cgi-bin directory must contain the following script which must also be owned by the customer's uid/gid. $ cat /usr/local/www/virtual/virtual-domain.tld/cgi-bin/php #!/bin/sh PHPRC="/usr/local/etc/php/php.ini" # or any custom php.ini file export PHPRC #PHP_FCGI_CHILDREN=4 #export PHP_FCGI_CHILDREN exec /usr/local/bin/php Now you can run a script like /usr/local/www/virtual/virtual-domain.tld/public_html/test.php and it will be run using suexec and fastcgi. It doesn't matter who owns the test.php script file, just the ownership of /cgi-bin and /cgi-bin/php. If you want to run normal cgi scripts from public_html, then the script and its parent directory must be owned exactly as indicated by the SuexecUserGroup directive. Let me know if you need any clarifications or if you have any more questions. - Sam ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: suPHP - secure/reliable?
M. L. wrote: Hi all, I'd like to know your opinions on suPHP. I was looking for some software that would execute PHP scripts as the user who owns them, instead of www, and came up with that. But the site is written in poor english, the software consists on a root setuid binary, so I'm a bit worried about the quality of this software. Does anyone have anything to say about suPHP, either good or bad stuff ? I'd like your opinions. Regards, M. L. I can't answer your questions about suPHP. I chose a different way. I installed the fastcgi apache module from ports, and I compiled the php-cgi port with fastcgi support. Then I compiled apache with suexec support so that I can run cgis (fastcgi included) as whatever users I need. If you are interested in taking this route I may be able to help you with the little details. - Sam Nilsson ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: php4 sessions not built by default?
Garrett Cooper wrote: Just trying to access some session variables via the PHP4 and for some odd reason it doesn't appear as if the function exists. Is this not built in PHP4 by default? And if so, how may I remedy the issue? Thanks, -Garrett Hi Garrett, Yeah, I think you are right that it doesn't install session support by default. I remember running into this myself. The solution is to install the lang/php4-extensions port if you don't already have it installed. That port will give you options to install all kinds of php extensions that you might need including session support. If you already have the lang/php4-extensions port installed and you need a different way to install session support, install the www/php4-session port directly. - Sam ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: PHP4 & PHP5 on same server?
Mark Bucciarelli wrote:
On Tue, Sep 27, 2005 at 11:16:04AM +0200, [EMAIL PROTECTED] wrote:
Mark Bucciarelli wrote:
Is it possible install both php4 and php5 on the same server using
ports?
I'm using fastcgi so two different interpreters should be fine. (Rename
/usr/local/bin/php to /usr/local/bin/php5-fcgi, for example.)
Can I assume the php4 and php5 modules (for example, pear) won't step on
each other's toes?
I google around but didn't find much on this topic ... :(
m
We have them as mod with two chrooted Apache servers on two different IPs.
Thanks for the reply.
From doing some more research list night, my understanding is that
the php binary is the whole kit and kaboodle, so if I
- build PHP4 from source and
- configure it to look in a different spot for extensions,
then I should be able to use PHP4 and PHP5 via fastcgi on a per-vhost
basis.
I just won't be able to rely on ports for updates to PHP4.
m
I found a way to do it where I can install both php instances from
ports. In my case I am using php5-cli (command line interpreter) as well
as php5-cgi (compiled for fast cgi) both installed from ports. php5-cli
is installed into the normal directories under /usr/local. php5-cgi is
installed into an alternate base directory /usr/local/alt.
Basically, you can use the PREFIX environment variable to tell the ports
system to use an alternate base directory for installation. This works
with portupgrade as well.
Here are some notes that I took when I was setting this up. Note that
I'm using portupgrade (hence the reference to
/usr/local/etc/pkgtools.conf)...
== Install PHP5 with fastcgi support ==
In order to have an alternative fastcgi version of php, we need to
install it to an alternate location.
First this to /usr/local/etc/pkgtools.conf:
{{{
MAKE_ARGS {
'php5-cgi*' => 'WITH_APACHE2=yes WITH_FASTCGI=yes'
}
}}}
Assuming that we already have php5 for cli and apache installed, we can
install an alternate fastcgi enabled version like this:
{{{
$ su -
$ mkdir /usr/local/alt
$ export PREFIX=/usr/local/alt
$ script /usr/local/alt/install.log
$ portupgrade -pNi www/php5-cgi
$ exit # (exit script)
$ exit # (exit su)
}}}
There can be a few little problems with this process. Here is the
preliminary report:
Modules not loaded
php5-cgi installed fine into the alternate prefix, but it didn't know
about any of the extensions (modules) that the main php install had.
To fix this, I pointed the new php5-cgi at the main php instance's
modules. '''I believe that this will only work if both instances of php5
are the exact same version'''
Here is what I did:
{{{
$ cd /usr/local/alt/etc
# /usr/local/etc/php is a directory that contains an 'extensions.ini' file.
# The 'extensions.ini' file lists the extensions that should be loaded.
$ ln -s /usr/local/etc/php php
}}}
- Sam Nilsson
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
