upgrading mysql client and server

2006-09-02 Thread Dave
Hello, I've got mysql server and client v4.1 running on a FreeBSD6.x box. They were installed via ports not packages using custom make options which i have in portupgrade's pkgtools.conf file. I now would like to upgrade both of them to v5, without causing dependency issues with installed

Re: upgrading mysql client and server

2006-09-02 Thread Matthew Seaman
Dave wrote: I've got mysql server and client v4.1 running on a FreeBSD6.x box. They were installed via ports not packages using custom make options which i have in portupgrade's pkgtools.conf file. I now would like to upgrade both of them to v5, without causing dependency issues

RE: PHP5 and MySQL

2006-08-29 Thread Muhammad Omer Iqbal
So it seems that my ports collectionwas indeed out of date, even though I installed FreeBSD 6.1 only two weeks back. Lesson learnt: always update ports collection after installing FreeBSD. I am doing MySQL 5.0 instead of 5.1, I do not want a beta release, and I am comparing and doing an analysis

MySQL package loop

2006-08-28 Thread Nazar
Was trying to set up a quick web server on my old box, so I was using packages and run into a loopback. Whenever I try installing MySQL 5.1server, the package is also installing MySQL 5.1 client with it, but php5-mysql-5.1.2_1 is installing MySQL 4 client. I cant get MySQL v5 without getting rid

Re: MySQL package loop

2006-08-28 Thread Matthew Seaman
Nazar wrote: Was trying to set up a quick web server on my old box, so I was using packages and run into a loopback. Whenever I try installing MySQL 5.1server, the package is also installing MySQL 5.1 client with it, but php5-mysql-5.1.2_1 is installing MySQL 4 client. I cant get MySQL v5

PHP5 and MySQL

