- Arch-general - lists.archlinux.org

Re: [arch-general] Fwd: Re: [arch-dev-public] MySQL 5.5
by Marek Otahal 22 Dec '10

22 Dec '10

On Wednesday 22 of December 2010 16:51:23 Andrea Scarpino wrote: > On Wednesday 22 December 2010 15:35:38 Marek Otahal wrote: > > Well, I managed to get it running: > > install mysql (& the rest) from extra, run mysql_upgrade (ok), restart > > mysqld, install from testing, now mysqld restart works, but on > > > mysql_upgrade i get : > Hi, did you set some password? If so, try with mysql_upgrade -p. > (and with mysql running) Thanks Andrea, it was the password. Now running all fine. I had to use this link to reset the passwd : http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting- permissions-unix --just note: the file with sql command to change pwd must be chmod a+r 'd and placed to an accessible folder if done under root and run as --user=mysql. I also had to rm some log files since size did not fit and it died with error. After this I could run mysql_upgrade -p , restart mysqld and now everything plays nice. Thanks everyone and merry Christmas :o) -- Marek Otahal :o)

1 0

[arch-general] Fwd: Re: [arch-dev-public] MySQL 5.5
by Marek Otahal 22 Dec '10

22 Dec '10

Well, I managed to get it running: install mysql (& the rest) from extra, run mysql_upgrade (ok), restart mysqld, install from testing, now mysqld restart works, but on mysql_upgrade i get : # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '-- socket=/var/run/mysqld/mysqld.sock' '--port=3306' '-- socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect FATAL ERROR: Upgrade failed [root@beruska etc]# /etc/rc.d/mysqld restart :: Stopping MySQL Server [DONE] :: Starting MySQL Server [DONE] [root@beruska etc]# ...all config files are untouched. -- Marek Otahal :o)

2 1

Re: [arch-general] [arch-dev-public] MySQL 5.5
by Marek Otahal 22 Dec '10

22 Dec '10

On Wednesday 22 of December 2010 10:29:43 Andrea Scarpino wrote: > > [root@beruska ~]# mysql_upgrade > > Looking for 'mysql' as: mysql > > Looking for 'mysqlcheck' as: mysqlcheck > > Running 'mysqlcheck' with connection arguments: '--port=3306' '-- > > socket=/var/run/mysqld/mysqld.sock' '--port=3306' '-- > > socket=/var/run/mysqld/mysqld.sock' > > mysqlcheck: Got error: 2002: Can't connect to local MySQL server through > > socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect > > FATAL ERROR: Upgrade failed > > > > Any ideas? > > Is mysql running? It is not, mysqld doesn't know some option '--skip-locking' . Here's my debugging : [root@beruska ~]# ps aux | grep mysql marek 27468 1.1 1.2 235992 24788 ? Sl 11:19 0:03 /usr/bin/mysqld --defaults-file=/home/marek/.local/share/akonadi//mysql.conf --datadir /home/marek/.local/share/akonadi/db_data/ -- socket=/home/marek/.local/share/akonadi/db_misc/mysql.socket root 27829 0.0 0.0 4284 828 pts/2 S+ 11:23 0:00 grep mysql [root@beruska ~]# /etc/rc.d/mysqld restart :: Stopping MySQL Server [FAIL] :: Starting MySQL Server [FAIL] [root@beruska ~]# vim /etc/rc.d/mysqld I tried the commands manually to see output [root@beruska ~]# pgrep -u mysql mysqld [root@beruska ~]# /usr/bin/mysqld_safe --user=mysql 101222 11:26:35 mysqld_safe Logging to '/var/lib/mysql/beruska.err'. 101222 11:26:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 101222 11:26:37 mysqld_safe mysqld from pid file /var/lib/mysql/beruska.pid ended [root@beruska ~]# /usr/bin/mysqladmin -uUNKNOWN_USER ping /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! [root@beruska ~]# ls -l /var/run/mysqld/mysqld.sock ls: cannot access /var/run/mysqld/mysqld.sock: No such file or directory [root@beruska ~]# tail -10 /var/lib/mysql/beruska.err 101222 11:26:36 InnoDB: highest supported file format is Barracuda. 101222 11:26:36 InnoDB: 1.1.4 started; log sequence number 1591525 101222 11:26:36 [ERROR] /usr/bin/mysqld: unknown option '--skip-locking' 101222 11:26:36 [ERROR] Aborting 101222 11:26:36 InnoDB: Starting shutdown... 101222 11:26:37 InnoDB: Shutdown completed; log sequence number 1591525 101222 11:26:37 [Note] /usr/bin/mysqld: Shutdown complete 101222 11:26:37 mysqld_safe mysqld from pid file /var/lib/mysql/beruska.pid ended Thanks, Marek -- Marek Otahal :o)

