- Arch-general - lists.archlinux.org

[arch-general] upgrading mysql to mariadb
by David Benfell 30 Mar '13

30 Mar '13

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I had managed not to see this: https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/ But it turned up on one of my feeds today, so I went to work. All went well until the final step, the upgrade: Phase 3/3: Running 'mysql_fix_privilege_tables'... ERROR 1064 (42000) at line 87: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL, thread_id INTEGER NOT NULL, server_' at line 1 ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1243 (HY000) at line 89: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE ERROR 1064 (42000) at line 95: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, user_host MEDIUMTEXT NOT NULL, query_time TIME(6) NOT NULL, lock_t' at line 1 ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to EXECUTE ERROR 1243 (HY000) at line 97: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE ERROR 1064 (42000) at line 343: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, ERROR 1064 (42000) at line 354: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, ERROR 1548 (HY000) at line 1136: Cannot load from mysql.proc. The table is probably corrupted ERROR 1548 (HY000) at line 1137: Cannot load from mysql.proc. The table is probably corrupted ERROR 1548 (HY000) at line 1150: Cannot load from mysql.proc. The table is probably corrupted FATAL ERROR: Upgrade failed I haven't checked thoroughly, but it appears my sites are all up. So I really don't know what to make of this. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJRVhBJAAoJELJhbl/uPb4S7bwQAJHMeHYNO1I1PLD6/C9zvj+4 tNT7Z2qYAHyodnTY7ZzPs0726PX4OPPztPT4k28Bstl3CW4GSMyi9m2zliDJiJk+ q2mhfxNKkP3lAMH5Yq1Nzku86DEuibJtuzfSNm0HkNLGh9MnL/rL32nQRwaYT+XZ 1A8tBQtqNPUOvNLG6m1GoHqptwfuaWud72QWQ+iI3o8sqi2+rBeS9t0Lje3C3RVY 8R7XPk0ilOOwzItgC27zYWTJ8BuK//UsJ/cF4ZS1pcFk2+WvB9X7kwjKvFj0PP97 qqEjfnWwf6zspoCzKBg7rJQulh2VB4dGHaWljxWrDXyUn8DSoQ1Oyfz3GYHch0+l vetXks11NhVDEzxiJ1rtBQsAtPrXjOunTXAU2b9kuIt5aMbQVgUrfyavqSBFUa6j 6LZVAT7dkmCYVZIHwDkuwBRmc02x1TrigzpUlv8sqNEnd/MDsgX0IvhXBhJAF5j0 DueF8m7TGl8wl1UgVvpNNmJ/cfiJWC3+k3cmKLG+ldvoHzPVgBSbR1zeFKsqD5N3 lcU8VOGosxf2GpBNAIyXT8LYMdwg1FXvX8zkf3wyyUc+LhgbxWhRpGsUM2Kc5m+K X9UenI/SXJjrFBfRU31S+/voWQPCVPHb9RzHDM6oJyAsb7lDc6I/nRITDjXCu9U2 bzg/liGHVI39/2CYQpeO =4+EX -----END PGP SIGNATURE-----

2 1

[arch-general] downgrades when moving out of [testing]
by Matthew Monaco 28 Mar '13

28 Mar '13

I typically upgrade with -uu, and use [*testing]. I've noticed lately that there is a window when a package moves out of [testing] that it will be downgraded. For example, this happened when openssh-6.2 recently moved. Are the packages being removed from [testing] before being added to e.g. [core]? Does mirroring happen separately, but faster for [testing]? (I use kernel.org) Best, Matt

9 10

[arch-general] Automatically stop systemd service
by Robbie Smith 28 Mar '13

28 Mar '13

