kernel option HZ and mysql

2005-04-20 Thread Chad Leigh -- Shire . Net LLC
I have a self-compiled mysql 4.1 (4.1.9) on FreeBSD 5.3. (Not built from ports for various reasons). The system load skyrockets when the web server that is using the mysql for its PHPnuke storage starts to get 100 or so or more active sessions. It appears that mysql is the culprit

Problem linking MySQL 4.1.11 via FreeBSD 4.10 ports

2005-04-19 Thread Clifton Royston
I am having a problem building from ports, which is a fairly rare experience for me. When I try to make the current port of the MySQL 4.1 server under FreeBSD 4.10, I get a huge stream of undefined reference errors at the link step for mysqld. It would seem it can't find any thread-related

Re: Problem linking MySQL 4.1.11 via FreeBSD 4.10 ports

2005-04-19 Thread Clifton Royston
On Tue, Apr 19, 2005 at 02:02:39PM -1000, Clifton Royston wrote: When I try to make the current port of the MySQL 4.1 server under FreeBSD 4.10, I get a huge stream of undefined reference errors at the link step for mysqld. More factoids - the same error continues to happen: * After

Re: Problem linking MySQL 4.1.11 via FreeBSD 4.10 ports

2005-04-19 Thread Clifton Royston
needed to build them starting from the default build environment for FreeBSD 4.x? ( Not for 4.1!) And last, I meant to say I'd rather not upgrade the compiler unless *necessary* to get MySQL running - I will if I have to. I have seen a number of people post about running MySQL on FreeBSD

MySql Server Not Starting

2005-04-16 Thread Richard Collyer
Hello, Done a google on this and come up with nothing. I had this problem a week ago and found the solution but I cant find it again and its bugging me. in rc.conf I have mysqld_enable=YES also I have mysql-server.sh in /usr/local/etc/rc.d/mysql-server.sh Upon boot or by running the script

Re: MySql Server Not Starting

2005-04-16 Thread Subhro
Richard Collyer wrote: Hello, Done a google on this and come up with nothing. I had this problem a week ago and found the solution but I cant find it again and its bugging me. in rc.conf I have mysqld_enable=YES also I have mysql-server.sh in /usr/local/etc/rc.d/mysql-server.sh Its

Re: Anyone ever consider a filesystem served by MySQL for mail folders?

2005-04-10 Thread Mario Hoerich
# Doug Lee: [ fixed quote-levels ] On Sat, Apr 09, 2005 at 05:33:22PM -0400, Chuck Swiger wrote: [ mail storage backed by DB ] The advantage is that users gets fancy searching. The disadvantage is that you need to provide around 4 times as much disk space for a DB-based mailstore

Re: Anyone ever consider a filesystem served by MySQL for mail folders?

