Re: MySQL on YDL, LinuxPPC, et al


Subject: Re: MySQL on YDL, LinuxPPC, et al
schinder@pobox.com
Date: Mon Sep 13 1999 - 16:40:18 MDT


On Mon, Sep 13, 1999 at 05:35:40PM -0400, Jason P. Stanford wrote:
} I'm sure this has been asked a million times already, but I *cannot*
} find any definitive info on this subject. I got the source rpm for
} 3.22.25, modified the SPEC file to exclude the "--enable-assembler" flag
} and (temporarily) use the "--without-perl" flag. I can build the
} binaries, and install them, but they always fail to run because of the
} following:
}
} 990913 17:29:54 /usr/sbin/mysqld: Incorrect information in file:
} './mysql/host.frm'
}
} I see occassional references in postings to this newsgroup that people
} do have MySQL up and running. What are the parameters necessary to make
} this happen? I don't want to put Postgres on, then a month or two down
} the road have to deal with switching and moving to MySQL. A lot of the
} PHP3 and Perl scripts I have written interface with MySQL, and would be
} a big pain (for now) to debug and "port" to Postgres.
}
} Any help of tips would be greatly appreciated... Thanks!

All you need to do is get rid of the "Big file support" section of
configure. After that you should have no troubles. I only
occasionally use mysql, and then almost always with perl and
DBD::mysql, and it works for me without problems. Here's a diff (this
is for 3.22.25):

linux% diff -u configure~ configure
--- configure~ Thu Jul 8 00:13:39 1999
+++ configure Sun Aug 15 18:13:44 1999
@@ -4724,25 +4724,25 @@
 fi
 
 
-# Big file support ? (Solaris 2.6 style)
-# This may have to be commented on Relient (Siemens) unix
-echo $ac_n "checking "for Sun style big file support"""... $ac_c" 1>&6
-echo "configure:4731: checking "for Sun style big file support"" >&5
-LFS_CFLAGS=`getconf LFS_CFLAGS 2>/dev/null`
-if test $? = 0 -a "$SYSTEM_TYPE" != "sni-sysv4"
-then
- CFLAGS="$CFLAGS $LFS_CFLAGS"
- CXXFLAGS="$CXXFLAGS $LFS_CFLAGS"
- #
- LFS_LDFLAGS=`getconf LFS_LDFLAGS`
- LDFLAGS="$LDFLAGS $LFS_LDFLAGS"
- #
- LFS_LIBS=`getconf LFS_LIBS`
- LIBS="$LIBS $LFS_LIBS"
- echo "$ac_t"""Found. Using C $LFS_CFLAGS LD $LFS_LDFLAGS LIB $LFS_LIBS"" 1>&6
-else
- echo "$ac_t"""No"" 1>&6
-fi
+# # Big file support ? (Solaris 2.6 style)
+# # This may have to be commented on Relient (Siemens) unix
+# echo $ac_n "checking "for Sun style big file support"""... $ac_c" 1>&6
+# echo "configure:4731: checking "for Sun style big file support"" >&5
+# LFS_CFLAGS=`getconf LFS_CFLAGS 2>/dev/null`
+# if test $? = 0 -a "$SYSTEM_TYPE" != "sni-sysv4"
+# then
+# CFLAGS="$CFLAGS $LFS_CFLAGS"
+# CXXFLAGS="$CXXFLAGS $LFS_CFLAGS"
+# #
+# LFS_LDFLAGS=`getconf LFS_LDFLAGS`
+# LDFLAGS="$LDFLAGS $LFS_LDFLAGS"
+# #
+# LFS_LIBS=`getconf LFS_LIBS`
+# LIBS="$LIBS $LFS_LIBS"
+# echo "$ac_t"""Found. Using C $LFS_CFLAGS LD $LFS_LDFLAGS LIB $LFS_LIBS"" 1>&6
+# else
+# echo "$ac_t"""No"" 1>&6
+# fi
 
 echo $ac_n "checking "need of special linking flags"""... $ac_c" 1>&6
 echo "configure:4749: checking "need of special linking flags"" >&5

}

-- 
Paul Schinder
schinder@pobox.com



This archive was generated by hypermail 2a24 : Fri Oct 01 1999 - 16:13:43 MDT