TL;DR: More toying with mobile broadband and systemd; would like help automatically stopping service depending on device availability. I’ve been adjusting the .service file for netcfg(a)ppp-mobile.service so it plays nicely with my modem. It will only start if the USB modem is plugged in and exposing a serial port to the computer, and when I manaually stop the unit, the ppp daemon is also killed, so it doesn’t lock the device and reconnect automatically upon the device being detected again, thus *bringing up the network interface when systemd and netcfg say it is down*. /etc/systemd/system/netcfg(a)ppp-mobile.service: ---------------------------------------------- .include /usr/lib/systemd/system/netcfg@.service [Unit] Description=Netcfg networking service for mobile broadband point to-point protocol. ConditionPathExists=/dev/ttyUSB0 [Service] KillMode=control-group What I cannot figure out how to do is automatically stop the service if the device is unplugged, similar to how ifplugd works for wired ethernet interfaces. I’ve read the manual pages and asked Google, and I cannot seem to find more detailed information. I think it may be possible to write a service that will use udev’s polling capabilities, but then I have to somehow link that unit to the netcfg one such that it gets stopped and started when netcfg is, which implies it would listen to udev, wait for the device to be unplugged, then stop netcfg and kill itself. systemd's PartOf= may offer an answer, but I don’t really know how to tie it all together. How should I best go about this? Another systemd service, a udev rule, or is it possible to further modify the ppp-mobile service? regards, Robbie

2 4

[arch-general] netctl development
by Robbie Smith 28 Mar '13

28 Mar '13

Is there a publicly-accessible list to follow the development of netcfg’s successor-to-be, netctl? From my experiments with systemd and netcfg, there’s a few features that could definitely come in useful, and I’m certainly willing to help contribute where I can, be it testing, coding, or writing documentation. Does it depend on anything in [testing] or could I build and install it via ABS/AUR?

2 2

[arch-general] [classroom] PKGBUILD Lessons postponed
by William Giokas 27 Mar '13

27 Mar '13

All, The first Arch Linux class has been postponed. The other presenter, Daniel Wallace, has recently been hired and will be inactive[0]. He will be unavailable for much of the next month as well. March 31st is Easter, and we understand that many people will be unable to attend. That being said, we sill still be having this class at a later date, so keep your weekends open if you are planning to attend. The time (16:00 UTC) will remain the same. Daniel: I know I've said it many times on IRC, but congratulations on the job! [0]: https://mailman.archlinux.org/pipermail/aur-general/2013-March/022850.html Thank you, -- William Giokas | KaiSforza GnuPG Key: 0x73CD09CF Fingerprint: F73F 50EF BBE2 9846 8306 E6B8 6902 06D8 73CD 09CF

1 0

[arch-general] MaraDNS and Zonetransfer
by Δημήτρης Ζέρβας 27 Mar '13

27 Mar '13

I want am using MaraDNS and I want to enable zonetransfer. When I try to enable zonetransfer service via systemd, I get failed status and this in my messages.log: Mar 27 18:01:53 localhost systemd[1]: Starting Zone AXFR service for MaraDNS server... Mar 27 18:01:53 localhost systemd[1]: Started Zone AXFR service for MaraDNS server. Mar 27 18:01:53 localhost systemd[1]: zoneserver.service: main process exited, code=exited, status=3/NOTIMPLEMENTED Mar 27 18:01:53 localhost systemd[1]: Unit zoneserver.service entered failed state I am able to start zonetransfer with "duende zonetransfer -f /etc/mararc". Also, I am able to start zonetranfer via systemd when I bring maradns down, then if I start maradns I'll get the same errors in my messages.log BTW: journalctl is disabled because it was resource hungry. So, all messages go @/var/log/messages.log Thank you.

1 0

[arch-general] Question about mariadb replacing mysql
by Mike Cloaked 27 Mar '13

27 Mar '13

With the move to mariadb I have the following situation: I am not explicitely running mysqld so checking the status with systemctl shows it is inactive. However I am running KDE as my desktop. After doing the suggested install after ensuring that mysqld is stopped: pacman -S mariadb libmariadbclient mariadb-clients and accepting the install of these packages with removal of mysql equivalents, I then find that there is a private instance of mysql running by the KDE desktop: ps -eaf | egrep mysql mike 660 657 0 Mar23 ? 00:00:42 /usr/bin/mysqld --defaults-file=/home/mike/.local/share/akonadi/mysql.conf --datadir=/home/mike/.local/share/akonadi/db_data/ --socket=/home/mike/.local/share/akonadi/socket-home1/mysql.socket mike 9747 761 0 13:39 pts/3 00:00:00 egrep mysql So does any expert know whether a mysql_upgrade is necessary for KDE and if so how does one go about doing that upgrade? Thanks. -- mike c

