Re: [Cooker] mysql-max 4.0.16 segfaults

[Oden Eriksson]

onsdagen den 12 november 2003 16.52 skrev Luca Berra:
> On Wed, Nov 12, 2003 at 01:02:58AM +0100, Oden Eriksson wrote:
> >onsdagen den 12 november 2003 00.06 skrev Luca Berra:
> >> 031112 00:03:52  mysqld started
> >> mysqld got signal 11;
> >
> >Weird. It's running just fine on 9.2. Would a rebuild help?
>
> nope, i tried rebuilding today
> mysqld works
> mysqld-max segfaults

Hmmm..., I'm using this in production and I'm not experiencing any problems 
like this. You're sure nothing's wrong at your end?

To be honest I'm not using max generally, but I have briefly switched over to 
max but had no problems.

Re: [Cooker] mysql-max 4.0.16 segfaults

[Luca Berra]

On Wed, Nov 12, 2003 at 01:02:58AM +0100, Oden Eriksson wrote:
onsdagen den 12 november 2003 00.06 skrev Luca Berra:
031112 00:03:52  mysqld started
mysqld got signal 11;
Weird. It's running just fine on 9.2. Would a rebuild help?
nope, i tried rebuilding today
mysqld works
mysqld-max segfaults
--
Luca Berra -- [EMAIL PROTECTED]
   Communication Media & Services S.r.l.
/"\
\ / ASCII RIBBON CAMPAIGN
 XAGAINST HTML MAIL
/ \

Re: [Cooker] mysql-max 4.0.16 segfaults

[Oden Eriksson]

onsdagen den 12 november 2003 00.06 skrev Luca Berra:
> 031112 00:03:52  mysqld started
> mysqld got signal 11;

Weird. It's running just fine on 9.2. Would a rebuild help?

[Cooker] mysql-max 4.0.16 segfaults

[Luca Berra]

031112 00:03:52  mysqld started
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this
binary
or one of the libraries it was linked against is corrupt, improperly
built,
or misconfigured. This error can also be caused by malfunctioning
hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x84491f8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Bogus stack limit or frame pointer, fp=0xbfffdb38,
stack_bottom=0x5040504, thread_stack=196608, aborting backtrace.
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x5040504  is invalid pointer
thd->thread_id=0
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
031112 00:03:52  mysqld ended
--
Luca Berra -- [EMAIL PROTECTED]
   Communication Media & Services S.r.l.
/"\
\ / ASCII RIBBON CAMPAIGN
 XAGAINST HTML MAIL
/ \

[Cooker] mysql and perl

[Marco Rothley]

Hello again!

Sorry my mistake! I just found that I produced a kind of dead lock in one of 
my scripts.

Marco.

[Cooker] MySQL and perl

[Marco Rothley]

Hello!

I have a problem with perl and MySQL since my last cooker update though I'm 
not sure if it is really a cooker problem:

All my perl scripts that try to access data from a MySQL data base hang when 
they try to make their first request. So I wrote a small testscript:

#!/usr/bin/perl

use DBI;
use strict;

my $dbh = DBI->connect('DBI:mysql:SHOP', 'marco', 'x');

my $sth = $dbh->prepare('SELECT * FROM session');
$sth->execute();
while(my @data = $sth->fetchrow_array()){
print "@data\n";
}
$dbh->disconnect();

and tried:
strace ./test_db_connect.pl