2005-04-10 Thread Joel
The disadvantage is that you need to provide around 4 times as much disk (B space for a DB-based mailstore as you would for a normal mbox/maildir (B style (B representation, you need to provide a lot more server horsepower, you (B need (B to continuously maintain and purge

Anyone ever consider a filesystem served by MySQL for mail folders?

2005-04-09 Thread Doug Lee
Ok, tell me if this is a totally awful idea, but it seems quite useful to me, even if unusual... Is it practical to implement a mountable filesystem for mail archiving whose contents are served by a MySQL (or other SQL) database? Creating this is surely way beyond my level of expertise in FreeBSD

Re: Anyone ever consider a filesystem served by MySQL for mail folders?

2005-04-09 Thread Chuck Swiger
Doug Lee wrote: Ok, tell me if this is a totally awful idea, but it seems quite useful to me, even if unusual... It's a totally awful idea. :-) Is it practical to implement a mountable filesystem for mail archiving whose contents are served by a MySQL (or other SQL) database? Creating

Re: Anyone ever consider a filesystem served by MySQL for mail folders?

2005-04-09 Thread Doug Lee
On Sat, Apr 09, 2005 at 05:33:22PM -0400, Chuck Swiger wrote: Doug Lee wrote: Is it practical to implement a mountable filesystem for mail archiving whose contents are served by a MySQL (or other SQL) database? Creating this is surely way beyond my level of expertise in FreeBSD, and maybe even

MySQL client only

2005-04-07 Thread Irina
Hello at FreeBSD list. I am having a problem with MySQL on a server. When I access MySQL server 4.1.10 from a C program (or on the command line), I have this ERROR 1043: Bad handshake It says I should upgrade my client on this server. Trying to do so by doing Updated ports/database

Re: MySQL client only

2005-04-07 Thread Subhro
Irina wrote: snip Not sure what to do. Or, may be my mistake was that I CVSUPed only ports/databases? Partial updates are never a good idea. However in this case it seems to me as if your link is givig you problems. Can you access other things on the internet? Regards S.

question about mysql-server.sh

2005-04-05 Thread Christopher Lane
Hi, Long story made short: The mysql-server.sh that came with mysql-server-4.1.10a (installed from cvsup'ed ports) wouldn't work until after I rebooted the server. It's working now, so I know I shouldn't complain, but anyone know what happened? Long story: 1. Minimum installation, added

Re: question about mysql-server.sh

2005-04-05 Thread Ed Stover
rcsubr is the culprit, when you added the line in the rc.conf then all was well. You can add a line in the rc.conf and then run the /usr/local/etc/rc.d/mysql-server.sh start command with out having to reboot. Personally I really dislike rcsubr, makes me think that FreeBSD is drifting toward

Re: question about mysql-server.sh

2005-04-05 Thread Dan Nelson
In the last episode (Apr 05), Ed Stover said: rcsubr is the culprit, when you added the line in the rc.conf then all was well. You can add a line in the rc.conf and then run the /usr/local/etc/rc.d/mysql-server.sh start command with out having to reboot. Personally I really dislike rcsubr

mysql 4.1 on freebsd 4.8

2005-04-04 Thread Ray Watts
I have been trying to install mysql 4.1.10a on freebsd 4.8 but I get the following error: SuffFindDeps (pre-fetch) No known suffix on pre-fetch. Using .NULL suffix not adding suffix rules pre-fetch:@ = pre-fetch pre-fetch:* = pre-fetch Examining pre-fetch...non-existent...non-existent

mysql upload_max_filesize

2005-03-31 Thread Dennis Olvany
Everything I've seen says to put the upload_max_filesize into php.ini, but I searched my drive and I don't have a php.ini. Anyone know the deal? FreeBSD 5.3 PHP 4.3.10 ___ freebsd-questions@freebsd.org mailing list

Re: mysql upload_max_filesize

2005-03-31 Thread Mario Hoerich
# Dennis Olvany: Everything I've seen says to put the upload_max_filesize into php.ini, but I searched my drive and I don't have a php.ini. Anyone know the deal? IIRC there are two files (php.ini-dist and php.ini-recommended) in /usr/local/etc. Copy either to php.ini and you're all set. :)

Default mysql config file

2005-03-18 Thread KP
Hello, My /var will run out of space soon, I was told that changing mysql store place was a good solution. But I can't find the default configuration file, is it ok to create a new file with the only line indicating the store position? I'm a newbie and more details would be appreciated. Regards

Re: Default mysql config file

2005-03-18 Thread Jerry McAllister
Hello, My /var will run out of space soon, I was told that changing mysql store place was a good solution. But I can't find the default configuration file, is it ok to create a new file with the only line indicating the store position? I'm a newbie and more details would be appreciated

new install of fbsd with apache/php/mysql

2005-03-17 Thread Chip Wiegand
I just finished installed 5.3 and am now trying to get apache2, php4, myql4 installed. I run sysinstall to install the packages from ftp. php4 installed, mysql-client installed, but apache2 and mysql-server failed. I get this message when I tried mysql4.1.5 - Add of package mysql-client

Re: new install of fbsd with apache/php/mysql

2005-03-17 Thread Thomas Foster
with apache/php/mysql I just finished installed 5.3 and am now trying to get apache2, php4, myql4 installed. I run sysinstall to install the packages from ftp. php4 installed, mysql-client installed, but apache2 and mysql-server failed. I get this message when I tried mysql4.1.5 - Add of package mysql

MySQL ports 'missing'

2005-03-17 Thread Nigel Moore
Hi I'm trying to use FreeBSD ports to install MySQL server 4.1.10. The CLI throws back an error to the effect that mysql-4.1.5-gamma.tar.gz is unavailable. The website (http://www.freebsd.org/cgi/pds.cgi?ports/databases/mysql41-server) cannot find the ports. What' s the problem and how can I

Re: MySQL ports 'missing'

2005-03-17 Thread Kris Kennaway
On Thu, Mar 17, 2005 at 11:14:51PM +0100, Nigel Moore wrote: Hi I'm trying to use FreeBSD ports to install MySQL server 4.1.10. The CLI throws back an error to the effect that mysql-4.1.5-gamma.tar.gz is unavailable. The website (http://www.freebsd.org/cgi/pds.cgi?ports/databases

Re: Mysql postfix SASL cyrus imap problem

2005-03-16 Thread Daniel S. Haischt
if this was a double post my subscribe was not working :( Im not sure if the original mail went through. Hi All I have a problem with my cyrus imap / mysql install after 3 days on google looking around i am ripping my hair out I have tried everything i have found in the faq's / howto's but just

/bin/sh, php mysql

2005-03-16 Thread George Dew
After upgrading to BSD 4.11, I've been having all sorts of problems. Please help! - The shell no longer supports the up cursor key, which gives a history of commands that you type. - Also, mod_php no longer supports mySQL. Does anyone know what's going on here

Re: /bin/sh, php mysql

2005-03-16 Thread Tofik Suleymanov
,that you used before upgrade. - Also, mod_php no longer supports mySQL. Does anyone know what's going on here? Did you recompile all the installed ports after upgrading to 4.11 ? If not,then do it. ___ freebsd-questions@freebsd.org mailing list http

Mysql postfix SASL cyrus imap problem

2005-03-15 Thread Jason M aka Talon
Sorry if this was a double post my subscribe was not working :( Im not sure if the original mail went through. Hi All I have a problem with my cyrus imap / mysql install after 3 days on google looking around i am ripping my hair out I have tried everything i have found in the faq's / howto's

mysql troubles

2005-03-14 Thread Dennis Olvany
just installed it and having trouble getting it going fresh mysql4.1 install on fbsd5.3 bsd# mysqladmin flush-privileges mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running

Re: mysql troubles

2005-03-14 Thread Jeff Wirth
On Mon, 14 Mar 2005 07:15:39 -0600, Dennis Olvany [EMAIL PROTECTED] wrote: just installed it and having trouble getting it going fresh mysql4.1 install on fbsd5.3 bsd# mysqladmin flush-privileges mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server

Re: mysql troubles

2005-03-14 Thread Jeff Wirth
On Mon, 14 Mar 2005 12:52:59 -0600, Dennis Olvany [EMAIL PROTECTED] wrote: mysql via ports If that's the case everything should to be good to go after the port is install. With the exception of creating the root password (and of course creating your own dbs). On your original post you

mod_chroot php and mysql connection

2005-03-09 Thread Muhammad Reza
Dear list.. I try to configure mod_chroot-0.3 (apache-2.0) in my machine. But i cant connect to mysql database via my php connection. I'm already change bind address for mysql to loopback address (127.0.0.1) but still can't connect from my php connection. please give me a hint to solve

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-12 Thread Nick Pavlica
: I would like to install SQL here for my own use, not for any real life currently, round now for learning. Right now plan to install MySQL. Looking through the ports there is numerous version and some say for server, some say for client. Looking for some tips as to what version

(mySQL) benchmarks strike back

2005-02-11 Thread Jorge Mario G.
Hi there I just read http://software.newsforge.com/software/04/12/27/1243207.shtml?tid=72tid=29%20result and as in any onther benchmark there is a lot stuff that can be arguable. I would like to know why is that happening? the problem is that we are pushing FreeBSD/postgreSQL as a database

Re: (mySQL) benchmarks strike back

2005-02-11 Thread Ean Kingston
with the filsystems mounted syncronously and you don't risk the data loss if the power fails. That was a performance test for MySQL. You are using Postgres. These are different databases. Postgres is a much better choice. It is a much more complete database server. For example, last time I checked

Re: (mySQL) benchmarks strike back

2005-02-11 Thread Andrew L. Gould
are polarized. Linux gamers tend to say yes. More conservative users often say, no. Running the benchmarks using SUSE Professional, Slackware or Debian (or others) would have provided more comfort to business users. 5. Is MySQL different from PostgreSQL in ways that should affect the relevance

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-11 Thread Sean
Jan Branbergen wrote: I would like to install SQL here for my own use, not for any real life currently, round now for learning. Right now plan to install MySQL. Looking through the ports there is numerous version and some say for server, some say for client. Looking for some tips as to what

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-11 Thread Peter Risdon
On Fri, 2005-02-11 at 17:17 -0500, Sean wrote: What is the difference between PostgreSQL and MySQL? From what I see MySQL seems to be more common. They are completely separate projects. Postgresql grew out of an academic project (ingres), mysql was developed by a commercial organisation

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-11 Thread Oliver Leitner
and to the point. Greetings Oliver Leitner Technical Staff http://www.shells.at Jan Branbergen wrote: I would like to install SQL here for my own use, not for any real life currently, round now for learning. Right now plan to install MySQL. Looking through the ports there is numerous version

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-11 Thread Kevin Kinsey
Sean wrote: What is the difference between PostgreSQL and MySQL? From what I see MySQL seems to be more common. Sean There are a lot of threads on a forum I frequent (www.phpbuilder.com/board) that address this issue. Here are a few links. http://www.phpbuilder.com/board/showthread.php

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-11 Thread Andrew L. Gould
On Friday 11 February 2005 04:17 pm, Sean wrote: What is the difference between PostgreSQL and MySQL? From what I see MySQL seems to be more common. Sean What.not enough holy wars this week? ;-) PostgreSQL and MySQL are both good database server applications. Here are some

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-11 Thread Ean Kingston
On February 11, 2005 05:17 pm, Sean wrote: Jan Branbergen wrote: I would like to install SQL here for my own use, not for any real life currently, round now for learning. Right now plan to install MySQL. Looking through the ports there is numerous version and some say for server, some

Re: SQL Questions (MySQL or PostgreSQL?)

2005-02-11 Thread Louis LeBlanc
Then again, you could just ride the fence and install them both . . . I'd also suggest you start with MySQL though. As mentioned previously, it's the more commonly used DB. I started with PostgreSQL, and wound up having to install MySQL anyway because I wanted to try some apps that requred

Re: SQL Questions - migrating MySQL to PostgreSQL?

2005-02-11 Thread Erik Norgaard
Peter Risdon wrote: Postgresql is an excellent dbms and well worth a look. But if you're starting out, I think mysql is the place to be. Ok, since the discussion is up, I have used MySQL for years, no problem serves my needs. Yet, I'd like to try out that PostgreSQL so many talks about. So, how

Re: SQL Questions - migrating MySQL to PostgreSQL?

2005-02-11 Thread Mike Jeays
On Fri, 2005-02-11 at 19:18, Erik Norgaard wrote: Peter Risdon wrote: Postgresql is an excellent dbms and well worth a look. But if you're starting out, I think mysql is the place to be. Ok, since the discussion is up, I have used MySQL for years, no problem serves my needs. Yet, I'd

Re: SQL Questions - migrating MySQL to PostgreSQL?

2005-02-11 Thread Oliver Leitner
well, i havent done that one yet, but you might want to have a look onto this page, that i just discovered via google: http://www.sitepoint.com/article/site-mysql-postgresql-1 there are many more articles about this one. i hope this helps you further. Greetings Oliver Leitner Technical Staff

Re: FreeBSD 5.3 MySQL Performance

2005-02-10 Thread Ceri Davies
On Wed, Feb 09, 2005 at 04:22:02PM -0800, Matt Olander wrote: hey gang, We've got a customer that is considering a network expansion while moving from Linux to FreeBSD. They are big users of MySQL and have been running it on Linux. Most of the information that I've found is a bit old

installing mysql , apache with ssl and mod_php4 help ?

2005-02-10 Thread Brent
Im running FBSD 4.10 and to cure the problem with a recent php4 exploit i had to upgrade to 4.3.10 ..i did this by going to /usr/ports/www/mod_php4 and doing make deinstall make reinstall in doing this after restarting apache which by the way said it loaded the php module im getting no Mysql

Re: installing mysql , apache with ssl and mod_php4 help ?

2005-02-10 Thread Kevin Kinsey
getting no Mysql support when i try to access my mysql/php sites anyone run accross this ?? if so ...how do i fix it ? i was thinking of just reinstalling mysql / apache ssl /mod_php4 any thoughts ? Hi, Brent. Check /usr/ports/UPDATING and note that the PHP port was splitted last July. To get

Re: FreeBSD 5.3 MySQL Performance

2005-02-10 Thread Jeff Behl
the same performance? this isn't meant as a rub, i would seriously consider doing this if it were the case. i'd like to know any and all ways i can make mysql faster. we have fleats of mysql servers with redundant data. the loss of a server due to corruption is not problematic

Re: FreeBSD 5.3 MySQL Performance

2005-02-10 Thread Ean Kingston
by this logic, if i re-mount my partitions async i can get the same performance? this isn't meant as a rub, i would seriously consider doing this if it were the case. i'd like to know any and all ways i can make mysql faster. we have fleats of mysql servers with redundant data. the loss

RE: MySQL query tool and Administrator

2005-02-09 Thread Damian Sobieralski
I downloaded the source from: http://dev.mysql.com/downloads/query-browser/1.1.html I extracted and it created three directories: mysql-query-browser-1.1.5/ mysql-gui-common/ mysql-query-browser/ I cd into mysql-query-broswer-1.1.5/mysql-query-browser and ran

FreeBSD 5.3 MySQL Performance

2005-02-09 Thread Matt Olander
hey gang, We've got a customer that is considering a network expansion while moving from Linux to FreeBSD. They are big users of MySQL and have been running it on Linux. Most of the information that I've found is a bit old, but I guess my question is if LinuxThreads should still be used

Re: FreeBSD 5.3 MySQL Performance

2005-02-09 Thread Jeremy C. Reed
On Wed, 9 Feb 2005, Matt Olander wrote: Also, does anybody have any FreeBSD 5.3/MySQL benchmarks? I searched the mailing lists but didn't turn up anything. This was posted to some NetBSD lists today: http://software.newsforge.com/article.pl?sid=04/12/27/1243207from=rss This Comparing MySQL

Re: FreeBSD 5.3 MySQL Performance

2005-02-09 Thread Matt Olander
On Wed, Feb 09, 2005 at 07:58:56PM -0500, Alec Berryman wrote: Also, does anybody have any FreeBSD 5.3/MySQL benchmarks? I searched the mailing lists but didn't turn up anything. There was an article posted to Newsforge today about benchmarking MySQL on different operating systems. oh

Re: FreeBSD 5.3 MySQL Performance

2005-02-09 Thread Joe Kelsey
On Wed, 2005-02-09 at 16:44 -0800, Matt Olander wrote: On Wed, Feb 09, 2005 at 07:58:56PM -0500, Alec Berryman wrote: Also, does anybody have any FreeBSD 5.3/MySQL benchmarks? I searched the mailing lists but didn't turn up anything. There was an article posted to Newsforge today about

RE: FreeBSD 5.3 MySQL Performance

2005-02-09 Thread Ted Mittelstaedt
[EMAIL PROTECTED] wrote: On Wed, 2005-02-09 at 16:44 -0800, Matt Olander wrote: On Wed, Feb 09, 2005 at 07:58:56PM -0500, Alec Berryman wrote: Also, does anybody have any FreeBSD 5.3/MySQL benchmarks? I searched the mailing lists but didn't turn up anything. There was an article posted

Changing mysql root password

2005-02-08 Thread gabriel
Hello gang, Okay so I've read the mysql docs and also googled my little heart out; have also tried various solutions none of which worked. I've done a fresh install of mysql3*-server from ports. The db dir is /usr/local/mysql and I've been starting the deamon utilizing the following line

Re: Changing mysql root password

2005-02-08 Thread Adi Pircalabu
On Tue, 8 Feb 2005 00:37:40 -0800 gabriel [EMAIL PROTECTED] wrote: Please someone enlighten me! Hi, http://dev.mysql.com/doc/mysql/en/resetting-permissions.html Hope it helps -- Adrian Pircalabu Public KeyID = 0x04329F5E -- This message was scanned for spam and viruses by BitDefender

Re: Changing mysql root password

2005-02-08 Thread gabriel
Nope, negative. Any other suggestions? On Tue, 8 Feb 2005 10:59:21 +0200, Adi Pircalabu [EMAIL PROTECTED] wrote: On Tue, 8 Feb 2005 00:37:40 -0800 gabriel [EMAIL PROTECTED] wrote: Please someone enlighten me! Hi, http://dev.mysql.com/doc/mysql/en/resetting-permissions.html Hope

Re: Changing mysql root password

2005-02-08 Thread Adi Pircalabu
On Tue, 8 Feb 2005 01:21:45 -0800 gabriel [EMAIL PROTECTED] wrote: Nope, negative. Any other suggestions? From what I know, if you installed mysql from ports system, without any particular knobs, the database directory should be /var/db/mysql. So, if you want to use another path, you should

Re: Changing mysql root password

2005-02-08 Thread gabriel
Okay, I'm not asking you to guess it, I didn't include it because I didn't think it was relevant. Regardless, here it goes: This the make line: make DB_DIR=/usr/local/mysql WITH_LINUXTHREADS=yes BUILD_STATIC=yes BUILD_OPTIMIZED=yes install I'm not sure what else you need. Cheers! On Tue, 8

Re: Changing mysql root password

2005-02-08 Thread Adi Pircalabu
On Tue, 8 Feb 2005 01:40:36 -0800 gabriel [EMAIL PROTECTED] wrote: I'm not sure what else you need. I'm not sure what I need either :), anyway: - did you notice any errors after install? - do you have a proper user/group setup on DB_DIR ? - does the error occur if you start safe_mysqld as root

Re: Changing mysql root password

2005-02-08 Thread gabriel
hmm you know what worked? Just doing this: /usr/local/bin/safe_mysqld Before I was adding some flags that the manual said I should add. I've sinced placed them in the config. Thanks for your help though!! :) On Tue, 8 Feb 2005 11:55:14 +0200, Adi Pircalabu [EMAIL PROTECTED] wrote: On Tue, 8

RE: MySQL query tool and Administrator

2005-02-04 Thread Damian Sobieralski
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Schmehl Sent: Thursday, February 03, 2005 2:19 PM To: Damian Sobieralski; freebsd-questions@freebsd.org Subject: Re: MySQL query tool and Administrator Go to /usr/ports/emulators/linux_base/ and install the linux emulator port

Re: MySQL query tool and Administrator

2005-02-04 Thread Andrew L. Gould
On Friday 04 February 2005 10:45 am, Damian Sobieralski wrote: I'd be happy to try that. Quick question- I use KDE. Can I have GNOME installed on the same box with KDE without any conflicts? Can I run the compiled app via KDE? In ignornance, - Damian Yes, KDE and Gnome can coexist

Re: MySql Load balancing Solutions?

2005-02-03 Thread Matthew Seaman
On Wed, Feb 02, 2005 at 01:46:22PM -0700, Nick Pavlica wrote: MySql 4.1 has been the production release since 4.1.7 and are currently at the 4.1.9 release. You could look into the seperate MySql Cluster product, but it is around $5k per cpu last time I checked. Uh --- MySQL Cluster

Re: make switch for alternate data directory on mysql???-server install

2005-02-03 Thread Matthew Seaman
On Wed, Feb 02, 2005 at 02:13:31PM -0800, Ken Hawkins wrote: I know there is a switch for make install that will tell it where the database files will be held (mysql, test, etc...) and I thought it was; make DB_DIR=/some/other/dir install No -- that is right. However be aware that setting

Re: MySql Load balancing Solutions?

2005-02-03 Thread Nick Pavlica
Uh --- MySQL Cluster is a standard part of 4.1.9. You just have to install the mysql41-server port WITH_NDB=yes, which gets you a bunch of extra executables, mostly in /usr/local/libexec, including ndb_mgmd and ndbd. See: http://dev.mysql.com/doc/mysql/en/ndbcluster.html Yes it's part

MySQL query tool and Administrator

2005-02-03 Thread Damian Sobieralski
I'm running FreeBSD 5.3-RELEASE and I am looking for one of my favorite MySQL tools- mysql-query-tool. I use this tool extensively on MS Windows and now that I am migrating over to my BSD workstation I'd like to continue using it (along with MySQL Administrator) as the other MySQL GUI tools

RE: MySQL query tool and Administrator

2005-02-03 Thread Ted Mittelstaedt
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Schmehl Sent: Thursday, February 03, 2005 2:19 PM To: Damian Sobieralski; freebsd-questions@freebsd.org Subject: Re: MySQL query tool and Administrator Go to /usr/ports/emulators/linux_base

MySQL Disk Quotas per User/Group

2005-02-02 Thread Grant Peel
Hi all, I have been struggling with how to include a users MySQL disk usage within thier disk quota. Currently, each user has a disk quota set on thier /home/usernamehere directory The mysql databases are kept in the /home/usernamehere/database directory, but, mysql insists on owning

Re: MySql Load balancing Solutions?

2005-02-02 Thread Drumslayer
--- Technical Director [EMAIL PROTECTED] wrote: Drumslayer, I am part of a team running MySQL 4.1.X on 5 machines in a replication setup. Our first way to help manage load is the use of useful rules in our connection classes to direct Writes to our big server with fast I/O and memory

Re: MySql Load balancing Solutions?

2005-02-02 Thread Technical Director
of beta into Generally Available with a This is the current generally available (GA) release of the MySQL database server. It is recommended for most users. [ http://dev.mysql.com/downloads/mysql/4.1.html ] Not necessarily saying it's bomb proof but I don't know if they classify it as beta anymore

Re: MySql Load balancing Solutions?

2005-02-02 Thread Nick Pavlica
All, MySql 4.1 has been the production release since 4.1.7 and are currently at the 4.1.9 release. You could look into the seperate MySql Cluster product, but it is around $5k per cpu last time I checked. --Nick On Wed, 2 Feb 2005 13:28:22 -0700 (MST), Technical Director [EMAIL PROTECTED

Re: MySql Load balancing Solutions?

2005-02-02 Thread Drumslayer
possibly naive but from what I understand 4.1.X moved off of beta into Generally Available with a This is the current generally available (GA) release of the MySQL database server. It is recommended for most users. [ http://dev.mysql.com/downloads/mysql/4.1.html ] Not necessarily saying

make switch for alternate data directory on mysql???-server install

2005-02-02 Thread Ken Hawkins
I know there is a switch for make install that will tell it where the database files will be held (mysql, test, etc...) and I thought it was; make DB_DIR=/some/other/dir install but this is not the case. how can i find out the switches for this and any other ports? thanks, ken

FreeBSD + Apache2 + PHP + MySQL ?

2005-02-01 Thread Joseph Koenig (jWeb)
this server will get a decent amount of traffic. There's about 200 web sites on it that total about 1.5 million hits per day. Has anyone had any experience with Apache 2, PHP, MySQL on FreeBSD 5.3 in a production environment? Any input would be appreciated. Please CC me on responses. Thanks, Joe Koenig

MySql Load balancing Solutions?

2005-02-01 Thread Drumslayer
Hi I have been running a fairly heavy duty server for MySQL on FreeBSD but its starting to peak. I would like to know what others have done as far as using a load balancing solution for MySQL or their success with replication. Also has anyone done a 64 bit build of MySQL on FreeBSD successfully

Re: FreeBSD + Apache2 + PHP + MySQL ?

2005-02-01 Thread Kevin Kinsey
concerns me because this server will get a decent amount of traffic. There's about 200 web sites on it that total about 1.5 million hits per day. Has anyone had any experience with Apache 2, PHP, MySQL on FreeBSD 5.3 in a production environment? Any input would be appreciated. Please CC me

Re: MySql Load balancing Solutions?

2005-02-01 Thread Technical Director
Drumslayer, I am part of a team running MySQL 4.1.X on 5 machines in a replication setup. Our first way to help manage load is the use of useful rules in our connection classes to direct Writes to our big server with fast I/O and memory and directing Rreads to our slower I/O less RAM slaves only

mysql port question

2005-01-31 Thread Omer Faruk Sen
Hi, I am planning to install mysql on a FreeBSD 5 system but I am confused a little bit. I had some problem while I had installed mysql on FreeBSD4. I know there were problems on FreeBSD 4 (in fact thread implementation of FreeBSD) with mysql. On FreeBSD mysql40-server port I have seen

Re: MySQL update from 4.1 to 4.7

2005-01-31 Thread Eric S
From: Phillip Hocking [EMAIL PROTECTED] Subject: MySQL update from 4.1 to 4.7 To: [EMAIL PROTECTED] Now it will not allow me to login to the database with any of the usernames that I remember here is the error in the log 2:58:29 [Warning] Found 4.1 style password for user '[EMAIL PROTECTED

Re:php install with mysql confirmation?

2005-01-31 Thread Ken Hawkins
Fatal error: Call to undefined function: mysql_pconnect() in /.../phpPollUI6.php on line 77 I have a couple of questions. how can I verify that mysql support (possibly ? php-mysql ?) is installed? what steps do I need to take to ensure that this gets installed as part of my installation

MySQL update from 4.1 to 4.7

2005-01-30 Thread Phillip Hocking
Now it will not allow me to login to the database with any of the usernames that I remember here is the error in the log 2:58:29 [Warning] Found 4.1 style password for user '[EMAIL PROTECTED]'. Ignoring user. You should change password for this user. How do I flush the tables to resolve this

Re: Witch apache, mysql and php do i need ?

2005-01-28 Thread Gert Cuykens
) apache-1.3.33_1 expat-1.95.8 fontconfig-2.2.3,1 freetype2-2.1.7_4 jpeg-6b_3 mysql-client-4.0.23a openssl-0.9.7e_2 pdflib-6.0.1_1 pecl-pdflib-2.0.4 perl-5.8.5 php4-4.3.10_2 php4-bz2-4.3.10_2 php4-gd-4.3.10_2 php4-mysql-4.3.10_2 php4-openssl-4.3.10_2 php4-pcre-4.3.10_2 php4-zlib-4.3.10_2 pkgconfig

Re: Witch apache, mysql and php do i need ?

2005-01-28 Thread Matthew Seaman
:) 7rxI# make pretty-print-run-depends-list This port requires package(s) apache-1.3.33_1 expat-1.95.8 fontconfig-2.2.3,1 freetype2-2.1.7_4 jpeg-6b_3 mysql-client-4.0.23a openssl-0.9.7e_2 pdflib-6.0.1_1 pecl-pdflib-2.0.4 perl-5.8.5 php4-4.3.10_2 php4-bz2-4.3.10_2 php4-gd-4.3.10_2 php4-mysql

Re: Witch apache, mysql and php do i need ?

2005-01-28 Thread Gert Cuykens
another one : cd /usr/ports make fetchindex portsdb -u woh :) 7rxI# make pretty-print-run-depends-list This port requires package(s) apache-1.3.33_1 expat-1.95.8 fontconfig-2.2.3,1 freetype2-2.1.7_4 jpeg-6b_3 mysql-client-4.0.23a openssl-0.9.7e_2 pdflib-6.0.1_1 pecl

Re: using ports (WAS: Witch apache, mysql and php do i need ?)

2005-01-28 Thread Karol Kwiatkowski
Gert Cuykens wrote: thx is there also a command that just tells you what it is going to download without downloading it ? man ports and have a look at 'fetch-list' and other TARGETS. Cheers, Karol -- Karol Kwiatkowski freebsd at orchid dot homeunix dot org

Re: Witch apache, mysql and php do i need ?

2005-01-27 Thread christophe ollier
Le 27/01/2005 à 07:49, Gert Cuykens a écrit : So i can use phpmyadmin, use php as a apache module , make a ssl connection and use the include feature. The easiest way would be to install the phpMyAdmin port, it will build all needed software, with the exception of mysql-server (the MySQL port

Re: Witch apache, mysql and php do i need ?

2005-01-27 Thread Gert Cuykens
, it will build all needed software, with the exception of mysql-server (the MySQL port is split between a client and a server softwares). PS 2.1+ and 5+ are my favorite numbers :) Sorry, the dependencies at this time show Apache 1.3.33, mod_php 4.4.3, MySQL 4.0.23a. Wrong numbers :) Also

Re: Witch apache, mysql and php do i need ?

2005-01-27 Thread christophe ollier
Le 27/01/2005 à 10:16, Gert Cuykens a écrit : If i install phpmyadmin will php be a module into apache or a cgi bin ? It's mod_php, as in module. It brings better integration of PHP into Apache than the classic CGI. Witch mysql do i install exactly ? And after installing it, will it work

Re: Witch apache, mysql and php do i need ?

2005-01-27 Thread Matthew Seaman
all needed software, with the exception of mysql-server (the MySQL port is split between a client and a server softwares). PS 2.1+ and 5+ are my favorite numbers :) Sorry, the dependencies at this time show Apache 1.3.33, mod_php 4.4.3, MySQL 4.0.23a. Wrong numbers :) Those are just

Re: Witch apache, mysql and php do i need ?

2005-01-27 Thread Gert Cuykens
On Thu, 27 Jan 2005 10:44:04 +, Matthew Seaman [EMAIL PROTECTED] wrote: Those are just the defaults. You can override them by putting: WITH_APACHE2=yes APACHE_PORT=www/apache21 DEFAULT_PHP_VER=5 WITH_MYSQL_VER=50 into /etc/make.conf There are quite a few similar

Re: Witch apache, mysql and php do i need ?

2005-01-27 Thread christophe ollier
Le 28/01/2005 à 00:48, Gert Cuykens a écrit : 7rxI# make pretty-print-run-depends-list This port requires package(s) grep: /usr/ports/INDEX-5: No such file or directory to run. 7rxI# make pretty-print-build-depends-list 7rxI# How can i show the list of dependencies ? It seems your ports index is

Witch apache, mysql and php do i need ?

2005-01-26 Thread Gert Cuykens
So i can use phpmyadmin, use php as a apache module , make a ssl connection and use the include feature. PS 2.1+ and 5+ are my favorite numbers :) Also can everybody make a ssl connection or do you have to register a key or something ? ___

Re: Witch apache, mysql and php do i need ?

2005-01-26 Thread Olivier Nicole
Also can everybody make a ssl connection or do you have to register a key or something ? You can make self signed certificate, that means that when accessing your site, a user will be prompted to accept your certificate, saying that no known authority has signed it. Hopefully, he will save the

Re: Witch apache, mysql and php do i need ?

2005-01-26 Thread Gert Cuykens
On Thu, 27 Jan 2005 14:19:30 +0700 (ICT), Olivier Nicole [EMAIL PROTECTED] wrote: Also can everybody make a ssl connection or do you have to register a key or something ? You can make self signed certificate, that means that when accessing your site, a user will be prompted to accept your

RE: Trouble starting MySQL

2005-01-13 Thread Freek Nossin
People should really check /usr/ports/CHANGES after synchronising the ports tree. One of the entries in the file is: (there are also entries for the other mysql versions) 20041019: AFFECTS: users of databases/mysql41-server AUTHOR: [EMAIL PROTECTED] The MySQL Daemon must now be enabled

<    6   7   8   9   10   11   12   13   14   15   >