4 9

[arch-general] Upgrade finish in a "Kernel Panic - not syncing : no init found"
by Dany De Bontridder 27 Mar '13

27 Mar '13

Hi, I reinstalled 2 weeks ago arch linux, because a pacman -Syu broke everything. Today, everything works fine and I decide to keep my PC up-to-date, so I run pacman -Syu and I get a message when trying to boot *** Kernel Panic - not syncing : No init found. *** Of course, because I saved the list of the packages before and after this upgrade, (with pacman -Qe) I tried to downgrade, but it doesn't work at all. I still have the same message error, I checked and changed the grub.cfg without no success : the rootfs is correct, the init is on /dev/sda2 (a link to /usr/lib/systemd/systemd) So I tried to append to vmlinuz line "init=3" "init=/sbin/init" "init=/usr/lib/systemd/systemd" ... Without any success even when downgrading the kernel version (from 3.8 to 3.7) I can of course reinstall everything but I prefer to avoid that, someone can help me please ??? I really don't understand what happened. Thanks in advance Dany

6 9

[arch-general] Broadcom B43 problems
by Magnus Therning 27 Mar '13

27 Mar '13

I have seen some indications that my Broadcom B43 *ought* to work with the kernel's b43 driver, but I've never managed to get it working on my own. I'd love to be able to switch away from the broadcom-wl package is possible. Using a kernel from a few days ago, 3.7.9 and the b43-firmware package from AUR I only get as far as connecting to my router (at least that's what NetworkManager says), but then I can't actually connect to any site. If I then bring down the network and then bring it back up again the connection to the router will fail (NetworkManager keeps asking for the password). Any suggestions on what might be causing this, and what I should try next? /M % lspci -nn|grep Broadcom 03:00.0 Network controller [0280]: Broadcom Corporation BCM4312 802.11b/g LP-PHY [14e4:4315] (rev 01) Wireless network uses WPA2 -- Magnus Therning OpenPGP: 0xAB4DFBA4 email: magnus(a)therning.org jabber: magnus(a)therning.org twitter: magthe http://therning.org/magnus I invented the term Object-Oriented, and I can tell you I did not have C++ in mind. -- Alan Kay

8 13

[arch-general] strange behaviour of pacman, what did I do?
by Shridhar Daithankar 27 Mar '13

27 Mar '13

Hi I was updating an archroot, created with mkarchroot to play with lxc. I thought following would work but it was doing something else altogether ------------------------ [root@bheem lxc]# pacman -Su -c /var/cache/pacman/pkg/ --root=$PWD/server1 Cache directory: /var/cache/pacman/pkg/ Packages to keep: All locally installed packages Do you want to remove all other packages from cache? [Y/n] ^C Interrupt signal received ------------------------ I think I lost a few packages during this because following command lead to a 30MB worth of download. ------------------------ [root@bheem lxc]# pacman -Su --cachedir=/var/cache/pacman/pkg/ --root=$PWD/server1 ------------------------ What did pacman do the first time? The man page does not have bare -c option and it wasn't -Sc where it started cleaning the packages(or was it?) And just to be sure.. I wanted to run pacman on the host again.. and eh? I lost my synced dbs? Thats strange.. ------------------------ [root@bheem lxc]# pacman -Syu :: Synchronizing package databases... error: core.db appears to be truncated: 3990/0 bytes error: failed retrieving file 'core.db' from mirrors.kernel.org : Failed error: core.db appears to be truncated: 3990/0 bytes error: core.db appears to be truncated: 3990/0 bytes error: core.db appears to be truncated: 3990/0 bytes error: failed retrieving file 'core.db' from mirrors.easynews.com : Resolving timed out after 10000 milliseconds core is up to date 0.0 B 0.00B/s 00:00 [---------------------------------------------------------------------] 0% extra 1416.8 KiB 205K/s 00:07 [#####################################################################] 100% community 1917.7 KiB 206K/s 00:09 [#####################################################################] 100% :: Starting full system upgrade... there is nothing to do ------------------------ -- Regards Shridhar

2 2