TCP Wrappers in 3.23.58

2004-01-31 Thread Alan W. Rateliff, II
Recently I became aware that MySQL 3.23.58 on my Solaris 8/x86 box was
ignoring my /etc/hosts.allow and /etc/hosts.deny files and permitting
unrestricted connection access to my MySQL daemon.

I use entries such as mysqld: 127.0.0.1 and mysqld: ALL in hosts.allow
and hosts.deny, respectively.

After attempting to configure with --with-libwrap=/path/to/tcp_wrappers, I
would get a failure with make.  I found an article [1] which presents an
updated tcpd.h file to use instead of the one native with
tcp_wrappers_7.6_ipv6 which I have been using.

Now configure recognizes and uses tcpd.h, but it seems that, unless I've
looked in the wrong places, sql/mysqld.cc doesn't include wrapper checks
unless HAVE_LIBWRAP is defined at compile time, and in my case it is not.

Has anyone else been successful including wrapper support with tcpd.h and
libwrap.a from the tcp_wrappers compiled source?

[1] http://linuxfromscratch.org/pipermail/blfs-dev/2002-December/001770.html

-- 
   Alan W. Rateliff, II:   RATELIFF.NET
 Independent Technology Consultant :[EMAIL PROTECTED]
  (Office) 850/350-0260:  (Mobile) 850/559-0100
-
[System Administration][IT Consulting][Computer Sales/Repair]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Reported to SpamCop

2003-03-19 Thread Alan W. Rateliff, II
A few minutes ago I noticed the emails from MySQL list were being rejected
at my server because of the mysql.com server being listed in SpamCop.

Information from http://spamcop.net/w3m?action=checkblockip=62.119.101.229
reveals that some of the spam messages that have made it through the list
were either reported to SpamCop by users, or filtered by SpamCop.

Just a heads-up.  Generally, it's not a good, nor fair, idea to report spam
received through a mailing list to SpamCop or other spam-catching entities,
for this very reason.  Now MySQL's list server has wound up on a block list.

query, mysql

--
   Alan W. Rateliff, II:   RATELIFF.NET
 Independent Technology Consultant :[EMAIL PROTECTED]
  (Office) 850/350-0260:  (Mobile) 850/559-0100
-
[System Administration][IT Consulting][Computer Sales/Repair]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Re: The Solaris 2.7 version of the binaries

2003-02-18 Thread Alan W. Rateliff, II
- Original Message -
From: Nesh Nenad Mijailovic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 5:23 PM
Subject: The Solaris 2.7 version of the binaries



  Hi All,

  is there a reason why there are no MySQL binaries for Solaris 2.7 any
more.
 I have been downloading the binaries before for Solaris 2.7 from the Web
 Site and now trying to compile the source doesn't work.

  Is it possible to put a link on the download page to a Solaris 2.7
binaries
 if you have them?

  Thanks,

 Nesh Nenad Mijailovic

The crew noted a while back that their Solaris 7 machine died and has yet to
be replaced.  Until then, what kind of problems are you having compiling on
Solaris 7?

Alternately, check out SunFreeware  http://sunfreeware.com  as Steve has
MySQL 3.23.53 ready to go for 7/SPARC.

--
   Alan W. Rateliff, II:   RATELIFF.NET
 Independent Technology Consultant :[EMAIL PROTECTED]
  (Office) 850/350-0260:  (Mobile) 850/559-0100
-
[System Administration][IT Consulting][Computer Sales/Repair]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Problems installing on Solaris/Intel

2002-10-15 Thread Alan W. Rateliff, II