2006-08-27 Thread Muhammad Omer Iqbal
Hi folks, I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? Thanks Omer (Please do

Re: PHP5 and MySQL

2006-08-27 Thread Gerard Seibert
Muhammad Omer Iqbal wrote: I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can someone help and let me know what the right mailing list is? http

RE: PHP5 and MySQL

2006-08-27 Thread Muhammad Omer Iqbal
I have gone through the mysql and php docs and there are some possible solutions listed, none of those worked. Of course, I tried looking for a solution first before sending it here, this is like one of the last resort places, don't want to bug people with something trivial or easily fixable. I

Re: PHP5 and MySQL

2006-08-27 Thread Gerard Seibert
Muhammad Omer Iqbal wrote: I have gone through the mysql and php docs and there are some possible solutions listed, none of those worked. Of course, I tried looking for a solution first before sending it here, this is like one of the last resort places, don't want to bug people with something

RE: PHP5 and MySQL

2006-08-27 Thread Muhammad Omer Iqbal
I am sorry, being a newbie, I do not know what this means: Please don't top post! What version issue are you referring to? As for this: I am assuming that you installed both MySQL and PHP5 from an updated ports collection. Did you run: 'make config' in the PHP5 directory before building

RE: PHP5 and MySQL

2006-08-27 Thread Muhammad Omer Iqbal
@freebsd.org' Subject: RE: PHP5 and MySQL I am sorry, being a newbie, I do not know what this means: Please don't top post! What version issue are you referring to? As for this: I am assuming that you installed both MySQL and PHP5 from an updated ports collection. Did you run: 'make config

Re: PHP5 and MySQL

2006-08-27 Thread Matthew Seaman
Muhammad Omer Iqbal wrote: Looking through phpinfo, I do not find mysql or mysqli installed, even though I have enabled, remade and reinstalled both MySQL and PHP5. In fact, I think that my PHP5 is no longer remade, it just reconfigures it and reinstalls it because the build date shows

RE: PHP5 and MySQL

2006-08-27 Thread fbsd
: Sunday, August 27, 2006 6:08 AM To: freebsd-questions@freebsd.org Subject: PHP5 and MySQL Hi folks, I have problems with PHP5 and MySQL running together. I know this is a freebsd mailing list, not PHP/MySQL, but I am unable to find an appropriate mailing list for getting my problem resolved. Can

RE: PHP5 and MySQL

2006-08-27 Thread Muhammad Omer Iqbal
My installation also completed without any problems. However, it is the php5-mysql/mysqli libraries that are missing. This will show up as a problem only when you try to connect to mysql from a php web-page. Otherwise, my server runs php just fine, and I am also able to run mysql and issue

Re: PHP5 and MySQL

2006-08-27 Thread Mike Fern
hello, there are some mailing lists which may suit your needs. http://www.php.net/mailing-lists.php my recommendation is general user list. regards, ___ freebsd-questions@freebsd.org mailing list

RE: PHP5 and MySQL

2006-08-27 Thread Muhammad Omer Iqbal
Thank you for the help! It seems strange to have to install it again especially when I installed php5-extensions with mysql and mysqli extensions. When I tried to make, it tries to fetches MySQL 4.1 whereas I have 5.0 installed. How can I update the version? I have updated Makefile.ext in PHP5

RE: PHP5 and MySQL

2006-08-27 Thread fbsd
I have HTML/php5 web site that connects to mysql5 database and adds new records, deletes records and searches. Sounds to me like you did not do make options and select php-mysql interface of php5 before doing make install. For some reason in Freebsd 6.1 they removed php-mysql interface as default

RE: PHP5 and MySQL

2006-08-27 Thread Muhammad Omer Iqbal
And by the way, I already have MySQL 5.0 as a .tar in the mysql folder, so probably all I need to do is let php5-mysql extension know how to access that .tar file. -Original Message- From: Muhammad Omer Iqbal [mailto:[EMAIL PROTECTED] Sent: Sunday, August 27, 2006 9:48 AM To: 'Matthew

RE: PHP5 and MySQL

2006-08-27 Thread fbsd
and MySQL Thank you for the help! It seems strange to have to install it again especially when I installed php5-extensions with mysql and mysqli extensions. When I tried to make, it tries to fetches MySQL 4.1 whereas I have 5.0 installed. How can I update the version? I have updated Makefile.ext

Re: PHP5 and MySQL

2006-08-27 Thread Matthew Seaman
Muhammad Omer Iqbal wrote: And by the way, I already have MySQL 5.0 as a .tar in the mysql folder, so probably all I need to do is let php5-mysql extension know how to access that .tar file. A .tar of what? The sources? Better put them into /usr/ports/distfiles. It seems strange to have

MySQL 5.0.22 - 5.0.24 upgrade replication issue.

2006-08-22 Thread Andrew Tulloch
. Each of the MySQL instances is running inside a jail(8) on each of the two machines, the jails are full basic installs with no attempts to cut down the size. Each of the jails has a libmap.conf with the following: [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so

mysql version question

2006-08-17 Thread jan gestre
i recently upgraded the mysql 4.1.20 ports (both client and server) via portmanager to version 4.1.21, however as i login to the mysql prompt or phpmyadmin what i see is the old version, does this mean i still run on the old version? is there a way to fix these? TIA

Re: mysql version question

2006-08-17 Thread jan gestre
On 8/17/06, jan gestre [EMAIL PROTECTED] wrote: i recently upgraded the mysql 4.1.20 ports (both client and server) via portmanager to version 4.1.21, however as i login to the mysql prompt or phpmyadmin what i see is the old version, does this mean i still run on the old version

Re: mysql version question

2006-08-17 Thread Gerard Seibert
jan gestre wrote: On 8/17/06, jan gestre [EMAIL PROTECTED] wrote: i recently upgraded the mysql 4.1.20 ports (both client and server) via portmanager to version 4.1.21, however as i login to the mysql prompt or phpmyadmin what i see is the old version, does this mean i still run

Re: Mysql from ports

2006-08-03 Thread Ron Clark
OK, I rebuilt the box again and cvsuped my ports and got the machi= ne back to 5.5 STABLE. When I tried to install mysql server 5.1, I get the = following: === Running ldconfig /sbin/ldconfig -m /usr/local/lib/mysql === Ins= talling ldconfig configuration file cannot

Re: Problems with MySQL since upgrade

2006-08-03 Thread usleepless
research, and a number of places say that there are threading issues on FreeBSD 5 with MySQL thread when using the standard threading library. I'm going to recompile MySQL with the linuxpthreads option, and see if that stops this... i understand if this is of no use to you, but: switch

Re: Problems with MySQL since upgrade

2006-08-03 Thread Richard Morse
On Aug 3, 2006, at 3:36 PM, [EMAIL PROTECTED] wrote: Dear Ricky, i understand if this is of no use to you, but: switch to PostgreSQL as soon as you can. MySQL has given me nothing but trouble, especially on FBSD ( threads ). PGSQL is more complete, and faster on harder queries. Hi! Thanks

Re: Problems with MySQL since upgrade

2006-08-03 Thread Richard Morse
Hi! I finally figured out what was going on. Thanks for the people who gave suggestions. The query I thought was the problem really wasn't -- at some point between 5.0.13 and 5.0.22 a change was introduced which affected inner joins. I had a view which was aggresively created using

Re: Mysql from ports

2006-08-03 Thread Greg 'groggy' Lehey
On Thursday, 3 August 2006 at 12:39:00 -0400, Ron Clark wrote: OK, I rebuilt the box again and cvsuped my ports and got the machi= ne back to 5.5 STABLE. When I tried to install mysql server 5.1, I get the = following: === Running ldconfig /sbin/ldconfig -m /usr/local/lib

Re: Problems with MySQL since upgrade

2006-08-02 Thread Richard Morse
On Aug 1, 2006, at 9:24 AM, Richard Morse wrote: Hi! I recently updated MySQL to version 5.0.22 using the ports system (portupgrade -r -R mysql-\*). Previous to this, MySQL was behaving perfectly normally. Since the upgrade, I have found that every so often -- sometimes two or three

Re: Problems with MySQL since upgrade

2006-08-02 Thread Jim Stapleton
Not sure, seems more of a mysql question, but here's some guesses I have for diagnostics. could you run these queries? SELECT COUNT(*) FROM users WHERE status 3 SELECT COUNT(*) FROM sessiions WHERE sid = d9fe25949f79f2c767a0d237b4fdf841 SELECT COUNT(*) FROM FROM users u INNER JOIN sessions s

Re: Problems with MySQL since upgrade

2006-08-02 Thread Richard Morse
Hi! All of these queries worked just fine, without causing any problems. As this is more of a mysql issue, do you have any suggestions where it would be best for me to query them? Thanks, Ricky On Aug 2, 2006, at 9:36 AM, Jim Stapleton wrote: Not sure, seems more of a mysql question

Re: Problems with MySQL since upgrade

2006-08-02 Thread Jim Stapleton
I thought there were mysql forums, but I am not sure. In the queries I gave you, none of the results were too large I take it (not above the low thousands)? -Jim Stapleton On 8/2/06, Richard Morse [EMAIL PROTECTED] wrote: Hi! All of these queries worked just fine, without causing any

Re: Problems with MySQL since upgrade

2006-08-02 Thread Richard Morse
that there are threading issues on FreeBSD 5 with MySQL thread when using the standard threading library. I'm going to recompile MySQL with the linuxpthreads option, and see if that stops this... Thanks, Ricky On Aug 2, 2006, at 10:00 AM, Jim Stapleton wrote: I thought there were mysql forums, but I am

Mysql from ports

2006-08-02 Thread Ron Clark
Good day all, I am building a new server and need Mys= ql. I have tried to install 4.1 server and 5.0 server. Both error out durin= g the build. I try to restart the install and it installs, but then will no= t start because /var/log/mysql directory does not exist. I create

Re: Mysql from ports

2006-08-02 Thread Eric
Ron Clark wrote: Good day all, I am building a new server and need Mys=l. I have tried to install 4.1 server and 5.0 server. Both error out durin= the build. I try to restart the install and it installs, but then will no= start because /var/log/mysql directory does not exist

Re: Mysql from ports

2006-08-02 Thread Gerard Seibert
Ron Clark wrote: Good day all, I am building a new server and need Mysql. I have tried to install 4.1 server and 5.0 server. Both error out during the build. I try to restart the install and it installs, but then will not start because /var/log/mysql directory does not exist

Re: Mysql from ports

2006-08-02 Thread Ron Clark
server and 5.0 server. Both error out durin= the build. I try= to restart the install and it installs, but then will no= start beca= use /var/log/mysql directory does not exist. I create the direc=ory a= nd try to restart, to no avail

Problems with MySQL since upgrade

2006-08-01 Thread Richard Morse
Hi! I recently updated MySQL to version 5.0.22 using the ports system (portupgrade -r -R mysql-\*). Previous to this, MySQL was behaving perfectly normally. Since the upgrade, I have found that every so often -- sometimes two or three times a day, sometimes every other day, but no more

Re: Problems with MySQL since upgrade

2006-08-01 Thread Richard Morse
On Aug 1, 2006, at 9:38 AM, William Woodhams wrote: My first question would be what version of MySQL did you come from? This sometimes can have an effect on queries. Hi! My apologies for leaving this out. It was 5.0.13. Ricky ___ freebsd

MySQL Signal 10 on FreeBSD 6.0-RELEASE-P6

2006-07-31 Thread Erik Kristensen
Good Afternoon, I have an interesting issue with FreeBSD 6.0 and MySQL 5.0. Part of my problem has been discussed serveral times in the past on other mailing lists and it seems there has been fixes for older versions of MySQL. The MySQL server is currently receiving a SIGNAL 10 about once

Re: MySQL Signal 10 on FreeBSD 6.0-RELEASE-P6

2006-07-31 Thread Greg 'groggy' Lehey
On Monday, 31 July 2006 at 11:35:04 -0400, Erik Kristensen wrote: I have an interesting issue with FreeBSD 6.0 and MySQL 5.0. Part of my problem has been discussed serveral times in the past on other mailing lists and it seems there has been fixes for older versions of MySQL. From what you

Re: MySQL Signal 10 on FreeBSD 6.0-RELEASE-P6

2006-07-31 Thread Erik Kristensen
Thanks for the reply. I apologize, I should have been more clear with my first paragraph in my email. I have found several other somewhat similar problems with MySQL on FreeBSD 6.0 but with the MySQL 4.1.x series. Nothing in the Bug report you suggested bears much resemblance at first glance

Re: Memory usage for MySQL

2006-07-23 Thread Vinicius Vianna
, check limits also and see what the init scripts may be limiting on this process. HTH, DS Thaddeus Quintin wrote: I'm working on a FreeBSD 6.1 machine and setting up MySQL 5.0 with some InnoDB tables. The machine has 2GB of RAM and will primarily be used as a database machine and will also

Memory usage for MySQL

2006-07-19 Thread Thaddeus Quintin
I'm working on a FreeBSD 6.1 machine and setting up MySQL 5.0 with some InnoDB tables. The machine has 2GB of RAM and will primarily be used as a database machine and will also be serving files over NFS (not high volume). The issue that I'm having is that when I start up MySQL I get

Re: Memory usage for MySQL

2006-07-19 Thread Charles Swiger
On Jul 19, 2006, at 1:14 PM, Thaddeus Quintin wrote: The issue that I'm having is that when I start up MySQL I get a couple Out of Memory errors before it actually starts up. Looks like this- 060719 11:55:35 InnoDB: Started; log sequence number 0 43656 /usr/local/libexec/mysqld: Out

Re: Memory usage for MySQL

2006-07-19 Thread Thaddeus Quintin
for processes already (rebooted after changes)- kern.maxdsiz=1395864371 # 1.3GB kern.dfldsiz=1395864371 # 1.3GB kern.maxssiz=134217728 # 128MB From what I read, that should do it, but I still get those start up errors before MySQL decides to run. Maybe it has something to do with how

Re: Memory usage for MySQL

2006-07-19 Thread Charles Swiger
=134217728 # 128MB From what I read, that should do it, but I still get those start up errors before MySQL decides to run. Maybe it has something to do with how quickly MySQL is asking for memory? Or maybe it's trying to ask for a big shared memory segment...? -- -Chuck

Re: Memory usage for MySQL

2006-07-19 Thread Thaddeus Quintin
kern.dfldsiz=1395864371 # 1.3GB kern.maxssiz=134217728 # 128MB From what I read, that should do it, but I still get those start up errors before MySQL decides to run. Maybe it has something to do with how quickly MySQL is asking for memory? Or maybe it's trying to ask for a big shared

Re: Memory usage for MySQL

2006-07-19 Thread Charles Swiger
On Jul 19, 2006, at 2:51 PM, Thaddeus Quintin wrote: Or maybe it's trying to ask for a big shared memory segment...? Your guess is as good as mine. Are there tools or anything else I can use to try and figure this out? MySQL probably has some documentation which would help, although

RE: sshd/mysql errors.

2006-07-06 Thread fbsd
a firewall deny rule for will 192.168.48.66 stop all traffic from that domain. The real question is, do you really have real remote users who ssh into your system and or have remote users who access your mysql system? If not then add a firewall rule to deny the sshd mysql port numbers from entering

RE: sshd/mysql errors.

2006-07-05 Thread Marwan Sultan
packets from entering your system. Good chance attack packets are spoofed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marwan Sultan Sent: Tuesday, July 04, 2006 6:40 AM To: freebsd-questions@freebsd.org Subject: sshd/mysql errors. Hello gurus, my

sshd/mysql errors.

2006-07-04 Thread Marwan Sultan
Hello gurus, my logs full of hundreds of these lines..i starts since few days and up to day .. - Jul 2 00:00:03 server mysqld[28598]: warning: /etc/hosts.allow, line 25: can't verify hostname: getaddrinfo(host73.hostname_net, AF_INET) failed Jul 2 00:00:27 server sshd[83738]:

RE: sshd/mysql errors.

2006-07-04 Thread fbsd
PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marwan Sultan Sent: Tuesday, July 04, 2006 6:40 AM To: freebsd-questions@freebsd.org Subject: sshd/mysql errors. Hello gurus, my logs full of hundreds of these lines..i starts since few days and up to day .. - Jul 2 00:00:03 server mysqld[28598

snort and mysql connection at start troubles

2006-07-04 Thread César Amaya
Hi list I am installing SNORT 2.4.5 to log into a MySQL-5.1 database. snort logs are being stored fine into the db, but whe the system start snort fails because of this: snort[396]: FATAL ERROR: database: mysql_error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2

Re: snort and mysql connection at start troubles

2006-07-04 Thread Kevin Kinsey
César Amaya wrote: Hi list I am installing SNORT 2.4.5 to log into a MySQL-5.1 database. snort logs are being stored fine into the db, but whe the system start snort fails because of this: snort[396]: FATAL ERROR: database: mysql_error: Can't connect to local MySQL server through socket

Re: snort and mysql connection at start troubles

2006-07-04 Thread César Amaya
Kevin Kinsey wrote: César Amaya wrote: Hi list I am installing SNORT 2.4.5 to log into a MySQL-5.1 database. snort logs are being stored fine into the db, but whe the system start snort fails because of this: snort[396]: FATAL ERROR: database: mysql_error: Can't connect to local MySQL

Re: snort and mysql connection at start troubles

2006-07-04 Thread César Amaya
César Amaya wrote: Kevin Kinsey wrote: César Amaya wrote: Hi list I am installing SNORT 2.4.5 to log into a MySQL-5.1 database. snort logs are being stored fine into the db, but whe the system start snort fails because of this: snort[396]: FATAL ERROR: database: mysql_error: Can't connect

postfix+mysql not working with amavisd-new

2006-06-26 Thread Kyrre Nygard
Hello! Sorry if this is a bit off topic ... It appears that postfix won't use my mysql setup whenever amavisd-new is around. Does anyone know what to do? Thanks, Kyrre # tail /var/log/maillog amavis[46670]: (46670-02) Blocked TEMPFAIL, [80.201.214.30] [EMAIL PROTECTED] - [EMAIL

Re: MySQL RC script failing

2006-06-25 Thread Joe Auty
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This problem has been resolved... As it turns out, both parent mysql directories in /usr/local/share and /usr/local/lib were set with incorrect permissions. I was expecting that reinstalling the port would have corrected that, but clearly

Re: MySQL RC script failing

2006-06-23 Thread Dennis Olvany
060622 23:54:39 [ERROR] Can't find messagefile '/usr/local/share/mysql/english/errmsg.sys' http://bugs.mysql.com/bug.php?id=1455 This is typical for mixing files from different MySQL releases. Your errmsg.sys is most probably dtalled file from older release

MySQL RC script failing

2006-06-22 Thread Joe Auty
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm basically having the same problem described in this thread: http://lists.freebsd.org/pipermail/freebsd-questions/2004-December/ 067213.html A solution was never posted... Has anybody come up with something? This same RC script is working

Re: MySQL RC script failing

2006-06-22 Thread Dennis Olvany
I recall having to tinker with the rc script. Let's have a look at the script and also the log residing in the db root, probably /var/db/mysql. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions

Re: MySQL RC script failing

2006-06-22 Thread Joe Auty
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Jun 23, 2006, at 12:19 AM, Dennis Olvany wrote: I recall having to tinker with the rc script. Let's have a look at the script and also the log residing in the db root, probably /var/ db/mysql

Re: upgrading mysql-server

2006-06-11 Thread Michael P. Soulier
On 10/06/06 Gerard Seibert said: I'm not aware of any port doing this. If you use portupgrade, use the AFTERINSTALL configuration options to call the rc.d scripts and restart. You can configure 'portmanager' to stop and restart a program also. I was having the same problem with MySQL

Re: upgrading mysql-server

2006-06-10 Thread Riemer Palstra
On Fri, Jun 09, 2006 at 09:01:00PM -0400, Michael P. Soulier wrote: If the port is mysql41-server, maybe the package name should be similar? Ah, because the package is named mysql-server-4.1.20.tbz you mean? Hm, for people using packages, this would maybe make life easier, but to be honest, I

Re: upgrading mysql-server

2006-06-10 Thread Riemer Palstra
On Fri, Jun 09, 2006 at 09:08:03PM -0400, Michael P. Soulier wrote: And it shuts down my mysql server, but does not start it again. That's not very nice. Should the upgrade not handle this? I'm not aware of any port doing this. If you use portupgrade, use the AFTERINSTALL configuration options

Re: upgrading mysql-server

2006-06-10 Thread Gerard Seibert
Riemer Palstra wrote: On Fri, Jun 09, 2006 at 09:08:03PM -0400, Michael P. Soulier wrote: And it shuts down my mysql server, but does not start it again. That's not very nice. Should the upgrade not handle this? I'm not aware of any port doing this. If you use portupgrade, use

Re: upgrading mysql-server

2006-06-10 Thread Nikolas Britton
On 6/8/06, Michael P. Soulier [EMAIL PROTECTED] wrote: So, my nightly security report says that I should upgrade mysql-server. [EMAIL PROTECTED] ~]# pkg_info | grep mysql-server mysql-server-4.1.15 Multithreaded SQL database (server) But, what port does this correspond to? Simply cd

Re: upgrading mysql-server

2006-06-09 Thread Riemer Palstra
On Thu, Jun 08, 2006 at 06:40:01PM -0400, Michael P. Soulier wrote: [EMAIL PROTECTED] ~]# ls -d /usr/ports/databases/mysql*server /usr/ports/databases/mysql323-server/ /usr/ports/databases/mysql50-server/ /usr/ports/databases/mysql40-server//usr/ports/databases/mysql51-server/ /usr/ports

Re: upgrading mysql-server

2006-06-09 Thread Michael P. Soulier
On 09/06/06 Riemer Palstra said: I'm assuming mysql41-server, since it's version 4.1.15. Your assumption is right. Ok. Upgrading now. If the port is mysql41-server, maybe the package name should be similar? Thanks, Mike -- Michael P. Soulier [EMAIL PROTECTED] Any intelligent fool can

Re: upgrading mysql-server

2006-06-09 Thread Michael P. Soulier
On 09/06/06 Michael P. Soulier said: Ok. Upgrading now. And it shuts down my mysql server, but does not start it again. That's not very nice. Should the upgrade not handle this? Mike -- Michael P. Soulier [EMAIL PROTECTED] Any intelligent fool can make things bigger and more complex

upgrading mysql-server

2006-06-08 Thread Michael P. Soulier
So, my nightly security report says that I should upgrade mysql-server. [EMAIL PROTECTED] ~]# pkg_info | grep mysql-server mysql-server-4.1.15 Multithreaded SQL database (server) But, what port does this correspond to? [EMAIL PROTECTED] ~]# ls -d /usr/ports/databases/mysql*server /usr/ports

MySQL port won't understand SSL configuration directives

2006-06-04 Thread Matt Bostock
Hello, I compiled the MySQL port with WITH_OPENSSL=yes, but it won't start as it complains about the SSL directives in /etc/my.cnf; [ERROR] /usr/local/libexec/mysqld: unknown variable 'ssl-ca=/x' Any help is much appreciated, Matt

Re: MySQL port won't understand SSL configuration directives

2006-06-04 Thread Greg 'groggy' Lehey
On Sunday, 4 June 2006 at 15:07:39 +, Matt Bostock wrote: Hello, I compiled the MySQL port with WITH_OPENSSL=yes, but it won't start as it complains about the SSL directives in /etc/my.cnf; [ERROR] /usr/local/libexec/mysqld: unknown variable 'ssl-ca=/x' Any help is much

Re: MySQL port won't understand SSL configuration directives

2006-06-04 Thread Matt Bostock
Greg 'groggy' Lehey wrote: The FreeBSD ports of MySQL don't install a my.cnf file; if they did, it would be in /usr/local/etc/, not /etc. So it looks as if this is something you've done. Thanks for your reply Greg. From experience I've found that MySQL usually looks for /etc/my.cnf

installing MySQL with FreeBSD pkg_add

2006-05-20 Thread Peter Michaux
Hi, I am happy to have FreeBSD 6.1-RELEASE and KDE running on my intel box. I am now trying to install MySQL. I logged in as root and ran the following commands # pkg_add -r msql41-server Added group mysql Added user mysql # pkg_add -r mysql41-client mysql-client-4.1.18_1 or its older version

Re: installing MySQL with FreeBSD pkg_add

2006-05-20 Thread John Cruz
Peter, cp /usr/local/share/my-small.cnf /var/db/mysql/my.cnf. Have a look at your new config in /var/db/mysql and make any necessary adjustments. There's some other configs in /usr/local/share so if you need something other than the small configuration file copy that one over. All depends

RE: installing MySQL with FreeBSD pkg_add

2006-05-20 Thread fbsd
mysql_install_db --user=mysql from the command line to tell mysql to create its internel control db. Then mysql -u root should work. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Peter Michaux Sent: Saturday, May 20, 2006 11:58 AM To: freebsd-questions@freebsd.org

Re: installing MySQL with FreeBSD pkg_add

2006-05-20 Thread Kevin Kinsey
Peter Michaux wrote: # mysql -uroot ERROR 2002 (HY000): Can't connect to local MySQL server through socket 'tmp/mysql.sock' (2) What to do? The server isn't running. Start it, and this message will go away. If the port/package is correctly installed, then $ /usr/local/etc/rc.d/mysql

Mysql FreeBSD 6.x

2006-05-11 Thread Mohamad Babaei
Hi, Has anyone installed Mysql 4.x or 5.x on FreeBSD 6.x in a production environment? Is the problem with FreeBSD threading is still exist? (in Freebsd 4.x i used Linux threads in production and it works fine.) Regards, Mo ___ freebsd-questions

Re: Mysql FreeBSD 6.x

2006-05-11 Thread Riemer Palstra
On Thu, May 11, 2006 at 12:23:25PM +0430, Mohamad Babaei wrote: Has anyone installed Mysql 4.x or 5.x on FreeBSD 6.x in a production environment? Quite a few I think. Is the problem with FreeBSD threading is still exist? See these Wiki pages: http://wikitest.freebsd.org/moin.cgi/MySQL

Re: Mysql FreeBSD 6.x

2006-05-11 Thread Pietro Cerutti
On 5/11/06, Riemer Palstra [EMAIL PROTECTED] wrote: On Thu, May 11, 2006 at 12:23:25PM +0430, Mohamad Babaei wrote: Has anyone installed Mysql 4.x or 5.x on FreeBSD 6.x in a production environment? Quite a few I think. Is the problem with FreeBSD threading is still exist? See these Wiki

Re: Mysql FreeBSD 6.x

2006-05-11 Thread Nikos Vassiliadis
On Thursday 11 May 2006 14:54, Pietro Cerutti wrote: On 5/11/06, Riemer Palstra [EMAIL PROTECTED] wrote: On Thu, May 11, 2006 at 12:23:25PM +0430, Mohamad Babaei wrote: Has anyone installed Mysql 4.x or 5.x on FreeBSD 6.x in a production environment? Quite a few I think

Re: Mysql FreeBSD 6.x

2006-05-11 Thread Riemer Palstra
On Thu, May 11, 2006 at 01:54:18PM +0200, Pietro Cerutti wrote: How does one do that? I read the wiki page but didn't find any info about how to apply the switch libpthread - libthr.. My /etc/libmap.conf looks something like this: [mysqld] libc_r.so.5 libthr.so.2 libc_r.so.6

Re: Mysql FreeBSD 6.x

2006-05-11 Thread Pietro Cerutti
On 5/11/06, Riemer Palstra [EMAIL PROTECTED] wrote: On Thu, May 11, 2006 at 01:54:18PM +0200, Pietro Cerutti wrote: How does one do that? I read the wiki page but didn't find any info about how to apply the switch libpthread - libthr.. My /etc/libmap.conf looks something like this: [mysqld]

Re: mysql rc.d script

2006-04-19 Thread Lowell Gilbert
Vlad GURDIGA [EMAIL PROTECTED] writes: I have a FreeBSD 6-current build from almost the most recent source. I have installed mysql41-server port and observed a strange behaviour: as usual, I only have to put the mysqld_enable=yes in my /etc/rc.conf to have mysql server started at boot

Re: mysql rc.d script

2006-04-19 Thread Jerry McAllister
Vlad GURDIGA [EMAIL PROTECTED] writes: I have a FreeBSD 6-current build from almost the most recent source. I have installed mysql41-server port and observed a strange behaviour: as usual, I only have to put the mysqld_enable=yes in my /etc/rc.conf to have mysql server started at boot

mysql rc.d script

2006-04-18 Thread Vlad GURDIGA
Hello all, I have a FreeBSD 6-current build from almost the most recent source. I have installed mysql41-server port and observed a strange behaviour: as usual, I only have to put the mysqld_enable=yes in my /etc/rc.conf to have mysql server started at boot, but this time it did not work. I've

Unable to start MySQL

2006-04-13 Thread Gerard Seibert
I am unable to get the latest version of MySQL 5.1.7 running under FreeBSD 6.1 beta4. This is the output from the hostname.err file. 060409 20:06:04 mysqld started ^G/usr/local/libexec/mysqld: Can't find file: './mysql/general_log.frm' (errno: 13) 060409 20:06:05 InnoDB: Operating system

RE: Unable to start MySQL

2006-04-13 Thread Gayn Winters
[mailto:[EMAIL PROTECTED] On Behalf Of Gerard Seibert Sent: Thursday, April 13, 2006 3:35 PM To: Freebsd Questions Subject: Unable to start MySQL I am unable to get the latest version of MySQL 5.1.7 running under FreeBSD 6.1 beta4. This is the output from the hostname.err file

Re: mysql-server50 lacks supports for innodb ???

2006-03-27 Thread Ian Lord
At 02:47 2006-03-27, Glenn Dawson wrote: At 10:22 PM 3/26/2006, Ian Lord wrote: Hi, I just installed mysql-server50 port for the ports databases directory... I compiled it using defaults make make install and InnoDB is not available... What's wrong with the port ??? I have mysql50-server

Re: mysql-server50 lacks supports for innodb ???

2006-03-27 Thread Ian Lord
At 07:47 2006-03-27, Ian Lord wrote: At 02:47 2006-03-27, Glenn Dawson wrote: At 10:22 PM 3/26/2006, Ian Lord wrote: Hi, I just installed mysql-server50 port for the ports databases directory... I compiled it using defaults make make install and InnoDB is not available... What's wrong

Re: mysql-server50 lacks supports for innodb ???

2006-03-27 Thread Glenn Dawson
At 04:51 AM 3/27/2006, Ian Lord wrote: At 07:47 2006-03-27, Ian Lord wrote: At 02:47 2006-03-27, Glenn Dawson wrote: At 10:22 PM 3/26/2006, Ian Lord wrote: Hi, I just installed mysql-server50 port for the ports databases directory... I compiled it using defaults make make install

mysql-server50 lacks supports for innodb ???

2006-03-26 Thread Ian Lord
Hi, I just installed mysql-server50 port for the ports databases directory... I compiled it using defaults make make install and InnoDB is not available... What's wrong with the port ??? Thanks ___ freebsd-questions@freebsd.org mailing list http

Re: mysql-server50 lacks supports for innodb ???

2006-03-26 Thread Glenn Dawson
At 10:22 PM 3/26/2006, Ian Lord wrote: Hi, I just installed mysql-server50 port for the ports databases directory... I compiled it using defaults make make install and InnoDB is not available... What's wrong with the port ??? I have mysql50-server built and installed with the defaults

Re: mysql start on boot

2006-03-23 Thread Lowell Gilbert
eoghan [EMAIL PROTECTED] writes: Can I add something to my rc.conf to have mysql start at boot, something like: mysql_enable=YES? That or something like it, yes. See the script that the port added to the startup directory (/usr/local/etc/rc.d

Re: mysql for freebsd 6.0

2006-03-23 Thread Ludwig Pummer
kalin mintchev wrote: hi all... i can't see the mysql 5 version for freebsd 6.0 on the mysql developer site? am i blind or it's on purpose?!?! curious... and actually need it... thanks... /usr/ports/databases/mysql50-server/ /usr/ports/databases/mysql51-server/ I suggest you

Re: mysql for freebsd 6.0

2006-03-23 Thread Greg 'groggy' Lehey
On Thursday, 23 March 2006 at 0:52:18 -0500, kalin mintchev wrote: hi all... i can't see the mysql 5 version for freebsd 6.0 on the mysql developer site? am i blind or it's on purpose?!?! No, it's on its way. We should have a version up within a week or so. But you're the first

Re: mysql for freebsd 6.0

2006-03-23 Thread kalin mintchev
On Thursday, 23 March 2006 at 0:52:18 -0500, kalin mintchev wrote: hi all... i can't see the mysql 5 version for freebsd 6.0 on the mysql developer site? am i blind or it's on purpose?!?! No, it's on its way. We should have a version up within a week or so. But you're the first

<    2   3   4   5   6   7   8   9   10   11   >