Re: [gentoo-user] glibc-2.17 fails and warning: setlocale: LC_ALL error
On Tue, Jul 15, 2014 at 12:33:57AM -0500, Dale wrote: SNIP make -j3 -s glibc-test * Your old kernel is broken. You need to update it to * a newer version as syscall(bignum) will break. * http://bugs.gentoo.org/279260 * ERROR: sys-libs/glibc-2.17::gentoo failed (setup phase): * keeping your system alive, say thank you * * Call stack: SNIP UPDATE: Thanks to Hinnerk, the locale error is fixed. I am still looking for ideas on the glibc error tho. Since this original post, I have tried the following versions of glibc with the same result. sys-libs/glibc-2.18-r1 sys-libs/glibc-2.19-r1 So, it seems something else is wrong here. I have googled and most things I find are with older kernels and I'm using the newest kernel I can find in the tree. 3.15.5-gentoo Ideas? Fixes? Bug that needs Raid? I've taken a look at the bug that is mentioned in the error and there were several things mentioned that are supposed to fix this: 1. disable auditd (if you have it running) - this was the newest (from '14) So if you have it installed run /etc/init.d/auditd stop 2. reemerge several packages because python may have issues: - sync your tree - emerge portage (which will likely pull in some python stuff if the box wasn't updated for some time) (- optional: run eselect python and select a sane version and run python updater - this wasn't mentioned but may make sense nonetheless) - emerge linux-headers - emerge glibc (hopefully with success this time) WKR Hinnerk signature.asc Description: Digital signature
Re: [gentoo-user] glibc-2.17 fails and warning: setlocale: LC_ALL error
Hinnerk van Bruinehsen wrote: I've taken a look at the bug that is mentioned in the error and there were several things mentioned that are supposed to fix this: 1. disable auditd (if you have it running) - this was the newest (from '14) So if you have it installed run /etc/init.d/auditd stop 2. reemerge several packages because python may have issues: - sync your tree - emerge portage (which will likely pull in some python stuff if the box wasn't updated for some time) (- optional: run eselect python and select a sane version and run python updater - this wasn't mentioned but may make sense nonetheless) - emerge linux-headers - emerge glibc (hopefully with success this time) WKR Hinnerk I didn't have the audit stuff installed BUT it was turned on in the kernel. I kicked that out and also got rid of all that cgroup stuff I don't have any need for. Rebooted then tried your list. Audit stuff, gone. Sync is maybe a couple days old so should be OK. Portage is up to date. Python as follows: dev-lang/python-2.7.6 dev-lang/python-3.3.3 localhost ~ # eselect python list Available Python interpreters: [1] python2.7 * [2] python3.3 localhost ~ # Updated linux-headers. It was a little out of sync with kernel version. After all that, I get this: These are the packages that would be merged, in order: Calculating dependencies... done! [ebuild R] sys-libs/glibc-2.17:2.2 USE=-debug -gd (-hardened) (-multilib) -nscd -profile (-selinux) -suid -systemtap -vanilla 0 kB Total: 1 package (1 reinstall), Size of downloads: 0 kB Verifying ebuild manifests Emerging (1 of 1) sys-libs/glibc-2.17 Failed to emerge sys-libs/glibc-2.17, Log file: '/var/tmp/portage/sys-libs/glibc-2.17/temp/build.log' Jobs: 0 of 1 complete, 1 failed Load avg: 0.27, 0.59, 0.43 * Package:sys-libs/glibc-2.17 * Repository: gentoo * Maintainer: toolch...@gentoo.org * USE:abi_x86_32 elibc_glibc kernel_linux userland_GNU x86 * FEATURES: preserve-libs sandbox make -j3 -s glibc-test make -j3 -s glibc-test * Your old kernel is broken. You need to update it to * a newer version as syscall(bignum) will break. * http://bugs.gentoo.org/279260 * ERROR: sys-libs/glibc-2.17::gentoo failed (setup phase): * keeping your system alive, say thank you * * Call stack: * ebuild.sh, line 93: Called pkg_setup * glibc-2.17.ebuild, line 151: Called eblit-run 'pkg_setup' * glibc-2.17.ebuild, line 137: Called eblit-glibc-pkg_setup * pkg_setup.eblit, line 75: Called die * The specific snippet of code: * die keeping your system alive, say thank you * * If you need support, post the output of `emerge --info '=sys-libs/glibc-2.17::gentoo'`, * the complete build log and the output of `emerge -pqv '=sys-libs/glibc-2.17::gentoo'`. * The complete build log is located at '/var/tmp/portage/sys-libs/glibc-2.17/temp/build.log'. * The ebuild environment file is located at '/var/tmp/portage/sys-libs/glibc-2.17/temp/die.env'. * Working directory: '/usr/lib/portage/pym' * S: '/var/tmp/portage/sys-libs/glibc-2.17/work/glibc-2.17' * * The following package has failed to build or install: * * (sys-libs/glibc-2.17::gentoo, ebuild scheduled for merge), Log file: * '/var/tmp/portage/sys-libs/glibc-2.17/temp/build.log' * localhost ~ # So, the locale junk is gone but glibc is still not liking something. Where did I put that hammer the last time I used it?? ;-) Ideas? I'm pretty much out of them right now. My idea is the hammer. lol Dale :-) :-)
Re: [gentoo-user] glibc-2.17 fails and warning: setlocale: LC_ALL error
On Tue, Jul 15, 2014 at 02:40:13AM -0500, Dale wrote:
Hinnerk van Bruinehsen wrote:
I've taken a look at the bug that is mentioned in the error and there were
several things mentioned that are supposed to fix this:
1. disable auditd (if you have it running) - this was the newest (from
'14)
So if you have it installed run /etc/init.d/auditd stop
2. reemerge several packages because python may have issues:
- sync your tree
- emerge portage (which will likely pull in some python stuff if the
box
wasn't updated for some time)
(- optional: run eselect python and select a sane version and run
python
updater - this wasn't mentioned but may make sense nonetheless)
- emerge linux-headers
- emerge glibc (hopefully with success this time)
WKR
Hinnerk
I didn't have the audit stuff installed BUT it was turned on in the
kernel. I kicked that out and also got rid of all that cgroup stuff I
don't have any need for. Rebooted then tried your list. Audit stuff,
gone. Sync is maybe a couple days old so should be OK. Portage is up to
date. Python as follows:
dev-lang/python-2.7.6
dev-lang/python-3.3.3
localhost ~ # eselect python list
Available Python interpreters:
[1] python2.7 *
[2] python3.3
localhost ~ #
Updated linux-headers. It was a little out of sync with kernel
version. After all that, I get this:
SNIP
So, the locale junk is gone but glibc is still not liking something.
Where did I put that hammer the last time I used it?? ;-)
Ideas? I'm pretty much out of them right now. My idea is the hammer.
lol
Generally hammers tend to make things worse... ;-)
Can you run;
printf #include unistd.h\n#include sys/syscall.h\nint main(){return \
syscall(1000)!=-1;}\n syscall.c make syscall ./syscall echo $?
(It should be all one line).
It will compile the test that seems to fail on your system and runs it,
expected output would be:
cc syscall.c -o syscall
0
The 0 says that all went well, if it reports something else then it's not
just the buildsystem...
If it's the system you'll have to reinstall glibc (no kidding, as it provides
the used headers (though they should be somewhat dependent on linux-headers)).
You could do the following to break out of this chicken-and-egg-problem:
you can download an appropriate stage3-tarball (x86 or amd64) and extract it to
some arbitrary location. Then you essentially do the same as if you would
install gentoo from scratch (bind mount dev and sys and mount proc) and chroot
into it.
Inside the chroot you sync your tree (you could also bind-mount it from the
default location) and emerge glibc again but this time with the --build-pkg
flag set (emerge --buildpkg glibc). As long as you kernel is new enough (which
3.15.5 definitely is) the build should succeed and leave you with a nice binpkg
of glibc sitting in path-to-chroot/usr/portage/packages (in case of the
bind mount it should also be there inside your real system). If needed copy
it to /usr/portage/packages and run emerge -K glibc (this will force portage
to use the binpkg).
I hope that this es enough to circumvent the check (if not you could also try
to boot your rig from usb and copy the contents of the binpkg manually).
If the build breaks even inside the chroot run uname -a and take a look if the
kernel you're running acutally reports to be a 3.15.5 one.
Good luck,
Hinnerk
signature.asc
Description: Digital signature
Re: [gentoo-user] glibc-2.17 fails and warning: setlocale: LC_ALL error
On a side note: You can also boot into a chroot, move your /etc and /var directories elsewhere (e.g. etc_old and var_old) (do the same for other directories where you yourself made changes), extract a stage 3 tarball on top of your normal / directory (overwriting potentially broken stuff), move etc_old and var_old back to their old locations/names, chroot into it (like during install) and emerge @system @world -evDNa (to rebuild everything from the known-good start that the stage3 provides). signature.asc Description: Digital signature
Re: [gentoo-user] File timestamps got confused...why?
On Monday, July 14, 2014 04:42:40 PM Dale wrote: Stroller wrote: On Mon, 14 July 2014, at 6:54 pm, meino.cra...@gmx.de wrote: I am running Gentoo Linux, which I update on a ~daily basis. ... solfire:/home/userfstat smartlog.txt What package provides `fstat`, please? I don't have it installed on this machine, and the first google hit for fstat gentoo suggests it's a BSD command, unavailable on Linux. http://forums.gentoo.org/viewtopic-p-1853116.html#1853116 Stroller. In case you are not aware. I ran up on this ages ago and bookmarked this nifty site. http://www.portagefilelist.de/site/query It seems to show what you posted tho. Sort of. Dale :-) :-) stat is the closest I can find: $ stat notes File: ‘notes’ Size: 89 Blocks: 8 IO Block: 4096 regular file Device: 804h/2052d Inode: 656477 Links: 1 Access: (0644/-rw-r--r--) Uid: ( 1000/ joost) Gid: ( 100/ users) Access: 2014-07-08 10:00:01.297341996 +0200 Modify: 2014-07-08 10:00:01.297341996 +0200 Change: 2014-07-08 10:00:01.330675330 +0200 Birth: - -- Joost
Re: [gentoo-user] Can emerge play a sound on either a successful/unsuccessful build?
On Monday, July 14, 2014 12:46:48 PM Neil Bothwick wrote: I actually have it send an alert to my phone with Posterous but you can do whatever you want. Which Posterous is this? When I google it, I only get information that it actually got shut down after being bought by Twitter. I am looking for a cheap method to get notifications to my mobile phone. I used to use a free SMS service via a company in SA. -- Joost
Re: [gentoo-user] glibc-2.17 fails and warning: setlocale: LC_ALL error
Hinnerk van Bruinehsen wrote: On a side note: You can also boot into a chroot, move your /etc and /var directories elsewhere (e.g. etc_old and var_old) (do the same for other directories where you yourself made changes), extract a stage 3 tarball on top of your normal / directory (overwriting potentially broken stuff), move etc_old and var_old back to their old locations/names, chroot into it (like during install) and emerge @system @world -evDNa (to rebuild everything from the known-good start that the stage3 provides). It's getting close to nap time here. Also, more stormy stuff could pop up at any time. I shut the old rig back down again. It doesn't have a UPS or anything on it. Anyway, I suspect strongly that the error is on the stage3 tarball. I got it installed but I have not been able to get a clean emerge -e system as of yet. I generally unpack, get things to where I can emerge and then do a emerge -e system as soon as I can. That way anything else I build is built on top of updated packages. I have installed Gentoo so many times it is pitiful. What I may do, unpack the stage3 somewhere, recompile glibc to create a binary and then install that package. I'm not going to be to shocked if it fails to build straight out of the stage3 tarball tho. I'm going to work on this some more when I get both eyes open. Dale :-) :-)
Re: [gentoo-user] Can emerge play a sound on either a successful/unsuccessful build?
On Tue, 15 Jul 2014 11:17:33 +0200, J. Roeleveld wrote: I actually have it send an alert to my phone with Posterous but you can do whatever you want. Which Posterous is this? When I google it, I only get information that it actually got shut down after being bought by Twitter. Sorry, brain fade. I meant Pushover - https://pushover.net - I did use Posterous before it got shut down, but that was for something completely different. I am looking for a cheap method to get notifications to my mobile phone. I used to use a free SMS service via a company in SA. This may do the job for you. I used to use NotifyMyAndroid but Pushover is faster (NMA sometimes had delays) and is a one-off cost of $5. -- Neil Bothwick Tagline stealing is the sincerest form of flattery. signature.asc Description: PGP signature
[gentoo-user] mysql to postgresql migration
Hello, I recently ran across this script: py-mysql2pgsql [1] and this discussion on it's origin [2]. I'm keenly interested in the recommendations of others for migrating mysql databases to postgresql and any comments on this aforementioned script or other methodologies TIA, James [1] https://github.com/philipsoutham/py-mysql2pgsql [2] http://www.tryolabs.com/Blog/2012/02/10/django-migrating-mysql-postgresql/
Re: [gentoo-user] kernel bug?
I've checked all many times...
The problem is present again
Anybody has the same problem with kernel 3.12.2x?
Il 15/07/2014 02:47, taozhijiang ha scritto:
Maybe you should check your grub2 chkconfig whether
it is OK, especially the real_init filed.
Suggest if failed again, re-emerge dbus and systemd???
;-) I am a new comer...
2014-07-15
Thanks Best Regards.
陶治江 | TAO Zhijiang
研发处 | SOHO国际产品线
Tel: 3129
Mobile: 18938910923
Email: taozhijiang@tp-link.{net, com.cn}
*发件人：* Gmail
*发送时间：* 2014-07-14 22:17:57
*收件人：* gentoo-user
*抄送：*
*主题：* [gentoo-user] kernel bug?
Hi, i've upgraded kernel from 3.12.13 to 3.12.20.
I've make a oldconfig as usual, but with new kernel the boot blocks at
the begining to the ramdisk loading.
I've tried with other 3.12.2x with the same negative results.
I use grub2 with systemd.
Re: [gentoo-user] File timestamps got confused...why?
On Mon, Jul 14, 2014 at 10:04:36PM +0100, Stroller wrote: On Mon, 14 July 2014, at 6:54 pm, meino.cra...@gmx.de wrote: I am running Gentoo Linux, which I update on a ~daily basis. ... solfire:/home/userfstat smartlog.txt What package provides `fstat`, please? I don't have it installed on this machine, and the first google hit for fstat gentoo suggests it's a BSD command, unavailable on Linux. http://forums.gentoo.org/viewtopic-p-1853116.html#1853116 Stroller. Not to get terribly off topic here, but fstat is, in fact, a C call. I wonder if this is simply a user-made tool. If you look at code examples for this call, it's not terribly difficult to use at all. Actually, I wonder if the tool this user is using pulls the wrong field and calls it 'year'. -- Dan Oriani redchops.com (Website perpetually under construction) signature.asc Description: Digital signature
Re: [gentoo-user] mysql to postgresql migration
On 15 July 2014 14:55:14 CEST, James wirel...@tampabay.rr.com wrote: Hello, I recently ran across this script: py-mysql2pgsql [1] and this discussion on it's origin [2]. I'm keenly interested in the recommendations of others for migrating mysql databases to postgresql and any comments on this aforementioned script or other methodologies TIA, James [1] https://github.com/philipsoutham/py-mysql2pgsql [2] http://www.tryolabs.com/Blog/2012/02/10/django-migrating-mysql-postgresql/ James, I haven't looked into this recently. But I believe that the DDLs and data can be migrated relatively easy. Just be aware that software specifically written using MySQLs version of SQL is unlikely to work on a different RDBMS without extensive rewrites. This is the biggest problem people are facing when porting websites to use a different database. What is the reason for migrating and what kind of data and applications are you using? -- Joost -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Re: [gentoo-user] kernel bug?
On 07/14/2014 05:18 PM, Gmail wrote: Hi, i've upgraded kernel from 3.12.13 to 3.12.20. I've make a oldconfig as usual, but with new kernel the boot blocks at the begining to the ramdisk loading. I've tried with other 3.12.2x with the same negative results. I use grub2 with systemd. Is your '/usr' partition housed on a filesystem of its own, or does it reside on the '/' partition? http://wiki.gentoo.org/wiki/Initramfs/HOWTO For systems where all necessary files and tools reside on the same file system, the |init| application can perfectly control the further boot process. But when multiple file systems are defined (or more exotic installations are done), this might become a bit more tricky: * When the /usr partition is on a separate file system, tools and drivers that have files stored within /usr cannot be used unless /usr is available. If those tools are needed to make /usr available, then we cannot boot up the system. * If the root file system is encrypted, then the Linux kernel will not be able to find the |init| application, resulting in an unbootable system. The solution for this problem has since long been to use an /initrd/ (initial root device). Did you run a diff on your 3.12.13/.config and 3.12.13/.config, to make sure you didn't overlook anything to do with the systemd-related config options?
Re: [gentoo-user] kernel bug?
My /usr partition in on the / partition. I just use initrd, i've compiled kernel with genkernel. I'm trying to look row for row if there's some diff. Il 15/07/2014 17:34, Alexander Kapshuk ha scritto: On 07/14/2014 05:18 PM, Gmail wrote: Hi, i've upgraded kernel from 3.12.13 to 3.12.20. I've make a oldconfig as usual, but with new kernel the boot blocks at the begining to the ramdisk loading. I've tried with other 3.12.2x with the same negative results. I use grub2 with systemd. Is your '/usr' partition housed on a filesystem of its own, or does it reside on the '/' partition? http://wiki.gentoo.org/wiki/Initramfs/HOWTO For systems where all necessary files and tools reside on the same file system, the |init| application can perfectly control the further boot process. But when multiple file systems are defined (or more exotic installations are done), this might become a bit more tricky: * When the /usr partition is on a separate file system, tools and drivers that have files stored within /usr cannot be used unless /usr is available. If those tools are needed to make /usr available, then we cannot boot up the system. * If the root file system is encrypted, then the Linux kernel will not be able to find the |init| application, resulting in an unbootable system. The solution for this problem has since long been to use an /initrd/ (initial root device). Did you run a diff on your 3.12.13/.config and 3.12.13/.config, to make sure you didn't overlook anything to do with the systemd-related config options?
Re: [gentoo-user] kernel bug?
On 07/15/2014 06:38 PM, Gmail wrote: My /usr partition in on the / partition. I just use initrd, i've compiled kernel with genkernel. I'm trying to look row for row if there's some diff. Il 15/07/2014 17:34, Alexander Kapshuk ha scritto: On 07/14/2014 05:18 PM, Gmail wrote: Hi, i've upgraded kernel from 3.12.13 to 3.12.20. I've make a oldconfig as usual, but with new kernel the boot blocks at the begining to the ramdisk loading. I've tried with other 3.12.2x with the same negative results. I use grub2 with systemd. Is your '/usr' partition housed on a filesystem of its own, or does it reside on the '/' partition? http://wiki.gentoo.org/wiki/Initramfs/HOWTO For systems where all necessary files and tools reside on the same file system, the |init| application can perfectly control the further boot process. But when multiple file systems are defined (or more exotic installations are done), this might become a bit more tricky: * When the /usr partition is on a separate file system, tools and drivers that have files stored within /usr cannot be used unless /usr is available. If those tools are needed to make /usr available, then we cannot boot up the system. * If the root file system is encrypted, then the Linux kernel will not be able to find the |init| application, resulting in an unbootable system. The solution for this problem has since long been to use an /initrd/ (initial root device). Did you run a diff on your 3.12.13/.config and 3.12.13/.config, to make sure you didn't overlook anything to do with the systemd-related config options? Googling for 'gentoo linux kernel gets stuck at ramdisk loading', returned the following gentoo specific results. See if that helps pin down the problem: http://forums.gentoo.org/viewtopic-t-912622-start-0.html http://forums.gentoo.org/viewtopic-p-7552928.html http://forums.gentoo.org/viewtopic-t-989210.html http://forums.gentoo.org/viewtopic-p-7179048.html
Re: [gentoo-user] kernel bug?
On 07/15/2014 06:38 PM, Gmail wrote: My /usr partition in on the / partition. I just use initrd, i've compiled kernel with genkernel. I'm trying to look row for row if there's some diff. Il 15/07/2014 17:34, Alexander Kapshuk ha scritto: On 07/14/2014 05:18 PM, Gmail wrote: Hi, i've upgraded kernel from 3.12.13 to 3.12.20. I've make a oldconfig as usual, but with new kernel the boot blocks at the begining to the ramdisk loading. I've tried with other 3.12.2x with the same negative results. I use grub2 with systemd. Is your '/usr' partition housed on a filesystem of its own, or does it reside on the '/' partition? http://wiki.gentoo.org/wiki/Initramfs/HOWTO For systems where all necessary files and tools reside on the same file system, the |init| application can perfectly control the further boot process. But when multiple file systems are defined (or more exotic installations are done), this might become a bit more tricky: * When the /usr partition is on a separate file system, tools and drivers that have files stored within /usr cannot be used unless /usr is available. If those tools are needed to make /usr available, then we cannot boot up the system. * If the root file system is encrypted, then the Linux kernel will not be able to find the |init| application, resulting in an unbootable system. The solution for this problem has since long been to use an /initrd/ (initial root device). Did you run a diff on your 3.12.13/.config and 3.12.13/.config, to make sure you didn't overlook anything to do with the systemd-related config options? Did the output you got when generating 'grub.cfg' look similar to this? http://www.gentoo.org/doc/en/handbook/handbook-x86.xml?style=printablefull=1#genkernel Code Listing 2.3: Generating GRUB2 configuration # grub2-mkconfig -o /boot/grub/grub.cfg Generating grub.cfg ... Found linux image: /boot/vmlinuz-3.12.20-gentoo Found initrd image: /boot/initramfs-genkernel-x86-3.12.20-gentoo done The output of the command must mention that at least one Linux image is found, as those are needed to boot the system. If you use initramfs or used genkernel to build the kernel, the correct initrd image should be detected as well. If this is not the case, go to /boot and check the contents using the ls command. If the files are indeed missing, go back to the kernel configuration and installation instructions.
Re: [gentoo-user] kernel bug?
Maybe you doesn't have enabled systemd support . 2014-07-15 17:05 GMT+00:00 Alexander Kapshuk alexander.kaps...@gmail.com: On 07/15/2014 06:38 PM, Gmail wrote: My /usr partition in on the / partition. I just use initrd, i've compiled kernel with genkernel. I'm trying to look row for row if there's some diff. Il 15/07/2014 17:34, Alexander Kapshuk ha scritto: On 07/14/2014 05:18 PM, Gmail wrote: Hi, i've upgraded kernel from 3.12.13 to 3.12.20. I've make a oldconfig as usual, but with new kernel the boot blocks at the begining to the ramdisk loading. I've tried with other 3.12.2x with the same negative results. I use grub2 with systemd. Is your '/usr' partition housed on a filesystem of its own, or does it reside on the '/' partition? http://wiki.gentoo.org/wiki/Initramfs/HOWTO For systems where all necessary files and tools reside on the same file system, the init application can perfectly control the further boot process. But when multiple file systems are defined (or more exotic installations are done), this might become a bit more tricky: - When the /usr partition is on a separate file system, tools and drivers that have files stored within /usr cannot be used unless /usr is available. If those tools are needed to make /usr available, then we cannot boot up the system. - If the root file system is encrypted, then the Linux kernel will not be able to find the init application, resulting in an unbootable system. The solution for this problem has since long been to use an *initrd* (initial root device). Did you run a diff on your 3.12.13/.config and 3.12.13/.config, to make sure you didn't overlook anything to do with the systemd-related config options? Did the output you got when generating 'grub.cfg' look similar to this? http://www.gentoo.org/doc/en/handbook/handbook-x86.xml?style=printablefull=1#genkernel Code Listing 2.3: Generating GRUB2 configuration # grub2-mkconfig -o /boot/grub/grub.cfg Generating grub.cfg ... Found linux image: /boot/vmlinuz-3.12.20-gentoo Found initrd image: /boot/initramfs-genkernel-x86-3.12.20-gentoo done The output of the command must mention that at least one Linux image is found, as those are needed to boot the system. If you use initramfs or used genkernel to build the kernel, the correct initrd image should be detected as well. If this is not the case, go to /boot and check the contents using the ls command. If the files are indeed missing, go back to the kernel configuration and installation instructions.
[gentoo-user] Re: mysql to postgresql migration
J. Roeleveld joost at antarean.org writes: I recently ran across this script: py-mysql2pgsql [1] and this discussion on it's origin [2]. I'm keenly interested in the recommendations of others for migrating mysql databases to postgresql and any comments on this aforementioned script or other methodologies [1] https://github.com/philipsoutham/py-mysql2pgsql [2] http://www.tryolabs.com/Blog/2012/02/10/django-migrating-mysql- postgresql/ James, I haven't looked into this recently. But I believe that the DDLs and data can be migrated relatively easy. Just be aware that software specifically written using MySQLs version of SQL is unlikely to work on a different RDBMS without extensive rewrites. So, If you run the same program, say gnucash, on top of mysql, then migrate the mysql dB it to pgsql, it will require an extensive rewrite? This shouild be an easy example, which is quite common (google). So, let's just say that I run across mysql -- pgsql quite often to the point that it's time for me to develop some slick_skills here. This is the biggest problem people are facing when porting websites to use a different database. What is the reason for migrating and what kind of data and applications are you using? Joost Another more serious problem: I'm not porting websites, but more working on science applications with huge data. Some of it is organized via mysql, others are more in the form of vary large test vectors (matricies) that are sparsely populated. Others portions are double float or other forms of scientific data. So in this case there is not a one-2-one semantic. But, I do need to extract (dump?) mysql into a form where I can later include it into a much larger, designed from the ground floor up, pgsql dB. I relaize this sort of effort is unique, but surely some additional slick_tools exist for this sort of effort? Actually, some good articles, book, wikis, etc, would be keen too? James
Re: [gentoo-user] stable/testing system requiring an *UNstable* dev-lang/perl
On Tue, Jul 08 2014, Andreas K. Huettel wrote: Am Mittwoch, 9. Juli 2014, 00:02:56 schrieb gottl...@nyu.edu: For some reason my mostly-stable-slightly-testing system is trying to merge *UNstable* dev-lang/perl. I do not have a package.unmask file Specifically it wants me to unmask =dev-lang/perl-5.20.0-r1 An eix on the same system (with no sync in between) does not even show such a version as existing. I realize I must be misreading some output, but I can't find my error. Help would be greatly appreciated. [ebuild U ~] virtual/perl-ExtUtils-Command-1.180.0-r1 [1.180.0] 0 The following keyword changes are necessary to proceed: (see package.accept_keywords in the portage(5) man page for more details) # required by virtual/perl-ExtUtils-Command-1.180.0-r1 # required by perl-core/ExtUtils-MakeMaker-6.820.0 # required by virtual/perl-ExtUtils-MakeMaker-6.820.0 # required by perl-core/CPAN-Meta-2.132.510 # required by virtual/perl-CPAN-Meta-2.132.510 # required by perl-core/Module-Build-0.400.700 # required by virtual/perl-Module-Build-0.400.700 # required by dev-perl/File-MimeInfo-0.170.0 # required by x11-misc/xdg-utils-1.1.0_rc2[perl] # required by www-client/chromium-35.0.1916.153 # required by @selected # required by @world (argument) =dev-lang/perl-5.20.0-r1 ~amd64 =virtual/perl-ExtUtils-Command-1.180.0-r1 is the culprit. (And the autounmask recommendation by portage is weird. Which portage version is that?) It is sys-apps/portage-2.2.8-r1, the highest stable version. If you look at the emerge output, you see that you have ~arch virtual/perl- ExtUtils-Command. (Not masked, only ~arch) That specific version, virtual/perl-ExtUtils-Command-1.180.0-r1, can be fulfilled by either dev-lang/perl-5.20* (masked) or perl-core/ExtUtils- Command-1.180.0 (~arch). You have three alternative options: 1) downgrade virtual/perl-ExtUtils-Command to stable (recommended) 2) keyword perl-core/ExtUtils-Command ~arch (should be fine too) 3) unmask =dev-lang/perl-5.20* (NOT RECOMMENDED) Good luck, Andreas Sorry for the delay in responding; I was without convenient email access for a week. Thanks to everyone for their help. In particular to andreas. I used his second option, following neil's general advise for applying his goingstable procedure. All is well. thanks again, allan
Re: [gentoo-user] glibc-2.17 fails and warning: setlocale: LC_ALL error
On Tue, Jul 15, 2014 at 2:25 AM, Dale rdalek1...@gmail.com wrote: Anyway, I suspect strongly that the error is on the stage3 tarball. I got it installed but I have not been able to get a clean emerge -e system as of yet. I know you say you have the latest kernel installed, Dale, but are you certain it's the running kernel? uname -r to confirm :) -- Douglas J Hunley (doug.hun...@gmail.com) Twitter: @hunleyd Web: about.me/douglas_hunley G+: http://google.com/+DouglasHunley
Re: [gentoo-user] Re: mysql to postgresql migration
On 15 July 2014 19:40:14 CEST, James wirel...@tampabay.rr.com wrote: J. Roeleveld joost at antarean.org writes: I recently ran across this script: py-mysql2pgsql [1] and this discussion on it's origin [2]. I'm keenly interested in the recommendations of others for migrating mysql databases to postgresql and any comments on this aforementioned script or other methodologies [1] https://github.com/philipsoutham/py-mysql2pgsql [2] http://www.tryolabs.com/Blog/2012/02/10/django-migrating-mysql- postgresql/ James, I haven't looked into this recently. But I believe that the DDLs and data can be migrated relatively easy. Just be aware that software specifically written using MySQLs version of SQL is unlikely to work on a different RDBMS without extensive rewrites. So, If you run the same program, say gnucash, on top of mysql, then migrate the mysql dB it to pgsql, it will require an extensive rewrite? Not always. But if the software was written using the non standard SQL that is common when the developers only know MySQL then you are likely to find that the SQL is invalid for other databases. This shouild be an easy example, which is quite common (google). So, let's just say that I run across mysql -- pgsql quite often to the point that it's time for me to develop some slick_skills here. I deal with migrations and integration projects on a daily basis as part of my job. Some are simple. Some require extensive skills and knowledge. This is the biggest problem people are facing when porting websites to use a different database. What is the reason for migrating and what kind of data and applications are you using? Joost Another more serious problem: I'm not porting websites, but more working on science applications with huge data. Some of it is organized via mysql, others are more in the form of vary large test vectors (matricies) that are sparsely populated. Others portions are double float or other forms of scientific data. So in this case there is not a one-2-one semantic. But, I do need to extract (dump?) mysql into a form where I can later include it into a much larger, designed from the ground floor up, pgsql dB. I relaize this sort of effort is unique, but surely some additional slick_tools exist for this sort of effort? The tools that exist to make these things easier require plenty of practice and experience to use properly. For your usecase, if not too often, I would recommend exporting the DDL (all create table/index/ statements) and export the table contents to CSV files (with headers to ensure data goes back to correct columns) -- Joost -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Re: [gentoo-user] glibc-2.17 fails and warning: setlocale: LC_ALL error
Douglas J Hunley wrote: On Tue, Jul 15, 2014 at 2:25 AM, Dale rdalek1...@gmail.com mailto:rdalek1...@gmail.com wrote: Anyway, I suspect strongly that the error is on the stage3 tarball. I got it installed but I have not been able to get a clean emerge -e system as of yet. I know you say you have the latest kernel installed, Dale, but are you certain it's the running kernel? uname -r to confirm :) -- Douglas J Hunley (doug.hun...@gmail.com mailto:doug.hun...@gmail.com) Twitter: @hunleyd Web: about.me/douglas_hunley http://about.me/douglas_hunley G+: http://google.com/+DouglasHunley Yep. I posted that somewhere in this thread. Usually when I first install a kernel, I do a uname -r just to be certain. Even tho that was a fresh install, I checked it anyway. Sounds silly since it was the only kernel there but it's a habit now. lol I do that on my main rig too. Sometimes it is those simple things that bite us tho. It's always worth a mention. thumbs up Dale :-) :-)
Re: [gentoo-user] kernel bug?
2014-07-15 9:38 GMT-06:00 Gmail serverp...@gmail.com: My /usr partition in on the / partition. I just use initrd, i've compiled kernel with genkernel. I'm trying to look row for row if there's some diff. Are you using genkernel also to generate a the initramfs? for booting systemd this is not supported by genkernel(tthat's is pointed in the systemd instalation guide in the wiki), you should be using either sys-kernel/genkernel-next, or sys-kernel/dracut(this has been the most widely recommended on this list).
Re: [gentoo-user] File timestamps got confused...why?
On Tue, 15 Jul 2014 10:02:18 Dan Oriani wrote: On Mon, Jul 14, 2014 at 10:04:36PM +0100, Stroller wrote: On Mon, 14 July 2014, at 6:54 pm, meino.cra...@gmx.de wrote: I am running Gentoo Linux, which I update on a ~daily basis. ... solfire:/home/userfstat smartlog.txt What package provides `fstat`, please? I don't have it installed on this machine, and the first google hit for fstat gentoo suggests it's a BSD command, unavailable on Linux. http://forums.gentoo.org/viewtopic-p-1853116.html#1853116 Stroller. Not to get terribly off topic here, but fstat is, in fact, a C call. I wonder if this is simply a user-made tool. If you look at code examples for this call, it's not terribly difficult to use at all. Actually, I wonder if the tool this user is using pulls the wrong field and calls it 'year'. I don't think it's the wrong field. Most (all?) C time calls use years since 1900 instead of the actual year value, so the 114 return values from the original message look like they are just the raw returned data. (See 'man time.h' for more information) In 1999 or earlier this just gave you the correct 2-digit year value so yes, this does like like a Y2K problem, if not a very serious one. -- Reverend Paul Colquhoun, ULC. http://andor.dropbear.id.au/ Asking for technical help in newsgroups? Read this first: http://catb.org/~esr/faqs/smart-questions.html#intro
[gentoo-user] Re: Re: [gentoo-user] kernel bug?
Yes, genkernel-next should be used. look at the install gentoo gnome with
systemd from
scratch ( Sorry for currently I can not access Internet so can not provide your
link)
I have test genkernel-next with systemd (needed by GNOME 3.12)， all seems OK,
with
kernel version 3.15。
But now I am using KDE 4.13 with openRC on ZFS。systemd sometimes makes things
strange, I switched to KDE, all seems well currently.
;-)
2014-07-16
Thanks Best Regards.
陶治江 | TAO Zhijiang
研发处 | SOHO国际产品线
Tel: 3129
Mobile: 18938910923
Email: taozhijiang@tp-link.{net, com.cn}
发件人： Jc_García
发送时间： 2014-07-16 05:26:08
收件人： gentoo-user
抄送：
主题： Re: [gentoo-user] kernel bug?
2014-07-15 9:38 GMT-06:00 Gmail serverp...@gmail.com:
My /usr partition in on the / partition.
I just use initrd, i've compiled kernel with genkernel.
I'm trying to look row for row if there's some diff.
Are you using genkernel also to generate a the initramfs? for booting
systemd this is not supported by genkernel(tthat's is pointed in the
systemd instalation guide in the wiki), you should be using either
sys-kernel/genkernel-next, or sys-kernel/dracut(this has been the most
widely recommended on this list).
Re: [gentoo-user] File timestamps got confused...why?
On Wed, Jul 16, 2014 at 12:02:16PM +1000, Paul Colquhoun wrote: On Tue, 15 Jul 2014 10:02:18 Dan Oriani wrote: On Mon, Jul 14, 2014 at 10:04:36PM +0100, Stroller wrote: On Mon, 14 July 2014, at 6:54 pm, meino.cra...@gmx.de wrote: I am running Gentoo Linux, which I update on a ~daily basis. ... solfire:/home/userfstat smartlog.txt What package provides `fstat`, please? I don't have it installed on this machine, and the first google hit for fstat gentoo suggests it's a BSD command, unavailable on Linux. http://forums.gentoo.org/viewtopic-p-1853116.html#1853116 Stroller. Not to get terribly off topic here, but fstat is, in fact, a C call. I wonder if this is simply a user-made tool. If you look at code examples for this call, it's not terribly difficult to use at all. Actually, I wonder if the tool this user is using pulls the wrong field and calls it 'year'. I don't think it's the wrong field. Most (all?) C time calls use years since 1900 instead of the actual year value, so the 114 return values from the original message look like they are just the raw returned data. (See 'man time.h' for more information) In 1999 or earlier this just gave you the correct 2-digit year value so yes, this does like like a Y2K problem, if not a very serious one. -- Reverend Paul Colquhoun, ULC. http://andor.dropbear.id.au/ Asking for technical help in newsgroups? Read this first: http://catb.org/~esr/faqs/smart-questions.html#intro Yeah, you're definitely right there. I was thinking that it might have been another field, I wasn't even thinking of the year difference. Though I still wonder where he got this program from. It doesn't appear to be in any packages at all, doesn't even seem to be a part of any linux basesystems. -- Dan Oriani redchops.com (Website perpetually under construction) signature.asc Description: Digital signature
Re: [gentoo-user] File timestamps got confused...why?
2014-07-15 21:44 GMT-06:00 Dan Oriani d...@redchops.com: Yeah, you're definitely right there. I was thinking that it might have been another field, I wasn't even thinking of the year difference. Though I still wonder where he got this program from. It doesn't appear to be in any packages at all, doesn't even seem to be a part of any linux basesystems. he might have modified the example in the manual of stat(2), and compiled it, seems simple. Here's how I got a binary that stat() a file and prints the info. $ man fstat | sed -ne '364,419p' | gcc -x c -o ~/fstat.bin - ; ~/fstat.bin ~/fstat.bin File type:regular file I-node number:323473 Mode: 100755 (octal) Link count: 1 Ownership:UID=1000 GID=100 Preferred I/O block size: 4096 bytes File size:8413 bytes Blocks allocated: 24 Last status change: Tue Jul 15 22:51:33 2014 Last file access: Tue Jul 15 22:51:33 2014 Last file modification: Tue Jul 15 22:51:33 2014 -- Dan Oriani redchops.com (Website perpetually under construction)