- Original Message -
From: Jesse Sheidlower [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 5:07 PM
Subject: Re: Problems installing on Solaris/Intel



 I did check out the link below, in which someone else has an
 error identical to mine, and Sinisa Milivojevic replied
 basically saying that the answer is described in detail in the
 Manual.

 Well, I can't find it in the Manual. There are things somewhat
 related in the various Solaris sections, and I've tried them,
 such as adding -DHAVE_CURSES_H to the CFLAGS and CXXFLAGS,
 adding /opt/sfw/lib to the LD_LIBRARY_PATH variable, and
 adding the flags suggested at the Solaris X86 section.

 None of these work; it always breaks in the same way at the
 same place.

 I appreciate that it's probably my ignorance that's preventing
 me from figuring this out, if it is indeed described so obviously
 in the Manual, but I've discussed it with someone who's very
 knowledgable about MySQL and he's stumped too. So I would be
 very grateful if anyone could explain to me what it is I'm
 missing.

 I seem not to have mentioned in my original post that I'm running
 gcc 2.95.2 and SunOS 5.8 on x86.

First, install gcc 3.2.  Then, check out this link (thanks to John
Warburton):

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116929:200208:ngkbacmgkmgkdbbf
gjdo

The line numbers are different as of the latest MySQL version, but modifying
the configure script as shown (just search for some keyword using your
favorite text editor) works like a charm, promise.

Also, if you have crle configured already, you needn't worry about the
LD_LIBRARY_PATH variable.  I don't have it set on any of my boxen, and
everything runs peachy.

--
   Alan W. Rateliff, II:   RATELIFF.NET
 Independent Technology Consultant :[EMAIL PROTECTED]
  (Office) 850/350-0260:  (Mobile) 850/559-0100
-
[System Administration][IT Consulting][Computer Sales/Repair]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: How I compiled MySQL on Solaris 8

2002-08-13 Thread Alan W. Rateliff, II

- Original Message -
From: John Warburton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 3:17 AM
Subject: How I compiled MySQL on Solaris 8


 Hi All

 It seems that compiling MySQL on a Solaris 8 box is a non-trivial task if
your
 environment is different to the MySQL developers (whatever that is). It
has
 taken me a couple of days, hacking  trawling the mailing list to get a
 successful compile. I thought I would share my findings with others, and
hope
 that maybe it might be incorporated into the build and documentation (do I
have
 to submit a bug??).

Worked like a charm.  Thanks for all your hard work.  Looks like I'll be
updating my aged HOWTO :)

--
   Alan W. Rateliff, II:   RATELIFF.NET
 Independent Technology Consultant :[EMAIL PROTECTED]
  (Office) 850/350-0260:  (Mobile) 850/559-0100
-
[System Administration][IT Consulting][Computer Sales/Repair]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: compile problems on Solaris8

2001-11-30 Thread Alan W. Rateliff, II

On 30-Nov-01, Ravi Raman said something totally profound about RE: compile problems on 
Solaris8 that made me ponder...

RR It's been a while since I tried to compile mysql on a Solaris box, but
RR that error most like likely indicates a compiler-related issue...I don't
RR know how much help I can be with this, but one thing missing from your
RR earlier post is what arguments (if any) you passed to ./configure. I'd be
RR interested to see those if you could post them.
RR 
RR I was just about to hit send, when I got curious and found something: This
RR page (http://www.mysql.com/doc/S/o/Solaris.html) says to add a line to
RR your config.cache, and also has recommended configure arguments.

I've got a solid mini-HOWTO on compiling MySQL on Solaris.

 http://users.talstar.com/forager/MySQL-HOWTO.html 

This is what we use internally.  I have successfully compiled and installed
MySQL on Solaris 2.4, 2.5.1, 2.6, 7, and 8.

Normally, I get my packages from SunFreeware.  As of 07/01, the Solaris 8
Companion CD comes with the latest versions of bison and flex, as well as gcc
2.95.3.  Most programs I compile will not compile with gcc3.0.x from
SunFreeware.

You should have, at least, bison, flex, and gcc installed.  I also recommend
using tcp-wrappers.  Package v7.6 is included in the companion CD, but I
haven't tried them.  I used the source to compile two versions: auth and
non-auth.

Your PATH should be at least:
/usr/bin:/usr/sbin:/usr/local/bin:/usr/xpg4/bin:/usr/ccs/bin

If you use any of the companion CD packages, you should have /opt/sfw/bin
directly after /usr/local/bin.

That should be enough to get you going.  I have tested this time and time
again and various right-off-the-CD Solaris installations.

Don't forget to check the MySQl on-line documentation for performance
information.  Could save you a few headaches on slower boxes (I have MySQL
running on a 40MHz Sparc with Solaris 7.)  Now if I can just port this over to
Amiga :)
-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Build problems on Solaris 7 and 8.

2001-10-26 Thread Alan W. Rateliff, II

On 26-Oct-01, Jeff Wiegley, Ph.D. said something totally profound about Build problems 
on Solaris 7 and 8. that made me ponder...

JWP The only useful question in this message is:
JWP 
JWP How do I pass -Wl,-R/usr/local/lib to everything while
JWP configuring and compiling MySQL?

