Mysql Installation query

2005-09-13 Thread Vizion
I notice that the manual from http://www.mysql.com includes the following 
comments:
---

The recommended way to compile and install MySQL on FreeBSD with gcc (2.95.2 
and up) is:

CC=gcc CFLAGS=-O2 -fno-strength-reduce \
CXX=gcc CXXFLAGS=-O2 -fno-rtti -fno-exceptions \
-felide-constructors -fno-strength-reduce \
./configure --prefix=/usr/local/mysql --enable-assembler
gmake
gmake install
cd /usr/local/mysql
bin/mysql_install_db --user=mysql
bin/mysqld_safe 


Does anyone know if the above recomendations also apply to:

drwxr-xr-x  4 root  wheel 512 Sep  9 12:42 mysql50-client
drwxr-xr-x  3 root  wheel 512 Sep  4 19:11 mysql50-scripts
drwxr-xr-x  6 root  wheel 512 Sep  8 08:12 mysql50-server
and the other databases/mysql*
Thanks

david


40 yrs navigating and computing in blue waters.
English Owner  Captain of British Registered 60' bluewater Ketch S/V Taurus.
 Currently in San Diego, CA. Sailing bound for Europe via Panama Canal after 
completing engineroom refit.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Mysql Installation query

2005-09-13 Thread Greg 'groggy' Lehey
On Tuesday, 13 September 2005 at 18:46:38 -0700, Vizion wrote:
 I notice that the manual from http://www.mysql.com includes the following
 comments:
 ---

 The recommended way to compile and install MySQL on FreeBSD with gcc (2.95.2
 and up) is:

 CC=gcc CFLAGS=-O2 -fno-strength-reduce \
 CXX=gcc CXXFLAGS=-O2 -fno-rtti -fno-exceptions \
 -felide-constructors -fno-strength-reduce \
 ./configure --prefix=/usr/local/mysql --enable-assembler
 gmake
 gmake install
 cd /usr/local/mysql
 bin/mysql_install_db --user=mysql
 bin/mysqld_safe 
 

 Does anyone know if the above recomendations also apply to:

 drwxr-xr-x  4 root  wheel 512 Sep  9 12:42 mysql50-client
 drwxr-xr-x  3 root  wheel 512 Sep  4 19:11 mysql50-scripts
 drwxr-xr-x  6 root  wheel 512 Sep  8 08:12 mysql50-server
 and the other databases/mysql*

I suppose they apply, but are they correct?  For all versions of MySQL
I'd recommend using the ports collection, as with every other FreeBSD
port.

As of tomorrow, I'll be working for MySQL, so I will pay special
attention to MySQL problems on FreeBSD.  One of the things I'll be
looking at is bringing FreeBSD and MySQL recommendations into line
with each other.

