Re: [gentoo-user] [systemd] Is this a NetworkManager bug?
On Mon, 13 Oct 2014 16:39:18 -0700, walt wrote: I just switched my home LAN from wired to all wifi and I'm having trouble with NetworkManager at boot time. I have systemd start NetworkManager at boot because I need the internet for ntpdate and to start the nfs server for the LAN. Before I switched to all-wireless this method worked perfectly, but no longer. If you only connect to a limited number of networks, you can do without NM and let systemd-networkd handle it all for you. https://bbs.archlinux.org/viewtopic.php?id=178625 For roaming, a network manager of some type is still preferable. -- Neil Bothwick Tact is the intelligence of the heart. signature.asc Description: PGP signature
[gentoo-user] [slightly O/T] mysql problems
Hi All, This may be slightly off topic, but I thought of asking here first. I noticed two problems, one specific to a particular database, the other more general. In reverse order: 1. I am getting this error when I start mysqld 141014 19:41:38 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated' Sure enough I seem to have this in /etc/mysql/my.cnf: # Uncomment this to get FEDERATED engine support #plugin-load=federated=ha_federated.so loose-federated As far as I recall this is a default setting. Should I change it? 2. A particular database which I have imported locally from a live site gives me loads of this: 141014 19:41:37 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 141014 19:41:37 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './website1@002dnew/webform_validation_rule_components.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. Is this some error imported from the live site, or is it due to something being wrong locally? Any ideas how to fix this? -- Regards, Mick signature.asc Description: This is a digitally signed message part.
Re: [gentoo-user] [slightly O/T] mysql problems
On 10/14/2014 11:54 AM, Mick wrote: Hi All, This may be slightly off topic, but I thought of asking here first. I noticed two problems, one specific to a particular database, the other more general. In reverse order: 1. I am getting this error when I start mysqld 141014 19:41:38 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated' Did you compile with the 'extraengine' USE flag? It's required for federated engine support. 141014 19:41:37 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './website1@002dnew/webform_validation_rule_components.ibd'! Does this file (and directory) exist? Is this some error imported from the live site, or is it due to something being wrong locally? Most likely the live website stores its files in a different place. I'm not sure how to fix that, though. I would imagine the error text gives hints. (DISCARD TABLESPACE and IMPORT TABLESPACE - I've never used them.) Then again, I only use mysql for pretty basic stuff. Dan
Re: [gentoo-user] has anyone tried KDE5?
On 10/13/2014 10:50 PM, J. Roeleveld wrote: What do you mean with select Do all the entries become selected (marked) ready for delete/copy/...? Yes. It's been doing this since I upgraded to KDE4 with Dolphin. KDE3 was perfectly fine. I have seen this behaviour in a lot of different programs (also on MS Windows). Usually caused by some key-combination which is accidentally pressed and forces the shift-key to be locked. I thought that but it isn't the case. I am using this particular install through spawning VNC sessions on my server. As I said, KDE3 did not have this issue at all (used with the exact same VNC setup), nor does it present itself in apps other than Dolphin. Strange, huh? Dan
Re: [gentoo-user] [slightly O/T] mysql problems
On 14/10/2014 19:54, Mick wrote: Hi All, This may be slightly off topic, but I thought of asking here first. I noticed two problems, one specific to a particular database, the other more general. In reverse order: 1. I am getting this error when I start mysqld 141014 19:41:38 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated' Sure enough I seem to have this in /etc/mysql/my.cnf: # Uncomment this to get FEDERATED engine support #plugin-load=federated=ha_federated.so loose-federated As far as I recall this is a default setting. Should I change it? No. I presume that you are not actively using the federated storage engine but let's put that aside because there is more to this error than meets the eye. Check your MySQL error log and look for any anomalies from the point at which MySQL is started. If you don't know where the log file is, execute SELECT @@log_error. I have several questions: * Have you started MySQL with skip-grant-tables in effect? * Have you upgraded MySQL recently without going through the documented upgrade procedure? [1] * Have you copied files into MySQL's data directory that originated from a different version of MySQL? * Have you otherwise removed or modified files in the data directory? 2. A particular database which I have imported locally from a live site gives me loads of this: The wording here suggests a broader context that would be relevant. Please be specific as to the circumstances. What procedure did you employ in order to migrate and import the database? What do you mean by live site? Which versions of MySQL are running at both source and destination? How are they configured? 141014 19:41:37 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 141014 19:41:37 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './website1@002dnew/webform_validation_rule_components.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. Is this some error imported from the live site, or is it due to something being wrong locally? MySQL believes that an InnoDB table named webform_validation_rule_components presently exists in a database named website1@002dnew but the corresponding tablespace file does not exist, relative to the MySQL datadir. The reason for this may become clear if you answer the questions posed above. --Kerin [1] https://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html (and its predecessors)
Re: [gentoo-user] has anyone tried KDE5?
On 14/10/2014 21:22, Daniel Frey wrote: On 10/13/2014 10:50 PM, J. Roeleveld wrote: What do you mean with select Do all the entries become selected (marked) ready for delete/copy/...? Yes. It's been doing this since I upgraded to KDE4 with Dolphin. KDE3 was perfectly fine. I have seen this behaviour in a lot of different programs (also on MS Windows). Usually caused by some key-combination which is accidentally pressed and forces the shift-key to be locked. I thought that but it isn't the case. I am using this particular install through spawning VNC sessions on my server. As I said, KDE3 did not have this issue at all (used with the exact same VNC setup), nor does it present itself in apps other than Dolphin. Strange, huh? Not really strange - I got something similar with dolphin too. I use NFS mounts in dolphin a lot (not using the built-in nfs kpart, it's a traditional mount). Double clicking through on folder names would often select everything from where the cursor landed to the top of what is shown in the dolphin window. F5 refresh, or Alt-left and Alt-right wouldn't change anything (I assume some caching is involved). But, clicking away from the current pane to some other folder outside the nfs mount, then re-navigating back to it would make the issue go away. I keep this ~amd64 system quite current (update twice weekly or so) and haven't run into this again for about 6 weeks now. Looks like someone fixed something, in whole or in part. -- Alan McKinnon alan.mckin...@gmail.com
Re: [gentoo-user] [slightly O/T] mysql problems
On Tuesday 14 Oct 2014 20:21:27 Daniel Frey wrote: On 10/14/2014 11:54 AM, Mick wrote: Hi All, This may be slightly off topic, but I thought of asking here first. I noticed two problems, one specific to a particular database, the other more general. In reverse order: 1. I am getting this error when I start mysqld 141014 19:41:38 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated' Did you compile with the 'extraengine' USE flag? It's required for federated engine support. I had emerged mysql with USE=-extraengine it seems. However the configuration includes the federated option regardless. -- Regards, Mick signature.asc Description: This is a digitally signed message part.
Re: [gentoo-user] [slightly O/T] mysql problems
On Tuesday 14 Oct 2014 21:15:48 Kerin Millar wrote: On 14/10/2014 19:54, Mick wrote: # Uncomment this to get FEDERATED engine support #plugin-load=federated=ha_federated.so loose-federated As far as I recall this is a default setting. Should I change it? No. I presume that you are not actively using the federated storage engine but let's put that aside because there is more to this error than meets the eye. Check your MySQL error log and look for any anomalies from the point at which MySQL is started. If you don't know where the log file is, execute SELECT @@log_error. 141014 19:41:37 [Warning] No argument was provided to --log-bin, and --log- bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem. 141014 19:41:37 InnoDB: The InnoDB memory heap is disabled 141014 19:41:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 141014 19:41:37 InnoDB: Compressed tables use zlib 1.2.8 141014 19:41:37 InnoDB: Using Linux native AIO 141014 19:41:37 InnoDB: Initializing buffer pool, size = 16.0M 141014 19:41:37 InnoDB: Completed initialization of buffer pool 141014 19:41:37 InnoDB: highest supported file format is Barracuda. 141014 19:41:37 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 141014 19:41:37 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './website1@002dnew/actions.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html I have several questions: * Have you started MySQL with skip-grant-tables in effect? Not knowingly. How do I find out? * Have you upgraded MySQL recently without going through the documented upgrade procedure? [1] I'm still on mysql-5.5.39 Installed versions: 5.5.39(16:42:22 08/09/14)(community perl ssl - bindist -cluster -debug -embedded -extraengine -jemalloc -latin1 -max-idx-128 -minimal -profiling -selinux -static -static-libs -systemtap -tcmalloc -test) * Have you copied files into MySQL's data directory that originated from a different version of MySQL? No, not manually. * Have you otherwise removed or modified files in the data directory? Not as far as I know. I have suspicions of fs corruption though (it's been running out of space lately and I haven't yet found out why). 2. A particular database which I have imported locally from a live site gives me loads of this: The wording here suggests a broader context that would be relevant. Please be specific as to the circumstances. What procedure did you employ in order to migrate and import the database? What do you mean by live site? Which versions of MySQL are running at both source and destination? How are they configured? mysql -u webadmin -h localhost -p website_test website1_20141014.sql The server is on 5.5.36. website1 is the database name of the live site, and website_test is the local development database. The server is a shared server, so I'm getting its vanilla configuration with no choice on the matter. The local configuration is attached. Is this some error imported from the live site, or is it due to something being wrong locally? MySQL believes that an InnoDB table named webform_validation_rule_components presently exists in a database named website1@002dnew but the corresponding tablespace file does not exist, relative to the MySQL datadir. The reason for this may become clear if you answer the questions posed above. I'll check this when I get a minute and report back. Right now the machine is locked up - no space left on the root partition for some obscure reason. I need to start clearing stuff out. Thanks for your help! -- Regards, Mick # /etc/mysql/my.cnf: The global mysql configuration file. # $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-5.5,v 1.3 2014/04/25 00:43:46 jmbsvicetto Exp $ # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket = /var/run/mysqld/mysqld.sock [mysql] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqladmin] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqlcheck] character-sets-dir=/usr/share/mysql/charsets default-character-set=utf8 [mysqldump]
[gentoo-user] [OT] Six non-Gentoo installs
In order to do some software testing (having mostly to do with different init systems), I installed 6 distros yesterday and this morning (I already had both 32 and 64 bit Gentoo/Openrc systems installed). These were all on a single 1TB drive with a bunch of 100GB partitions that contain a Windows system and eight Linux systems. [There's a master installation of Grub legacy that chainloads any one of the 9 OS partitions.] My 6 latest installs were: Xubuntu 12.04 Xubuntu 13.10 Xubuntu 14.04 CentOS 5.11 CentOS 6.5 CentOS 7.0 CentOS 5.11 was the only downloaded ISO that wouldn't boot directly from a USB flash drive and required that a CD be burned. The first five were all quick and uneventful and took a total of maybe 3-4 hours (including downloading the ISO images). At each step of the installs it was obvious what to do. They all allowed me to use the existing partitioning table and install both OS and bootloader into an existing partition. They all recognized both Ethernet adapters, and all booted fine when chainloaded by my master copy of Grub legacy. CentOS 7.0, however, was a mess. It took three attempts and almost an entire day of work. My first attempt was to use the minimal ISO image so that I would have the option of burning a CD if needed (I can't burn DVDs at the moment). That was a mistake. It was too minimal, and I couldn't get the network working to the point where I could configure repositories and install other stuff. Since the CentOS 7 ISO images all boot from USB flash drive anyway, staying under the 700MB CD size limit was moot anyway. Next I tried the net install ISO. I'm guessing I could have burned the DVD image to USB drive, but all I want is a minimal desktop system, so I figured why wait for a download of 3.5GB of stuff I don't care about. It still didn't recognize the NVidia Ethernet controller on my 5-year-old motherboard. After some cable swapping and futzing around, I got the netinstall going using the Realtek NIC. Maybe I just got unlucky and picked a slow mirror site, but once I got the install going, it ran for over 3 hours when installing a vanilla Gnome desktop system. Compare that with a 15 minute download time for a 700MB Xubuntu CD and then a 15 minute install. CentOS 7 refused to install the bootloader in a partition: your only choices are MBR or nothing. When I manually installed grub legacy it failed because I had stupidly allowed CentOS to use ext4, and the build of Grub I had laying around didn't grok ext4. So I re-do the whole net install again using ext3 instead. Now, after manually installing Grub legacy in the CentOS 7 partition, it boots up. The next problem is that the Gnome Shell is burning 100% of the CPU time, and a terminal window can't even keep up with my typing. Forget that: I can do what I want via ssh, so just disable X11. CentOS still doesn't recognize the NVidia motherboard Ethernet controller. After Google finds me a pages full of links to other people complaining about the exact same thing, I find out RedHat decided that the NVidia forcedeth driver wasn't widely used enough to deserve inclusion on an ISO image that was already 360+ MB. Thanks for that, RedHat. So it takes another 45 minutes of faffing around finding a third party src.rpm file for the forcedeth module and installing it. [It was either that or build a kernel and initrd.] After about 7 hours I got a usable CentOS 7 system running (as long as I don't try to use the Gnome desktop). I'm more convinced than ever that Gentoo is the way to go for my real systems... -- Grant Edwards grant.b.edwardsYow! I feel partially at hydrogenated! gmail.com
[gentoo-user] Re: [systemd] Is this a NetworkManager bug?
On 10/13/2014 04:56 PM, Canek Peláez Valdés wrote: On Mon, Oct 13, 2014 at 6:39 PM, walt w41...@gmail.com wrote: I just switched my home LAN from wired to all wifi and I'm having trouble with NetworkManager at boot time. I have systemd start NetworkManager at boot because I need the internet for ntpdate and to start the nfs server for the LAN. Before I switched to all-wireless this method worked perfectly, but no longer. After bootup I see that NetworkManager started wpa_supplicant in the background, but apparently does *not* run dhcpcd. (The wlan0 is up but it has no IP address and the routing table is empty.) Do you have a system-wide connection for the wireless network? They live in /etc/NetworkManager/system-connections. Also, what does nmcli -p general says? In my case is: centurion ~ # nmcli -p general = NetworkManager status = STATE CONNECTIVITY WIFI-HW WIFI WWAN-HW WWAN - connected full enabled enabled enabled enabled As an alternative to NetworkManager I can have systemd start dhcpcd at boot, which almost (but not quite) works well enough. This causes a race condition because wlan0 takes several seconds to come up properly and by then both ntpdate and nfs-server have already run and failed. So, I asked myself, why not have systemd start dhcpcd at boot in addition to NetworkManager? NetworkManager starts wpa_supplicant, but it does *NOT* use wpa_supplicant.conf. If you do systemctl status wpa_supplicant.service you will see that wpa_supplicant runs with the -u flag; that enables the DBus control interface, and it's through this that NetworkManager controls wpa_supplicant. If you do not have system-wide connections, NM will ask wpa_supplicant to *not* enable any connection. NM calls the shots in this case. The reason that fails is that they both start wpa_supplicant in the background and the two instances interfere with each other. Anyone see a way around this catch22? If I'm not mistaken, you need a system-wide NM connection enabled. You can use nm-connection-editor (included with nm-applet), or nmtui (ncurses interface since 0.9.10.0). Also, and orthogonal to almost all of this; I switched from ntp to systemd-timesyncd, and it works *great*, specially in my laptop. With my laptop, changing networks all the time, ntpd never quite worked. Lots of great information, thanks. What I learned while following up on your hints is that the NM behavior I thought was a bug is merely a feature ;) After boot, but before startx, wlan0 exists but is not properly set up. After X is running I can use the nm-applet to click on the name of my wireless network and *then* NM runs dhcpcd to configure wlan0 and set up the routing table. It works, but I need to do that manually after every boot, not really optimal for my purpose. I tried Neil's suggestion to use systemd-networkd and it works perfectly for this (desktop) machine. (BTW enabling systemd-networkd also pulls in systemd-timesyncd, which works great, just as you said.) Great advice Canek and Neil, and very much appreciated.
Re: [gentoo-user] Re: [systemd] Is this a NetworkManager bug?
On Tue, Oct 14, 2014 at 5:48 PM, walt w41...@gmail.com wrote: [ snip ] Lots of great information, thanks. What I learned while following up on your hints is that the NM behavior I thought was a bug is merely a feature ;) After boot, but before startx, wlan0 exists but is not properly set up. After X is running I can use the nm-applet to click on the name of my wireless network and *then* NM runs dhcpcd to configure wlan0 and set up the routing table. It works, but I need to do that manually after every boot, not really optimal for my purpose. I've seen this behavior before (that you need to manually enable the wireless connection), but never on my machines. On my two wireless systems (laptop and desktop), NM enables the connection by default. I don't think I did anything special for this to happen, it just does. I tried Neil's suggestion to use systemd-networkd and it works perfectly for this (desktop) machine. (BTW enabling systemd-networkd also pulls in systemd-timesyncd, which works great, just as you said.) Good to know. Regards. -- Canek Peláez Valdés Profesor de asignatura, Facultad de Ciencias Universidad Nacional Autónoma de México
Re: [gentoo-user] [OT] Six non-Gentoo installs
On 10/14/2014 06:36 PM, Grant Edwards wrote: CentOS 7.0, however, was a mess. It took three attempts and almost an entire day of work. I run it on my home server. It works pretty well for me. My first attempt was to use the minimal ISO image so that I would have the option of burning a CD if needed (I can't burn DVDs at the moment). That was a mistake. It was too minimal, and I couldn't get the network working to the point where I could configure repositories and install other stuff. Since the CentOS 7 ISO images all boot from USB flash drive anyway, staying under the 700MB CD size limit was moot anyway. Next I tried the net install ISO. I'm guessing I could have burned the DVD image to USB drive, but all I want is a minimal desktop system, so I figured why wait for a download of 3.5GB of stuff I don't care about. It still didn't recognize the NVidia Ethernet controller on my 5-year-old motherboard. After some cable swapping and futzing around, I got the netinstall going using the Realtek NIC. Maybe I just got unlucky and picked a slow mirror site, but once I got the install going, it ran for over 3 hours when installing a vanilla Gnome desktop system. Compare that with a 15 minute download time for a 700MB Xubuntu CD and then a 15 minute install. CentOS 7 refused to install the bootloader in a partition: your only choices are MBR or nothing. When I manually installed grub legacy it failed because I had stupidly allowed CentOS to use ext4, and the build of Grub I had laying around didn't grok ext4. So I re-do the whole net install again using ext3 instead. Now, after manually installing Grub legacy in the CentOS 7 partition, it boots up. The main problem (imnho) is that you think CentOS cares about configurability/multiple ways of doing things. They do not. They have their packages and their way of doing things, following TUV so that the distro is easily supportable. When installing, you just have to keep clicking next like a robot. I'm more convinced than ever that Gentoo is the way to go for my real systems... Definitely agree; any systems that I spend a substantial amount of time using run Gentoo. Nothing else is equal. I mostly run it on my home server because I want it to Just Work (tm) without any work on my part. It also prevents me from playing around too much with USE and other things, which is another bonus as I get more work done ;) Alec
[gentoo-user] FIXED: Re: Failed to emerge dev-python/pytables-3.0.0
On Tue, Oct 14, 2014 at 1:53 AM, Valmor de Almeida val.gen...@gmail.com wrote: Hello, On a recent portage update, I tried to emerge pytables-3.0.0 and the error: * python3_3: running distutils-r1_run_phase distutils-r1_python_compile * python2_7: running distutils-r1_run_phase distutils-r1_python_compile /usr/bin/python3.3 setup.py build /usr/bin/python2.7 setup.py build * Using Python 2.7.7 (default, Oct 12 2014, 17:42:53) * Found numpy 1.8.0 package installed. * Found numexpr 2.2.2 package installed. .. ERROR:: You need Cython 0.13 or greater to compile PyTables! * ERROR: dev-python/pytables-3.0.0::gentoo failed (compile phase): is confusing since Cython is installed with version greater than 0.13 - cython -V Cython version 0.21 or - emerge --search cython Searching... [ Results for search key : cython ] [ Applications found : 1 ] * dev-python/cython Latest version available: 0.21 Latest version installed: 0.21 Size of files: 1,455 kB Homepage: http://www.cython.org/ http://pypi.python.org/pypi/Cython Description: A Python to C compiler License: Apache-2.0 Any inputs appreciated. Thanks, -- Valmor This Gentoo bug was helpful https://bugs.gentoo.org/show_bug.cgi?id=523166 I moved to pytables-3.1.1 (unstable) and it compiles. -- Valmor
[gentoo-user] Re: [OT] Six non-Gentoo installs
Grant Edwards grant.b.edwards at gmail.com writes: In order to do some software testing (having mostly to do with different init systems), I installed 6 distros yesterday and this morning (I already had both 32 and 64 bit Gentoo/Openrc systems installed). I'm more convinced than ever that Gentoo is the way to go for my real systems... You might find this page interesting, if You have not seen it before: http://wiki.gentoo.org/wiki/Comparison_of_init_systems James
Re: [gentoo-user] [slightly O/T] mysql problems
On 14/10/2014 23:25, Mick wrote: On Tuesday 14 Oct 2014 21:15:48 Kerin Millar wrote: On 14/10/2014 19:54, Mick wrote: # Uncomment this to get FEDERATED engine support #plugin-load=federated=ha_federated.so loose-federated As far as I recall this is a default setting. Should I change it? No. I presume that you are not actively using the federated storage engine but let's put that aside because there is more to this error than meets the eye. Check your MySQL error log and look for any anomalies from the point at which MySQL is started. If you don't know where the log file is, execute SELECT @@log_error. 141014 19:41:37 [Warning] No argument was provided to --log-bin, and --log- bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem. 141014 19:41:37 InnoDB: The InnoDB memory heap is disabled 141014 19:41:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins 141014 19:41:37 InnoDB: Compressed tables use zlib 1.2.8 141014 19:41:37 InnoDB: Using Linux native AIO 141014 19:41:37 InnoDB: Initializing buffer pool, size = 16.0M 141014 19:41:37 InnoDB: Completed initialization of buffer pool 141014 19:41:37 InnoDB: highest supported file format is Barracuda. 141014 19:41:37 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 141014 19:41:37 InnoDB: Error: trying to open a table, but could not InnoDB: open the tablespace file './website1@002dnew/actions.ibd'! InnoDB: Have you moved InnoDB .ibd files around without using the InnoDB: commands DISCARD TABLESPACE and IMPORT TABLESPACE? InnoDB: It is also possible that this is a temporary table #sql..., InnoDB: and MySQL removed the .ibd file for this. InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html Nothing particularly interesting there. I have several questions: * Have you started MySQL with skip-grant-tables in effect? Not knowingly. How do I find out? If you had, you would know. It disables the privilege handling system outright. Typically it's used in situations where the root password has been forgotten or just prior to executing mysql_upgrade. The reason for asking is that it may also prevent some storage engines from loading, in which case their options will not be recognized. In turn, this may result in confusing error messages such as the one that you encountered. However, with the benefit of being able to read your my.cnf, the explanation turns out to be much simpler. You have loose-federated specified as an option but you are not loading the corresponding storage plugin. There is also the possibility that the engine was not compiled in at all (whether as a plugin or not). Simply remove or comment the line specifying this option and the error should go away. * Have you upgraded MySQL recently without going through the documented upgrade procedure? [1] I'm still on mysql-5.5.39 OK. If it has always been running MySQL 5.5, there's nothing to be concerned about. Installed versions: 5.5.39(16:42:22 08/09/14)(community perl ssl - bindist -cluster -debug -embedded -extraengine -jemalloc -latin1 -max-idx-128 -minimal -profiling -selinux -static -static-libs -systemtap -tcmalloc -test) * Have you copied files into MySQL's data directory that originated from a different version of MySQL? No, not manually. Good. * Have you otherwise removed or modified files in the data directory? Not as far as I know. I have suspicions of fs corruption though (it's been running out of space lately and I haven't yet found out why). Not good. Which filesystem, if I may ask? XFS is preferable, due to its very good performance with O_DIRECT, which ext4 coming in second. Other filesystems may be problematic. In particular, ZFS does not support asynchronous I/O. 2. A particular database which I have imported locally from a live site gives me loads of this: The wording here suggests a broader context that would be relevant. Please be specific as to the circumstances. What procedure did you employ in order to migrate and import the database? What do you mean by live site? Which versions of MySQL are running at both source and destination? How are they configured? mysql -u webadmin -h localhost -p website_test website1_20141014.sql Ah, just using DDL. That shouldn't have caused any trouble. The server is on 5.5.36. website1 is the database name of the live site, and website_test is the local development database. The server is a shared server, so I'm getting its vanilla configuration with no choice on the matter. The local configuration is attached. Is this some error imported from
[gentoo-user] Re: [OT] Six non-Gentoo installs
On 2014-10-15, Alec Ten Harmsel a...@alectenharmsel.com wrote: The main problem (imnho) is that you think CentOS cares about configurability/multiple ways of doing things. Oh, I don't think that -- it's pretty obvious that in the RedHat world, choice is not an option. It's one prix fixe menu, and you can either eat what's set in front of you or go hungry. They do not. They have their packages and their way of doing things, following TUV so that the distro is easily supportable. When installing, you just have to keep clicking next like a robot. I'm more convinced than ever that Gentoo is the way to go for my real systems... Definitely agree; any systems that I spend a substantial amount of time using run Gentoo. Nothing else is equal. I mostly run it on my home server because I want it to Just Work (tm) without any work on my part. It also prevents me from playing around too much with USE and other things, which is another bonus as I get more work done ;) And you avoid being forced every couple years to choose between a major version upgrade (which invariably turns into to a minor disaster) or reinstall from scratch (which usually turns out a little better, but requires that normal work stop for several days). -- Grant
[gentoo-user] Re: [OT] Six non-Gentoo installs
On 2014-10-15, James wirel...@tampabay.rr.com wrote: Grant Edwards grant.b.edwards at gmail.com writes: In order to do some software testing (having mostly to do with different init systems), I installed 6 distros yesterday and this morning (I already had both 32 and 64 bit Gentoo/Openrc systems installed). I'm more convinced than ever that Gentoo is the way to go for my real systems... You might find this page interesting, if You have not seen it before: http://wiki.gentoo.org/wiki/Comparison_of_init_systems No, I hadn't. For the immediate future, it looks like I'm going to have to support upstart, systemd, openrc and generic sys V init. A lot of distros manage to maintain some level of backwards compatibility with sys V init scripts, but that level seems to be falling. -- Grant
Re: [gentoo-user] Re: [OT] Six non-Gentoo installs
On Tue, Oct 14, 2014 at 10:39 PM, Grant Edwards grant.b.edwa...@gmail.com wrote: On 2014-10-15, Alec Ten Harmsel a...@alectenharmsel.com wrote: The main problem (imnho) is that you think CentOS cares about configurability/multiple ways of doing things. Oh, I don't think that -- it's pretty obvious that in the RedHat world, choice is not an option. It's one prix fixe menu, and you can either eat what's set in front of you or go hungry. I can see the potential benefits of that. It sounds a bit like the whole convention over configuration approach. As long as the convention works, it does greatly simplify things. One thing I do like is the trend towards putting default configs in /usr and using /etc more for overrides. If everything went that way (and we stuck stuff like /var/lib/portage/world in /etc) then you could have an /etc with 20 short files in it that reflected all the tweaking you did to a system from a generic install. Sure, I love config protection and etc-keeper and the like, but I'd like it still better if etc wasn't such a mix. I'd really love it if I could dump 20 files in /etc and run emerge -uDNv world and end up with a system identical to the one those 20 files were copied from. -- Rich
Re: [gentoo-user] Re: [OT] Six non-Gentoo installs
On 10/14/2014 10:39 PM, Grant Edwards wrote: On 2014-10-15, Alec Ten Harmsel a...@alectenharmsel.com wrote: The main problem (imnho) is that you think CentOS cares about configurability/multiple ways of doing things. Oh, I don't think that -- it's pretty obvious that in the RedHat world, choice is not an option. It's one prix fixe menu, and you can either eat what's set in front of you or go hungry. Wasn't trying to talk down to you; you were just trying something exotic. But yeah, it's the RedHat way or the highway which, as Rich mentioned, is great if you're looking for consistency and a support contract. Alec
[gentoo-user] LXQT(5) soon!
Hello QT5! It looks like LXQT-0.8.0 has a simple and shinny new minimal QT5 desktop announcement: http://sourceforge.net/p/lxde/mailman/message/32927295/ There's already a gentoo bug filed, so maybe this weekend or early next week: bug 525410 I've also been reading around the net about many new features coming to lxqt; soon. LXQT seems to be picking up devs and users aplenty.. enjoy! James
