Re: [opensuse] MySQL 5 rpms for SuSE 9.3?
Kevin Thorpe wrote: > Does anyone know where I can get mysql version 5 for SuSE 9.3? There are 5.0 and 5.1 rpms for 10.0 in the buildservice: http://software.opensuse.org/search?q=mysql&baseproject=SUSE%3ASL-10.0 , if you're lucky, it'll work on 9.3 too. If not, you can take the src.rpm and rebuild. > I really should upgrade Definitely. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] mysql starts with --skip-grant-tables
Adam Fisher wrote: > I did a fresh install of 10.2 and now when I start mysql (rcmysql start). > It starts with --skip-grant-tables and the mysql.sock is loaded in > /var/run/mysql/.protected folder. I have apparmor turned off and don't > see how it is installed in chroot. In my.cnf it is not listed as well. But it should then shutdown and start normally, doesn't it? /var/run/mysql/.protected is just a trick to be able to run mysql_upgrade from the init script without knowing the mysql root password. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySQL Update Table Error.
G T Smith wrote: > I have run the above without any issues, and as far as I can work out > the problem (if it really was a problem) is fixed (for me) with 10.2... Yeah, it's not _that_ bug issue as long as your data is there, but still the fact that mysqld sometimes doesn't restart after the sec. update scares me. But I weren't able to reproduce it yet. > I will file a report if you still wish me to, and BTW should it be > against original... Thanks. > I cannot say anything about the 10.3 reports as I am still on 10.2. Well, the 10.3 reports are unrelated > I am probably > going to be late to the 10.3 party as I need to put together a cunning > plan to manage the 10.3 upgrade :-) ;-) Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySQL Update Table Error.
Ionut Vancea wrote: > hello, > > On 10/5/07, G T Smith <[EMAIL PROTECTED]> wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> SuSE 10.2 >> >> Did an update today including MySQL security updates. > > yes, I have something similar. After I did the update from 10.2 to > 10.3 mysql doesn't work. That must be something different, but please file a bugreport (https://bugzilla.novell.com/) as well. Michal > It seems that the databases and the tables > are ok, the mysql is starting, but when I tried wordpress, mambo, > mysql.log tells me that mysql restarted during a SELECT. I tried this > SELECT command also in mysql command line, also in phpmyadmin, but I > got the same error and mysqld restarted. I don't know how to fix that. > > thanks, > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] MySQL Update Table Error.
J Sloan wrote: > G T Smith wrote: >> SuSE 10.2 >> >> Did an update today including MySQL security updates. >> >> Found MySQL had failed to reload for some reason. >> Restarted MySQL and got a a duplicate column error message when an >> attempt to update the mysql database tables was applied. (unfortunately, >> error message went before I could take notes and nothing in logs). >> Nothing seems to broken but unable to repeat error (I suspect because >> the database schema update has now been flagged as applied). >> > Yes, I noticed that mysql was dead after the last upgrade on my suse > 10.2/64 server, and a bit of lookikng in the the mysqld log turned up a > complaint about a duplicate column IIRC - but I started it with the rc > script and it has run normally from that point on, so I hadn't give it > too much further thought. Hi, the 'duplicate column' errors come from mysql_fix_privilege_tables.sql and are in fact harmless (see https://bugzilla.novell.com/228248 , fixed in 10.3). However, it seems that the init script thinks that something failed during the upgrade :-(. Could you try # touch /var/lib/mysql/.run-mysql_upgrade # rcmysql restart ? Also please file a bugreport and assign it to [EMAIL PROTECTED] I'm going to try it myself. thanks, Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: > 2007/8/9, Michal Marek <[EMAIL PROTECTED]>: >> Ciro Iriarte wrote: >>> Probably i'll copy the datafiles (as soon as i get the needed space) >>> to a vmware installation and try to update mysql or probably reinstall >>> it (rpm -e mysql/rpm -i mysql-5.blah). >> If you have the possibility to test your app in a testing environment, >> then this is definitely the recommended way. rpm -Uvh should work as > > That probably won't do it, the package are not the same. We currently have: > > mysql-4.1.10a-3.4 < taken from suse 9.3 > mysql-client-4.1.10a-3 < taken from suse 9.3 > mysql-shared-4.0.18-32.1 <--- stock, needed by php and other > packages. It'll be a mess to try to compile php with the new libs i > guess > mysql-devel-4.0.18-32.20 <--- stock too > > MySQL5: > > libedit-devel-2.10.snap20070302-11.1.x86_64.rpm > libedit0-2.10.snap20070302-11.1.x86_64.rpm <--- huh? > > libmysqlclient-devel-5.0.45-2.1.x86_64.rpm > libmysqlclient15-5.0.45-2.1.x86_64.rpm <--- confused > libmysqlclient_r15-5.0.45-2.1.x86_64.rpm <--- confused > > mysql-5.0.45-2.1.x86_64.rpm <--- goes in > mysql-Max-5.0.45-2.1.x86_64.rpm <-- not interested in > mysql-bench-5.0.45-2.1.x86_64.rpm <-- not interested in > mysql-client-5.0.45-2.1.x86_64.rpm <--- goes in > mysql-debug-5.0.45-2.1.x86_64.rpm <-- not interested in > mysql-test-5.0.45-2.1.x86_64.rpm <-- i don't think we need it > mysql-tools-5.0.45-2.1.x86_64.rpm <-- not sure > pgpool-3.1.1-4.3.x86_64.rpm <-- sounds out of place And what's the problem? 'rpm -Uvh mysql-5.0.*.rpm mysql-client-5.0.*.rpm libmysqlclient15-5.0.*.rpm' will give you a working mysql5 setup. And it'll keep the 4.x libs for apps linked against it (php). Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: > Probably i'll copy the datafiles (as soon as i get the needed space) > to a vmware installation and try to update mysql or probably reinstall > it (rpm -e mysql/rpm -i mysql-5.blah). If you have the possibility to test your app in a testing environment, then this is definitely the recommended way. rpm -Uvh should work as well btw, or adding the repo to yast (if you want to update all packages). > For production i would like to wait for 5.1 as i'm interested on using > table partitions (there's an ugly +60GB table around). Have any idea > when it's going to be released (and added to Build Service)? I can't answer the first question. As for buildservice, there used to be rpms of 5.1 beta version in the same repository, but I removed them, as it caused problems when building other packages. I'm going to resurrect them however (after 10.3 or so). So the answer to the second question is "soon after the official release" ;) > I'll report back the result of my tests. Cool. Looking forward for your results :) Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SMP kernel
Michael Riess wrote: > why is i586 kernel divided into SMP and default? > or: why the x68_64 is not? kernel-default.i586 also has SMP support. There's the kernel-bigsmp.i586 package for those big iron 32bit machines with >4GB of RAM and >64 cpus. On x86_64, you get all that with the default kernel for free. hth, Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: > 2007/8/5, Leo Eraly <[EMAIL PROTECTED]>: >> On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote: >>> Hi, anybody update an stock MySQL4 from SLES9 with a live database to >>> MySQL5 from Build Service >>> (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) >> Best thing to do is to check: >> >> http://dev.mysql.com/doc/refman/5.0/en/upgrade.html >> >> >> Leo >> -- >> Leo Eraly <[EMAIL PROTECTED]> > > Thanks, i've already seen this (exactly > http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html), but i > was willing to hear experiences from someone that actually did the > upgrade. I would be interested as well. But I'm affraid the buildservice packages for SLES9 don't have many users, given that two months ago they didn't exist. You'll probably be the first one! ;-) Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] SLES9 and MySQL5
Ciro Iriarte wrote: > 2007/8/5, Ciro Iriarte <[EMAIL PROTECTED]>: >> 2007/8/5, Leo Eraly <[EMAIL PROTECTED]>: >>> On Sat, 2007-08-04 at 08:06 -0400, Ciro Iriarte wrote: Hi, anybody update an stock MySQL4 from SLES9 with a live database to MySQL5 from Build Service (http://download.opensuse.org/repositories/server:/database/SLES_9/x86_64/) > Also noticed that those packages appeared on July (in many years i've > looked after SLES9, there weren't packages for mysql5), maybe they're > going to be included on SP4? They appeared recently because the SLES9 builds were broken previously: * Fri Jun 01 2007 - [EMAIL PROTECTED] - fixed build for older distributions in the buildservice This has nothing to do with SP4. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] php5-pdo_mysql-5.2
Aigars wrote: > Hello. > > I can't find package php5-pdo_mysql-5.2 for SuSE > > This seems strange, because there is package php5-pdo_mysql-5.1 The pdo_mysql extension is now part of the php5-mysql package. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] Re: mysql will not start after php upgrade
Michal Marek wrote: > Sorry, I didn't get it in my previous mail :-) I looked into it now and > it seems to me that the buildservice ignores the libmysqlclient-devel > package, which then causes this failure. I asked on the buildservice ml: > http://lists.opensuse.org/opensuse-buildservice/2007-06/msg7.html server_database_* build targets are fixed now. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[opensuse] Re: mysql will not start after php upgrade
Cristian Rodriguez R. wrote: > Still might not work. as PHP does not want to build against > server:database_10.1 this is the error now. > > installing libmysqlclient15-5.0.41-4.1 > file /usr/lib/libmysqlclient.so.15.0.0 from install of > libmysqlclient15-5.0.41-4.1 conflicts with file from package > mysql-shared-5.0.18-16 > file /usr/lib/mysql/libmysqlclient.so.15 from install of > libmysqlclient15-5.0.41-4.1 conflicts with file from package > mysql-shared-5.0.18-16 Sorry, I didn't get it in my previous mail :-) I looked into it now and it seems to me that the buildservice ignores the libmysqlclient-devel package, which then causes this failure. I asked on the buildservice ml: http://lists.opensuse.org/opensuse-buildservice/2007-06/msg7.html Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[opensuse] Re: mysql will not start after php upgrade
Cristian Rodriguez R. wrote: > Michal Marek escribió: >> Patrick Shanahan wrote: >>> ok, >>> 1. reinstalled mysql from server:database repo >>> rpm -Uvh --replacepkgs ./mysql-5.0.41-4.1.x86_64.rpm >>> 2. reinstalled php5 from server:/php/SUSE_Linux_10.1/x86_64/ >>> rpm -Uvh --replacepkgs ./php5-5.2.2-49.1.x86_64.rpm >>> 3. installed mysql-shared-5.0.18-16 >>> had newer version which apparently was dropped? >> Please do *not* mix different versions. Use only the 5.0.41 packages >> from the buildservice repository and post the results here. >> >> >>> 4. installed libmysqlclient15-5.0.41.-4.1 >>> required by (3), BUT provides overlapping files ??? >> No, this is a replacement for the old mysql-shared package. >> > > Still might not work. as PHP does not want to build against > server:database_10.1 this is the error now. Getting the php5-mysql extension working with the new mysql lib is another story (btw, I removed mysql-beta yesterday, so it's just a question of time until the packages are ready). Let's first focus on the mysql_upgrade failure reported in the original mail. > if RPMs are not there that means it is broken and you need to wait for > them to be ready to use. do not mix stuff, as that way you will only > shoot yourself in the foot. Exactly. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] Re: mysql will not start after php upgrade
Patrick Shanahan wrote: > ok, > 1. reinstalled mysql from server:database repo > rpm -Uvh --replacepkgs ./mysql-5.0.41-4.1.x86_64.rpm > 2. reinstalled php5 from server:/php/SUSE_Linux_10.1/x86_64/ > rpm -Uvh --replacepkgs ./php5-5.2.2-49.1.x86_64.rpm > 3. installed mysql-shared-5.0.18-16 > had newer version which apparently was dropped? Please do *not* mix different versions. Use only the 5.0.41 packages from the buildservice repository and post the results here. > 4. installed libmysqlclient15-5.0.41.-4.1 > required by (3), BUT provides overlapping files ??? No, this is a replacement for the old mysql-shared package. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[opensuse] Re: mysql will not start after php upgrade
Cristian Rodriguez R. wrote: > Michal Marek escribió: >> Patrick Shanahan wrote: >>> openSUSE 10.1 x86_64 >>> >>> updated mysql yesterday to mysql-5.0.41-4.1 >> From server:database buildservice project, right? > > > if so, it may not work :( > > there are multiple providers of libmysqlclient.so.15 in server:database > and PHP is NOT building against it because the buildservice aborts on > multiple choices... :( OK, then I'll simply delete the mysql-beta package (it's not quite maintained anyway ;)) and perhaps put it somewhere else later. I never liked the idea of projects grouping several unrelated (and sometimes conflisting) packages like server:database... Not sure whether this is the cause of Patrick's problem, we'll see. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] mysql will not start after php upgrade
Patrick Shanahan wrote: > openSUSE 10.1 x86_64 > > updated mysql yesterday to mysql-5.0.41-4.1 >From server:database buildservice project, right? > and php5 today to > php5-5.2.2-49.1. Noticed my photo gallery was down and found mysqld > not running. Restart attempt yields: > > 13:20 wahoo:~ # rcmysql start > Updating MySQL privilege database... > /usr/bin/mysql_upgrade: relocation error: /usr/bin/mysql_upgrade: > symbol dynstr_append_os_quoted, version libmysqlclient_15 not defined > in file libmysqlclient.so.15 with link time referencefailed Not good. Did you update all the packages, inc. the client library and the client programs (run rpm -qa '*mysql*'; rpm -q --changelog | head)? The client programs are in mysql-client.rpm, the library used to be in mysql-shared.rpm, now it's in libmysqlclient15.rpm. The current and 10.1 version of the library *should* be compatible, but if you mixed them, then it *could* be the reason. Anyway, on Factory x86_64 it works fine... > reverted php5 to earlier version php5-5.1.2-29.25.6.x86_64.rpm PHP shouldn't have any influence. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] which user runs PHP5 in suse 10.1
vinayan K.P wrote: > Hello all, > > Could someone tell me how to find as which user PHP5 is run in SUSE > 10.1. Which sapi (apache2 / fastcgi)? If you use the apache2 module (apache2-mod_php5.rpm), then php runs as part of the httpd processes, so it has privileges of the wwwrun user. Michal In which file it is set like the way the user and group who runs > webserver is mentioned in /etc/apache2/httpd.conf and in uid.conf. > > I need the user which runs PHP5 to set up a vacation mail plugin for > squirrel mail. > > Thanks in advance. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] Re: help about php5 and utf8
Cristian Rodriguez R. wrote: > jdd escribió: >> I was said (by Cristian Rodriguez R), that a patch was writen for this >> accent problem. >> >> I just DL with You a bunch of php5 updates, but the bug is still here >> >> is there a way to get the patch (even by hand) thanks >> jdd >> > > it is not there, probably will be in the second part of fixes for the > Month of PHP bugs. If you mean bug 236680, then please reopen it if you think the fix needs to be added to 10.2 (and add an explanation why you think so). Atm is't only fixed in the bs project, which I'm going to copy to Factory now. For released distributions, we usually only fix security bugs, so you have to tell us in cases like this. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] list version of OpenSUSE using php 4.x
Cristian Rodriguez R. wrote: > jdd escribió: >> Michael Skiba wrote: >> I was wondering what was the last version of OpenSUSE using php4.x? >> I think 10.0 - I can't find php4 on 10.1 and used it on 10.0 > > Yes, and is currenlty, no longer supported. I know what you mean, but such statement could be misleading: 10.0, inc. the php4-4.4.0 package, _is_ still supported by security updates (but of course bugs that are not security relevant will very likely be closed as WONTFIX). Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] less broken from 394-12(10.1) to 394-32(10.2)
Linda Walsh wrote: > Have noticed with identical calling args, the less from 10.2 (less-394-32) > counts lines incorrectly (appear to be not counting lines that wrap). > > Installed less from 10.1 -- it works. :-( > Guess I need to start filing less bugs Yes, please do so (esp. if it worked previously and then broke somehow). And attach a testcase to the bugreport. thanks, Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] php5: dynamic extensions in php.ini?
Daniel Bauer wrote: > On Thursday 01 February 2007 14:28, Michal Marek wrote: >> No, each extension has it's own config in /etc/conf.d/*.ini > > thanks. I found them in /etc/php5/conf.d > all modules are listed there. Arr, yes it's of course /etc/php5/conf.d >> PS: You might perhaps be interested in the latest and greatest php5 >> packages in the Build Service: >> http://software.opensuse.org/download/server:/php/SUSE_Linux_10.0/ > > thanks for the url. I guess it's the same as > ftp-1.gwdg.de/pub/opensuse/repositories/server:/php/SUSE_Linux_10.0/ > mentioned by Cristian Rodriguez in his post. Yes it's a mirror, in fact software.o.o just redirects downloads to one of the mirrors. BTW Cristian is one of the packagers of server:php (usually the most active one :)). > btw.: when updating to the above version I had to remove some modules that > caused conflicts because they are not available in the same version as the > rest (I guess I don't need these modules anyway). Some modules were merged (like php5-mysqli is now part of php5-mysql), could it be that? Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] php5: dynamic extensions in php.ini?
Daniel Bauer wrote: > Hi :-) > > I finally upgraded from php4 to php5. When I compared my old php.ini to the > new one, I saw that the "dynamic extension" are not listed anymore in the new > one. > > Is it advisable to list the installed extensions there? No, each extension has it's own config in /etc/conf.d/*.ini > Should I just add all modules that are listed in /usr/lib/php5/extensions ? > Oh, and, I thought, these files were named like "mysql.so" but all files in > that directory don't have any file name extension??? Shouldn't be a problem (from 10.1 on, it's extension.so again). hth, Michal PS: You might perhaps be interested in the latest and greatest php5 packages in the Build Service: http://software.opensuse.org/download/server:/php/SUSE_Linux_10.0/ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] Looking for a php5-module RPM spec file
Jeffery Fernandez wrote: > Thanks Cristian. I was after the php-APC which I have found at: > http://ftp-1.gwdg.de/pub/opensuse/repositories/server:/php:/extensions/server_php_openSUSE_10.2/i586/ > > I know to download them and install, but it would be neater if I can add it > as > a repository. Do you know what URL I should be adding into zypper ? One directory up. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[opensuse] unofficial php4 rpms for 10.2 and 10.1 available
See http://repos.opensuse.org/home:/michal-m:/php4/ for packagers with Build Service account (maintainers welcome): http://build.opensuse.org/package/show?package=php4&project=home%3Amichal-m%3Aphp4 For now Factory is used instead of 10.2, I'll change it as soon as 10.2 appears in the BS. Please keep in mind that php4 is more or less discontinued upstream, so relying on it is not sustainable... I'll drop these packages when 10.0 reaches its EOL (fall 2007). Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] PHP4 and 10.1
Stevens wrote: > I have always been amused by the fact that there are so many in the > developer community that I refer to as "brilliant but unstable" (also > "highly educated idiots") Uh, pardon? We _do_ ship php4 with SUSE Linux 10.0, which is going be supported for about a year from now on. If you want even longer support, look at sles9. What we don't support is running an obsolete php version on the newest SUSE Linux / OpenSUSE version, but I offer to provide unofficial builds via the Build Service (see my mail above). Despite of this, you call us "idiots". Thank you! :-/ Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [opensuse] PHP4 and 10.1
Marcus Rueckert wrote: > On 2006-11-24 11:36:04 +, Kevin Donnelly wrote: >> cost-effective when running up smaller sites. Does anyone have any >> suggestions on a way around this (apart from "compile it yourself"!), or is >> the only answer to stay on 10.0 for work like this? > > no package had time for this so far. neither internally or externally. The sad part of the story is that people who are able to "compile it themselves" don't seem to need php4, and people who need it aren't willing to do the packaging :( So, given that this is not the first request, I can repack the 10.0 php4 for 10.1 and 10.2 in the buildservice next week, but do not expect too much support for it (that is: I can continue adding security fixes from 10.0, but bugreports without attached patch will have very very low priority). Upstream doesn't care much about php4 either. Michal -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