Note the (unchanged) .sig to this message: please don't contact me
directly with topics of interest to FreeBSD-questions, unless you have
a good reason (like if you think I've missed something altogether).

Greg
--
When replying to this message, please copy the original recipients.
If you don't, I may ignore the reply or reply to the original recipients.
For more information, see http://www.lemis.com/questions.html
See complete headers for address and phone numbers.


pgpqVlCqMpRkP.pgp
Description: PGP signature


MySQL installation troubles ...

2004-04-07 Thread Mazen S. Alzogbi
Hi,

I am trying to install MySQL server  client from the packages 
collection with no success. Being a FreeBSD newbie I will need your 
help. Please check the following:

mazenbsd# pkg_add -r mysql-server
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/Latest/mysq 
l-server.tgz... Done.
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/p5-DBD- 
mysql-2.1026_1.tgz... Done.
pkg_add: could not find package mysql-client-4.0.15 !
pkg_add: pkg_add of dependency 'p5-DBD-mysql-2.1026_1' failed!
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/mysql-c 
lient-4.1.0.tgz... Done.

What I understood is p5-DBD-mysql-2.1026_1.tgz package depends on the 
mysql-client-4.0.15 package which cannot be found (how? why?) and 
instead the mysql-client-4.1.0.tgz package was installed. All in all the 
server installation failed.

What should I do to fix this?

TIA

Cheers,
--
Mazen S. Alzogbi
http://alzogbi.com/mazen
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: MySQL installation troubles ...

2004-04-07 Thread Andrew L. Gould
On Wednesday 07 April 2004 03:00 pm, Mazen S. Alzogbi wrote:
 Hi,

 I am trying to install MySQL server  client from the packages
 collection with no success. Being a FreeBSD newbie I will need your
 help. Please check the following:

 mazenbsd# pkg_add -r mysql-server
 Fetching
 ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/Latest/my
sq l-server.tgz... Done.
 Fetching
 ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/p5-DB
D- mysql-2.1026_1.tgz... Done.
 pkg_add: could not find package mysql-client-4.0.15 !
 pkg_add: pkg_add of dependency 'p5-DBD-mysql-2.1026_1' failed!
 Fetching
 ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/mysql
-c lient-4.1.0.tgz... Done.

 What I understood is p5-DBD-mysql-2.1026_1.tgz package depends on the
 mysql-client-4.0.15 package which cannot be found (how? why?) and
 instead the mysql-client-4.1.0.tgz package was installed. All in all the
 server installation failed.

 What should I do to fix this?


Try deleting the installed packages using pkg_delete; and then install the 
applications from the ports.

Best of luck,

Andrew Gould
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: MySQL installation troubles ...

2004-04-07 Thread Chris Strzelczyk
Try compiling instead of using pkg_add.  I've noticed this will work 
more often as packages are not available sometimes.

Make install all clean

Should do you well.

-cs

Mazen S. Alzogbi wrote:

Hi,

I am trying to install MySQL server  client from the packages 
collection with no success. Being a FreeBSD newbie I will need your 
help. Please check the following:

mazenbsd# pkg_add -r mysql-server
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/Latest/mysq 
l-server.tgz... Done.
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/p5-DBD- 
mysql-2.1026_1.tgz... Done.
pkg_add: could not find package mysql-client-4.0.15 !
pkg_add: pkg_add of dependency 'p5-DBD-mysql-2.1026_1' failed!
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/mysql-c 
lient-4.1.0.tgz... Done.

What I understood is p5-DBD-mysql-2.1026_1.tgz package depends on the 
mysql-client-4.0.15 package which cannot be found (how? why?) and 
instead the mysql-client-4.1.0.tgz package was installed. All in all 
the server installation failed.

What should I do to fix this?

TIA

Cheers,
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: MySQL installation troubles ...

2004-04-07 Thread Demian L'Ecuyer
Mazen S. Alzogbi wrote:

Hi,

I am trying to install MySQL server  client from the packages 
collection with no success. Being a FreeBSD newbie I will need your 
help. Please check the following:

mazenbsd# pkg_add -r mysql-server
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/Latest/mysq 
l-server.tgz... Done.
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/p5-DBD- 
mysql-2.1026_1.tgz... Done.
pkg_add: could not find package mysql-client-4.0.15 !
pkg_add: pkg_add of dependency 'p5-DBD-mysql-2.1026_1' failed!
Fetching 
ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-4.9-release/All/mysql-c 
lient-4.1.0.tgz... Done.

What I understood is p5-DBD-mysql-2.1026_1.tgz package depends on the 
mysql-client-4.0.15 package which cannot be found (how? why?) and 
instead the mysql-client-4.1.0.tgz package was installed. All in all 
the server installation failed.

What should I do to fix this?

TIA

Cheers,
Hello Mazen,

I'm not going to cover whats wrong with pkg_add -r because I don't know 
.. however, there are a couple of other ways to install MySQL. You could 
use the ports, build from source, or use binaries.  In my opinion, the 
quickest way to get things up and running is using the binaries.

First, go here: http://www.mysql.com/downloads/mysql-4.0.html
Second, download the first file from the FreeBSD downloads section ( 
Standard 4.0.18 9.4M )
Third, in the directory where you downloaded the file run this command, 
tar zxvf  mysql-standard-4.0.18-unknown-freebsd4.7-i386.tar.gz
Fourth, cd into the newly created directory and read the INSTALL-BINARY 
text file, that should give you what you need.

Hope this helps,
Thanatos
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


THREADSAFE, DHAVE-BROKEN-REALPATH; MySql Installation Errors.

2004-03-25 Thread samy lancher
Hello,
I am trying to install mysql4.0 on my FreeBSD4.7 system. When I gave make in 
usr/ports/databases/mysql40-server, the installation process went on on and on ... 
until i gave Ctrl-C. I think it is going into some kind of loop. During installation i 
saw several messages having words like THREADSAFE, DHAVE-BROKEN-REALPATH.
Does anyone had similar problem? Any suggestions?
 
Thanks in advance.
 
Naveen.
 



-
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: THREADSAFE, DHAVE-BROKEN-REALPATH; MySql Installation Errors.-SOLVED

2004-03-25 Thread samy lancher

Hello,
I did make install and the installation process took almost 8 mins but at the end 
mysql4.0 was installed without any problems. 
Thankyou very very much.
 
Naveen.
 

Eric F Crist [EMAIL PROTECTED] wrote:
On Thursday 25 March 2004 09:05 am, you wrote:
 Hello,
 I am trying to install mysql4.0 on my FreeBSD4.7 system. When I gave make
 in usr/ports/databases/mysql40-server, the installation process went on on
 and on ... until i gave Ctrl-C. I think it is going into some kind of loop.
 During installation i saw several messages having words like THREADSAFE,
 DHAVE-BROKEN-REALPATH. Does anyone had similar problem? Any suggestions?

Do a 'make install' and let it run. This will take a while. Start it, let it 
go, and wait for it to either 1) Error out, or 2) Finish successfully. Trust 
me, everything is fine.