The last few lines of strace output are:
socket(PF_UNIX, SOCK_STREAM, 0) = 3
fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR)
connect(3, {sa_family=AF_UNIX, path="/var/lib/mysql/mysql.sock"}, 110) = 0
brk(0)  = 0x81a6000
brk(0x81a8000)  = 0x81a8000
setsockopt(3, SOL_IP, IP_TOS, [8], 4)   = -1 EOPNOTSUPP (Operation not 
supported)
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
read(3, "\'\0\0\0", 4)  = 4
read(3, "\n4.0.13\0\5\0\0\0*((/T8\\G\0, \10\2\0\0\0\0\0\0\0"..., 39) = 39
open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = 4
fstat64(4, {st_mode=S_IFREG|0755, st_size=621, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x40147000
read(4, "# sql/share/charsets/Index\n#\n# T"..., 4096) = 621
brk(0)  = 0x81a8000
brk(0x81a9000)  = 0x81a9000
read(4, "", 4096)   = 0
close(4)= 0
munmap(0x40147000, 4096)= 0
write(3, "\27\0\0\1\215 \0\0\0root\0^ET]SBXW\0SHOP", 27) = 27
read(3, "\5\0\0\2", 4)  = 4
read(3, "\0\0\0\2\0", 5)= 5
fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
read(3, 0x81a5bc8, 8192)= -1 EAGAIN (Resource temporarily 
unavailable)
fcntl64(3, F_SETFL, O_RDWR) = 0
write(3, "\26\0\0\0\3SELECT * FROM session", 26) = 26
read(3, 

that's it. No more output. I could wait for an hour, but no more output. Seems 
that mysql didn't responed to the Select query.

I tried the original RPMs from MySQL but no difference. As far as I remember, 
I updated some perl packages AND MySQL (all MySQL packages now Version 
4.0.13-3mdk, perl-5.8.0-28mdk, perl-DBI-1.37-2mdk, perl-Mysql-1.22_19-7mdk, 
but same effect with MySQL-xxx-4.0.13-0 packages from MySQL).

Any hints? Did anyone else recognize such a problem?


Thanks!

Marco

[Cooker] mysql-client: failed dependency on perl(the)

[Robert Kulagowski]

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

This is with synced cooker.


[EMAIL PROTECTED] mythtv]# urpmi mysql-client
Some package requested cannot be installed:
MySQL-client-4.0.13-1mdk.i586 (due to unsatisfied perl(the))
do you agree ? (Y/n) y
Everything already installed


"perl(the)"?

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use 

iQA/AwUBPto5Fvc1NpCTlP0JEQIHYQCgq9/eNLYyVGE4WEqLxD8JQiVXmdgAoOpI
L+539/Ur7cRgdQHwlYarX/Zs
=35NM
-END PGP SIGNATURE-

Re: [Cooker] MySQL-4.0.12-1mdk

[Oden Eriksson]

måndag 31 mars 2003 10:16 fm skrev Oden Eriksson:
> Hi.
>
> Here's a proposed patch to update MySQL to production status.

Oops, it seems I used a too old spec file but you probably see the tiny 
changes anyway.

-- 
Regards // Oden Eriksson, Deserve-IT.com

[Cooker] MySQL-4.0.12-1mdk

[Oden Eriksson]

Hi.

Here's a proposed patch to update MySQL to production status.

Chears.
-- 
Regards // Oden Eriksson, Deserve-IT.com--- MySQL.spec	2003-03-12 11:14:39.0 +0100
+++ MySQL.spec.oden	2003-03-31 09:42:32.0 +0200
@@ -1,6 +1,6 @@
 %define nameMySQL
-%define version			4.0.11a
-%define release 5mdk
+%define version			4.0.12
+%define release 1mdk
 %define major   12
 %define libname_orig	mysql
 %define libname %mklibname %{libname_orig} %{major}
@@ -21,13 +21,13 @@
 Release:%{release}
 License:	GPL
 #Source:http://www.mysql.com/Downloads/MySQL-3.23/
-Source: ftp.free.fr:/pub/MySQL/Downloads/MySQL-4.0/mysql-%{version}-gamma.tar.bz2
+Source0: mysql-%{version}.tar.gz
+Source1: mysql-%{version}.tar.gz.asc
 Patch0: mysql-4.0.9-init.patch.bz2
 Patch1: mysql-3.23.42-bench.patch.bz2
 Patch2:		mysql-3.23.51-other-libc.patch.bz2
 Patch3: mysql-3.23.54a-errno.patch.bz2
 Patch4: 	MySQL-4.0.11-fix-test-ssl-include.patch.bz2
-Patch5:		MySQL-4.0.11a-fix_install_scripts.patch.bz2
 Icon:		mysql.gif
 URL:http://www.mysql.com
 Provides:   msqlormysql MySQL-server mysqlserver mysql
@@ -101,7 +101,7 @@
 Group:  Development/Other
 Obsoletes:  MySQL-devel mysql-devel
 Provides:   MySQL-devel = %{version}-%{release} mysql-devel = %{version}-%{release} %{libname_orig}-devel = %{version}-%{release}
-Requires:   %{libname} = %{version} MySQL-common = %{version}-%{release} MySQL-client = %{version}-%{release}
+Requires:   %{libname} = %{version} MySQL = %{version}-%{release} MySQL-client = %{version}-%{release}
 
 %description -n %{libname}-devel
 This package contains the development header files and libraries
@@ -134,7 +134,7 @@
 package after the MySQL package.
 
 %prep
-%setup -q -n mysql-%{version}-gamma
+%setup -q -n mysql-%{version}
 %patch0 -p1 -b .server-stop
 
 ##%patch1 -b .patch
@@ -143,7 +143,6 @@
 #%patch3 -p1 -b .errno
 
 %patch4 -p1 -b .my_net
-%patch5 -p1 -b .max
 
 
 # 20021227 warly manual include files not in the archives
@@ -195,6 +194,7 @@
 --infodir=%{_infodir} \
 --includedir=%{_includedir} \
 --mandir=%{_mandir} \
+	--with-query-cache \
 --program-prefix= ;
 #	--with-comment=\"%{distribution} MySQL RPM\";
 	# Add this for more debugging support
@@ -217,7 +217,7 @@
 # Use the build root for temporary storage of the shared libraries.
 
 RBR=$RPM_BUILD_ROOT
-MBD=$RPM_BUILD_DIR/mysql-%{version}-gamma
+MBD=$RPM_BUILD_DIR/mysql-%{version}
 
 #
 # Use MYSQL_BUILD_PATH so that we can use a dedicated version of gcc
@@ -229,7 +229,7 @@
 # are using --with-other-libc
 
 # BuildMySQL "--disable-shared $USE_OTHER_LIBC_DIR --with-berkeley-db --with-innodb --with-mysqld-ldflags='-all-static' --with-server-suffix='-Max'"
-BuildMySQL "--enable-shared --with-berkeley-db --with-innodb --with-openssl --with-server-suffix='-Max'"
+BuildMySQL "--enable-shared --with-berkeley-db --with-innodb --with-openssl=%{_prefix} --with-server-suffix='-Max'"
 
 # Save mysqld-max
 mv sql/mysqld sql/mysqld-max
@@ -268,7 +268,7 @@
 
 %install -n mysql-%{version}
 RBR=$RPM_BUILD_ROOT
-MBD=$RPM_BUILD_DIR/mysql-%{version}-gamma
+MBD=$RPM_BUILD_DIR/mysql-%{version}
 # Ensure that needed directories exists
 install -d $RBR%{_sysconfdir}/{logrotate.d,rc.d/init.d}
 install -d $RBR%{_localstatedir}/mysql/mysql
@@ -369,10 +369,9 @@
 %pre common
 %_pre_useradd mysql %{_localstatedir}/mysql /bin/bash
 
-%post common
+%post
 %_install_info mysql.info
 
-%post
 # Initiate databases
 su - mysql -c "mysql_install_db -IN-RPM" > /dev/null
 
@@ -384,7 +383,7 @@
 # try to fix privileges table, use a no password user table for that
 fix_privileges() 
 {
-datadir=`my_print_defaults mysqld | grep '^--datadir=' | cut -d= -f2`
+datadir=`my_print_defaults mysqld | grep '^--datadir' | cut -d \  -f2-`
 if [ -z $datadir ]; then
 datadir=%{_localstatedir}/mysql/
 fi
@@ -418,9 +417,6 @@
 fi
 
 %post Max
-
-su - mysql -c "mysql_install_db -IN-RPM" > /dev/null
-
 %_post_service mysql-max
 # Allow mysqld_safe to start mysqld and print a message before we exit
 sleep 2
@@ -428,7 +424,7 @@
 # try to fix privileges table, use a no password user table for that
 fix_privileges() 
 {
-datadir=`my_print_defaults mysqld | grep '^--datadir=' | cut -d= -f2`
+datadir=`my_print_defaults mysqld | grep '^--datadir' | cut -d \  -f2-`
 if [ -z $datadir ]; then
 datadir=%{_localstatedir}/mysql/
 fi
@@ -470,7 +466,7 @@
 %_remove_install_info mysql.info
 
 %preun Max
-%_preun_service mysql-max
+%_preun_service mysql
 
 %post -n %{libname} -p /sbin/ldconfig
 %postun -n %{libname} -p /sbin/ldconfig
@@ -585,11 +581,9 @@
 %config(noreplace) /etc/rc.d/init.d/mysql-max
 
 %changelog
-* Wed Mar 12 2003 Warly <[EMAIL PROTECTED]> 4.0.11a-5mdk
-- Apply Benjamin Pflugmann patch to mysql_install_db
-
-* S

[Cooker] MySQL passwd aged

[Henri]

during urpmi --auto-select, this is the result for MySQL server :

314:MySQL  
##
You are required to change your password immediately (password aged)
(current) UNIX password:
su: Mot de passe incorrect.

Is it normal that the sql user can have a aged passwd ??

[Cooker] MySQL 4.x removed from cooker?

[Horst Gutmann]

Today I wanted to install MySQL 4.x from the cooker ( 
ftp://ftp-stud.fht-esslingen.de/pub/Mirrors/Mandrake-devel/cooker/cooker/Mandrake/ 
) and only got a 404 :( But it's still in the package list for this 
mirror. I also looked on another mirror and couldn't find it there either.

[Cooker] MySQL requires perl-DBI

[Guillaume Rousse]

perl-DBI is needed by MySQL-4.0.10-1mdk

I guess this is because MySQL use some perl script requiring perl MySQL 
interface, contained in the same package as the MySQL DBD driver, which 
requires perl-DBI. Yet another reason to split it.
-- 
Software bugs are impossible to detect by anybody except the end user. 
-- Murphy's Computer Laws n°10

Re: [Cooker] MySQL 4.0.11

[Benjamin Pflugmann]

On Thu 2003-02-27 at 11:50:37 +0100, [EMAIL PROTECTED] wrote:
> 
> We are in version freeze, however does some of you guys thinks this
> version fixes bugs very important for your personal usage?

Most of the fixes seem to be for bugs that are not encountered that
often (judging from lack of repeating reports on the main discussion
and the bug mailing lists). But there is one major change that may be
of interest:

 * `NULL' is now sorted *LAST* if you use `ORDER BY ... DESC' (as it
   was before before MySQL 4.0.2).  This is change was required to
   follow ANSI SQL 99.  (The original change was because we thought
   that ANSI SQL 99 required NULL to be always sorted at the same
   position, but this was wrong).

That is, only with 4.0.11 MySQL adheres to the SQL standard the same
as 3.23 in this regard. On the other hand, the whole MySQL beta cycle
passed until someone bothered to complain, so maybe that is not used
as much either.

For me, 4.0.10 works fine. On the other hand, with 4.0.6 the 4.0 cycle
has gone gamma status and in bug-squashing mode. So maybe 4.0.11
should be applied simply because it has to be considered mainly a
bug-fix release?

HTH,

Benjamin.



pgp0.pgp
Description: PGP signature

[Cooker] MySQL 4.0.11

[Warly]

We are in version freeze, however does some of you guys thinks this
version fixes bugs very important for your personal usage?

-- 
Warly

Re: [Cooker] MySQL-4.0.10+apache2-mod_mya

[Jean-Michel Dault]

Le ven 21/02/2003 à 14:21, Oden Eriksson a écrit :
 >
> > perl -pi -e "s/my_connect/mya_connect/g;" mod_mya.c
> 
> Thank you J-M, I tried this earlier and it built fine, but I didn't test it. 
> You mean that's it? It's a "go"?

I didn't test it, but after checking the source, that seemed like it was
the right thing to do, and it compiles, so... ;-)

Jean-Michel

Re: [Cooker] MySQL-4.0.10+apache2-mod_mya

[Oden Eriksson]

fredagen den 21 februari 2003 17.41 skrev Jean-Michel Dault:
> Le ven 21/02/2003 à 12:59, Oden Eriksson a écrit :
> > I'm trying to build "apache2-mod_mya", but I'm getting this error (with
> > mysql-4.0.10):
> >
> > apxs2 -DHAVE_STDDEF_H -I/usr/include/mysql -L/usr/lib -Wl,-lmysqlclient
> > -c mod_mya.c
> > /usr/lib/apache2-2.0.44/build/libtool --silent --mode=compile gcc
> > -prefer-pic -O2 -fomit-frame-pointer -pipe -march=i586 -mcpu=pentiumpro
> > -fno-omit-frame-pointer -DAP_HAVE_DESIGNATED_INITIALIZER -DLINUX=2
> > -D_REENTRANT -D_XOPEN_SOURCE=500 -D_BSD_SOURCE -D_SVID_SOURCE
> > -D_GNU_SOURCE -pthread -DRECORD_FORWARD -I/usr/include/apache2
> > -I/usr/include/mysql -DHAVE_STDDEF_H  -c -o mod_mya.lo mod_mya.c && touch
> > mod_mya.slo mod_mya.c:271: conflicting types for `my_connect'
> > /usr/include/mysql/mysql_com.h:181: previous declaration of `my_connect'
> > apxs:Error: Command failed with rc=65536
> > How do I get this done right? hack the source, but how?
> > http://www.synthemesc.com/mod_mya/
>
> perl -pi -e "s/my_connect/mya_connect/g;" mod_mya.c

Thank you J-M, I tried this earlier and it built fine, but I didn't test it. 
You mean that's it? It's a "go"?

-- 
Regards // Oden Eriksson, Deserve-IT.com

Re: [Cooker] MySQL-4.0.10+apache2-mod_mya

[Jean-Michel Dault]

Le ven 21/02/2003 à 12:59, Oden Eriksson a écrit :
> I'm trying to build "apache2-mod_mya", but I'm getting this error (with 
> mysql-4.0.10):
> 
> apxs2 -DHAVE_STDDEF_H -I/usr/include/mysql -L/usr/lib -Wl,-lmysqlclient -c 
> mod_mya.c
> /usr/lib/apache2-2.0.44/build/libtool --silent --mode=compile gcc -prefer-pic 
> -O2 -fomit-frame-pointer -pipe -march=i586 -mcpu=pentiumpro 
> -fno-omit-frame-pointer -DAP_HAVE_DESIGNATED_INITIALIZER -DLINUX=2 
> -D_REENTRANT -D_XOPEN_SOURCE=500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE 
> -pthread -DRECORD_FORWARD -I/usr/include/apache2 -I/usr/include/mysql 
> -DHAVE_STDDEF_H  -c -o mod_mya.lo mod_mya.c && touch mod_mya.slo
> mod_mya.c:271: conflicting types for `my_connect'
> /usr/include/mysql/mysql_com.h:181: previous declaration of `my_connect'
> apxs:Error: Command failed with rc=65536
> How do I get this done right? hack the source, but how?
> http://www.synthemesc.com/mod_mya/

perl -pi -e "s/my_connect/mya_connect/g;" mod_mya.c

Jean-Michel

[Cooker] MySQL-4.0.10+apache2-mod_mya

[Oden Eriksson]

Hi.


I'm trying to build "apache2-mod_mya", but I'm getting this error (with 
mysql-4.0.10):

apxs2 -DHAVE_STDDEF_H -I/usr/include/mysql -L/usr/lib -Wl,-lmysqlclient -c 
mod_mya.c
/usr/lib/apache2-2.0.44/build/libtool --silent --mode=compile gcc -prefer-pic 
-O2 -fomit-frame-pointer -pipe -march=i586 -mcpu=pentiumpro 
-fno-omit-frame-pointer -DAP_HAVE_DESIGNATED_INITIALIZER -DLINUX=2 
-D_REENTRANT -D_XOPEN_SOURCE=500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE 
-pthread -DRECORD_FORWARD -I/usr/include/apache2 -I/usr/include/mysql 
-DHAVE_STDDEF_H  -c -o mod_mya.lo mod_mya.c && touch mod_mya.slo
mod_mya.c:271: conflicting types for `my_connect'
/usr/include/mysql/mysql_com.h:181: previous declaration of `my_connect'
apxs:Error: Command failed with rc=65536


How do I get this done right? hack the source, but how?


http://www.synthemesc.com/mod_mya/


-- 
Regards // Oden Eriksson, Deserve-IT.com

Re: [Cooker] Mysql gui / frontend

[James Sparenberg]

Uh dont' forget my favorite ... webmin.  Works like a charm.

On Mon, 2003-02-17 at 16:59, Jason Straight wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> Sure there is - php and apache ;)
> 
> 
> 
> On Monday 17 February 2003 06:09 pm, J. Greenlees wrote:
> > Mandrake?
> >
> > they are lgpl so I doubt it is a licensing concern.
> >
> > ran into a shopkeeper that is using Mandrake 9 and he was complaining that
> > there wasn't a gui / frontend for Mysql. I checked thier site and found two
> > versions, on not being developed in favour of the other.
> >
> > if no-one knows why they haven't been packaged, I'll have to learn how to
> > build rpms, then upload the srpm to contrib. ( testing the option being
> > developed [ well actually compiling it to verify the functionality ] right
> > now )
> >
> >
> > Jaqui
> >
> > ---
> > ***Protect your PC from local E-Mail Application security
> > holes*** ***Maintain your Privacy - Passport Free***
> > ***Anti SPAM "Whitelist" feature***
> >
> > http://www.x-mail.net Web Based E-Mail, accessible anywhere
> >
> > Voice Messages, Voice Calls, Live Chat, X-Mail Messenger,
> > Personal Web Hosting, 128 bit SSL Secure, Calendar, Bookmarks,
> > Forwarding, Virtual Mail Map Aliasing
> >
> > X-Mail Premium: 20MB Messages, 100MB Storage, POP3, Ad Free
> 
> - -- 
> Jason Straight
> [EMAIL PROTECTED]
> icq: 1796276
> pgp: http://www.JeetKuneDoMaster.net/~jason/pubkey.asc
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.2.1 (GNU/Linux)
> 
> iQCVAwUBPlGFXRFHZPcobeHxAQKj0gQAh6YYSkP37yMdDsJ/0oskrhQXKOVSCiKE
> +3yzSy2l0I36EzLnTzSa0q2vs5dfNzKWv2m9Bfev0EiJvwhwOhEBwQiMT9Kk3Aq7
> YD7BfNHRX6Rg7LNmunwn0jDFoPCfiXOkD7mAN8gDSsOcyhrSHQFdCvhaHhbnJtGD
> fWCbpCqgn1A=
> =en/N
> -END PGP SIGNATURE-
> 
> 

Re: [Cooker] Mysql gui / frontend

[Jason Straight]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Sure there is - php and apache ;)



On Monday 17 February 2003 06:09 pm, J. Greenlees wrote:
> Mandrake?
>
> they are lgpl so I doubt it is a licensing concern.
>
> ran into a shopkeeper that is using Mandrake 9 and he was complaining that
> there wasn't a gui / frontend for Mysql. I checked thier site and found two
> versions, on not being developed in favour of the other.
>
> if no-one knows why they haven't been packaged, I'll have to learn how to
> build rpms, then upload the srpm to contrib. ( testing the option being
> developed [ well actually compiling it to verify the functionality ] right
> now )
>
>
> Jaqui
>
> ---
> ***Protect your PC from local E-Mail Application security
> holes*** ***Maintain your Privacy - Passport Free***
> ***Anti SPAM "Whitelist" feature***
>
> http://www.x-mail.net Web Based E-Mail, accessible anywhere
>
> Voice Messages, Voice Calls, Live Chat, X-Mail Messenger,
> Personal Web Hosting, 128 bit SSL Secure, Calendar, Bookmarks,
> Forwarding, Virtual Mail Map Aliasing
>
> X-Mail Premium: 20MB Messages, 100MB Storage, POP3, Ad Free

- -- 
Jason Straight
[EMAIL PROTECTED]
icq: 1796276
pgp: http://www.JeetKuneDoMaster.net/~jason/pubkey.asc
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)