2 2

Re: [arch-general] [arch-dev-public] MySQL 5.5
by Marek Otahal 22 Dec '10

22 Dec '10

On Wednesday 22 of December 2010 08:33:20 Andrea Scarpino wrote: > On Tuesday 21 December 2010 16:16:57 Andrea Scarpino wrote: > > I am trying to update mysql to 5.5.8. It uses cmake now. > > > > I built and successfully installed it on my system. It seems to work, but > > I won't broke any Arch Linux system and I want to know the right > > procedure on how to proceed with this major update. > > Also, before I put the packages in [testing], I'd like if someone can > > take a look to them or try the new packages. > > > > PKGBUILD is here[1]; packages are here[2]. > > A diff between my PKGBUILD and the current one is here[3]. > > > > Remember that you need to run mysql_upgrade as root after the > > installation and with mysql running. I added a message to post_update() > > for this. > > No reply. This goes in [testing] to get more feedback. You were right :) ==> Software upgrade (new version) : testing/libmysqlclient 5.1.51-1 -> 5.5.8-1 testing/mysql-clients 5.1.51-1 -> 5.5.8-1 testing/mysql 5.1.51-1 -> 5.5.8-1 ==> Continue upgrade ? [Y/n] ==> [V]iew package detail [M]anually select packages ==> -------------------------------------------------- ==> :: Starting full system upgrade... resolving dependencies... looking for inter-conflicts... Targets (3): libmysqlclient-5.5.8-1 [3.38 MB] mysql-clients-5.5.8-1 [0.68 MB] mysql-5.5.8-1 [6.20 MB] Total Download Size: 10.26 MB Total Installed Size: 103.15 MB Proceed with installation? [Y/n] :: Retrieving packages from testing... libmysqlclient-5.5.8-1-i686 3.4M 150.8K/s 00:00:23 [#####################################] 100% mysql-clients-5.5.8-1-i686 694.4K 52.0K/s 00:00:13 [#####################################] 100% mysql-5.5.8-1-i686 6.2M 142.8K/s 00:00:44 [#####################################] 100% checking package integrity... (3/3) checking for file conflicts [#####################################] 100% (1/3) upgrading libmysqlclient [#####################################] 100% (2/3) upgrading mysql-clients [#####################################] 100% (3/3) upgrading mysql [#####################################] 100% warning: directory permissions differ on var/lib/mysql/ filesystem: 755 package: 700 Major version update. Consider running mysql_upgrade. [root@beruska ~]# mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '-- socket=/var/run/mysqld/mysqld.sock' '--port=3306' '-- socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect FATAL ERROR: Upgrade failed Any ideas? Thanks, Marek -- Marek Otahal :o)

2 1

[arch-general] Arduino 64 Wiki page
by Neil Munro 22 Dec '10

22 Dec '10

Hello all I have spend the last 3 hours hunting down a way to make my arduino uno work with arch64, and appear to have been successful. Upon noting the arch64 wiki page had been removed I rewrote it. However I imagine its not quite to arch documentation standards, but I would like to get it to that point. It can be found here: https://wiki.archlinux.org/index.php/Arduino_64bit I would be grateful for feedback to help improve the quality of the document and if possible help testing that my experience was not a fluke. Thanks. Neil

3 2

[arch-general] updating xorg packages and nvidia packages, now x doesn't start
by Jeffrey Lynn Parke Jr. 20 Dec '10

20 Dec '10

I did a big update on my main arch machine and rebooted, I can't start X anymore. I saw that xorg-xinit and xorg-xauth as well as the nvidia packages were upgraded. Startx gives me a blank screen and switching to the first login (ctrl-alt-F1) shows a never ending "No Protocol Specified" message which finally fails with "xinit: unable to connect to X server: Connection refused" and "Xauth: error in locking authority file /home/user/.Xauthority" I checked my Xorg.0.log file and I see this message listed: (II) NVIDIA(0): Setting mode "nvidia-auto-select" (II) NVIDIA(0): ACPI: > failed to connect to the ACPI event daemon; the daemon (II) NVIDIA(0): may > not be running or the "AcpidSocketPath" X (II) NVIDIA(0): configuration > option may not be set correctly. When the (II) NVIDIA(0): ACPI event daemon > is available, the NVIDIA X driver will (II) NVIDIA(0): try to use it to > receive ACPI event notifications. For (II) NVIDIA(0): details, please see > the "ConnectToAcpid" and (II) NVIDIA(0): "AcpidSocketPath" X configuration > options in Appendix B: X (II) NVIDIA(0): Config Options in the README what could be the problem here?

4 6

Re: [arch-general] [arch-dev-public] [signoff] reiserfsprogs-3.6.21-3
by Allan McRae 20 Dec '10

20 Dec '10

On 04/12/10 22:34, Allan McRae wrote: > Rebuild and tidy of old package. > > Signoff both, > Allan > Anyone. User signoffs are all good too.

2 1

Re: [arch-general] [arch-dev-public] [signoff] isdn4k-utils-3.2p1-6
by Allan McRae 20 Dec '10

20 Dec '10

On 04/12/10 22:33, Allan McRae wrote: > Rebuild and tidy-up of old package. Merged the separate build fixes for > gcc-3.3, gcc-3.4 and gcc-4.0 into one patch. > > Signoff both, > Accepting user signoffs here too. Allan

1 0

[arch-general] postfix/procmail unable to write to /var/spool/mail/$USER
by David C. Rankin 19 Dec '10

19 Dec '10

Guys, I'm stuck on mail setup with a procmail error saying it can't write to /var/spool/mail/$USER. It is a postfix error, but it is complaining about procmail. An example of the error is: Dec 18 19:10:37 localhost postfix/local[2104]: E238BE7E78: to=<david@mymailaddress>, relay=local, delay=1.2, delays=0.14/0.04/0/1, dsn=5.2.0, status=bounced (can't create user output file. Command output: procmail: Error while writing to "/var/spool/mail/david" ) I'm fairly certain it is a user permission problem, but I can't recall ever changing anything before on my other setups to get procmail working. In this current config, /etc/postfix/main.cf has: mailbox_command = /usr/bin/procmail -a "$EXTENSION" The permission for /var/spool/mail are the exact same I have on my x86_64 Arch server at home where procmail is working just fine: [19:27 phoenix:/var/spool/mail] # l total 386772 drwxrwxrwt 2 root root 4096 Dec 18 19:13 . drwxr-xr-x 8 root root 4096 Dec 18 16:54 .. -rw------- 1 david dcr 362640748 Dec 18 19:05 david <snip> Just as with that box, I moved the mail spool from the suse install to the new install, so I don't think that would be the issue here. Anybody have any idea why postfix/procmail can't write to /var/spool/mail? -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com

3 4

[arch-general] dhcpd fails to start when using TSIG key created with hmac-sha256 encryption
by David C. Rankin 18 Dec '10

18 Dec '10

Guys, I have run into a problem with the dhcpd daemon refusing to start when using the default hmac-sha256 algorithm for key encryption. A good description of the problem is here: http://www.pubbs.net/201009/dhcp/8256-cant-start-isc-dhcpd-420.html The bind documentation shows host key creation using: dnssec-keygen -a hmac-sha256 -b 128 -n HOST yoursite.com This results in the following host key: Kyoursite.com.+163+02215.key it contains yoursite. IN KEY 512 3 163 BV_the_key________DG/g== from which you create the key for use with bind and dhcp in the form key yoursite.com { algorithm hmac-sha256; secret "BV_the_key________DG/g=="; }; bind will start and run using the key, but dhcpd fails to start giving the following error: [15:54 phoenix:/etc] # dhcpd -f Internet Systems Consortium DHCP Server 4.2.0-P1 Copyright 2004-2010 Internet Systems Consortium. All rights reserved. For info, please visit https://www.isc.org/software/dhcp/ ../../../lib/dns/dst_api.c:1023: REQUIRE(keyp != ((void *)0) && (((*keyp) != ((void *)0)) && (((const isc__magic_t *)(*keyp))->magic == ((('D') << 24 | ('S') << 16 | ('T') << 8 | ('K')))))) failed, back trace #0 0x81756de in ?? #1 0x8175837 in ?? #2 0x8151058 in ?? #3 0x80c331a in ?? #4 0x80a7150 in ?? #5 0x80aa6cf in ?? #6 0x805c59c in ?? #7 0x8061bda in ?? #8 0x8061e6b in ?? #9 0x80620fc in ?? #10 0x804beab in ?? #11 0xb75fbc76 in ?? #12 0x804a0d1 in ?? Aborted Simply regenerating the key with hmac-md5 to create a ..+157..key works (dnssec complains about hmac-md5 now for some reason): dnssec-keygen -a hmac-md5 -b 128 -n HOST yoursite.com and then using that key in dhcpd.conf works fine. Does anybody have any additional background on this problem? I'm always hesitant to use an older key version when apparently ISC want you to use sha256. But obviously I need to get dhpcd going and providing updates to bind. Are there better alternatives to hmac-md5? -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com

1 1