-- 
Eric F Crist
AdTech Integrated Systems, Inc
(612) 998-3588

-
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: MySQL Installation

2002-07-22 Thread Marc Silver

Hi there,

You can install this with ease using the FreeBSD ports tree.

Simply cd into /usr/ports/databases/mysql323-server 

and type make install  

that'll install it all for you... :)  Good luck.

You'll need to consult the MySQL documentation for information on
adding/creating databases etc, but this will install the actual server
binaries etc for you.

- Marc

On Mon, Jul 22, 2002 at 11:28:37AM -0400, MET wrote:
 I was wondering if someone could be so kind as to write up directions
 for installing MySQL that makes sense.  I've read all of the
 documentation from their site that I can handle, and can take no more.
 Simply put I'm a Unix newbie, and their directions are definitely for
 someone with more knowledge than I.  I've just installed FreeBSD 4.6,
 clean install, without any GUI interface, CLI strictly.  The purpose of
 MySQL is for nothing more than a mere web database (I've been doing PHP
 + MySQL for years and figured I'd give server technology a try).
  
 Thank yous to the daring.
  
  
 - Matthew Metnetsky

To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



Re: MySQL Installation

2002-07-22 Thread Wayne Pascoe

MET [EMAIL PROTECTED] writes:

 I was wondering if someone could be so kind as to write up
 directions for installing MySQL that makes sense.  I've read all of
 the documentation from their site that I can handle, and can take no
 more.  Simply put I'm a Unix newbie, and their directions are
 definitely for someone with more knowledge than I.  I've just
 installed FreeBSD 4.6, clean install, without any GUI interface, CLI
 strictly.  The purpose of MySQL is for nothing more than a mere web
 database (I've been doing PHP + MySQL for years and figured I'd give
 server technology a try).

cd /usr/ports/databases/mysql323-server/
make install

Hope that helps.

-- 
- Wayne Pascoe  -  http://www.penguinpowered.org.uk/wayne/
Everything to excess. To enjoy the flavour of 
life, take big bites. Moderation is for 
monks. - Robert Heinlein


To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



Re: MySQL Installation

2002-07-22 Thread Jason Porter

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Use the ports.
# cd /usr/ports/databases/mysql323-server
# make install clean

As soon as it's all done you'll have to configure it, but that's pretty
straight forward.  Enjoy :)



MET wrote:

| Message
| I was wondering if someone could be so kind as to write up directions
| for installing MySQL that makes sense.  I've read all of the
| documentation from their site that I can handle, and can take no
| more.  Simply put I'm a Unix newbie, and their directions are
| definitely for someone with more knowledge than I.  I've just
| installed FreeBSD 4.6, clean install, without any GUI interface, CLI
| strictly.  The purpose of MySQL is for nothing more than a mere web
| database (I've been doing PHP + MySQL for years and figured I'd give
| server technology a try).
|  
| Thank yous to the daring.
|  
|  
| - Matthew Metnetsky
|  
|  
| /**
|  
|   Matthew Metnetsky
|  
|   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]_
|  
| **/
|  


- --
- -Jason Porter

Real programmers are secure enough to write
readable code, which they then self-righteously
refuse to explain.

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9PCUuYV2rputn/eARArNzAKCwQmpKMbfHD5wrefHLvN2swZ25FACgxcUi
SN4WKInimR4GWxdPojxEtJI=
=FAUx
-END PGP SIGNATURE-



To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message



Re: MySQL Installation

2002-07-22 Thread Kevin Golding

Someone, quite probably MET, once wrote:
I was wondering if someone could be so kind as to write up 
directions for installing MySQL that makes sense.  I've read all of 
the documentation from their site that I can handle, and can take 
no more.  Simply put I'm a Unix newbie, and their directions are 
definitely for someone with more knowledge than I.  I've just 
installed FreeBSD 4.6, clean install, without any GUI interface, 
CLI strictly.  The purpose of MySQL is for nothing more than a mere 
web database (I've been doing PHP + MySQL for years and figured I'd 
give server technology a try).

# cd /usr/ports/databases/mysql323-server
# make
# make install
# make clean

Congratulations :-)

You may want to read the following section of the handbook as it will
make so much of your life easier:
http://www.freebsd.org/doc/handbook/ports.html

Kevin
-- 
[EMAIL PROTECTED]

To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message