iQCVAwUBPlGFXRFHZPcobeHxAQKj0gQAh6YYSkP37yMdDsJ/0oskrhQXKOVSCiKE
+3yzSy2l0I36EzLnTzSa0q2vs5dfNzKWv2m9Bfev0EiJvwhwOhEBwQiMT9Kk3Aq7
YD7BfNHRX6Rg7LNmunwn0jDFoPCfiXOkD7mAN8gDSsOcyhrSHQFdCvhaHhbnJtGD
fWCbpCqgn1A=
=en/N
-END PGP SIGNATURE-

[Cooker] Mysql gui / frontend

[J. Greenlees]

Mandrake?

they are lgpl so I doubt it is a licensing concern.

ran into a shopkeeper that is using Mandrake 9 and he was complaining that there wasn't
a gui / frontend for Mysql. I checked thier site and found two versions, on not being
developed in favour of the other.

if no-one knows why they haven't been packaged, I'll have to learn how to build rpms,
then upload the srpm to contrib. ( testing the option being developed [ well actually
compiling it to verify the functionality ] right now )


Jaqui

---
***Protect your PC from local E-Mail Application security holes***
***Maintain your Privacy - Passport Free***
***Anti SPAM "Whitelist" feature***

http://www.x-mail.net Web Based E-Mail, accessible anywhere

Voice Messages, Voice Calls, Live Chat, X-Mail Messenger,
Personal Web Hosting, 128 bit SSL Secure, Calendar, Bookmarks,
Forwarding, Virtual Mail Map Aliasing

X-Mail Premium: 20MB Messages, 100MB Storage, POP3, Ad Free

  

[Cooker] MySQL-Max with no SSL

[Toni Hermoso]

MySQL-Max-4.0.10-1mdk seems not to be compiled with OpenSSL. 
I think it's woth including it since it is a new hot 4.0 option.


-- 
Toni Hermoso Pulido
--
web: http://www.arrakis.es/~toniher
 http://caudeldrac.homelinux.org

email: [EMAIL PROTECTED]
[EMAIL PROTECTED]

pgp_public_key:
http://www.arrakis.es/~toniher/toniher.pgp

*** Cífratelo, cífraselo ***
--



signature.asc
Description: This is a digitally signed message part

Re: [Cooker] MySQL 4.0.9-1mdk

[Warly]

Linux Autrement <[EMAIL PROTECTED]> writes:

> Line 144 of /etc/init.d/mysql is incorrect.
>
> The check is for mysqld_safe and succeeds but the call is to
> safe_mysqld.

yes, it will be fixed in 4.0.10

-- 
Warly

[Cooker] MySQL 4.0.9-1mdk

[Linux Autrement]

Line 144 of /etc/init.d/mysql is incorrect.

The check is for mysqld_safe and succeeds but the call is to
safe_mysqld.


-- 
Dave Cotton
Directeur
Linux Autrement

Re: [Cooker] mysql not starting when using nss_ldap for groups ...

[Buchan Milne]

Martin Fahrendorf wrote:
> Am Mittwoch, 22. Januar 2003 15:39 schrieb Buchan Milne:

>>I tried to use "su - mysql -c '(existing safe_mysqld command)'" in the
>>init script, but that didn't work.
>>
>>Any ideas?
> 
> 
> Hm,
> 
> I use
> 
> cmd="$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file 2>&1 | logger -t 
>safe_mysqld &"
> su - mysql -c "$cmd"
> 
> in my mysql script in /etc/init.d and it works fine here. But if i recal fine, the 
>way
> su - mysql -c "$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file 2>&1 | 
>logger -t safe_mysqld &"
> does not work.
> 

Works for me ...

Warly, can you try this? Or must I submit a patch?


-- 
|--Another happy Mandrake Club member--|
Buchan MilneMechanical Engineer, Network Manager
Cellphone * Work+27 82 472 2231 * +27 21 8828820x121
Stellenbosch Automotive Engineering http://www.cae.co.za
GPG Key   http://ranger.dnsalias.com/bgmilne.asc
1024D/60D204A7 2919 E232 5610 A038 87B1 72D6 AC92 BA50 60D2 04A7

Re: [Cooker] mysql not starting when using nss_ldap for groups ...

[Martin Fahrendorf]

Am Mittwoch, 22. Januar 2003 15:39 schrieb Buchan Milne:
> On current cooker and 9.0 (at least, don't have 8.2 or 8.1 boxes around
> any more, but 8.0 is not affected), mysql won't start up when
> /etc/nsswitch.conf has 'ldap' in the group line:
>
> [bgmilne:~]# grep ^group /etc/nsswitch.conf
> group:  files ldap nisplus nis winbind3
> [bgmilne:~]# service mysql start
> Starting MySQL Server   [  OK  ]
> [bgmilne:~]# service mysql status
> mysqld is stopped
> [bgmilne:~]# mysql
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
>
>
> After removing the ldap entry from the group line in nsswitch.conf:
>
> [bgmilne:~]# grep ^group /etc/nsswitch.conf
> group:  files nisplus nis winbind3
> [bgmilne:~]# service mysql start
> Starting MySQL Server   [  OK  ]
> [bgmilne:~]# service mysql status
> mysqld (pid 10153) is running...
> 10152 (pid 10151) is running...
> [bgmilne:~]# mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 3.23.54
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> Bye
>
>
>
>
> If you su to mysql , you can manually start safe_mysqld even if you use
> nss_ldap for groups:
>
> [bgmilne:~]# service mysql status
> mysqld is stopped
> [bgmilne:~]# su - mysql
> -bash-2.05b$ grep ^group /etc/nsswitch.conf
> group:  files ldap nisplus nis winbind3
> -bash-2.05b$ safe_mysqld &
> [1] 9773
> -bash-2.05b$ Starting mysqld daemon with databases from /var/lib/mysql
>
> -bash-2.05b$ mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 1 to server version: 3.23.54
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> Bye
> -bash-2.05b$ logout
> [bgmilne:~]# service mysql status
> mysqld (pid 9782) is running...
> 9781 (pid 9780) is running...
> [bgmilne:~]#
> [bgmilne@bgmilne bgmilne]$ mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 2 to server version: 3.23.54
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> Bye
> [bgmilne@bgmilne bgmilne]$
>
> I tried to use "su - mysql -c '(existing safe_mysqld command)'" in the
> init script, but that didn't work.
>
> Any ideas?

Hm,

I use

cmd="$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file 2>&1 | logger -t 
safe_mysqld &"
su - mysql -c "$cmd"

in my mysql script in /etc/init.d and it works fine here. But if i recal fine, the way
su - mysql -c "$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file 2>&1 | 
logger -t safe_mysqld &"
does not work.

Martin
-- 

H E L I X Gesellschaft für Software & Engineering mbH

Hanauer Landstrasse 52  Telefon (069) 4789 35-30
60314 Frankfurt am Main Telefax (069) 4789 35-44

http://www.helix-gmbh.net[EMAIL PROTECTED]




msg88176/pgp0.pgp
Description: signature

Re: [Cooker] mysql not starting when using nss_ldap for groups ...

[Vincent Danen]

On Thu Jan 23, 2003 at 02:12:18PM +0200, Buchan Milne wrote:

> > Yes there is a bug in bugzilla for that. The problem is not mysql specific
> > and I have it with postgresql too.
> > 
> 
> Postgres works for me:
> 
> [bgmilne:~]# grep ^group /etc/nsswitch.conf
> group:  files ldap nisplus nis winbind3
> [bgmilne:~]# service postgresql start
> Starting postgresql service:[  OK  ]
> [bgmilne:~]# service postgresql status
> postmaster (pid 7808) is running...
> 7807 (pid 7805) is running...
> 
> I don't use postgres much, so don't even know how to create a db, but
> createuser is failing:
> 
> [bgmilne:~]# createuser root
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> psql: FATAL:  user "root" does not exist
> createuser: creation of user "root" failed
> 
> But that could just be my lack of experience with postgres.
> 
> Any way we can debug this?

Ummm... been a while since I've used postgres, but you can't do this as
root until root has an account.

su - postgres

first, then do the createuser stuff.  That should work.

-- 
MandrakeSoft Security; http://www.mandrakesecure.net/
"lynx -source http://linsec.ca/vdanen.asc | gpg --import"
{FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7  66F9 2043 D0E5 FE6F 2AFD}


msg87720/pgp0.pgp
Description: PGP signature

Re: [Cooker] mysql not starting when using nss_ldap for groups ...

[Buchan Milne]

Warly wrote:
> Buchan Milne <[EMAIL PROTECTED]> writes:

> Yes there is a bug in bugzilla for that. The problem is not mysql specific
> and I have it with postgresql too.
> 

Postgres works for me:

[bgmilne:~]# grep ^group /etc/nsswitch.conf
group:  files ldap nisplus nis winbind3
[bgmilne:~]# service postgresql start
Starting postgresql service:[  OK  ]
[bgmilne:~]# service postgresql status
postmaster (pid 7808) is running...
7807 (pid 7805) is running...

I don't use postgres much, so don't even know how to create a db, but
createuser is failing:

[bgmilne:~]# createuser root
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
psql: FATAL:  user "root" does not exist
createuser: creation of user "root" failed

But that could just be my lack of experience with postgres.

Any way we can debug this?

Buchan