CXXFLAGS?

JWP Please don't tell me about adding LD_LIBRARY_PATH to
JWP my profile. That's just plain dumb when you should be
JWP able to pass -R to the linker.

I don't touch my LD_LIBRARY_PATH variable in Solaris 7 or 8.

JWP I find it impossible to believe the INSTALL-SOURCE file when it
JWP says We use and develop the software ourselves primarily on
JWP Sun Solaris (Versions 2.5 - 2.7) and SuSE Linux Version 7.x.
JWP 
JWP Get a stock Solaris x86 box. Install GCC and make from
JWP sunfreeware.com like any sane administrator would do.
JWP Get, compile and install the shared zlib libraries(let it compile
JWP into the default /usr/local/lib ./configure --shared)
JWP 
JWP Now try to install and compile MySQL and watch it barf on
JWP trying to find libz. I've got to add so much crap to CFLAGS, LDFLAGS
JWP and CXXFLAGS before trying to configure MySQL that having an
JWP automated build environment is basically useless.

I agree that there's a good bit of additional things to do to get MySQL to
compile, but I am successful in getting it to compile under these conditions:

Vanilla Solaris 8 (Sparc or i86) installation
gcc, bison, flex packages from SunFreeWare
PATH=/usr/bin:/usr/sbin:/usr/local/bin:/usr/xpg4/bin:/usr/ccs/bin
Then compile using my mini-HOWTO
http://users.talstar.com/forager/MySQL-HOWTO.html

No muss, no fuss.

JWP Oh so maybe try Solaris 8... Get GCC 3.0.1 and try to build with that and
JWP make...
JWP gcc -DDEFAULT_CHARSET_HOME=\/usr\ -DDATADIR=\/home/mysql\
JWP -DSHAREDIR=\/usr/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID
JWP -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -O3
JWP -DHAVE_CURSES_H -I/mnt/nfs/NTCSoftware/mysql/src/mysql-3.23.43/include
JWP -DHAVE_RWLOCK_T -c password.c -fPIC -DPIC -o .libs/password.lo Assembler:
JWP password.c
JWP /var/tmp/ccn6BEfI.s, line 166 : Illegal mnemonic
JWP /var/tmp/ccn6BEfI.s, line 166 : Syntax error
JWP /var/tmp/ccn6BEfI.s, line 222 : Illegal mnemonic
JWP /var/tmp/ccn6BEfI.s, line 222 : Syntax error
JWP /var/tmp/ccn6BEfI.s, line 378 : Illegal mnemonic
JWP /var/tmp/ccn6BEfI.s, line 378 : Syntax error
JWP /var/tmp/ccn6BEfI.s, line 457 : Illegal mnemonic
JWP /var/tmp/ccn6BEfI.s, line 457 : Syntax error

I found that gcc3.0.1 is giving me problems with a lot of programs, MySQL
included.  I've gone back to 2.95.3 for the time being.

But this list of errors above looks VERY familiar with the latest MySQL
release vs gcc3.0.1.

JWP So I highly doubt anyone would have an accurate answer for me even
JWP if I did include details. And the answers in the INSTALL-SOURCE file
JWP are silly. Why should I have to mess up my filesystems by putting all
JWP sorts of crazy symbolic links everywhere or rely on people to have
JWP LD_LIBRARY_PATH set when I should be able to just as easily pass -R
JWP (or other options) to the compiler and linker when they are doing their
JWP job. Then mysql would work even if I moved the binaries to a different
JWP machine that didn't have all the messy sym-links.

I think I read that file a long time ago.  I've compiled many many version
since then using my standard technique, and also by watching a listening to
the successes and failures of others on this list.

JWP I am however suggesting that people take a closer look at the
JWP configuration stage and get it right.

There are a good deal of things that could be fixed in the ./configure, I'll
grant that.

JWP So that's my rant in a nutshell.

I've had simliar ranting sessions while beating my desk.  Hope you do better
in the future.
-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Problems installing under solaris 2.5.1

2001-07-15 Thread Alan W. Rateliff, II

On 16-Jul-01, Colin Faber said something totally profound about Re: Problems 
installing under solaris 2.5.1 that made me ponder...

CF You need to make sure that the gcc on your box is build on that box, 
CF Using a package won't do it, most of them where compiled on greater or 
CF lesser hardware versions than you might be running, This in turn causes 
CF the compiler it self to think that its running in cross-compile mode 
CF and mysql won't allow a cross compile(er) build.