-- 
|--Another happy Mandrake Club member--|
Buchan MilneMechanical Engineer, Network Manager
Cellphone * Work+27 82 472 2231 * +27 21 8828820x121
Stellenbosch Automotive Engineering http://www.cae.co.za
GPG Key   http://ranger.dnsalias.com/bgmilne.asc
1024D/60D204A7 2919 E232 5610 A038 87B1 72D6 AC92 BA50 60D2 04A7

Re: [Cooker] mysql not starting when using nss_ldap for groups ...

[Warly]

Buchan Milne <[EMAIL PROTECTED]> writes:

> On current cooker and 9.0 (at least, don't have 8.2 or 8.1 boxes around
> any more, but 8.0 is not affected), mysql won't start up when
> /etc/nsswitch.conf has 'ldap' in the group line:
>
> [bgmilne:~]# grep ^group /etc/nsswitch.conf
> group:  files ldap nisplus nis winbind3
> [bgmilne:~]# service mysql start
> Starting MySQL Server   [  OK  ]
> [bgmilne:~]# service mysql status
> mysqld is stopped
> [bgmilne:~]# mysql
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)

Yes there is a bug in bugzilla for that. The problem is not mysql specific
and I have it with postgresql too.

I do not investigate yet on this topic.

-- 
Warly

[Cooker] mysql not starting when using nss_ldap for groups ...

[Buchan Milne]

On current cooker and 9.0 (at least, don't have 8.2 or 8.1 boxes around
any more, but 8.0 is not affected), mysql won't start up when
/etc/nsswitch.conf has 'ldap' in the group line:

[bgmilne:~]# grep ^group /etc/nsswitch.conf
group:  files ldap nisplus nis winbind3
[bgmilne:~]# service mysql start
Starting MySQL Server   [  OK  ]
[bgmilne:~]# service mysql status
mysqld is stopped
[bgmilne:~]# mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)



After removing the ldap entry from the group line in nsswitch.conf:

[bgmilne:~]# grep ^group /etc/nsswitch.conf
group:  files nisplus nis winbind3
[bgmilne:~]# service mysql start
Starting MySQL Server   [  OK  ]
[bgmilne:~]# service mysql status
mysqld (pid 10153) is running...
10152 (pid 10151) is running...
[bgmilne:~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> Bye




If you su to mysql , you can manually start safe_mysqld even if you use
nss_ldap for groups:

[bgmilne:~]# service mysql status
mysqld is stopped
[bgmilne:~]# su - mysql
-bash-2.05b$ grep ^group /etc/nsswitch.conf
group:  files ldap nisplus nis winbind3
-bash-2.05b$ safe_mysqld &
[1] 9773
-bash-2.05b$ Starting mysqld daemon with databases from /var/lib/mysql

-bash-2.05b$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> Bye
-bash-2.05b$ logout
[bgmilne:~]# service mysql status
mysqld (pid 9782) is running...
9781 (pid 9780) is running...
[bgmilne:~]#
[bgmilne@bgmilne bgmilne]$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> Bye
[bgmilne@bgmilne bgmilne]$

I tried to use "su - mysql -c '(existing safe_mysqld command)'" in the
init script, but that didn't work.

Any ideas?


-- 
|--Another happy Mandrake Club member--|
Buchan MilneMechanical Engineer, Network Manager
Cellphone * Work+27 82 472 2231 * +27 21 8828820x121
Stellenbosch Automotive Engineering http://www.cae.co.za
GPG Key   http://ranger.dnsalias.com/bgmilne.asc
1024D/60D204A7 2919 E232 5610 A038 87B1 72D6 AC92 BA50 60D2 04A7

Re: [Cooker] MySQL-3.23.54a-1mdk

[Oden Eriksson]

fredagen den 3 januari 2003 01.14 skrev Mark Scott:
> Oden Eriksson wrote:
> > torsdagen den 2 januari 2003 22.25 skrev Mark Scott:
> >>Oden Eriksson wrote:
> >>>Hi.
> >>>
> >>>I'm trying to build MySQL-3.23.54a-1mdk on my ML9.0 system at home, but
> >>>it hangs at:
> >>>
> >>>perl -w ./Support/generate-mirror-listing.pl manual.texi > ../MIRRORS
> >>>
> >>>I was however able to build it on another similar system..., I can't
> >>>figure out what's wrong...
> >>
> >>Just got the same problem and found the cause - there's a missing '<'
> >>stdin redirection operator in the Docs Makefile, so the perl script is
> >>waiting indefinitely for input.
> >>
> >>The attached patch needs to be applied to Docs/Makefile.in. It should be
> >>in a suitable format to be bzipped and added to the spec.
> >
> > Thanks, but there appears to be the exact same thing with 3.23.53, but
> > that builds ok and 3.23.54a not. This is wierd...
>
> Did the patch make your 3.23.54a build work? If the build is interactive
> (i.e. started from a terminal), I found that pressing Ctrl-D at the hang
> point makes it continue. It might be something to do with perl/rpm and
> interactive/scripted invocation, but that's a wild guess.
>
> In case it's decided to include the Makefile.in patch, it might be
> better to use this version which also patches Makefile.am. I discovered
> that automake is called during %build - although by this time the Docs
> have been built. Better to play safe I think.
>
> I've also attached the alteration to the spec file to include the patch.

Cool, but I solved this as: 
http://www.mandrake.com/en/archives/cooker/2003-01/msg00084.php

Chears.
-- 
Regards // Oden Eriksson, Deserve-IT.com

Re: [Cooker] MySQL-3.23.54a-1mdk

[Mark Scott]

Oden Eriksson wrote:

torsdagen den 2 januari 2003 22.25 skrev Mark Scott:


Oden Eriksson wrote:


Hi.

I'm trying to build MySQL-3.23.54a-1mdk on my ML9.0 system at home, but
it hangs at:

perl -w ./Support/generate-mirror-listing.pl manual.texi > ../MIRRORS

I was however able to build it on another similar system..., I can't
figure out what's wrong...


Just got the same problem and found the cause - there's a missing '<'
stdin redirection operator in the Docs Makefile, so the perl script is
waiting indefinitely for input.

The attached patch needs to be applied to Docs/Makefile.in. It should be
in a suitable format to be bzipped and added to the spec.


Thanks, but there appears to be the exact same thing with 3.23.53, but that 
builds ok and 3.23.54a not. This is wierd...

Did the patch make your 3.23.54a build work? If the build is interactive 
(i.e. started from a terminal), I found that pressing Ctrl-D at the hang 
point makes it continue. It might be something to do with perl/rpm and 
interactive/scripted invocation, but that's a wild guess.

In case it's decided to include the Makefile.in patch, it might be 
better to use this version which also patches Makefile.am. I discovered 
that automake is called during %build - although by this time the Docs 
have been built. Better to play safe I think.

I've also attached the alteration to the spec file to include the patch.
--
Mark Scott
--- MySQL.spec~ 2002-12-30 13:59:33.0 +
+++ MySQL.spec  2003-01-03 00:13:41.0 +
@@ -26,6 +26,7 @@
 Patch1: mysql-3.23.42-bench.patch.bz2
 Patch2:mysql-3.23.51-other-libc.patch.bz2
 Patch3: mysql-3.23.54a-errno.patch.bz2
+Patch4: mysql-3.23.54a-mirrors.patch.bz2
 Icon:  mysql.gif
 URL:http://www.mysql.com
 Provides:   msqlormysql MySQL-server mysqlserver mysql
@@ -124,7 +125,7 @@
 %patch1 -b .patch
 %patch2 -p1 -b .other-libc
 #%patch3 -p1 -b .errno
-
+%patch4 -p1 -b .mirrors
 
 # 20021227 warly manual include files not in the archives
 perl -pi -e 's/\@include reservedwords.texi//' ./Docs/manual.texi

--- mysql-3.23.54a/Docs/Makefile.in.MIRRORS 2002-12-05 09:37:22.0 +
+++ mysql-3.23.54a/Docs/Makefile.in 2003-01-02 21:11:16.0 +
@@ -546,7 +546,7 @@
perl -w $(GT) mysql.info "LGPL license" "Function Index" > $@
 
 ../MIRRORS:manual.texi $(srcdir)/Support/generate-mirror-listing.pl
-   perl -w $(srcdir)/Support/generate-mirror-listing.pl manual.texi > $@
+   perl -w $(srcdir)/Support/generate-mirror-listing.pl < manual.texi > $@
 
 # Don't update the files from bitkeeper
 %::SCCS/s.%
--- mysql-3.23.54a/Docs/Makefile.am.mirrors 2003-01-03 00:02:29.0 +
+++ mysql-3.23.54a/Docs/Makefile.am 2003-01-03 00:02:53.0 +
@@ -146,7 +146,7 @@
perl -w $(GT) mysql.info "LGPL license" "Function Index" > $@
 
 ../MIRRORS:manual.texi $(srcdir)/Support/generate-mirror-listing.pl
-   perl -w $(srcdir)/Support/generate-mirror-listing.pl manual.texi > $@
+   perl -w $(srcdir)/Support/generate-mirror-listing.pl < manual.texi > $@
 
 # Don't update the files from bitkeeper
 %::SCCS/s.%

Re: [Cooker] MySQL-3.23.54a-1mdk

[Oden Eriksson]

torsdagen den 2 januari 2003 22.25 skrev Mark Scott:
> Oden Eriksson wrote:
> > Hi.
> >
> > I'm trying to build MySQL-3.23.54a-1mdk on my ML9.0 system at home, but
> > it hangs at:
> >
> > perl -w ./Support/generate-mirror-listing.pl manual.texi > ../MIRRORS
> >
> > I was however able to build it on another similar system..., I can't
> > figure out what's wrong...
>
> Just got the same problem and found the cause - there's a missing '<'
> stdin redirection operator in the Docs Makefile, so the perl script is
> waiting indefinitely for input.
>
> The attached patch needs to be applied to Docs/Makefile.in. It should be
> in a suitable format to be bzipped and added to the spec.
>
> N.B. The MIRRORS file will only contain 1 line once created, since there
> are no mirrors listed in the manual.texi input file.

Thanks, but there appears to be the exact same thing with 3.23.53, but that 
builds ok and 3.23.54a not. This is wierd...


-- 
Regards // Oden Eriksson, Deserve-IT.com

Re: [Cooker] MySQL-3.23.54a-1mdk

[Mark Scott]

Oden Eriksson wrote:

Hi.

I'm trying to build MySQL-3.23.54a-1mdk on my ML9.0 system at home, but it 
hangs at:

perl -w ./Support/generate-mirror-listing.pl manual.texi > ../MIRRORS

I was however able to build it on another similar system..., I can't figure 
out what's wrong...

Just got the same problem and found the cause - there's a missing '<' 
stdin redirection operator in the Docs Makefile, so the perl script is 
waiting indefinitely for input.

The attached patch needs to be applied to Docs/Makefile.in. It should be 
in a suitable format to be bzipped and added to the spec.

N.B. The MIRRORS file will only contain 1 line once created, since there 
are no mirrors listed in the manual.texi input file.
--
Mark Scott
--- mysql-3.23.54a/Docs/Makefile.in.MIRRORS 2002-12-05 09:37:22.0 +
+++ mysql-3.23.54a/Docs/Makefile.in 2003-01-02 21:11:16.0 +
@@ -546,7 +546,7 @@
perl -w $(GT) mysql.info "LGPL license" "Function Index" > $@
 
 ../MIRRORS:manual.texi $(srcdir)/Support/generate-mirror-listing.pl
-   perl -w $(srcdir)/Support/generate-mirror-listing.pl manual.texi > $@
+   perl -w $(srcdir)/Support/generate-mirror-listing.pl < manual.texi > $@
 
 # Don't update the files from bitkeeper
 %::SCCS/s.%

[Cooker] MySQL-3.23.54a-1mdk

[Oden Eriksson]

Hi.

I'm trying to build MySQL-3.23.54a-1mdk on my ML9.0 system at home, but it 
hangs at:

perl -w ./Support/generate-mirror-listing.pl manual.texi > ../MIRRORS

I was however able to build it on another similar system..., I can't figure 
out what's wrong...



-- 
Regards // Oden Eriksson, Deserve-IT.com

Re: [Cooker] mysql question

[slice91]

Le Mercredi 6 Novembre 2002 14:00, Oden Eriksson a écrit :
> onsdagen den 6 november 2002 14.54 skrev Per Øyvind Karlsen:
> > Oden Eriksson wrote:
> > >onsdagen den 6 november 2002 15.44 skrev [EMAIL PROTECTED]:
> > >>I have just installed mysql and i have this error
> > >>
> > >>ERROR 2002: Can't connect to local MySQL server through socket
> > >>'/var/lib/mysql/mysql.sock' (2)
> > >
> > >msec?
> > >
> > >chmod 755 /var/lib/mysql
> > >
> > >?
> >
> > or maybe he just have'nt started mysql?
> > service mysql start
> >
> > :)
>
> Ha ha ha ha ha !!!, funny !!!


Yeah, after i give permissions, it say me that i must see if mysqld is started
I start it and it's right

Thanks a lot

Re: [Cooker] mysql question

[Oden Eriksson]

onsdagen den 6 november 2002 14.54 skrev Per Øyvind Karlsen:
> Oden Eriksson wrote:
> >onsdagen den 6 november 2002 15.44 skrev [EMAIL PROTECTED]:
> >>I have just installed mysql and i have this error
> >>
> >>ERROR 2002: Can't connect to local MySQL server through socket
> >>'/var/lib/mysql/mysql.sock' (2)
> >
> >msec?
> >
> >chmod 755 /var/lib/mysql
> >
> >?
>
> or maybe he just have'nt started mysql?
> service mysql start
>
> :)

Ha ha ha ha ha !!!, funny !!!

-- 
Regards // Oden Eriksson, Deserve-IT Networks

Check the "Modules For Apache2" status page at: 
http://www.deserve-it.com/modules_for_apache2.html

Re: [Cooker] mysql question

[Oden Eriksson]

onsdagen den 6 november 2002 15.44 skrev [EMAIL PROTECTED]:
> I have just installed mysql and i have this error
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)

msec?

chmod 755 /var/lib/mysql

?

-- 
Regards // Oden Eriksson, Deserve-IT Networks

Check the "Modules For Apache2" status page at: 
http://www.deserve-it.com/modules_for_apache2.html

[Cooker] mysql question

[[EMAIL PROTECTED]]

I have just installed mysql and i have this error

ERROR 2002: Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (2)

Thanks for help

[Cooker] MySQL Server don't start if LDAP Authentication is enabled.

[MdkActe]

Hi,

another problem with ldap...

MySQL Server don't start if LDAP Authentication is enabled.
Problem exist with 9.0 and Cooker (20021017  1:33)

Packages:
MySQL-3.23.52-1mdk
MySQL-client-3.23.52-1mdk
libmysql10-3.23.52-1mdk
pam_ldap-148-3mdk
nss_ldap-194-3mdk
chkauth-0.1-7mdk

"strace mysqld -u mysql 2> strace.txt" with ldap autenthication enabled:

Relevant part of strace:
---
read(4, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1780
read(4, "", 4096)   = 0
close(4)= 0
munmap(0x4000, 4096)= 0
--- SIGSEGV (Segmentation fault) ---
write(2, "mysqld got signal 11;\nThis could"..., 247mysqld got signal 11;

So MySQL dies after reading /etc/nsswitch.conf, so my wild guess is that problem child 
is nss_ldap.

As long as there is ldap in nsswitch.conf at passwd: shadow: group: lines mysql dies, 
it doesn't matter if there is ldap enabled in
/etc/pam.d/system-auth or not, only nsswitch.conf have effect.

I also noticed that "chkauth file" doesn't remove ldap entries from nsswitch.conf.

Full strace:
---
execve("/usr/sbin/mysqld", ["mysqld", "-u", "mysql"], [/* 55 vars */]) = 0
fcntl64(0, F_GETFD) = 0
fcntl64(1, F_GETFD) = 0
fcntl64(2, F_GETFD) = 0
uname({sys="Linux", node="lokki.acte.fi", ...}) = 0
geteuid32() = 0
getuid32()  = 0
getegid32() = 0
getgid32()  = 0
getrlimit(0x3, 0xb0e8)  = 0
setrlimit(RLIMIT_STACK, {rlim_cur=2044*1024, rlim_max=RLIM_INFINITY}) = 0
getpid()= 11711
rt_sigaction(SIGRTMIN, {0x814dfc0, [], SA_RESTORER, 0x8167428}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x814d4f0, [], SA_RESTORER, 0x8167428}, NULL, 8) = 0
rt_sigaction(SIGRT_2, {0x814e030, [], SA_RESTORER, 0x8167428}, NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [RTMIN], NULL, 8) = 0
_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0xb0f0, 32, (nil), 0}) = 0
brk(0)  = 0x825ac28
brk(0x825ac58)  = 0x825ac58
brk(0x825b000)  = 0x825b000
brk(0x825c000)  = 0x825c000
open("/etc/localtime", O_RDONLY)= 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=682, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x4000
read(3, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\5\0\0\0\5\0"..., 4096) = 682
close(3)= 0
munmap(0x4000, 4096)= 0
time(NULL)  = 1034851521
uname({sys="Linux", node="lokki.acte.fi", ...}) = 0
open("/etc/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or 
directory)
open("/root/.my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
lstat64("/", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
rt_sigaction(SIGINT, {0x814e4c0, [], SA_RESTORER, 0x8167428}, {SIG_DFL}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [INT], NULL, 8) = 0
rt_sigaction(SIGALRM, {0x814e4c0, [], SA_RESTORER, 0x8167428}, {SIG_DFL}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigaction(SIGSEGV, {0x814e4c0, [], SA_RESTORER|SA_NOMASK|SA_ONESHOT, 0x8167428}, 
NULL, 8) = 0
rt_sigaction(SIGBUS, {0x814e4c0, [], SA_RESTORER|SA_NOMASK|SA_ONESHOT, 0x8167428}, 
NULL, 8) = 0
rt_sigaction(SIGILL, {0x814e4c0, [], SA_RESTORER|SA_NOMASK|SA_ONESHOT, 0x8167428}, 
NULL, 8) = 0
rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0
rt_sigaction(SIGTERM, {0x814e4c0, [], SA_RESTORER, 0x8167428}, {SIG_DFL}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [TERM], NULL, 8) = 0
rt_sigaction(SIGHUP, {0x814e4c0, [HUP], SA_RESTORER|SA_RESTART, 0x8167428}, {SIG_DFL}, 
8) = 0
rt_sigprocmask(SIG_SETMASK, [HUP QUIT PIPE TERM TSTP RTMIN], NULL, 8) = 0
open("/usr/share/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0755, st_size=549, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x4000
read(3, "# sql/share/charsets/Index\n#\n# T"..., 4096) = 549
brk(0x825e000)  = 0x825e000
read(3, "", 4096)   = 0
close(3)= 0
munmap(0x4000, 4096)= 0
stat64("/usr/share/mysql/charsets/dec8.conf", {st_mode=S_IFREG|0755, st_size=4384, 
...}) = 0
stat64("/usr/share/mysql/charsets/dos.conf", {st_mode=S_IFREG|0755, st_size=4383, 
...}) = 0
stat64("/usr/share/mysql/charsets/german1.conf", {st_mode=S_IFREG|0755, st_size=4387, 
...}) = 0
stat64("/usr/share/mysql/charsets/hp8.conf", {st_mode=S_IFREG|0755, st_size=4383, 
...}) = 0
stat64("/usr/share/mysql/charsets/koi8_ru.conf", {st_mode=S_IFREG|0755, st_size=4387, 
...}) = 0
stat64("/usr/share/mysql/charsets/latin2.conf", {st_mode=S_IFRE

[Cooker] mysql-3.23.52

[Oden Eriksson]

Hi.

Will this one make it into ML9.0?

http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.52.tar.gz

-- 
Regards // Oden Eriksson
Deserve-IT Networks -> http://d-srv.com

Re: [Cooker] MySQL required for kde3 dev ?

[Guillaume Rousse]

Le Samedi 3 Août 2002 16:04, Maks Orlovich a écrit :
> > As qt3 provide a database abstraction layer, it is linked against
> > libmysql, so libqt3-devel needs libmysql-devel.
>
> This is not accurate, the support is provided by a plugin; and I don't see
> a reason not to have the plugin in a separate package... Should I provide a
> .spec file patch?
You can, of course, but KDE maintainers seems to be relunctant to split their 
packages. Seems a good package should be at least 20Mo for them :-)

However, this would really make life easier (for users, of course). I hate to 
have ppp installed on my university box just because kdenetwork includes a 
dialer, for instance. And this would allows also to provide alternative 
boot-screen without file conflict...
-- 
Guillaume Rousse <[EMAIL PROTECTED]>
GPG key http://lis.snv.jussieu.fr/~rousse/gpgkey.html

Re: [Cooker] MySQL required for kde3 dev ?

[Maks Orlovich]

On Saturday 03 August 2002 08:55 am, Guillaume Rousse wrote:
> Le Samedi 3 Août 2002 14:43, Jérôme UZEL a écrit :
> > # urpme MySQL
> > Pour satisfaire les dépendances, les paquetages suivants vont être
> > désinstallés (55 Mo):
> > kdebase-devel-3.0.2-32mdk libqt3-devel-3.0.5-2mdk
> > kdelibs-devel-3.0.2-24mdk libmysql10-devel-3.23.51-3mdk
> > MySQL-3.23.51-3mdk Est-ce correct ? (O/n) O
> >
> > Is it the expected behaviour ?
>
> Unfortunatly, yes :-(
>
> As qt3 provide a database abstraction layer, it is linked against libmysql,
> so libqt3-devel needs libmysql-devel. 

This is not accurate, the support is provided by a plugin; and I don't see a 
reason not to have the plugin in a separate package... Should I provide a 
.spec file patch?

Re: [Cooker] MySQL required for kde3 dev ?

[Nelson Bartley]

It's been like that since KDE3 was released.

NB

On Sat, 2002-08-03 at 08:43, Jérôme UZEL wrote:
> # urpme MySQL
> Pour satisfaire les dépendances, les paquetages suivants vont être 
> désinstallés (55 Mo):
> kdebase-devel-3.0.2-32mdk libqt3-devel-3.0.5-2mdk 
> kdelibs-devel-3.0.2-24mdk libmysql10-devel-3.23.51-3mdk MySQL-3.23.51-3mdk
> Est-ce correct ? (O/n) O
> 
> Is it the expected behaviour ?
> 
> 
> 

Re: [Cooker] MySQL required for kde3 dev ?

[Guillaume Rousse]

Le Samedi 3 Août 2002 14:43, Jérôme UZEL a écrit :
> # urpme MySQL
> Pour satisfaire les dépendances, les paquetages suivants vont être
> désinstallés (55 Mo):
> kdebase-devel-3.0.2-32mdk libqt3-devel-3.0.5-2mdk
> kdelibs-devel-3.0.2-24mdk libmysql10-devel-3.23.51-3mdk MySQL-3.23.51-3mdk
> Est-ce correct ? (O/n) O
>
> Is it the expected behaviour ?
Unfortunatly, yes :-(

As qt3 provide a database abstraction layer, it is linked against libmysql, so 
libqt3-devel needs libmysql-devel. When you uninstall MySQL with every 
dependency, you trigger uninstall of all kde-devel package :-(

What i don't understand, however, if why libmysql-devel requires MySQL and 
MySQL-client ?
[guillaume@silbermann guillaume]$ rpm -q --requires libmysql10
rpmlib(VersionedDependencies) <= 3.0.3-1
/sbin/ldconfig
/sbin/ldconfig
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
rpmlib(CompressedFileNames) <= 3.0.4-1
ld-linux.so.2
libc.so.6
libcrypt.so.1
libm.so.6
libnsl.so.1
libpthread.so.0
libz.so.1
libc.so.6(GLIBC_2.0)
libc.so.6(GLIBC_2.1)
libc.so.6(GLIBC_2.1.2)
libc.so.6(GLIBC_2.1.3)
libc.so.6(GLIBC_2.2)
libpthread.so.0(GLIBC_2.0)
libpthread.so.0(GLIBC_2.2)
[guillaume@silbermann guillaume]$ rpm -q --requires libmysql10-devel
rpmlib(VersionedDependencies) <= 3.0.3-1
libmysql10 = 3.23.51
MySQL = 3.23.51-3mdk
MySQL-client = 3.23.51-3mdk
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
rpmlib(CompressedFileNames) <= 3.0.4-1
-- 
Guillaume Rousse <[EMAIL PROTECTED]>
GPG key http://lis.snv.jussieu.fr/~rousse/gpgkey.html

[Cooker] MySQL required for kde3 dev ?

[Jérôme UZEL]

# urpme MySQL
Pour satisfaire les dépendances, les paquetages suivants vont être 
désinstallés (55 Mo):
kdebase-devel-3.0.2-32mdk libqt3-devel-3.0.5-2mdk 
kdelibs-devel-3.0.2-24mdk libmysql10-devel-3.23.51-3mdk MySQL-3.23.51-3mdk
Est-ce correct ? (O/n) O

Is it the expected behaviour ?

[Cooker] MYSQL

[Magnus Holmberg]

I try to install and use MySQL. But I can't figure out how to sett a
password.

I try mysqladmin -p password test
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

What password is set when it is installed?

[Cooker] MySQL-Max

[Sebastian Dransfeld]

What's this? All the '.\c'?

root@tl-dhcp-100:/var/lib/mysql# service mysql restart
Stopping MySQL Server(pid 3019)Wait for mysqld to exit\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
.\c
[  OK  ]
Starting MySQL Server   [  OK  ]
root@tl-dhcp-100:/var/lib/mysql#

[Cooker] MySQL 3.23.50

[Christian Belisle]

Hi all

For those who noticed it, MySQL 3.23.50 is still a pre-release, meaning
that it's just a version to let the users report bugs before the
official release.

So for those who are interested, you can try this one. If you find bugs,
please report it to me as soon as possible, so I will report them to the
MySQL team for the official release (which should be out soon).

By the way, I compiled this one using gcc-3.1 because compiling it with
2.96 was causing table corruption. If all is ok, when the official
release will be out, we will probably update MySQL for older
distributions (it's an important bug fix).

Thanks,

-- 
Christian Belisle <[EMAIL PROTECTED]>
GPG Key: http://people.mandrakesoft.com/~cbelisle/cbelisle.asc

Re: [Cooker] MySQL-devel is a prereq, but there's no such package

[mandrake]

On Fri, 22 Feb, at 19:34:31 -0800, Quel Qun <[EMAIL PROTECTED]> done said:
> On Fri, 2002-02-22 at 10:27, Schlomo Schwartz wrote:
> > I'm in the process of trying to rebuild the cooker
> > snort SRPM and one of the BuildRequires is MySQL-devel
> > which doesn't appear to be a standard cooker package
> > anymore.  All I can find is MySQL, MySQL-client, and
> > MySQL-bench.  Are the mirrors on which I'm looking
> > missing something or
> > is MySQL-devel really not a standard package anymore?
> > 
> > 
> > __
> > Do You Yahoo!?
> > Yahoo! Sports - Coverage of the 2002 Olympic Games
> > http://sports.yahoo.com
> > 
> 
> surely libmysql10-devel-3.23.47-4mdk.i586.rpm

This wasn't included in any of betas up until now -- will it be included
in beta4, does anyone know?

Thanks,

-Charlie
-- 
GPG Key fingerprint = 4F36 EC4F 2F2C 5F59 9690  09E5 4C0F 9DB0 8623 53CE
You can't take it with you -- especially when crossing a state line.

Re: [Cooker] MySQL-devel is a prereq, but there's no such package

[Sergio Korlowsky]

On Thursday 21 February 2002 13:03, you wrote:
-> I'm in the process of trying to rebuild the cooker snort SRPM and one of
-> the BuildRequires is MySQL-devel which doesn't appear to be a standard
-> cooker package anymore.  All I can find is MySQL, MySQL-client, and
-> MySQL-bench.  Are the mirrors on which I'm looking missing something or
-> is MySQL-devel really not a standard package anymore?
->
-> -Charlie


This has been answered sooo many times!

libmysql10-3.23.47-4mdk.i586.rpm
libmysql10-devel-3.23.47-4mdk.i586.rpm

sk

[Cooker] MySQL-devel is a prereq, but there's no such package

[mandrake]

I'm in the process of trying to rebuild the cooker snort SRPM and one of
the BuildRequires is MySQL-devel which doesn't appear to be a standard
cooker package anymore.  All I can find is MySQL, MySQL-client, and
MySQL-bench.  Are the mirrors on which I'm looking missing something or
is MySQL-devel really not a standard package anymore?

-Charlie
-- 
GPG Key fingerprint = 4F36 EC4F 2F2C 5F59 9690  09E5 4C0F 9DB0 8623 53CE
I don't get no respect.

Re: [Cooker] MySQL-devel is a prereq, but there's no such package

[R.I.P. Deaddog]

On Fri, 22 Feb 2002, Schlomo Schwartz wrote:

> > surely libmysql10-devel-3.23.47-4mdk.i586.rpm
> 
> Why has this package been renamed?  Even Red Hat's
> rawhide still calls it mysql-devel (not to mention
> what RPMs you can download from mysql.com).  I just
> don't understand why these package names can't stick
> to the standard of what everyone else in the linux
> world knows them as.  Makes Mandrake look like they're
> the oddballs.
> 
> Thanks for the reply.

Have a look at

http://people.mandrakesoft.com/~warly/files/policy/index.html#N39

before making more comments.

Abel

Re: [Cooker] MySQL-devel is a prereq, but there's no such package

[Schlomo Schwartz]

--- Quel Qun <[EMAIL PROTECTED]> wrote:
> On Fri, 2002-02-22 at 10:27, Schlomo Schwartz wrote:
> > I'm in the process of trying to rebuild the cooker
> > snort SRPM and one of the BuildRequires is
> MySQL-devel
> > which doesn't appear to be a standard cooker
> package
> > anymore.  All I can find is MySQL, MySQL-client,
> and
> > MySQL-bench.  Are the mirrors on which I'm looking
> > missing something or
> > is MySQL-devel really not a standard package
> anymore?
> > 
> > 
> > __
> > Do You Yahoo!?
> > Yahoo! Sports - Coverage of the 2002 Olympic Games
> > http://sports.yahoo.com
> > 
> 
> surely libmysql10-devel-3.23.47-4mdk.i586.rpm

Why has this package been renamed?  Even Red Hat's
rawhide still calls it mysql-devel (not to mention
what RPMs you can download from mysql.com).  I just
don't understand why these package names can't stick
to the standard of what everyone else in the linux
world knows them as.  Makes Mandrake look like they're
the oddballs.

Thanks for the reply.

-s

__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

Re: [Cooker] MySQL-devel is a prereq, but there's no such package

[Quel Qun]

On Fri, 2002-02-22 at 10:27, Schlomo Schwartz wrote:
> I'm in the process of trying to rebuild the cooker
> snort SRPM and one of the BuildRequires is MySQL-devel
> which doesn't appear to be a standard cooker package
> anymore.  All I can find is MySQL, MySQL-client, and
> MySQL-bench.  Are the mirrors on which I'm looking
> missing something or
> is MySQL-devel really not a standard package anymore?
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.com
> 

surely libmysql10-devel-3.23.47-4mdk.i586.rpm

=-=
kk1

[Cooker] MySQL-devel is a prereq, but there's no such package

[Schlomo Schwartz]

I'm in the process of trying to rebuild the cooker
snort SRPM and one of the BuildRequires is MySQL-devel
which doesn't appear to be a standard cooker package
anymore.  All I can find is MySQL, MySQL-client, and
MySQL-bench.  Are the mirrors on which I'm looking
missing something or
is MySQL-devel really not a standard package anymore?


__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

Re: [Cooker] mysql

[Jeremy Salch]

Yep thanks I found it and got one.  

On Wednesday 20 February 2002 05:17 pm, you wrote:
> Jeremy Salch wrote:
> > I installed MySQL on my system and it didn't create a config file.
> > I would think that a config file should be made shouldn't it /?
>
> There's no default configuration file in /etc, but you can look at
> /usr/share/mysql to see many configuration files examples.
>
> Chris

Re: [Cooker] mysql

[Christian Belisle]

Jeremy Salch wrote:
> 
> I installed MySQL on my system and it didn't create a config file.
> I would think that a config file should be made shouldn't it /?

There's no default configuration file in /etc, but you can look at
/usr/share/mysql to see many configuration files examples.

Chris

[Cooker] mysql

[Jeremy Salch]

I installed MySQL on my system and it didn't create a config file.
I would think that a config file should be made shouldn't it /?

[Cooker] MySQL-devel?

[Vincent Meyer, MD]

Hi, 

qt3 wants MySQL-devel as a dependency to install, and as far
as I can tell, it isn't on any of my favorite mirrors...

V.

[Cooker] MySQL-InnoDB

[Christian Belisle]

Ok, I built a special version of MySQL with the InnoDB engine
(www.innodb.com).

If you are interested, I want you to test the package to see if it's
enough stable and fast to include it in the main distrib. Not in the
8.1, but maybe in the next one (I hope so).

Here is my web page where you can download it:
https://qa.mandrakesoft.com/~cbelisle/

Thank you to those who will test it!

Chris

Re: [Cooker] MySQL with InnoDB

[Christian Zoffoli]

Christian Belisle wrote:
> 
> InnoDB is a database engine for MySQL.
> 
> Look at the feature list... www.innodb.com/features.html
> 
> I found it very interesting. It's fast. But it's not as stable as the
> current database engine in MySQL. MySQL 3.23.38 had some problems with
> InnoDB if I remember well. That's why I would like to make a RPM, put it
> on my home page (btw, I need to have one...). And if we see, after few
> releases that InnoDB is enough fast & stable, we could include it
> instead of the current MySQL with the current DB engine.
> 
> I explain badly, I know, but look at the web site... very interesting
> :-)
> 
> Chris

mmm... interesting!!
I'll have a look ...thanks!

Christian

-- 
[EMAIL PROTECTED], OpenPGP key available on www.keyserver.net
1024D/2D3C2E70   6241 A35C DD72 242E 5430  2D01 F732 1EEF 2D3C 2E7

 - Littlepenguin Team  www.littlepenguin.org
 - jPackage Team   jpackage.sourceforge.net
 - Genetix Teamgenetix.sourceforge.net

Re: [Cooker] MySQL with InnoDB

[Christian Belisle]

InnoDB is a database engine for MySQL.

Look at the feature list... www.innodb.com/features.html

I found it very interesting. It's fast. But it's not as stable as the
current database engine in MySQL. MySQL 3.23.38 had some problems with
InnoDB if I remember well. That's why I would like to make a RPM, put it
on my home page (btw, I need to have one...). And if we see, after few
releases that InnoDB is enough fast & stable, we could include it
instead of the current MySQL with the current DB engine.

I explain badly, I know, but look at the web site... very interesting
:-)

Chris


Christian Zoffoli wrote:
> 
> Christian Belisle wrote:
> >
> > Someone is interested in InnoDB?
> >
> > I'm looking at this technology, but is it interesting for Mandrake?
> >
> > Maybe I can build a MySQL RPM with InnoDB, and put it on my web page,
> > just to test... and then, we will see if it's interesting.
> >
> > Chris
> 
> a link (and/or some infos) would be welcome... :)
> 
> Christian
> 
> --
> [EMAIL PROTECTED], OpenPGP key available on www.keyserver.net
> 1024D/2D3C2E70   6241 A35C DD72 242E 5430  2D01 F732 1EEF 2D3C 2E7
> 
>  - Littlepenguin Team  www.littlepenguin.org
>  - jPackage Team   jpackage.sourceforge.net
>  - Genetix Teamgenetix.sourceforge.net

Re: [Cooker] MySQL with InnoDB

[Christian Zoffoli]

Christian Belisle wrote:
> 
> Someone is interested in InnoDB?
> 
> I'm looking at this technology, but is it interesting for Mandrake?
> 
> Maybe I can build a MySQL RPM with InnoDB, and put it on my web page,
> just to test... and then, we will see if it's interesting.
> 
> Chris

a link (and/or some infos) would be welcome... :)

Christian

-- 
[EMAIL PROTECTED], OpenPGP key available on www.keyserver.net
1024D/2D3C2E70   6241 A35C DD72 242E 5430  2D01 F732 1EEF 2D3C 2E7

 - Littlepenguin Team  www.littlepenguin.org
 - jPackage Team   jpackage.sourceforge.net
 - Genetix Teamgenetix.sourceforge.net

[Cooker] MySQL with InnoDB

[Christian Belisle]

Someone is interested in InnoDB?

I'm looking at this technology, but is it interesting for Mandrake?

Maybe I can build a MySQL RPM with InnoDB, and put it on my web page,
just to test... and then, we will see if it's interesting.

Chris

Re: [Cooker] MYSQL Build on Cooker

[Wesley Hertlein]

On Mon, Jul 16, 2001 at 05:33:38PM -0700, Brad Bonkoski wrote:
> mysqladmin.c: In function `nice_time':
> mysqladmin.c:911: Internal error: Illegal instruction.
> Please submit a full bug report.
> See https://qa.mandrakesoft.com/> for instructions.
> make[2]: *** [mysqladmin.o] Error 1
> make[2]: Leaving directory `/home/SOURCE/mysql-3.23.39/client'

If you do a 'make clean', does this always happen in the same 
spot?  If so, does it still happen in the same spot if you copy
the source directory and run 'make' in both?

An 'internal error' is generally a hardware problem, especially
if it's happening in lots of different sets of source code.  Of
course, if you're running cooker, it could also be a real problem
with gcc.

Good luck.  If you think it might be a hardware problem, do a
google search on "Signal 11".  There's an excellent page out
there (I don't have the URL on hand, sorry) that deals with
diagnosing and fixing hardware problems.

-- 
Wes Hertlein
[EMAIL PROTECTED]

linux uptime: 24 days | 5 hours | 26 minutes
time checked: Tue Jul 17 20:41:04 2001 EDT

[Cooker] MYSQL Build on Cooker

[Brad Bonkoski]

Hello,
I can't get Mysql to build from source on Cooker, as well as Apache,
PostgreSQL, and PHP.
I would prefer not to use the RPMs so I am able to manage these myself.
For now, we can tackle MySQL.
The version is Mysql-3.23.39
my configure options are: ./configure --prefix=/home/mysql
when i run 'make' I get these errors:

c++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti
-rdynamic -o .libs/mysql mysql.o readline.o sql_string.o
completion_hash.o ../readline/libreadline.a -lncurses
../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt
-lnsl -lm -Wl,--rpath -Wl,/home/mysql/lib/mysql
creating mysql
gcc -DUNDEF_THREADS_HACK -I./../include
-I../include -I./.. -I..-I..-O3
-DDBUG_OFF   -c mysqladmin.c
mysqladmin.c: In function `nice_time':
mysqladmin.c:911: Internal error: Illegal instruction.
Please submit a full bug report.
See https://qa.mandrakesoft.com/> for instructions.
make[2]: *** [mysqladmin.o] Error 1
make[2]: Leaving directory `/home/SOURCE/mysql-3.23.39/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/SOURCE/mysql-3.23.39'
make: *** [all-recursive-am] Error 2

Any Ideas?  Thanks, Brad

Re: [Cooker] MySQL-3.23.39-1mdk.i586.rpm missing

[Chris]

Sorry, I did a mistake while uploading the package.

I re-uploaded MySQL-3.23.39-1mdk.i586.rpm

Chris

Arnd Bergmann wrote:

> # rpm -Fvh MySQL*.rpm
> Preparing...### [100%]
> file /usr/bin/mysql_config from install of MySQL-devel-3.23.39-1mdk conflicts with 
>file from package MySQL-3.23.38-2mdk
>
> # ls MySQL*
> MySQL-3.23.38-2mdk.i586.rpm MySQL-devel-3.23.39-1mdk.i586.rpm
> MySQL-bench-3.23.39-1mdk.i586.rpm   MySQL-shared-3.23.39-1mdk.i586.rpm
> MySQL-client-3.23.39-1mdk.i586.rpm
>
> It seems like the package versions for MySQL are out of sync
> on sunsite.uio.no as of Mon Jun 25 18:40:55 EEST 2001.
> Also, the file mysql_config probably should not be in both
> MySQL and MySQL-devel.
>
> Arnd <><

[Cooker] MySQL-3.23.39-1mdk.i586.rpm missing

[Arnd Bergmann]

# rpm -Fvh MySQL*.rpm
Preparing...### [100%]
file /usr/bin/mysql_config from install of MySQL-devel-3.23.39-1mdk conflicts with 
file from package MySQL-3.23.38-2mdk

# ls MySQL*
MySQL-3.23.38-2mdk.i586.rpm MySQL-devel-3.23.39-1mdk.i586.rpm
MySQL-bench-3.23.39-1mdk.i586.rpm   MySQL-shared-3.23.39-1mdk.i586.rpm
MySQL-client-3.23.39-1mdk.i586.rpm

It seems like the package versions for MySQL are out of sync
on sunsite.uio.no as of Mon Jun 25 18:40:55 EEST 2001.
Also, the file mysql_config probably should not be in both
MySQL and MySQL-devel.

Arnd <><

[Cooker] MySQL Client Program Problems.

[Russell \"Elik\" Rademacher]

Hello Guys.  I am not sure if you know about this but I use the
mysql_setpermission files quite often.  However...the RPMS that I have
gotten recently which is 3.22.32 version, it have client version of 9.38 or
something.  Now...here is the problem I came across when I tried to use it.

I type in the command to start and after giving the correct password, this
is what I get back.

[root@unixhost1 bin]# mysql_setpermission
Password for user  to connect to MySQL:
Can't make a connection to the mysql server.
 The error: Protocol mismatch. Server Version = 10 Client Version = 9 at
/usr/bin/mysql_setpermission line 65,  chunk 1.
[root@unixhost1 bin]#

I cannot figure out how to solve this, but I really need this fixed ASAP,
since I use them to do the quick add of the mysql databases for our
customers and after this upgrade...well.. I am really up the creek here.
Any help is appreciated.

[Cooker] mysql is gpl

[Brook humphrey]

They just announced mysql in now gpl.

[Cooker] MySQL now GPL

[Don Head]

Good news for the world, and Mandrake as well..

http://biz.yahoo.com/bw/000628/ca_va_linu.html

Excerpt:

MySQL has been re-licensed under the GNU General
Public License (GPL) from the Free Software
Foundation, the same license used by the Linux
operating system kernel. Programmers around the
world can now freely distribute modifications and
enhancements to the latest beta and future
releases of MySQL source code.

Don Head  [[EMAIL PROTECTED]]
Linux Mentor  [1 314 692-1942]
Wave Technologies, Inc. [1 800 826-4640 x1942]
[AIM - Don Wave][ICQ - 18804935][Yahoo - Don_Wave]
 

Re: [Cooker] MySQL-GPL or MySQL

[Axalon Bloodstone]

On 14 Jan 2000, Gary Lawrence Murphy wrote:

> > "W" == WH Bouterse <[EMAIL PROTECTED]> writes:
> 
> W> Well evidently due to some new legal snafu's The formal 7.0
> W> release now has ; MySQL_GPL-3.20.32a-1
> 
> W> While contribs has; MySQL-3.22.25-6
> 
> W> Could some gifted MySQL person offer some suggestions to less
> W> evolved Mandrake users and practicioners?
> 
> What do you need to know?  3.20 is a GPL release which is unsupported
> by the authors, whereas the more stable and debugged 3.22 is
> proprietary software, and as such is available in binary form only.

Hmm more correctly we can't support it, install it, or modify it, without
a license. Also it does get built from source.
 
> My guess is that you could only distribute the binary with Mandrake if
> you licence it, so you have the GPL in the installation, but can offer
> a mirror of the commercial release (are these fairly similar rules to
> distributing StarOffice or Corel WP/Linux?)
 
They are different, all of them :) 

-- 
MandrakeSoft  http://www.mandrakesoft.com/
--Axalon

Re: [Cooker] MySQL-GPL or MySQL

[Gary Lawrence Murphy]

> "W" == WH Bouterse <[EMAIL PROTECTED]> writes:

W> Well evidently due to some new legal snafu's The formal 7.0
W> release now has ; MySQL_GPL-3.20.32a-1

W> While contribs has; MySQL-3.22.25-6

W> Could some gifted MySQL person offer some suggestions to less
W> evolved Mandrake users and practicioners?

What do you need to know?  3.20 is a GPL release which is unsupported
by the authors, whereas the more stable and debugged 3.22 is
proprietary software, and as such is available in binary form only.

My guess is that you could only distribute the binary with Mandrake if
you licence it, so you have the GPL in the installation, but can offer
a mirror of the commercial release (are these fairly similar rules to
distributing StarOffice or Corel WP/Linux?)

-- 
Gary Lawrence Murphy <[EMAIL PROTECTED]>  TeleDynamics Communications Inc
Business Telecom Services : Internet Consulting : http://www.teledyn.com
Linux/GNU Education Group: http://www.egroups.com/group/linux-education/
"Computers are useless.  They can only give you answers."(Pablo Picasso)

[Cooker] MySQL-GPL or MySQL

[WH Bouterse]

Well evidently due to some new legal snafu's
The formal 7.0 release now has ;
MySQL_GPL-3.20.32a-1

While contribs has;
MySQL-3.22.25-6

So I am really in the North now ToTo?
Duh, you got me again on this one :o)

Could some gifted MySQL person offer
some suggestions to less evolved
Mandrake users and practicioners?

William Bouterse

Re: [Cooker] MySQL & alpha

[Axalon Bloodstone]

On Fri, 3 Dec 1999, Stefan van der Eijk wrote:

> Axalon,
> 
> > "
> > g++ -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3
> > -DDBUG_OFF -fno-implicit-templates -rdynamic -o gen_lex_hash
> > gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../heap/libheap.a
> > ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a
> > ../strings/libmystrings.a -ldl -lnsl -lm -lz -lcrypt -lpthread
> > "
>  
> > top out at just over 500Meg, goes back to 85 and starts climbing again,
> > does this twice and continues..
> On an alpha I presume?
> 
> hmmm... does this mean that 128M ram isn't enough to compile this
> package??
> 
> Greetings,
> 
> Stefan

Yeah on the alpha at the office (i've no specifics of what it is), should
be compileable just make a really big swapfile/partition and it should
complete 

--
MandrakeSoft  http://www.mandrakesoft.com/
--Axalon

Re: [Cooker] MySQL & alpha

[Stefan van der Eijk]

Axalon,

> "
> g++ -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3
> -DDBUG_OFF -fno-implicit-templates -rdynamic -o gen_lex_hash
> gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../heap/libheap.a
> ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a
> ../strings/libmystrings.a -ldl -lnsl -lm -lz -lcrypt -lpthread
> "
 
> top out at just over 500Meg, goes back to 85 and starts climbing again,
> does this twice and continues..
On an alpha I presume?

hmmm... does this mean that 128M ram isn't enough to compile this
package??

Greetings,

Stefan

Re: [Cooker] MySQL & alpha

[Axalon Bloodstone]

On Fri, 3 Dec 1999, Stefan van der Eijk wrote:

> Hi,
> 
> I just had some fun recompiling MySQL on my alpha... at a certain moment
> it started eating memory and basically crashed the system (many zombies
> etc. etc.). I must say that on my intel system it goes right... Has
> anybody else experienced this?? 
> 
> This is where it goes wrong:
> 
> sql_parse.cc: In function `int check_connections(class THD *)':
> sql_parse.cc:87: warning: passing `size_socket *' as argument 3 of
> `getpeername(int, sockaddr *, socklen_t *)' changes signedness
> g++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME="\"/\""
> -DDATADIR="\"/var/lib/mysql\"" 
> -DSHAREDIR="\"/usr/share/mysql\""   -DHAVE_CONFIG_H
> -I./../include
> -I./../regex-I. -I../include -I.. -I.   
> -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3
> -DDBUG_OFF   -fno-implicit-templates   -c sql_yacc.cc
> /my/gnu/lib/bison/bison.simple: In function `int yyparse()':
> /my/gnu/lib/bison/bison.simple:692: virtual memory exhausted
> make[3]: *** [sql_yacc.o] Error 1
> make[3]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27/sql'
> make[2]: *** [all-recursive] Error 1
> make[2]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27/sql'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27'
> make: *** [all-recursive-am] Error 2
> Bad exit status from /var/tmp/rpm-tmp.417 (%build)
> 
> Any idea's??
> 
> Greetings,
> 
> Stefan

"
g++ -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3
-DDBUG_OFF -fno-implicit-templates -rdynamic -o gen_lex_hash
gen_lex_hash.o ../isam/libnisam.a ../merge/libmerge.a ../heap/libheap.a
../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a
../strings/libmystrings.a -ldl -lnsl -lm -lz -lcrypt -lpthread
"

top out at just over 500Meg, goes back to 85 and starts climbing again,
does this twice and continues.. 

--
MandrakeSoft  http://www.mandrakesoft.com/
--Axalon

[Cooker] MySQL & alpha

[Stefan van der Eijk]

Hi,

I just had some fun recompiling MySQL on my alpha... at a certain moment
it started eating memory and basically crashed the system (many zombies
etc. etc.). I must say that on my intel system it goes right... Has
anybody else experienced this?? 

This is where it goes wrong:

sql_parse.cc: In function `int check_connections(class THD *)':
sql_parse.cc:87: warning: passing `size_socket *' as argument 3 of
`getpeername(int, sockaddr *, socklen_t *)' changes signedness
g++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME="\"/\""
-DDATADIR="\"/var/lib/mysql\"" 
-DSHAREDIR="\"/usr/share/mysql\""   -DHAVE_CONFIG_H
-I./../include
-I./../regex-I. -I../include -I.. -I.   
-D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3
-DDBUG_OFF   -fno-implicit-templates   -c sql_yacc.cc
/my/gnu/lib/bison/bison.simple: In function `int yyparse()':
/my/gnu/lib/bison/bison.simple:692: virtual memory exhausted
make[3]: *** [sql_yacc.o] Error 1
make[3]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27'
make: *** [all-recursive-am] Error 2
Bad exit status from /var/tmp/rpm-tmp.417 (%build)

Any idea's??

Greetings,

Stefan

[Cooker] MySQL

[Stefan van der Eijk]

Hi,

I just had some fun recompiling MySQL on my alpha... at a certain moment
it started eating memory and basically crashed the system (many zombies
etc. etc.). I must say that on my intel system it goes right... Has
anybody else experienced this?? 

This is where it goes wrong:

sql_parse.cc: In function `int check_connections(class THD *)':
sql_parse.cc:87: warning: passing `size_socket *' as argument 3 of
`getpeername(int, sockaddr *, socklen_t *)' changes signedness
g++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME="\"/\""
-DDATADIR="\"/var/lib/mysql\"" 
-DSHAREDIR="\"/usr/share/mysql\""   -DHAVE_CONFIG_H
-I./../include
-I./../regex-I. -I../include -I.. -I.   
-D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3
-DDBUG_OFF   -fno-implicit-templates   -c sql_yacc.cc
/my/gnu/lib/bison/bison.simple: In function `int yyparse()':
/my/gnu/lib/bison/bison.simple:692: virtual memory exhausted
make[3]: *** [sql_yacc.o] Error 1
make[3]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/RPM/BUILD/mysql-3.22.27'
make: *** [all-recursive-am] Error 2
Bad exit status from /var/tmp/rpm-tmp.417 (%build)

Any idea's??

Greetings,

Stefan

Re: [Cooker] MySQL released as GPL!!!

[tracer]

Hello Jean-Michel,

Monday, Monday, August 30, 1999, you wrote:

JMD> Do we put it in Cooker? If so, I build it.  =) Hurray!

JMD> Jean-Michel Dault
JMD> [EMAIL PROTECTED]
JMD> [EMAIL PROTECTED]

>> Michael Widenius <[EMAIL PROTECTED]>
>> Subject: MySQL 3.20.32a released as GPL
>>Date: Sun, 29 Aug 1999 01:07:15 +0300 (EEST)
>>  To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>>Reply-To: [EMAIL PROTECTED]
>>
>>
>>Hi!
>>
>>I just wanted to inform you that MySQL 3.20.32a was released as GPL at
>>1999-08-22. (http://www.mysql.com/news.html).  This means that
>>MySQL (at least this version:) is now Open Source.
>>
>>You can run all new MySQL clients (which are in public domain) against
>>this version!
>>
>>We will continue to release older releases of MySQL as GPL from time
>>to time...
>>
>>Regards,
>>Monty
>>


please add as having it in could be good reason to get cooker...

Best regards,
 
tracer

mail to: [EMAIL PROTECTED] 

Re: [Cooker] MySQL released as GPL!!!

[deskjock]

I think it would be a great addition.And to the person who can get
Subqueries working...

Jean-Michel Dault wrote:

> Do we put it in Cooker? If so, I build it.  =) Hurray!
>
> Jean-Michel Dault
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
>> Michael Widenius <[EMAIL PROTECTED]>
>> Subject: MySQL 3.20.32a released as GPL
>>Date: Sun, 29 Aug 1999 01:07:15 +0300 (EEST)
>>  To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>>Reply-To: [EMAIL PROTECTED]
>>
>>
>>Hi!
>>
>>I just wanted to inform you that MySQL 3.20.32a was released as GPL at
>>1999-08-22. (http://www.mysql.com/news.html).  This means that
>>MySQL (at least this version:) is now Open Source.
>>
>>You can run all new MySQL clients (which are in public domain) against
>>this version!
>>
>>We will continue to release older releases of MySQL as GPL from time
>>to time...
>>
>>Regards,
>>Monty
>>

Re: [Cooker] MySQL released as GPL!!!

[Timothy Litwiller]

I would like it to be included

Jean-Michel Dault wrote:

> Do we put it in Cooker? If so, I build it.  =) Hurray!
>
> Jean-Michel Dault
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
>> Michael Widenius <[EMAIL PROTECTED]>
>> Subject: MySQL 3.20.32a released as GPL
>>Date: Sun, 29 Aug 1999 01:07:15 +0300 (EEST)
>>  To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>>Reply-To: [EMAIL PROTECTED]
>>
>>
>>Hi!
>>
>>I just wanted to inform you that MySQL 3.20.32a was released as GPL at
>>1999-08-22. (http://www.mysql.com/news.html).  This means that
>>MySQL (at least this version:) is now Open Source.
>>
>>You can run all new MySQL clients (which are in public domain) against
>>this version!
>>
>>We will continue to release older releases of MySQL as GPL from time
>>to time...
>>
>>Regards,
>>Monty
>>

[Cooker] MySQL released as GPL!!!

[Jean-Michel Dault]

Do we put it in Cooker? If so, I build it.  =) Hurray!
Jean-Michel Dault
[EMAIL PROTECTED]
[EMAIL PROTECTED]

    Michael Widenius <[EMAIL PROTECTED]>
    Subject: MySQL 3.20.32a released as GPL
   Date: Sun, 29 Aug 1999 01:07:15 +0300 (EEST)
 To: [EMAIL PROTECTED], [EMAIL PROTECTED]
   Reply-To: [EMAIL PROTECTED]


   Hi!

   I just wanted to inform you that MySQL 3.20.32a was released as GPL at
   1999-08-22. (http://www.mysql.com/news.html).  This means that
   MySQL (at least this version:) is now Open Source.

   You can run all new MySQL clients (which are in public domain) against 
   this version!

   We will continue to release older releases of MySQL as GPL from time
   to time...

   Regards,
   Monty