I've been using gcc packages from SunFreeware.com for the last couple of
years.  I've not run into this problem yet.  I have also always kept my
version of gcc recent, and have had no problems compiling, installing, or
running MySQL binaries created by gcc v3.0.

However, this question (installation problems on Solaris with the cross
compile error message) has been asked and answered on this list NUMEROUS times.  To 
quote every message on this list:

Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

[snip]

CF 
CF loading cache ./config.cache
CF checking for a BSD compatible install... ./install-sh -c
CF checking for bison... no
CF checking for byacc... no
CF checking for pdftex... no
CF checking return type of sprintf... configure: error: can not run test
CF program while cross compiling

You don't have bison, which is recommended, although off the top of my head I
can't remember where I read that.

I've been using the instructions detailed on my page below for quite some time
now, without incident.  The source of the page details from where I compiled the 
information.  Please keep in mind that that is a bare minimum install, and you may 
have other options you wish to use.

 http://users.talstar.com/forager/MySQL-HOWTO.html 

This has worked for SPARC Solaris 2.4, 2.5.1, 2.6, and 7, as well as Intel
Solaris 7 and 8.

Good luck.
-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: ./configure errorRe: Solaris

2001-07-10 Thread Alan W. Rateliff, II

Make sure gcc is in your PATH, and make sure it's been installed properly.
You might also want to try some test compilations.

--
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 



- Original Message -
From: sherzod ruzmetov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Mysql [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 1:17 PM
Subject: ./configure errorRe: Solaris



 Please,help1

 [sherzod@cral mysql-3.23.39]$ ./configure
 loading cache ./config.cache
 checking host system type... i586-pc-linux-gnu
 checking target system type... i586-pc-linux-gnu
 checking build system type... i586-pc-linux-gnu
 checking for a BSD compatible install... /usr/bin/install -c
 checking whether build environment is sane... yes
 checking whether make sets ${MAKE}... yes
 checking for working aclocal... missing
 checking for working autoconf... missing
 checking for working automake... missing
 checking for working autoheader... missing
 checking for working makeinfo... found
 checking whether to enable maintainer-specific portions of Makefiles... no
 checking whether build environment is sane... yes
 checking whether make sets ${MAKE}... (cached) yes
 checking for gawk... gawk
 checking for gcc... gcc
 checking whether the C compiler (gcc   ) works... yes
 checking whether the C compiler (gcc   ) is a cross-compiler... no
 checking whether we are using GNU C... yes
 checking whether gcc accepts -g... yes
 checking for c++... no
 checking for g++... no
 checking for gcc... gcc
 checking whether the C++ compiler (gcc   ) works... no
 configure: error: installation or configuration problem: C++ compiler
 cannot create executables.
 [sherzod@cral mysql-3.23.39]$


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Solaris Users: FIX (for src builds)

2001-07-07 Thread Alan W. Rateliff, II

I'm using the procedures outline in my Mini-HOWTO at
 http://users.talstar.com/forager/MySQL-HOWTO.html  and have been for
several versions now without incident.  The most important bit is the variable
settings right before running ./configure.

This is interesting info about gcc.  I'll see how this affects everything
else.

The source for the HTML page lists where I got the information on the page.

On 07-Jul-01, Phil Dibowitz said something totally profound about Solaris Users: FIX 
(for src builds) that made me ponder...

PD For those of you Solaris users who are compiling from source:
PD 
PD If you get  checking return type of sprintf... configure: error: can
PD not run test program while cross compiling such as in posts:

[snip]
PD 
PD and many more... than I have a fix for you. The SFW version of gcc and
PD gc++ that ships with Solaris 8 (and I believe also the versions that are
PD 
PD available on sunfreeware.com) are slightly faulted. You need to have
PD your LD_LIBRARY_PATH set. For the SFW packages make sure /opt/sfw/lib is
PD 
PD in your LD_LIBRARY_PATH (and I'm not quite sure what it is for the
PD sunfreeware.com versions, probably /usr/lib or /usr/local/lib).
PD 
PD That should fix the problem both on Sparc and Intel (I've personally
PD only tested this on intel, but I've been told the same situation exists
PD on the sparc versions too). Thanks to friend and co-worker Phil Brown
PD (www.bolthole.com)  for his help.

[snip]

-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Install help for x86 Solaris 8

2001-06-14 Thread Alan W. Rateliff, II

On 14-Jun-01, Daniel Vignes said something totally profound about Install help for x86 
Solaris 8 that made me ponder...

DV Hi,
DV 
DV I hope someone out there has an answer to this problem I'm having.
DV I'm trying to get mysql installed on a x86 Solaris 8 box,  the
DV version I'm trying to install is 3.23.39.  The configure script goes
DV through fine,  when then try to make it dies out giving me this

I had similar errors when trying to compile --with-assembler.  What are your
./configure options?

Try these instructions and work from there:
 http://users.talstar.com/forager/MySQL-HOWTO.html 

-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: libwrap problems (compiling) and config questions

2001-06-08 Thread Alan W. Rateliff, II

On 07-Jun-01, Jason Bradley Nance said something totally profound about libwrap 
problems (compiling) and config questions that made me ponder...

JBN Hello everyone.
JBN I have hit a snag trying to compile mysql 3.23.38.  After running 
JBN this configure command:

[snip]

JBN If I don't include the --with-libwrap config, then the build completes 
JBN just fine.

I don't know if this will help, but I've successfully compiled MySQL .38 on
Solaris 2.x machines using tcp-wrappers v7.6, using the configure option like
this:

--with-libwrap=/local/home/users/forager/tcpwrapper7.6/

I'm not sure what kind of wrappers RedHat comes with, so this may only be
academic for you.
-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Fail to compile on Solaris 8 Intel

2001-06-08 Thread Alan W. Rateliff, II

On 08-Jun-01, Super-User said something totally profound about Fail to compile on 
Solaris 8 Intel that made me ponder...

S Hi,
S 
S I keep running into the following error trying to compile (running
S ./configure) mysql -3.23.38 on Solaris 8 x86:
S 
S checking return type of sprintf... configure: error: can not run test
S program while cross compiling
S 
S I'm using gcc  2.95.3.
S 
S Has anyone compiled succesfully on sol8 x86 and is willing to give me
S some tips?
S 
S Thanks up front.

 http://users.talstar.com/forager/MySQL-HOWTO.html 

The most important part is your PATH (not listed, but your C compiler and make
should be in your path) and the variable settings before you execute
./configure.

Works like a charm everytime on Solaris 2.4, 2.5.1, 2.6, 7, and 8/i86. :)

-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RAID stripping for MySQL

2001-04-05 Thread Alan W. Rateliff, II

It was mentioned to me today that there are various RAID policies necessary
for optimal performance for diffferent programs such as SQL, Oracle, etc.
Are there any special or recommended policies (like stripe size, etc) for
MySQL running under Solaris 8/i86 with a PERC2/DC configured for RAID 5 on
the data drive?

Thanks.
--
Alan W. Rateliff, II - L.I.V.R.  // Only Amiga Makes it Possible
(Learned, Impartial and Very Relaxed)  \X/   Power for Creative Minds...
 This signature looks great if you don't use proportional fonts!  




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Solaris compilations

2001-02-13 Thread Alan W. Rateliff, II

Apparently I jumped the gun today when I posted my last message about
compiling on Solaris.  I had inadvertantly extracted and compiled an older
version of MySQL.

Tonight I compiled the latest version, 3.23.33, and it does indeed fix all the
shortcomings of the previous compiles with Solaris.  No more manual editing of
config files are necessary to successfully compile on Solaris.

YAY!
-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Issues compiling under Solaris

2001-02-12 Thread Alan W. Rateliff, II

Previously someone had mentioned that the issues covered by my FAQ (located at
 http://users.talstar.com/forager/MySQL-HOWTO.html ) had been taken care of
with releases past 3.23.28.  However, just tonight I found that the problem
with the broken Solaris term.h file still exists, and after running
./configure you will have to edit the config.h file and either comment out or
undef the line:

#define HAVE_TERM_H 1

BEFORE running make.  After that things will flow smoothly.

This holds true for Solaris 7/Sparc, and Solaris 8/i86 and Sparc.  Hope this
is helpful to people.

-- 
   Alan W. Rateliff, II: YourVillage.com
  Assistant Systems Administrator  :   2700 Apalachee Pkwy
  [EMAIL PROTECTED]   :  Tallahassee, FL 32301
(850) 942-7021---
 [EMAIL PROTECTED]  http://support.yourvillage.com 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php