Re: sleepycat db VS MySQL or postgres
On 01/07/2013 22:28, Jim Pazarena wrote: I have a rather extensive series of databases created and in use all with the very old sleepycat db3. I believe in the addage don't fix what ain't broken, but in the case of db3, it IS broken and my db files get corrupted on occasion. I could move to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface for postgres or mysql, but also, do not know how much the c interface has changed for sleepycat 5/6 compared to the c interface for db3, which I understand quite well. So I am prepared for a learning curve irrespective of which platform I select. Records do not exceed much more than 10-20,000, with key sizes not much wider than 16 bytes (ipv4), 13 (mac), 32 (ipv6). And various smaller key sizes. Suggestions would be very much appreciated. Well, this is essentially a bikeshed thread... so why not chip in :) I'd say it depends on what is your priority or what do you want to achieve by switching databases. If you want it to be as easy as possible, switch to DB5 and you'll be ok. If you want to learn something interesting, try one of the recent NoSQL databases, such as Redis, MongoDB or CouchDB - they're like DBx but with significantly more powerful query capabilities. If you want to get a feel of how SQL databases work, go with PostgreSQL, but be aware that to really use a SQL database the way they're made to be used, you'll need to properly design a relational schema. Using them to store 20 KiB blobs indexed by a single key is way too simplistic and probably much slower than what you could get with a simple DBx engine. Also, SQL databases usually work with SQL queries, which are text, so you'll have a non-trivial task of fitting C structs in their text/blob field types - it's best to avoid it. Also, you'll need to learn how to tune and maintain proper database servers. If you want to just try SQL but without bothering with tuning and maintainance, try SQLite, but beware it is basically limited to a single writer (and inifinite reader) clients in the best case (with WAL journalling). signature.asc Description: OpenPGP digital signature
Re: sleepycat db VS MySQL or postgres
On Tue, 02 Jul 2013 05:45:47 -0500, Ivan Voras ivo...@freebsd.org wrote: Well, this is essentially a bikeshed thread... so why not chip in I disagree; all of these databases have distinctly different uses. MySQL/PostgreSQL: pick your poison. Relational databases. Will you have multiple users connecting to the database? Will there be lots of updates to the data? These are what you want. If you care about data integrity, I'd choose Postgres. SQLite: Do you want a relational database without needing a daemon to be running and will only have a single user/process accessing the database at one time? This is what you want. NoSQL: Do you want to dabble with the mess that is NoSQL so you can build your cloud? Don't care if other nodes aren't guaranteed to get the latest copy of the data? This is what you want. SleepyCat/BerkleyDB: Is your data WORM? (Write Once Read Many) If so, this is *ABSOLUTELY* what you want. If twitter was built upon a WORM database instead of MySQL they could host the entirety of twitter on a handful of servers instead of the gross MySQL+Cassandra mess they're fighting with today. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: sleepycat db VS MySQL or postgres
On 02/07/2013 13:55, Mark Felder wrote: If twitter was built upon a WORM database instead of MySQL they could host the entirety of twitter on a handful of servers instead of the gross MySQL+Cassandra mess they're fighting with today. I'd say their problem is not exactly solvable by only choosing a database :D They, like Facebook, have the problem of fanout, where a single piece of data goes into thousands of different user pages. Whatever they save in the raw data access operations will probably be relatively small compared to the horsepower needed to combine pages from all these fleeting data pieces. But yes, obviously a database designed specifically for one thing will be optimized for that thing. signature.asc Description: OpenPGP digital signature
Re: sleepycat db VS MySQL or postgres
On Tue, 02 Jul 2013 07:12:37 -0500, Ivan Voras ivo...@freebsd.org wrote: On 02/07/2013 13:55, Mark Felder wrote: If twitter was built upon a WORM database instead of MySQL they could host the entirety of twitter on a handful of servers instead of the gross MySQL+Cassandra mess they're fighting with today. I'd say their problem is not exactly solvable by only choosing a database :D They, like Facebook, have the problem of fanout, where a single piece of data goes into thousands of different user pages. Whatever they save in the raw data access operations will probably be relatively small compared to the horsepower needed to combine pages from all these fleeting data pieces. Good point :) I'm still sure it would work much, much better though. However, I'm just glad that's not *my* problem to fix. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
sleepycat db VS MySQL or postgres
I have a rather extensive series of databases created and in use all with the very old sleepycat db3. I believe in the addage don't fix what ain't broken, but in the case of db3, it IS broken and my db files get corrupted on occasion. I could move to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface for postgres or mysql, but also, do not know how much the c interface has changed for sleepycat 5/6 compared to the c interface for db3, which I understand quite well. So I am prepared for a learning curve irrespective of which platform I select. Records do not exceed much more than 10-20,000, with key sizes not much wider than 16 bytes (ipv4), 13 (mac), 32 (ipv6). And various smaller key sizes. Suggestions would be very much appreciated. -- Jim Pazarena fqu...@paz.bz ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: sleepycat db VS MySQL or postgres
On 1 July 2013 16:28, Jim Pazarena fqu...@paz.bz wrote: I could move to db5 or db6 OR MySQL, or even postgres. snip I have no experience with the c interface for postgres or mysql, but also, do not know how much the c interface has changed for sleepycat 5/6 compared to the c interface for db3, which I understand quite well. So I am prepared for a learning curve irrespective of which platform I select. Records do not exceed much more than 10-20,000, with key sizes not much wider than 16 bytes (ipv4), 13 (mac), 32 (ipv6). And various smaller key sizes. Suggestions would be very much appreciated. Jim - ultimately I'd recommend deciding which of the three you WANT to learn and then use it. I know nothing about db* but I use both MySQL and PostGreSQL on a regular basis. I like them both. I prefer the licence used by PostGreSQL, I prefer the PostGreSQL replication but I use whichever suits my needs. Some people are fanatical about one or the other, I say pick whichever you're more interested in and learn how to use it. kmw ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: sleepycat db VS MySQL or postgres
On 07/01/2013 01:28 PM, Jim Pazarena wrote: I have a rather extensive series of databases created and in use all with the very old sleepycat db3. I believe in the addage don't fix what ain't broken, but in the case of db3, it IS broken and my db files get corrupted on occasion. I could move to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface for postgres or mysql, but also, do not know how much the c interface has changed for sleepycat 5/6 compared to the c interface for db3, which I understand quite well. So I am prepared for a learning curve irrespective of which platform I select. Records do not exceed much more than 10-20,000, with key sizes not much wider than 16 bytes (ipv4), 13 (mac), 32 (ipv6). And various smaller key sizes. Suggestions would be very much appreciated. Jim, I'm a lazy bugger and what I'd do is knock together a small perl program using DBI and the DBD for Berkeley DB (sleepcat) and either MySQL or Postgres (pick your religion). You could grap the records out of one table and insert them into another as though they are the same db... LIke I say, I'm lazy. No, it's not shiney and new (may EVEN be deprecated) If you'd like assistance, I'll be happy to hold hands Bruce Ferrell ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: sleepycat db VS MySQL or postgres
On Mon, 01 Jul 2013 13:28:59 -0700, Jim Pazarena wrote: I have a rather extensive series of databases created and in use all with the very old sleepycat db3. I believe in the addage don't fix what ain't broken, but in the case of db3, it IS broken and my db files get corrupted on occasion. I could move to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface for postgres or mysql, but also, do not know how much the c interface has changed for sleepycat 5/6 compared to the c interface for db3, which I understand quite well. So I am prepared for a learning curve irrespective of which platform I select. Records do not exceed much more than 10-20,000, with key sizes not much wider than 16 bytes (ipv4), 13 (mac), 32 (ipv6). And various smaller key sizes. Suggestions would be very much appreciated. If you have to make a change, I'd recommend switching to Postgres. Worth the effort in the long run, and Postgres is not at all difficult if you have experience with any RDB. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: sleepycat db VS MySQL or postgres
On Mon, Jul 1, 2013 at 4:28 PM, Jim Pazarena fqu...@paz.bz wrote: I have a rather extensive series of databases created and in use all with the very old sleepycat db3. I believe in the addage don't fix what ain't broken, but in the case of db3, it IS broken and my db files get corrupted on occasion. I could move to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface for postgres or mysql, but also, do not know how much the c interface has changed for sleepycat 5/6 compared to the c interface for db3, which I understand quite well. So I am prepared for a learning curve irrespective of which platform I select. Records do not exceed much more than 10-20,000, with key sizes not much wider than 16 bytes (ipv4), 13 (mac), 32 (ipv6). And various smaller key sizes. Suggestions would be very much appreciated. -- Jim Pazarena fqu...@paz.bz The following page may be useful : http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems MySQL is dropped from some Linux distributions due to its restrictions and replaced by MariaDB : http://en.wikipedia.org/wiki/MariaDB Dropping of MySQL is continuing among Linux distributions for new releases . The PostgreSQL would be best choice : http://en.wikipedia.org/wiki/PostgreSQL I am not using any one of them , but my PhD ( in 1996 ) subject is A Multimedia Information Management System . Thank you very much . Mehmet Erol Sanlituk ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
MySQL hangs server completely
Hi, We've been having this problem with a customer for a while and it seems that some funky query makes MySQL use 100% of CPU. Nevertheless, even though you can see in top that it's only 1 CPU in 100% (out of 8) the server eventually becomes useless and stops responding completely. So my question is, how does a user process hang the whole server? What system resources could MySQL be draining to make the server stop responding completely? The MySQL database is running inside a Jail and perhaps that could help limit the damage it can cause. Has anyone else run into this problem? Thanks, -- Alejandro Imass ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL hangs server completely
On Wed, May 22, 2013 at 2:04 PM, Michael Ross g...@ross.cx wrote: On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass aim...@yabarana.com wrote: Hi, We've been having this problem with a customer for a while and it seems that some funky query makes MySQL use 100% of CPU. Nevertheless, even though you can see in top that it's only 1 CPU in 100% (out of 8) the server eventually becomes useless and stops responding completely. So my question is, how does a user process hang the whole server? What system resources could MySQL be draining to make the server stop responding completely? In laymans terms - can't do better - MySQL racing itself to obtain a ( table | memory | file ) lock? I know I can death-stall the MySQL server at a customer's site if I give it a big enough query ( like, DROPping a table, recreating it and pushing backup data inside ) while cron's hourly backup-dump is running on the database. Just the MySQL server, the machine itself hasn't stalled yet - but I'm sitting at the console while doing this, so I don't know what would eventually happen if I'd let it sit for a while. Right on the money. It doesn't immediately hang the server but in time it drains it to the point the shell stops responding and no more ssh access and even snmp stops responding! It doesn't happen immediately, but only after a while that MySQL has one of the CPUs at 100%. What I don't understand is how it manages to crash the whole server. Thanks, -- Alejandro Imass Regards, Michael ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL hangs server completely
On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass aim...@yabarana.com wrote: Hi, We've been having this problem with a customer for a while and it seems that some funky query makes MySQL use 100% of CPU. Nevertheless, even though you can see in top that it's only 1 CPU in 100% (out of 8) the server eventually becomes useless and stops responding completely. So my question is, how does a user process hang the whole server? What system resources could MySQL be draining to make the server stop responding completely? In laymans terms - can't do better - MySQL racing itself to obtain a ( table | memory | file ) lock? I know I can death-stall the MySQL server at a customer's site if I give it a big enough query ( like, DROPping a table, recreating it and pushing backup data inside ) while cron's hourly backup-dump is running on the database. Just the MySQL server, the machine itself hasn't stalled yet - but I'm sitting at the console while doing this, so I don't know what would eventually happen if I'd let it sit for a while. Regards, Michael ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
FreeBSD 9x - PHP and MySQL
FreeBSD 9.1-PRERELEASE Can you tell me what might be the best MySQL version to be used and which PHP version should I use to that? Running 64-bit. thanks, Jos Chrispijn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 9x - PHP and MySQL
MySQL 5.5 php 5.4.x FreeBSD 9.1-PRERELEASE Can you tell me what might be the best MySQL version to be used and which PHP version should I use to that? Running 64-bit. thanks, Jos Chrispijn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org -- Vladislav V. Prodan System Network Administrator http://support.od.ua +380 67 4584408, +380 99 4060508 VVP88-RIPE ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
RE: FreeBSD 9x - PHP and MySQL
There's no reason not to just use the latest in the ports tree, which as of now is: php5-5.4.7 mysql-server-5.5.28 I use phpmyadmin, which usually results in updating php5 every new release (which is why I'm on php5-5.4.7), although I'm still on mysql-server-5.5.16. -Original Message- From: owner-freebsd-questi...@freebsd.org [mailto:owner-freebsd-questi...@freebsd.org] On Behalf Of Vladislav Prodan Sent: Saturday, October 20, 2012 12:16 PM To: freebsd-questions@FreeBSD.org Subject: Re: FreeBSD 9x - PHP and MySQL MySQL 5.5 php 5.4.x FreeBSD 9.1-PRERELEASE Can you tell me what might be the best MySQL version to be used and which PHP version should I use to that? Running 64-bit. thanks, Jos Chrispijn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org -- Vladislav V. Prodan System Network Administrator http://support.od.ua +380 67 4584408, +380 99 4060508 VVP88-RIPE ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 9x - PHP and MySQL
On 20/10/2012 19:12, Jos Chrispijn wrote: Can you tell me what might be the best MySQL version to be used and which PHP version should I use to that? Unless you're running applications with known dependencies on earlier versions, always choose the latest stable release version of PHP. For MySQL, it's not so vital, but the latest release should be your default choice. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey signature.asc Description: OpenPGP digital signature
cron pile up! libnss-mysql and cron (Rehash)
4.5 years ago, I posted about cron's piling up. It seems if I install libnss-mysql on a fresh 9.0-STABLE, this problem persists. Here was the original post: http://lists.freebsd.org/pipermail/freebsd-questions/2007-December/164174.html I've seen this on 6.2, 7.x, and now 9.0 FreeBSD. How to repeat: install a fresh BSD system, install libnss-mysql, wait a few days. System info: FreeBSD 9.0-STABLE amd64 libnss-mysql-1.5_3 NSS module using a MySQL database for backend mariadb-client-5.3.6 Database server - drop-in replacement for MySQL mariadb-server-5.3.6 Database server - drop-in replacement for MySQL ps axlw | grep cron 0 56084 1 0 20 0 31064 2844 nanslp IsJ ?? 0:00.78 /usr/sbin/cron -s 0 68402 56084 0 20 0 31064 2844 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68403 68402 0 20 0 31064 2844 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) 0 68527 56084 0 20 0 31064 2848 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68528 56084 0 20 0 31064 2844 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68530 68527 0 20 0 31064 2848 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) 0 68531 68528 0 20 0 31064 2844 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) 0 68558 56084 0 20 0 31064 2844 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68559 68558 0 20 0 31064 2844 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) 0 68591 56084 0 20 0 31064 2844 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68592 68591 0 20 0 31064 2844 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) 0 68608 56084 0 20 0 31064 2848 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68609 68608 0 20 0 31064 2848 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) 0 68659 56084 0 20 0 31064 2848 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68660 68659 0 20 0 31064 2848 sbwait IVsJ ?? 0:00.00 cron: running job (cron) 0 68683 56084 0 20 0 31064 2844 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68684 68683 0 20 0 31064 2844 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) 0 68722 56084 0 21 0 31064 2848 ppwait DJ ?? 0:00.00 cron: running job (cron) 0 68723 68722 0 20 0 31064 2848 so_rcv_s IVsJ ?? 0:00.00 cron: running job (cron) Interestingly, if I do a truss and hit ^C, the process disappears... see below: # truss -p 68684 ^C # truss -p 68684 truss: can not attach to target process: No such process # grep 68684 /var/log/cron Jun 22 16:25:00 mail /usr/sbin/cron[68684]: (root) CMD (/usr/libexec/atrun) Rudy ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On 13/06/2012 19:34, Simon wrote: Hi, I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx Thank you! Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org Its not clear if you upgraded mysql or just did a vanilla fresh install, but assuming the former, i take it you ran the mysql_upgrade script post upgrade? /usr/ports/databases/mysqlXX-scripts -- - Paul Macdonald IFDNRG Ltd Web and video hosting - t: 0131 5548070 m: 07970339546PLEASE NOTE NEW MOBILE e: p...@ifdnrg.com w: http://www.ifdnrg.com - IFDNRG 40 Maritime Street Edinburgh EH6 6SA - ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Thu, 14 Jun 2012 09:04:26 +0100, Paul Macdonald wrote: On 13/06/2012 19:34, Simon wrote: Hi, I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx Thank you! Simon Its not clear if you upgraded mysql or just did a vanilla fresh install, but assuming the former, i take it you ran the mysql_upgrade script post upgrade? /usr/ports/databases/mysqlXX-scripts No, I did not run the mysql_upgrade because this was a minor upgrade. I was running 5.0.88 Community Server binary install built by mysql developers rock solid for long time. Then I decided to upgrade to latest 5.0.x but there is no such build for FreeBSD by the MySQL developers. So I decided to give the ports version a shot. I compiled and installed databases/mysql50-server with BUILD_STATIC The latest mysql50-server under FBSD 8.3 is 5.0.95 BTW, I'm doing this on FreeBSD 8.3-p3 AMD64 PS I just had it die on a different machine that is less loaded and uses less memory. -Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
FreeBSD 8.3 + MySQL 5.0.95
Hi, I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx Thank you! Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Possible but extremely unlikely, I always had issues whenever I tried to build MySQL server myself. The hardware where this is running has been very stable. I don't have any issues whatsoever making world, etc... There is no segfault which is what usually happens when you have memory issues. And why would MySQL community server run stable if it was somehow my hardware? Bottom line, if this was hardware issue, the server would have paniced long ago. I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. -Simon On Wed, 13 Jun 2012 11:36:48 -0700, Chuck Swiger wrote: On Jun 13, 2012, at 11:34 AM, Simon wrote: I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx This sounds like marginal hardware which is failing under load. Make sure you can run something like memtest86 or prime95 overnight without errors Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Jun 13, 2012, at 11:43 AM, Simon wrote: Possible but extremely unlikely, I always had issues whenever I tried to build MySQL server myself. That by itself is interesting. The hardware where this is running has been very stable. I don't have any issues whatsoever making world, etc... A make world is a decent stress test, but it doesn't take long enough on modern hardware to reliably uncover problems. There is no segfault which is what usually happens when you have memory issues. And why would MySQL community server run stable if it was somehow my hardware? Bottom line, if this was hardware issue, the server would have paniced long ago. I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Why not? it is designed precisely for this. Like I said, whenever I used MySQL project community server built binaries, I never had it crash. Right now I'm thinking: 1. the port build of 5.0.95 does something incorrectly. 2. it's running out of memory (FreeBSD's kernel still does not report out of memory errors for processes if it kills them; there is no way to know if kernel killed a process due to memory limit, it does not log this) 3. it's hitting some kind of 5.0.95 bug Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ -Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Wed, 13 Jun 2012, Simon wrote: I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Why not? it is designed precisely for this. Like I said, whenever I used MySQL project community server built binaries, I never had it crash. Right now I'm thinking: 1. the port build of 5.0.95 does something incorrectly. 2. it's running out of memory (FreeBSD's kernel still does not report out of memory errors for processes if it kills them; there is no way to know if kernel killed a process due to memory limit, it does not log this) 3. it's hitting some kind of 5.0.95 bug Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ try my...@lists.mysql.com - when I was an utter newbie they were quite helpful and tolerant. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Jun 13, 2012, at 11:34 AM, Simon wrote: I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx This sounds like marginal hardware which is failing under load. Make sure you can run something like memtest86 or prime95 overnight without errors Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ -Simon Yes you too are using the wrong list. The questions@ list was created to catch FreeBSD newbies, somewhere to point /etc/motd at. ( It's evolved to also deal with _some_ more complex issues 'cos some on questions@ failed to move on, post more complex non beginner issues to the maybe 50+ or more specialist lists. ) Examples for this topic might include: freebsd-...@freebsd.org freebsd-datab...@freebsd.org freebsd-hack...@freebsd.org freebsd-performa...@freebsd.org See http://lists.freebsd.org/mailman/listinfo Just 2 clicks from http://freebsd.org/ Sad how many people don't look, dump all on questions@, breaking the whole point of having 50+ different themed FreeBSD lists. Those only using questions@ _Please_ realise there are other lists. http://lists.freebsd.org/mailman/listinfo Read the remits of the other lists subscribe /or post those lists that match your topic. Cheers, Julian -- Julian Stacey, BSD Unix Linux C Sys Eng Consultants Munich http://berklix.com Reply below not above, cumulative like a play script, indent with . Format: Plain text. Not HTML, multipart/alternative, base64, quoted-printable. Mail from @yahoo dumped @berklix. http://berklix.org/yahoo/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Jun 13, 2012, at 12:24 PM, Simon wrote: I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Why not? it is designed precisely for this. That depends on workload. Table-level or page-level locking is fine for read-only or read-mostly; it wasn't until InnoDB storage that MySQL had row-level locking, which is kinda important when you *aren't* read-mostly. Like I said, whenever I used MySQL project community server built binaries, I never had it crash. But the process from these community server built binaries went away, right? Right now I'm thinking: 1. the port build of 5.0.95 does something incorrectly. 2. it's running out of memory (FreeBSD's kernel still does not report out of memory errors for processes if it kills them; there is no way to know if kernel killed a process due to memory limit, it does not log this) 3. it's hitting some kind of 5.0.95 bug The program termination ought to log something, at least if you enable logging or have a monitor in place which can see mysqld's error status; even mysqld_safe ought to take --log-error flag Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ That's likely to be a valid point; freebsd-ports would be appropriate for discussing the build problems with mysql port. freebsd-isp has a different population oriented towards hosting provider issues etc that you've mentioned. However, I can assure you that some folks here on freebsd-questions do deal with more than 10TPS. :-) Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Yes you too are using the wrong list. The questions@ list was created to catch FreeBSD newbies, somewhere to point /etc/motd at. ( It's evolved to also deal with _some_ more complex issues 'cos some on questions@ failed to move on, post more complex non beginner issues to the maybe 50+ or more specialist lists. ) Examples for this topic might include: freebsd-...@freebsd.org freebsd-datab...@freebsd.org freebsd-hack...@freebsd.org freebsd-performa...@freebsd.org See http://lists.freebsd.org/mailman/listinfo Just 2 clicks from http://freebsd.org/ Sad how many people don't look, dump all on questions@, breaking the whole point of having 50+ different themed FreeBSD lists. Those only using questions@ _Please_ realise there are other lists. http://lists.freebsd.org/mailman/listinfo Read the remits of the other lists subscribe /or post those lists that match your topic. Cheers, Julian -- Thanks Julian. The reason for freebsd-questions is because when I looked thru isp, database, and performance, and few others, they had one or two threads a month with barely much input. I figured I would reach more people on this list. The reason why I didn't use freebsd-hackers is because I thought perhaps this was somewhat trivial, like I was overlooking something, but I guess not. Next time I'll just use that list instead. I think it would be my best bet. -Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Can you repeat this issue with MariaDB? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Those only using questions@ _Please_ realise there are other lists. http://lists.freebsd.org/mailman/listinfo Read the remits of the other lists subscribe /or post those lists that match your topic. PS All credit thanks to a few highly skilled informed people on questions@ who regularly contribute good advice helping newcomers. Just that many Was-once-a-beginner should start to think: I've been using FreeBSD a while now, I'm no longer just a newbie to cluelessly use just questions@, I should look at what other FreeBSD lists there are. Cheers, Julian -- Julian Stacey, BSD Unix Linux C Sys Eng Consultants Munich http://berklix.com Reply below not above, cumulative like a play script, indent with . Format: Plain text. Not HTML, multipart/alternative, base64, quoted-printable. Mail from @yahoo dumped @berklix. http://berklix.org/yahoo/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Hi Simon Thanks Julian. The reason for freebsd-questions is because when I looked thru isp, database, and performance, and few others, they had one or two threads a month with barely much input. Yup, isp@ is quiet, some other lists too, doesn't necessarily mean there'snot good people listening, though I suspect total sub. # on isp@ might be low. I figured I would reach more people on this list. Certainly lots, but some specialist lists have good people listening, less troll noise than lately on questions@. The reason why I didn't use freebsd-hackers is because I thought perhaps this was somewhat trivial, like I was overlooking something, but I guess not. Next time I'll just use that list instead. I think it would be my best bet. Welcome to hackers@ the rest :-) PS The one list I periodicaly notice is not quite there, or a handbook entry either I think, is something for all of us who periodically suspect a machine is maybe a bit sick, want to give it a damn good thrashing to test it. Well, complex issue, how long is a piece of string ? but there's performance@ ports@ for ideas tools etc. Good luck. Cheers, Julian -- Julian Stacey, BSD Unix Linux C Sys Eng Consultants Munich http://berklix.com Reply below not above, cumulative like a play script, indent with . Format: Plain text. Not HTML, multipart/alternative, base64, quoted-printable. Mail from @yahoo dumped @berklix. http://berklix.org/yahoo/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Hello. 2012/06/13 14:43:29 -0400 Simon si...@optinet.com = To Chuck Swiger : S There is no segfault which is what usually happens when you have memory then there is the daemon's log... -- Peter Vereshagin pe...@vereshagin.org (http://vereshagin.org) pgp: A0E26627 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Simon wrote: Hint: Please learn to not top post. It makes it more difficult to arrange answers coherently. Possible but extremely unlikely, I always had issues whenever I tried to build MySQL server myself. The hardware where this is running has been very stable. I don't have any issues whatsoever making world, etc... There is no segfault which is what usually happens when you have memory issues. And why would MySQL community server run stable if it was somehow my hardware? Bottom line, if this was hardware issue, the server would have paniced long ago. I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. -Simon On Wed, 13 Jun 2012 11:36:48 -0700, Chuck Swiger wrote: On Jun 13, 2012, at 11:34 AM, Simon wrote: I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx This sounds like marginal hardware which is failing under load. Make sure you can run something like memtest86 or prime95 overnight without errors I don't know about 300+ queries per second, but I have been running MySQL since version 3.x.x, and so on, without much difficulty. It has been very stable for me for many years. Hardware related problems can be a cause of general flakiness one person can see while many, many others do not experience. Can be things such as old, weak, under rated power supply that has poor regulation and excessive ripple under load. This can actually resemble RAM problems at times, because with things like memtest there will be failures. It can be other things as well, such as a disk controller running a driver that has a bug. Rather than ramble through myriad possibilities, a general rule I've noticed over many years of dealing with computers: Hardware is often involved when the problem is very random, while when you can reproduce a specific error condition repeatedly by executing a set of commands or instructions in particular and specific order it is software related. I also question why you would want to run such an old version. Particularly I am aware that versions 5.0.50 and 5.0.51 contain several serious bugs. I run the latest version of the 5.1.xx branch, with an eye to moving towards 5.5.xx very soon. I have always compiled from the ports system. I have also tuned my.cnf according to the examples and the documentation recommendations. One of the first things you should look at is what about the compilation process on your machine is producing your flaky, crashy binaries. Using a GCC from ports?, CLANG?, remove any so-called 'optimizations' from your make.conf, etc. In the make config for building MySQL do _not_ select the 'build optimized binaries' choice (which sets -O3 optimization) and see if that makes a difference. I have used the -O3 in my builds for many years and never had a problem. Circle outwards in looking at OS tuning. An example would be vmstat -i, looking for a piece of hardware with a run away interrupt storm. Other things like IPC, SYSVSHM, Semaphores, and other such structure pools looking for resource starvation. If hardware proves not to be central to the problem, see if you can arrange a way to _not_ load it so heavily. If it runs at a lower load without crashing it might indicate you need some tuning. I would look at the hardware very hard. I would look at how you are building the compilation. I would also _not_ use this version, but rather at least 5.1.x and preferably (especially if this is a new start up) look at trying the latest in the 5.5.xx series. The 5.5.xx is supposed to offer better performance, and maybe with your 300+ per second query rate maybe you should focus on the version with the best performance. Bottom line: Many thousands of people and companies have run MySQL for many years and had it work just fine. Your particular situation is an aberration of some form. -Mike ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: securing MySQL: easiest/best ways?
Hello. 2012/05/08 21:51:49 +0100 Matthew Seaman m.sea...@infracaninophile.co.uk = To freebsd-questions@freebsd.org : MS data dir shared between two servers. Keeping the configs with the data MS does have a few advantages. I know yet another reason to do this. In common case this isn't mysql-specific. There may be a 'chroot' feature built into the daemon like mysqld that means that daemon does chroot(2) first when it is running, and the directory to chroot is the its own data directory, say, /var/db/mysql. This way it should be able to re-read its configuration file on receiving, say HUP or USR1 posix signal to chenge its settings on the fly. This is why in this particular case the configuration file must reside within the databse directory. -- Peter Vereshagin pe...@vereshagin.org (http://vereshagin.org) pgp: A0E26627 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
securing MySQL: easiest/best ways?
Monkeying with IPv6, I discovered that globally routable addresses are what it says on the tin, so hiding behind a network appliance is not longer viable for me. An nmap scan showed the port 3306 was hanging out for all to see but I couldn't figure out how to close it off. The --skip-networking argument seems not to work, either in my.cnf or as an rc argument. The server just fails to start. (For some reason the socket is hard-coded to live in /tmp, regardless of what's in my.cnf but I gave up bothering about that.) What I ended up doing was adding mysql_args=--bind-address=127.0.0.1 to /etc/rc.conf. This seems to work as netstat and sockstat no longer show port 3306 listening and database connections are happening. Is this the preferred/best way? -- Paul Beard Are you trying to win an argument or solve a problem?
Re: securing MySQL: easiest/best ways?
On 08/05/2012 14:49, Paul Beard wrote: Monkeying with IPv6, I discovered that globally routable addresses are what it says on the tin, so hiding behind a network appliance is not longer viable for me. An nmap scan showed the port 3306 was hanging out for all to see but I couldn't figure out how to close it off. The --skip-networking argument seems not to work, either in my.cnf or as an rc argument. The server just fails to start. (For some reason the socket is hard-coded to live in /tmp, regardless of what's in my.cnf but I gave up bothering about that.) What I ended up doing was adding mysql_args=--bind-address=127.0.0.1 to /etc/rc.conf. This seems to work as netstat and sockstat no longer show port 3306 listening and database connections are happening. Is this the preferred/best way? You have been restarting mysql to test changes to my.cnf? You have to do a full restart to get mysql to re-read the config file. If you need to reconfigure without interrupting service, you can set most parameters at runtime using mysql(1). Sounds almost as if the my.cnf you've been editing is not the my.cnf that your mysql instance is using. IIRC there was some talk about moving from the usual BSD-ish /var/db/mysql/my.cnf to /usr/local/etc/my.cnf (no doubt under some insidious influence from Linux.) skip-networking certainly should leave you with just the unix domain socket. Alternatively you can bind mysql's network socket to a specific interface -- so if you bind it to the loopback, it should make it inaccessible from the network. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matt...@infracaninophile.co.uk Kent, CT11 9PW signature.asc Description: OpenPGP digital signature
Re: securing MySQL: easiest/best ways?
Hello. 2012/05/08 06:49:01 -0700 Paul Beard paulbe...@gmail.com = To FreeBSD-questions : PB Monkeying with IPv6, I discovered that globally routable addresses are what it says on the tin, so hiding behind a network appliance is not longer viable for me. An nmap scan showed the port 3306 was hanging out for all to see but I couldn't figure out how to close it off. The --skip-networking argument seems not to work, either in my.cnf or as an rc argument. The server just fails to start. (For some reason the socket is hard-coded to live in /tmp, regardless of what's in my.cnf but I gave up bothering about that.) How can you know for sure that your my.cnf is being taken into the account by mysqld at all? I remember some issues that made me to put a symlink /etc/my.cnf to ..//usr/local/etc/my.cnf ... PB What I ended up doing was adding PB PB mysql_args=--bind-address=127.0.0.1 PB PB to /etc/rc.conf. This seems to work as netstat and sockstat no longer show port 3306 listening and database connections are happening. PB PB Is this the preferred/best way? I just think locking mysqld into the jail(4) is better. ;-) PB Are you trying to win an argument or solve a problem? Whatever I may need. -- Peter Vereshagin pe...@vereshagin.org (http://vereshagin.org) pgp: A0E26627 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: securing MySQL: easiest/best ways?
On Tue, 08 May 2012 15:34:02 +0100 Matthew Seaman articulated: Sounds almost as if the my.cnf you've been editing is not the my.cnf that your mysql instance is using. IIRC there was some talk about moving from the usual BSD-ish /var/db/mysql/my.cnf to /usr/local/etc/my.cnf (no doubt under some insidious influence from Linux.) The first time I ever looked for my.cnf I had expected to find it in /usr/local/etc. Since so many configuration files are stored there, it just seemed like a natural place for it to be located. IMHO, a centralized repository for configuration files greatly simplifies system maintenance. -- Jerry ♔ Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __ signature.asc Description: PGP signature
Re: securing MySQL: easiest/best ways?
On 08/05/2012 20:55, Jerry wrote: On Tue, 08 May 2012 15:34:02 +0100 Matthew Seaman articulated: Sounds almost as if the my.cnf you've been editing is not the my.cnf that your mysql instance is using. IIRC there was some talk about moving from the usual BSD-ish /var/db/mysql/my.cnf to /usr/local/etc/my.cnf (no doubt under some insidious influence from Linux.) The first time I ever looked for my.cnf I had expected to find it in /usr/local/etc. Since so many configuration files are stored there, it just seemed like a natural place for it to be located. IMHO, a centralized repository for configuration files greatly simplifies system maintenance. Yeah. It's no big deal. But... Maybe you want to run more than one instance of mysql on the same machine. Or you want to move the data directory lock, stock and barrel onto a different server. Maybe it's some ultra fancy fail-over setup with a data dir shared between two servers. Keeping the configs with the data does have a few advantages. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matt...@infracaninophile.co.uk Kent, CT11 9PW signature.asc Description: OpenPGP digital signature
Re: securing MySQL: easiest/best ways?
On Tue, 08 May 2012 15:55:36 -0400, Jerry je...@seibercom.net wrote: On Tue, 08 May 2012 15:34:02 +0100 Matthew Seaman articulated: Sounds almost as if the my.cnf you've been editing is not the my.cnf that your mysql instance is using. IIRC there was some talk about moving from the usual BSD-ish /var/db/mysql/my.cnf to /usr/local/etc/my.cnf (no doubt under some insidious influence from Linux.) The first time I ever looked for my.cnf I had expected to find it in /usr/local/etc. Since so many configuration files are stored there, it just seemed like a natural place for it to be located. IMHO, a centralized repository for configuration files greatly simplifies system maintenance. Hence the reason almost all of my config files are symlinked in someway in /etc/ Call it a habit from spending much of my time using working on Linux :p -- Using Opera's revolutionary email client: http://www.opera.com/mail/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: securing MySQL: easiest/best ways?
On Tue, 08 May 2012 21:51:49 +0100 Matthew Seaman articulated: On 08/05/2012 20:55, Jerry wrote: On Tue, 08 May 2012 15:34:02 +0100 Matthew Seaman articulated: Sounds almost as if the my.cnf you've been editing is not the my.cnf that your mysql instance is using. IIRC there was some talk about moving from the usual BSD-ish /var/db/mysql/my.cnf to /usr/local/etc/my.cnf (no doubt under some insidious influence from Linux.) The first time I ever looked for my.cnf I had expected to find it in /usr/local/etc. Since so many configuration files are stored there, it just seemed like a natural place for it to be located. IMHO, a centralized repository for configuration files greatly simplifies system maintenance. Yeah. It's no big deal. But... Maybe you want to run more than one instance of mysql on the same machine. Or you want to move the data directory lock, stock and barrel onto a different server. Maybe it's some ultra fancy fail-over setup with a data dir shared between two servers. Keeping the configs with the data does have a few advantages. Actually, it has a lot of advantages. I only run one instance of MySQL; however, for multiple instances, keeping the configs in one location would probably not be advantageous. Someone else mentioned creating a link for the my.cnf file. Since I never touch the my.cnf file once MySQL is setup, I probably would not bother with it, although it is an interesting idea. -- Jerry ♔ Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __ signature.asc Description: PGP signature
Re: MySQL Localhost install - Was: Hello
On 01/24/12 07:06, Crow wrote: I want to create MySQL localhost. Can you provide some more information? Like which version of FreeBSD you are using (or other OS if you happen to be needing other support), what you have completed so far, other parameters that you are able to tell us which may have a bearing on your situation. Generally you can install from ports: If you haven't already installed ports (try cd /usr/ports), then as root run portsnap fetch extract. If you have installed ports, then cd /usr/ports/databases/mysql55-server, and then make make install make clean. Then in /etc/rc.conf you will need mysql_enable=YES and you can look at the file /usr/local/etc/rc.d/mysql for how to set any flags you need. Usually you just have to set mysql_flags=your flags here in rc.conf. Hope that helps you get started, but if you need more then you'll have to supply more info. Cheers ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
mysql client(s)
PhpMyAdmin shows: Server: Localhost via UNIX socket Server version: 5.5.15 Protocol version: 10 User: root@localhost MySQL charset: UTF-8 Unicode (utf8) Apache/2.2.19 (FreeBSD) mod_ssl/2.2.19 OpenSSL/0.9.8q DAV/2 PHP/5.3.6 with Suhosin-Patch MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 308673 $ I don't understand the client version thing. I have mysql-client-5.5.15 installed too. *Why* does PhpMyAdmin not show this client but an (to me) unknown program (mysqlnd-5.0.8-dev) Where does this program come from. I have no idea how it came on my system. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql client(s)
First hit on google: http://www.google.com/search?q=mysqlnd On Thu, Aug 11, 2011 at 01:31:11PM +0200, Dick Hoogendijk typed: PhpMyAdmin shows: Server: Localhost via UNIX socket Server version: 5.5.15 Protocol version: 10 User: root@localhost MySQL charset: UTF-8 Unicode (utf8) Apache/2.2.19 (FreeBSD) mod_ssl/2.2.19 OpenSSL/0.9.8q DAV/2 PHP/5.3.6 with Suhosin-Patch MySQL client version: mysqlnd 5.0.8-dev - 20102224 - $Revision: 308673 $ I don't understand the client version thing. I have mysql-client-5.5.15 installed too. *Why* does PhpMyAdmin not show this client but an (to me) unknown program (mysqlnd-5.0.8-dev) Where does this program come from. I have no idea how it came on my system. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
MySQL update
Trying to update MySQL from 4.1 to 5.5. Updating mysql-client first. Make works great, but make install refuses to install saying 5.5 conflicts with 4.1, run pkg_delete for 4.1. pkg_delete for 4.1 refuses to deinstall as all the php52 packages (extensions, mysql, mysqli, pdo_mysql etc.) depend on mysql 4.1. Question: Do I have to deinstall everything, and then put it all back together, or can I force the mysql 5.5 client and 5.5 server to install? Thanks! Glenn. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL update
Glenn McCalley gl...@mail.bnetmd.net writes: Trying to update MySQL from 4.1 to 5.5. Updating mysql-client first. Make works great, but make install refuses to install saying 5.5 conflicts with 4.1, run pkg_delete for 4.1. pkg_delete for 4.1 refuses to deinstall as all the php52 packages (extensions, mysql, mysqli, pdo_mysql etc.) depend on mysql 4.1. Question: Do I have to deinstall everything, and then put it all back together, or can I force the mysql 5.5 client and 5.5 server to install? There are several ports management tools in ports/ports-mgmt which handle this for you. portmaster, portupgrade, etc... ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
MySQL update
Glenn McCalley writes: Question: Do I have to deinstall everything, and then put it all back together, or can I force the mysql 5.5 client and 5.5 server to install? Have to? Possibly not. That may, however, quite likely be the path of least resistance. Robert Huff ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL update
On 7 June 2011 12:56, Glenn McCalley gl...@mail.bnetmd.net wrote: Trying to update MySQL from 4.1 to 5.5. Updating mysql-client first. Make works great, but make install refuses to install saying 5.5 conflicts with 4.1, run pkg_delete for 4.1. pkg_delete for 4.1 refuses to deinstall as all the php52 packages (extensions, mysql, mysqli, pdo_mysql etc.) depend on mysql 4.1. Question: Do I have to deinstall everything, and then put it all back together, or can I force the mysql 5.5 client and 5.5 server to install? I'm at work at the moment, so I can't test these, sorry. Firstly, get portmaster: # pkg_add -r portmaster Then read the manpage: % man portmaster Try something like: # portmaster -o databases/mysql55-client mysql-client # portmaster -o databases/mysql55-server mysql-server Then, because you haven't read the manpage you'll have to confirm everything. Read the manpage! If it doesn't work (because I made a mistake with the -o syntax), read the manpage and then let us have the output. Chris ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL update
On 07/06/2011 13:37, Chris Rees wrote: On 7 June 2011 12:56, Glenn McCalley gl...@mail.bnetmd.net wrote: Trying to update MySQL from 4.1 to 5.5. Updating mysql-client first. Make works great, but make install refuses to install saying 5.5 conflicts with 4.1, run pkg_delete for 4.1. pkg_delete for 4.1 refuses to deinstall as all the php52 packages (extensions, mysql, mysqli, pdo_mysql etc.) depend on mysql 4.1. Question: Do I have to deinstall everything, and then put it all back together, or can I force the mysql 5.5 client and 5.5 server to install? I'm at work at the moment, so I can't test these, sorry. Firstly, get portmaster: # pkg_add -r portmaster Then read the manpage: % man portmaster Try something like: # portmaster -o databases/mysql55-client mysql-client # portmaster -o databases/mysql55-server mysql-server Then, because you haven't read the manpage you'll have to confirm everything. Read the manpage! If it doesn't work (because I made a mistake with the -o syntax), read the manpage and then let us have the output. After doing that, you will also need to: portmaster -fr databases/mysql55-client to relink everything against the new libmysql.so -- portmaster defaults to simply deleting any old shlibs when there is an ABI version bump, so anything dependent on the older version will cease to function corrrectly[*] from that point. There is a '-w' option which can help smooth over such transitions, but even that is no panacea. If you accidentally end up trying to load two different versions of libmysql.so into the same application, it will result in crashyness. Cheers, Matthew [*] ie. you can't /start/ it: stuff that is already running will mostly be OK. -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matt...@infracaninophile.co.uk Kent, CT11 9PW signature.asc Description: OpenPGP digital signature
MySQL update
Robert Huff writes: That may, however, quite likely be the path of least resistance. Also - have you read /usr/ports/UPDATING? Robert Huff ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
portaudit: exim vulnerable but exim-mysql not??
Hi, I've noticed that servers runing exim version 4.74 are being flagged by portaudit as having this vulnerability: http://www.FreeBSD.org/ports/portaudit/36594c54-7be7-11e0-9838-0022156e8794.html But systems with the port exim-mysql are not. This has to be an oversight doesn't it? If yes, who would need to be informed of this? thanks Andy. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL update - Done
Chris, portmaster was the key. Installed that (yes, read the manpage, and your -o syntax was OK anyway) and MAGIC! -- update went fine. Matthew and Robert's comments regarding updating taken to heart as well. THANKS guys, much appreciated. Glenn. - Original Message - From: Chris Rees utis...@gmail.com To: Glenn McCalley gl...@mail.bnetmd.net Cc: freebsd-questions@freebsd.org Sent: Tuesday, June 07, 2011 8:37 AM Subject: Re: MySQL update On 7 June 2011 12:56, Glenn McCalley gl...@mail.bnetmd.net wrote: Trying to update MySQL from 4.1 to 5.5. Updating mysql-client first. Make works great, but make install refuses to install saying 5.5 conflicts with 4.1, run pkg_delete for 4.1. pkg_delete for 4.1 refuses to deinstall as all the php52 packages (extensions, mysql, mysqli, pdo_mysql etc.) depend on mysql 4.1. Question: Do I have to deinstall everything, and then put it all back together, or can I force the mysql 5.5 client and 5.5 server to install? I'm at work at the moment, so I can't test these, sorry. Firstly, get portmaster: # pkg_add -r portmaster Then read the manpage: % man portmaster Try something like: # portmaster -o databases/mysql55-client mysql-client # portmaster -o databases/mysql55-server mysql-server Then, because you haven't read the manpage you'll have to confirm everything. Read the manpage! If it doesn't work (because I made a mistake with the -o syntax), read the manpage and then let us have the output. Chris ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
On 26 March 2011 21:40, Laszlo Nagy gand...@shopzeus.com wrote: There is nothing in /var/log/messages. It was working with 4.1 server, but I just uninstalled that (because the upgrading faq told me to install 4.0 instead.) Do you have the following in your /etc/rc.conf file: mysql_enable=YES Yes. I'm in the process of installing FreeBSD 6.4 in a virtual machine. Hopefully I'll be able to compile mysql 3.23 and make a backup from there. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org Why not get the binary packages off the freebsd archive servers from an earlier release and run those with the relevant compatibility layer ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how? [SOLVED]
I could install FreeBSD 6.4 on a virtual machine, replace the data dir and run mysqldump from there. Thank you for your help! L -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
MySQL 3 needed but how?
Hi, I have an old backup from a MySQL data directory. It was created with MySQL version 3. If I install MySQL 4 then I get this message telling that the table was created with a different MySQL version. So I try to install mysql 3. Here is the problem: gw# pwd /usr/ports/databases/mysql323-server gw# make === mysql-server-3.23.59.n.20050301_3 obsolete and does not build with gcc4.2; use mysql 5 or later. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. gw# But I really need mysql 3. I usually install everything from the ports tree, but in this case this won't work. I need a quick solution. Maybe I can install a different OS in a virtual machine. But do you know where can I download a BSD OS version that has a binary package of MySQL server 3? (I don't know how to search for a BSD OS that has binary packages for mysql3...) Thanks, Laszlo ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
In article 4d8e1e4a.5000...@shopzeus.com you write: Hi, I have an old backup from a MySQL data directory. It was created with MySQL version 3. If I install MySQL 4 then I get this message telling that the table was created with a different MySQL version. You should be able to restore the individual database directories under mysql 4 and use ALTER TABLE to upgrade the file formats. You'll lose the user access stuff, but that's usually easy enough to reconstruct. In MySQL, each database is self-describing. That is, for database foo, the files in the foo/ directory are both the description of the tables and the data in them. http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html R's, John ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
Quick glance /usr/ports/databases/mysql323-server/ 65 .if ${OSVERSION} = 70 66 IGNORE= obsolete and does not build with gcc4.2; use mysql 5 or later 67 .endif Get FreeBSD-6x installed somewhere and mysql port SHOULD compile and run. On Sat, Mar 26, 2011 at 7:11 PM, Laszlo Nagy gand...@shopzeus.com wrote: Hi, I have an old backup from a MySQL data directory. It was created with MySQL version 3. If I install MySQL 4 then I get this message telling that the table was created with a different MySQL version. So I try to install mysql 3. Here is the problem: gw# pwd /usr/ports/databases/mysql323-server gw# make === mysql-server-3.23.59.n.20050301_3 obsolete and does not build with gcc4.2; use mysql 5 or later. *** Error code 1 Stop in /usr/ports/databases/mysql323-server. gw# But I really need mysql 3. I usually install everything from the ports tree, but in this case this won't work. I need a quick solution. Maybe I can install a different OS in a virtual machine. But do you know where can I download a BSD OS version that has a binary package of MySQL server 3? (I don't know how to search for a BSD OS that has binary packages for mysql3...) Thanks, Laszlo ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
On 2011-03-26 18:41, John Levine wrote: In article4d8e1e4a.5000...@shopzeus.com you write: Hi, I have an old backup from a MySQL data directory. It was created with MySQL version 3. If I install MySQL 4 then I get this message telling that the table was created with a different MySQL version. You should be able to restore the individual database directories under mysql 4 and use ALTER TABLE to upgrade the file formats. You'll lose the user access stuff, but that's usually easy enough to reconstruct. In MySQL, each database is self-describing. That is, for database foo, the files in the foo/ directory are both the description of the tables and the data in them. http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html Okay, I tried to follow the instruction. So instead of installing 4.1, I have installed 4.0. After replacing /var/db/mysql with my archived directory: gw# /usr/local/etc/rc.d/mysql-server start Starting mysql. gw# /usr/local/etc/rc.d/mysql-server status mysql is not running. gw# There is nothing in /var/log/messages. It was working with 4.1 server, but I just uninstalled that (because the upgrading faq told me to install 4.0 instead.) So what now? L ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
Starting mysql. gw# /usr/local/etc/rc.d/mysql-server status mysql is not running. gw# There is nothing in /var/log/messages. Sounds like you'll have to do some debugging. Try adding --verbose to mysql_args in /etc/rc.conf, and see the other advice in http://dev.mysql.com/doc/refman/4.1/en/starting-server.html It may be something really simple, like the mysql data directory not being where the server expects it to be. Regards, John Levine, jo...@iecc.com, Primary Perpetrator of The Internet for Dummies, Please consider the environment before reading this e-mail. http://jl.ly ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
On Sat, 26 Mar 2011 20:21:08 +0100 Laszlo Nagy gand...@shopzeus.com articulated: On 2011-03-26 18:41, John Levine wrote: In article4d8e1e4a.5000...@shopzeus.com you write: Hi, I have an old backup from a MySQL data directory. It was created with MySQL version 3. If I install MySQL 4 then I get this message telling that the table was created with a different MySQL version. You should be able to restore the individual database directories under mysql 4 and use ALTER TABLE to upgrade the file formats. You'll lose the user access stuff, but that's usually easy enough to reconstruct. In MySQL, each database is self-describing. That is, for database foo, the files in the foo/ directory are both the description of the tables and the data in them. http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html Okay, I tried to follow the instruction. So instead of installing 4.1, I have installed 4.0. After replacing /var/db/mysql with my archived directory: gw# /usr/local/etc/rc.d/mysql-server start Starting mysql. gw# /usr/local/etc/rc.d/mysql-server status mysql is not running. gw# There is nothing in /var/log/messages. It was working with 4.1 server, but I just uninstalled that (because the upgrading faq told me to install 4.0 instead.) Do you have the following in your /etc/rc.conf file: mysql_enable=YES -- Jerry ✌ freebsd.u...@seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __ Microbiology Lab: Staph Only! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
There is nothing in /var/log/messages. It was working with 4.1 server, but I just uninstalled that (because the upgrading faq told me to install 4.0 instead.) Do you have the following in your /etc/rc.conf file: mysql_enable=YES Yes. I'm in the process of installing FreeBSD 6.4 in a virtual machine. Hopefully I'll be able to compile mysql 3.23 and make a backup from there. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
Sounds like you'll have to do some debugging. Try adding --verbose to mysql_args in /etc/rc.conf, and see the other advice in http://dev.mysql.com/doc/refman/4.1/en/starting-server.html gw# /usr/local/bin/mysqld_safe --verbose Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/gw.sznet.pid 110326 16:44:14 mysqld ended The data directory is correct. I don't understand why it is stopping immediatelly after startup. Trying the other way around (FreeBSD 6.4 on a virtual machine) It may be something really simple, like the mysql data directory not being where the server expects it to be. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
Laszlo Nagy wrote: Sounds like you'll have to do some debugging. Try adding --verbose to mysql_args in /etc/rc.conf, and see the other advice in http://dev.mysql.com/doc/refman/4.1/en/starting-server.html gw# /usr/local/bin/mysqld_safe --verbose Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/gw.sznet.pid 110326 16:44:14 mysqld ended The data directory is correct. I don't understand why it is stopping immediatelly after startup. Trying the other way around (FreeBSD 6.4 on a virtual machine) It may be something really simple, like the mysql data directory not being where the server expects it to be. No matter which version of mysql you install, you have to run this command mysql_install_db --user=mysql on the command line to create mysql's control databases first. Then restart the mysql service. To verify mysql is operational issue this command. mysqladmin version Them run your restore DB job pointing at your old bkup file. That should recreate your db definition and populate the db with your data in sync with the version of mysql your running. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 3 needed but how?
On Sat, 26 Mar 2011 18:56:03 -0400 Fbsd8 fb...@a1poweruser.com articulated: Laszlo Nagy wrote: Sounds like you'll have to do some debugging. Try adding --verbose to mysql_args in /etc/rc.conf, and see the other advice in http://dev.mysql.com/doc/refman/4.1/en/starting-server.html gw# /usr/local/bin/mysqld_safe --verbose Starting mysqld daemon with databases from /var/db/mysql STOPPING server from pid file /var/db/mysql/gw.sznet.pid 110326 16:44:14 mysqld ended The data directory is correct. I don't understand why it is stopping immediatelly after startup. Trying the other way around (FreeBSD 6.4 on a virtual machine) It may be something really simple, like the mysql data directory not being where the server expects it to be. No matter which version of mysql you install, you have to run this command mysql_install_db --user=mysql on the command line to create mysql's control databases first. I believe that all of that is done by the mysql-server start-up file. -- Jerry ✌ freebsd.u...@seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
mysql 559 and fbsd 8.2 'mysql_install_db' error
I have been using mysql since fbsd 7.2 and always just issued the mysql_install_db command on the command line to create it's control databases and it just worked fine. But now with 8.2 I get the following error and have no idea why. I installed using pkg_add mysql55-server command. # /usr/local/bin mysql_install_db --user=mysql FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. # /usr/local/bin locate my_print_defaults /usr/local/bin/my_print_defaults ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
Quoth Zbigniew Szalbot on Friday, 04 March 2011: Hello, Thanks duly noted to everyone. I was beginning to wonder if I had lost what mind I've got left! Not used to losing my two trial blog, (1), and beyond that, being dumbfounded at how messy it may be to keep WP current. (2) It seems to me you are making you life more difficult with WP than it needs to be. Keeping WP current is a piece of cake, and you do not need to do it via ports. WP has built-in ftp capabilities and once you provide it with proper credentials, upgrading is as easy as clicking the upgrade button from within WP admin interface. This way you can keep multiple WP installations and easily maintain them. :) I have not had a lot of luck with upgrading from within the admin panel, but it is still easy to upgrade by downloading the latest tarball and simply extracting it over the installation. Then go into the admin panel to see if it requires that you press a button to update the database. Done! Of course, make a backup first. -- Sterling (Chip) Camden | sterl...@camdensoftware.com | 2048D/3A978E4F http://chipsquips.com | http://camdensoftware.com | http://chipstips.com pgpdflAWmvQoM.pgp Description: PGP signature
Re: mysql missing from my home-page WordPress....
On Fri, Mar 04, 2011 at 07:27:44AM -0800, Chip Camden wrote: I have not had a lot of luck with upgrading from within the admin panel, but it is still easy to upgrade by downloading the latest tarball and simply extracting it over the installation. Then go into the admin panel to see if it requires that you press a button to update the database. Done! Of course, make a backup first. . . . and Heaven help you if you had to make any nontrivial changes to your local install of WordPress to make up for some of its many deficiencies, and don't have a detailed record of exactly what changes you made, since I know of no upgrade methodology for WordPress that don't destroy such changes in a way that makes it effectively impossible to just apply a patch to reintroduce them. WordPress developers apparently like to substantially change the way things look in all the core files (thus breaking patches made from earlier versions) without substantively changing the way things work or the readability of the code. -- Chad Perrin [ original content licensed OWL: http://owl.apotheon.org ] pgpstENE4ZRWH.pgp Description: PGP signature
Re: mysql missing from my home-page WordPress....
Quoth Chad Perrin on Friday, 04 March 2011: On Fri, Mar 04, 2011 at 07:27:44AM -0800, Chip Camden wrote: I have not had a lot of luck with upgrading from within the admin panel, but it is still easy to upgrade by downloading the latest tarball and simply extracting it over the installation. Then go into the admin panel to see if it requires that you press a button to update the database. Done! Of course, make a backup first. . . . and Heaven help you if you had to make any nontrivial changes to your local install of WordPress to make up for some of its many deficiencies, and don't have a detailed record of exactly what changes you made, since I know of no upgrade methodology for WordPress that don't destroy such changes in a way that makes it effectively impossible to just apply a patch to reintroduce them. WordPress developers apparently like to substantially change the way things look in all the core files (thus breaking patches made from earlier versions) without substantively changing the way things work or the readability of the code. -- Chad Perrin [ original content licensed OWL: http://owl.apotheon.org ] Yes, I've been bitten by that. Nowadays I confine all of my customizations to plugins or theme files, os I can always drop in their latest version and then check to see if they broke the plugins somehow (which has happened on occasion). -- Sterling (Chip) Camden | sterl...@camdensoftware.com | 2048D/3A978E4F http://chipsquips.com | http://camdensoftware.com | http://chipstips.com pgp0HDrqpcqog.pgp Description: PGP signature
Re: mysql missing from my home-page WordPress....
[Just a top post to say that recent troubles of unknown cause on my server --7.3-- have drained time from my thought of joining the Blogger World.] On Fri, Mar 04, 2011 at 09:09:20AM -0800, Chip Camden wrote: Quoth Chad Perrin on Friday, 04 March 2011: On Fri, Mar 04, 2011 at 07:27:44AM -0800, Chip Camden wrote: I have not had a lot of luck with upgrading from within the admin panel, but it is still easy to upgrade by downloading the latest tarball and simply extracting it over the installation. Then go into the admin panel to see if it requires that you press a button to update the database. Done! Of course, make a backup first. I make bups of bups; the thing is that when I _thought_ i had upgraded by push-button nothing had actually happened. My version had not been uprev'd to 3.1; it was still a 3.0.4. Etc. I'mall but certain this would have been the same if I were running Linux. ...So yes, I will d/load stuff, move or scp it into my www/data/blog/* and extract. My proposed site is titled ...And miles to go before I sleep; the blog directory is, literally blog. (I posted a question on the forum about where to change the author info and someone said it was www.home/blog/author/authorID --IIRC. I didn't understand the answer.) . . . and Heaven help you if you had to make any nontrivial changes to your local install of WordPress to make up for some of its many deficiencies, and don't have a detailed record of exactly what changes you made, since I know of no upgrade methodology for WordPress that don't destroy such changes in a way that makes it effectively impossible to just apply a patch to reintroduce them. WordPress developers apparently like to substantially change the way things look in all the core files (thus breaking patches made from earlier versions) without substantively changing the way things work or the readability of the code. I just found the WP-3.1.zip file in my ~/Downloads directory. I had not looked. On the WP.org forum I claimed to be running 3.1 rather than 3.0.4. Could have have nosed me somehow? How tightly integrated are the clients integrated with WordPress? Another thin I don't quite get is whether this group in a non-profit [.org] or a for-profit [.com]. I've seen some instructive videos for this effort; I'm assuming that these are for the .com/commercial side. Is there a place on the WP .org side that has a series of tutorials-- 001 to NNN that I should read? This one isn't going to be plug-in-an-use; it looks like it demands at least a moderate learning curve. -- Chad Perrin [ original content licensed OWL: http://owl.apotheon.org ] Yes, I've been bitten by that. Nowadays I confine all of my customizations to plugins or theme files, os I can always drop in their latest version and then check to see if they broke the plugins somehow (which has happened on occasion). Yipes. Thanks for the clue. gary -- Sterling (Chip) Camden | sterl...@camdensoftware.com | 2048D/3A978E4F http://chipsquips.com | http://camdensoftware.com | http://chipstips.com -- Gary Kline kl...@thought.org http://www.thought.org Public Service Unix Journey Toward the Dawn, E-Book: http://www.thought.org The 7.98a release of Jottings: http://jottings.thought.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
Quoth Gary Kline on Friday, 04 March 2011: ✂ snip ✂ it into my www/data/blog/* and extract. My proposed site is titled ...And miles to go before I sleep; the blog directory is, literally blog. (I posted a question on the forum about where to change the author info and someone said it was www.home/blog/author/authorID --IIRC. I didn't understand the answer.) ✂ snip ✂ It's in the MySQL database. You change it by going into the admin panel (www.home/blog/wp-admin) then go to the general settings (on the left sidebar, under Settings click General or navigate to www.home/blog/wp-admin/options-general.php). ✂ snip ✂ I just found the WP-3.1.zip file in my ~/Downloads directory. I had not looked. On the WP.org forum I claimed to be running 3.1 rather than 3.0.4. Could have have nosed me somehow? How tightly integrated are the clients integrated with WordPress? Another thin I don't quite get is whether this group in a non-profit [.org] or a for-profit [.com]. Wordpress.org is the site for the open source Wordpress project. It's where you download sources, and where everything's documented. Wordpress.com is a site where you can sign up for a free account that they host. You might want to bookmark http://codex.wordpress.org/Main_Page ✂ snip ✂ -- Sterling (Chip) Camden | sterl...@camdensoftware.com | 2048D/3A978E4F http://chipsquips.com | http://camdensoftware.com | http://chipstips.com pgpWQEvbihQfs.pgp Description: PGP signature
Re: mysql missing from my home-page WordPress....
On 03/01/2011 03:50 PM, Gary Kline wrote: On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn Sieb wrote: On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn This was the first thing I [re-] installed. q0 14:47 Serverethic [5001] pkg_info | gr php5-mysql 470:php5-mysql-5.3.5The mysql shared extension for php 471:php5-mysqli-5.3.5 The mysqli shared extension for php q0 14:47 Serverethic [5002] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org I had a similar problem with PHP after I upgraded it. The location of the php extensions had changed, but my php.ini was still pointing to the old location of the modules. You may want to double check the path and make sure they're both the same. If not, I recommend copying in the new .default php.ini file and make your custom changes there, as there were recently many settings changed/added in the latest PHP version. -- Thanks, John D Jones III freebsd-questi...@bsdgeeks4u.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
Wordpress install ftw I created a new database manually Http://www.inverselog.info John D Jones III freebsd-questi...@bsdgeeks4u.com wrote: On 03/01/2011 03:50 PM, Gary Kline wrote: On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn Sieb wrote: On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn This was the first thing I [re-] installed. q0 14:47 Serverethic [5001] pkg_info | gr php5-mysql 470:php5-mysql-5.3.5The mysql shared extension for php 471:php5-mysqli-5.3.5 The mysqli shared extension for php q0 14:47 Serverethic [5002] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org I had a similar problem with PHP after I upgraded it. The location of the php extensions had changed, but my php.ini was still pointing to the old location of the modules. You may want to double check the path and make sure they're both the same. If not, I recommend copying in the new .default php.ini file and make your custom changes there, as there were recently many settings changed/added in the latest PHP version. -- Thanks, John D Jones III freebsd-questi...@bsdgeeks4u.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
On Thu, Mar 03, 2011 at 02:34:56PM -0500, Michael J. Kearney wrote: Wordpress install ftw I created a new database manually Http://www.inverselog.info John D Jones III freebsd-questi...@bsdgeeks4u.com wrote: On 03/01/2011 03:50 PM, Gary Kline wrote: On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn Sieb wrote: On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn This was the first thing I [re-] installed. q0 14:47 Serverethic [5001] pkg_info | gr php5-mysql 470:php5-mysql-5.3.5The mysql shared extension for php 471:php5-mysqli-5.3.5 The mysqli shared extension for php q0 14:47 Serverethic [5002] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org I had a similar problem with PHP after I upgraded it. The location of the php extensions had changed, but my php.ini was still pointing to the old location of the modules. You may want to double check the path and make sure they're both the same. If not, I recommend copying in the new .default php.ini file and make your custom changes there, as there were recently many settings changed/added in the latest PHP version. -- Thanks, John D Jones III freebsd-questi...@bsdgeeks4u.com Thanks duly noted to everyone. I was beginning to wonder if I had lost what mind I've got left! Not used to losing my two trial blog, (1), and beyond that, being dumbfounded at how messy it may be to keep WP current. (2) All of a sudden I'm thinking [[*hmmm, well, censored*]]. -g ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org -- Gary Kline kl...@thought.org http://www.thought.org Public Service Unix Journey Toward the Dawn, E-Book: http://www.thought.org The 7.98a release of Jottings: http://jottings.thought.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
Hello, Thanks duly noted to everyone. I was beginning to wonder if I had lost what mind I've got left! Not used to losing my two trial blog, (1), and beyond that, being dumbfounded at how messy it may be to keep WP current. (2) It seems to me you are making you life more difficult with WP than it needs to be. Keeping WP current is a piece of cake, and you do not need to do it via ports. WP has built-in ftp capabilities and once you provide it with proper credentials, upgrading is as easy as clicking the upgrade button from within WP admin interface. This way you can keep multiple WP installations and easily maintain them. :) Warm regards, Zbigniew Szalbot ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
mysql missing from my home-page WordPress....
Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? -- Gary Kline kl...@thought.org http://www.thought.org Public Service Unix Journey Toward the Dawn, E-Book: http://www.thought.org The 7.98a release of Jottings: http://jottings.thought.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
And enabled php -m check that mysql extension is loaded Regards Rodrigo On Tuesday, March 01, 2011 06:03:13 PM Glenn Sieb wrote: On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
On Tue, Mar 01, 2011 at 06:22:13PM -0300, Rodrigo Gonzalez wrote: And enabled php -m check that mysql extension is loaded Regards Rodrigo Hmmm. Good one! ... well, maybe. I have no idea why PHP Startup can't load these libraries. PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/20090626/bcmath.so' - Cannot open /usr/local/lib/php/20090626/bcmath.so in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/20090626/mssql.so' - Cannot open /usr/local/lib/php/20090626/mssql.so in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/20090626/openssl.so' - Cannot open /usr/local/lib/php/20090626/openssl.so in Unknown on line 0 [PHP Modules] Core ctype date dom ereg filter hash iconv json libxml mhash mysql mysqli mysqlnd pcre PDO pdo_sqlite posix Reflection session SimpleXML SPL SQLite standard tokenizer xml xmlreader xmlwriter [Zend Modules] Any ideas? Should I just /bin/rm the ones that are loadable? gary On Tuesday, March 01, 2011 06:03:13 PM Glenn Sieb wrote: On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org -- Gary Kline kl...@thought.org http://www.thought.org Public Service Unix Journey Toward the Dawn, E-Book: http://www.thought.org The 7.98a release of Jottings: http://jottings.thought.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
you just need to delete them from /usr/local/etc/php/extensions.ini mysql extension is loaded when you are using cli, I would check at web server module. Create a file called info.php in your document root then go to http://your ip/info.php Check if there is a block called mysql Regards Rodrigo On Tuesday, March 01, 2011 07:59:56 PM Gary Kline wrote: On Tue, Mar 01, 2011 at 06:22:13PM -0300, Rodrigo Gonzalez wrote: And enabled php -m check that mysql extension is loaded Regards Rodrigo Hmmm. Good one! ... well, maybe. I have no idea why PHP Startup can't load these libraries. PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/20090626/bcmath.so' - Cannot open /usr/local/lib/php/20090626/bcmath.so in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/20090626/mssql.so' - Cannot open /usr/local/lib/php/20090626/mssql.so in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/20090626/openssl.so' - Cannot open /usr/local/lib/php/20090626/openssl.so in Unknown on line 0 [PHP Modules] Core ctype date dom ereg filter hash iconv json libxml mhash mysql mysqli mysqlnd pcre PDO pdo_sqlite posix Reflection session SimpleXML SPL SQLite standard tokenizer xml xmlreader xmlwriter [Zend Modules] Any ideas? Should I just /bin/rm the ones that are loadable? gary On Tuesday, March 01, 2011 06:03:13 PM Glenn Sieb wrote: On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
On Tue, Mar 01, 2011 at 04:03:13PM -0500, Glenn Sieb wrote: On 3/1/11 3:53 PM, Gary Kline wrote: Any clues why I get a one-liner from wordpress that my database extention is missing? I re-installed everything; it is running. The wordpress db is there when I check 'show database'. What else? Check and make sure the MySQL extensions are installed in PHP? pkg_info | grep php5-mysql (if not..) cd /usr/ports/databases/php5-mysql make install clean Good luck! --Glenn This was the first thing I [re-] installed. q0 14:47 Server ethic [5001] pkg_info | gr php5-mysql 470:php5-mysql-5.3.5The mysql shared extension for php 471:php5-mysqli-5.3.5 The mysqli shared extension for php q0 14:47 Server ethic [5002] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org -- Gary Kline kl...@thought.org http://www.thought.org Public Service Unix Journey Toward the Dawn, E-Book: http://www.thought.org The 7.98a release of Jottings: http://jottings.thought.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql missing from my home-page WordPress....
On Tue, Mar 01, 2011 at 08:35:25PM -0300, Rodrigo Gonzalez wrote: you just need to delete them from /usr/local/etc/php/extensions.ini mysql extension is loaded when you are using cli, I would check at web server module. Create a file called info.php in your document root then go to http://your ip/info.php Check if there is a block called mysql Regards Rodrigo Thanks for your help; I am back up, installed a new WordPress, and re-re-reinstalled the database. --I could ramble on for paragraphs, but will spare everybody! I am running WP on my FreeBSD 7.3 server and want to know how I can upgrade from within my present version. I'm running v 3.0.4 from ports; the latest is 3.1. Last time I tried upgrading from here as root I got power-surged off the Net. When I got back and tried to pick up the thread of thoughts, WordPress couldn't see MYSQL. Nutshell, is there a way that I can d/load and install WP on Berkeley Unix? ---just wondering! And how can I d/l Plugins and fonts? thanks again! appreciated your insights, gary -- Gary Kline kl...@thought.org http://www.thought.org Public Service Unix Journey Toward the Dawn, E-Book: http://www.thought.org The 7.98a release of Jottings: http://jottings.thought.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Continuing problems with Dovecot + MySQL 5.5.8_1
FreeBSD 8.2-PRERELEASE After updating to the latest version of MySQL (5.5.8_1), I am continuing to have problems with Dovecot failing to run correctly even though I completely removed and reinstalled it. I might add that I did a pkg_delete of the MySQL client and server also before updating the port. I was led to believe that this updated version corrected the problem; however, that does not appear to be correct. :-( Strangely enough, Postfix, after rebuilding it, works fine with the new version of MySQL. :-) What I need to do is get a gdb backtrace of dovecot. Since the program starts from the dovecot script in the /usr/local/etc/rc.d directory, I am unsure of how to accomplish this. I have tried several methods; however, they all fail. Exactly how would I start dovecot using the script via gdb to get a backtrace? Thanks -- Jerry ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Continuing problems with Dovecot + MySQL 5.5.8_1
On Jan 11, 2011, at 11:25 AM, Jerry wrote: FreeBSD 8.2-PRERELEASE After updating to the latest version of MySQL (5.5.8_1), I am continuing to have problems with Dovecot failing to run correctly even though I completely removed and reinstalled it. I might add that I did a pkg_delete of the MySQL client and server also before updating the port. I was led to believe that this updated version corrected the problem; however, that does not appear to be correct. :-( Strangely enough, Postfix, after rebuilding it, works fine with the new version of MySQL. :-) What I need to do is get a gdb backtrace of dovecot. Since the program starts from the dovecot script in the /usr/local/etc/rc.d directory, I am unsure of how to accomplish this. I have tried several methods; however, they all fail. Exactly how would I start dovecot using the script via gdb to get a backtrace? start it from the command line? There are some knobs in the conf file to help with debugging, too. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Continuing problems with Dovecot + MySQL 5.5.8_1
On Tue, Jan 11, 2011 at 7:25 PM, Jerry freebsd.u...@seibercom.net wrote: FreeBSD 8.2-PRERELEASE After updating to the latest version of MySQL (5.5.8_1), I am continuing to have problems with Dovecot failing to run correctly even though I completely removed and reinstalled it. I might add that I did a pkg_delete of the MySQL client and server also before updating the port. I was led to believe that this updated version corrected the problem; however, that does not appear to be correct. :-( Strangely enough, Postfix, after rebuilding it, works fine with the new version of MySQL. :-) What I need to do is get a gdb backtrace of dovecot. Since the program starts from the dovecot script in the /usr/local/etc/rc.d directory, I am unsure of how to accomplish this. I have tried several methods; however, they all fail. Exactly how would I start dovecot using the script via gdb to get a backtrace? Since you are on FreeBSD, you can do the following (as root of course): #ulimit -c unlimited #gdb -args /usr/local/sbin/dovecot -F -c /usr/local/etc/dovecot/dovecot.conf run bt full You would run 'bt full' only after Dovecot died (gdb will tell you when that happens) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql-5.5.8 Postfix/Dovecot
Jerry ha scritto: I have seen it posted here and on the Dovecot forum that upgrading to mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot. Fixed. -- Alex Dupre ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
mysql-5.5.8 Postfix/Dovecot
I have seen it posted here and on the Dovecot forum that upgrading to mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot. Apparently reverting to the mysql-client-5.5.7 corrects this problem. Can any one else confirm this or is this simply an isolated incident? If this is correct, is there a PR filed against it? I was not able to locate one. Specifically, I am interested in the interaction on an FreeBSD-8.2 / amd64 system. -- Jerry ✌ freebsd.u...@seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __ Kaufman's First Law of Party Physics: Population density is inversely proportional to the square of the distance from the keg. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql-5.5.8 Postfix/Dovecot
On Wed, Jan 5, 2011 at 2:49 PM, Jerry freebsd.u...@seibercom.net wrote: I have seen it posted here and on the Dovecot forum that upgrading to mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot. Apparently reverting to the mysql-client-5.5.7 corrects this problem. Can any one else confirm this or is this simply an isolated incident? If this is correct, is there a PR filed against it? I was not able to locate one. Specifically, I am interested in the interaction on an FreeBSD-8.2 / amd64 system. I haven't filed a case though. My system is 8.2-STABLE/i386. I was running 5.5.7 with Request Tracker (Devel)http://bestpractical.com/rtand all played nice until I upgraded to 5.5.8. As this is a test platform, I wanted to install the next devel version of RT when I encountered a problem with initializing the database: I get this error: cut DBD::mysql::st execute failed: 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 'ENGINE=InnoDB CHARACTER SET utf8' at line 15 at /usr/home/wash/Tools/RT/RT-4/rt-4.0.0rc1/sbin/../lib/RT/Handle.pm line 508. *** Error code 255 /cut My worry is so much about the character set error. I also found my dovecot broken: Jan 05 15:26:16 master: Error: service(auth): child 46112 returned error 1 Jan 05 15:26:16 master: Error: service(auth): command startup failed, throttling Jan 05 15:26:51 pop3-login: Error: Timeout waiting for handshake from auth server. my pid=46111, input bytes=0 Jan 05 15:27:16 auth: Error: /libexec/ld-elf.so.1: /usr/local/lib/libmysqlclient.so.16: version libmysqlclient_16 required by /usr/local/libexec/dovecot/auth not defined -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql-5.5.8 Postfix/Dovecot
On Wed, 5 Jan 2011 15:37:38 +0300 Odhiambo Washington odhia...@gmail.com articulated: On Wed, Jan 5, 2011 at 2:49 PM, Jerry freebsd.u...@seibercom.net wrote: I have seen it posted here and on the Dovecot forum that upgrading to mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot. Apparently reverting to the mysql-client-5.5.7 corrects this problem. Can any one else confirm this or is this simply an isolated incident? If this is correct, is there a PR filed against it? I was not able to locate one. Specifically, I am interested in the interaction on an FreeBSD-8.2 / amd64 system. I haven't filed a case though. My system is 8.2-STABLE/i386. I was running 5.5.7 with Request Tracker (Devel)http://bestpractical.com/rtand all played nice until I upgraded to 5.5.8. As this is a test platform, I wanted to install the next devel version of RT when I encountered a problem with initializing the database: I get this error: cut DBD::mysql::st execute failed: 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 'ENGINE=InnoDB CHARACTER SET utf8' at line 15 at /usr/home/wash/Tools/RT/RT-4/rt-4.0.0rc1/sbin/../lib/RT/Handle.pm line 508. *** Error code 255 /cut My worry is so much about the character set error. I also found my dovecot broken: Jan 05 15:26:16 master: Error: service(auth): child 46112 returned error 1 Jan 05 15:26:16 master: Error: service(auth): command startup failed, throttling Jan 05 15:26:51 pop3-login: Error: Timeout waiting for handshake from auth server. my pid=46111, input bytes=0 Jan 05 15:27:16 auth: Error: /libexec/ld-elf.so.1: /usr/local/lib/libmysqlclient.so.16: version libmysqlclient_16 required by /usr/local/libexec/dovecot/auth not defined I wonder if this is a Dovecot error or a problem with the MySQL upgrade. Did you try asking Timo regarding the Dovecot problem? In any case, it might be worth it to file a PR against both Dovecot and MySQL. Nothing will probably get done until one is filed. -- Jerry ✌ freebsd.u...@seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __ And that's the way it is... Walter Cronkite ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: mysql-5.5.8 Postfix/Dovecot
On Wed, Jan 5, 2011 at 10:09 PM, Jerry freebsd.u...@seibercom.net wrote: On Wed, 5 Jan 2011 15:37:38 +0300 Odhiambo Washington odhia...@gmail.com articulated: On Wed, Jan 5, 2011 at 2:49 PM, Jerry freebsd.u...@seibercom.net wrote: I have seen it posted here and on the Dovecot forum that upgrading to mysql-5.5.8 on FreeBSD breaks both Postfix and Dovecot. Apparently reverting to the mysql-client-5.5.7 corrects this problem. Can any one else confirm this or is this simply an isolated incident? If this is correct, is there a PR filed against it? I was not able to locate one. Specifically, I am interested in the interaction on an FreeBSD-8.2 / amd64 system. I haven't filed a case though. My system is 8.2-STABLE/i386. I was running 5.5.7 with Request Tracker (Devel)http://bestpractical.com/rtand all played nice until I upgraded to 5.5.8. As this is a test platform, I wanted to install the next devel version of RT when I encountered a problem with initializing the database: I get this error: cut DBD::mysql::st execute failed: 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 'ENGINE=InnoDB CHARACTER SET utf8' at line 15 at /usr/home/wash/Tools/RT/RT-4/rt-4.0.0rc1/sbin/../lib/RT/Handle.pm line 508. *** Error code 255 /cut My worry is so much about the character set error. I also found my dovecot broken: Jan 05 15:26:16 master: Error: service(auth): child 46112 returned error 1 Jan 05 15:26:16 master: Error: service(auth): command startup failed, throttling Jan 05 15:26:51 pop3-login: Error: Timeout waiting for handshake from auth server. my pid=46111, input bytes=0 Jan 05 15:27:16 auth: Error: /libexec/ld-elf.so.1: /usr/local/lib/libmysqlclient.so.16: version libmysqlclient_16 required by /usr/local/libexec/dovecot/auth not defined I wonder if this is a Dovecot error or a problem with the MySQL upgrade. Did you try asking Timo regarding the Dovecot problem? In any case, it might be worth it to file a PR against both Dovecot and MySQL. Nothing will probably get done until one is filed. Such minor breakages (like Dovecot experienced) don't worry me much sometimes. I simply recompile and life continues. When I upgrade a port I always expect (as a matter of principle) that something might go wrong and I go looking for it. However, the breakage with RT is one that has left me so worried - that character set issue, since it manifests itself on the main system, and only with 5.5.8 and not 5.5.7! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 5.5.7-5.5.8 Gotcha!
30.12.2010 14:23, Odhiambo Washington wrote): I am seeing a problem I am unable to solve after upgrading from 5.5.7 - 5.5.8. I am installing Request Tracket and I get the following error (which is in no way related to RT, I think): cut Character set 'latin1' is not a compiled character set and is not specified in the '/usr/local/share/mysql/charsets/Index.xml' file Failed to connect to dbi:mysql:;host=localhost as user 'root': Can't initialize character set latin1 (path: /usr/local/share/mysql/charsets/)*** Error code 255 /cut The Index.xml lists latin1 character set and even the file containing the charsets is there. I still don't think I should downgrade, but google isn't helping me much! I have seen the same when connecting from php5.2 built with mysql55-client to mysql51 database. -- Sphinx of black quartz judge my vow. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
MySQL 5.5.7-5.5.8 Gotcha!
I am seeing a problem I am unable to solve after upgrading from 5.5.7 - 5.5.8. I am installing Request Tracket and I get the following error (which is in no way related to RT, I think): cut Character set 'latin1' is not a compiled character set and is not specified in the '/usr/local/share/mysql/charsets/Index.xml' file Failed to connect to dbi:mysql:;host=localhost as user 'root': Can't initialize character set latin1 (path: /usr/local/share/mysql/charsets/)*** Error code 255 /cut The Index.xml lists latin1 character set and even the file containing the charsets is there. I still don't think I should downgrade, but google isn't helping me much! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
MySQL 5.5.7-5.5.8 instructions seem scary
I read this in /usr/ports/UPDATING today: = 20101227: AFFECTS: users of databases/mysql55-server AUTHOR: a...@freebsd.org MySQL 5.5 has been updated to 5.5.8 GA release. Since layout is changed you should remove mysql55-{client/server/scripts} ports before upgrading. The build system is changed too, so expect failures. = Now that seems pretty scary. Remove all mysql packages from my system?!?! Expect failures?!?!? I have important data in my current mysql install. porky/zsh# pkg_info -Qao | grep -i mysql mysql-client-5.5.7:databases/mysql55-client mysql-server-5.5.7:databases/mysql55-server php5-mysql-5.3.4:databases/php5-mysql Should I wait until things settle down before upgrading? I need better instruction on how to upgrade. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 5.5.7-5.5.8 instructions seem scary
On Wed, Dec 29, 2010 at 1:57 PM, Nerius Landys nlan...@gmail.com wrote: I read this in /usr/ports/UPDATING today: = 20101227: AFFECTS: users of databases/mysql55-server AUTHOR: a...@freebsd.org MySQL 5.5 has been updated to 5.5.8 GA release. Since layout is changed you should remove mysql55-{client/server/scripts} ports before upgrading. The build system is changed too, so expect failures. = Now that seems pretty scary. Remove all mysql packages from my system?!?! Expect failures?!?!? I have important data in my current mysql install. If there is no reason for you to run it, then keep off. Otherwise backup your DB and follow the instructions:-) -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Damn!! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 5.5.7-5.5.8 instructions seem scary
In response to Odhiambo Washington odhia...@gmail.com: On Wed, Dec 29, 2010 at 1:57 PM, Nerius Landys nlan...@gmail.com wrote: I read this in /usr/ports/UPDATING today: = 20101227: AFFECTS: users of databases/mysql55-server AUTHOR: a...@freebsd.org MySQL 5.5 has been updated to 5.5.8 GA release. Since layout is changed you should remove mysql55-{client/server/scripts} ports before upgrading. The build system is changed too, so expect failures. = Now that seems pretty scary. Remove all mysql packages from my system?!?! Expect failures?!?!? I have important data in my current mysql install. If there is no reason for you to run it, then keep off. Otherwise backup your DB and follow the instructions:-) Better yet, make a jail, install the version of MySQL you're currently using and copy your data over, then practice upgrading in the jail. Once you have the procedure figured out, you can execute it on the production system with a high level of confidence. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: MySQL 5.5.7-5.5.8 instructions seem scary
Oops, forgot the reply-all. :X Sorry Bill. :) I ran the update two nights ago, and it went rather smoothly for me (updating from the 5.5.7 RC to 5.5.8 GA), but your mileage may vary. Additionally, you can find some general rules for updating your MySQL install here: http://dev.mysql.com/doc/refman/5.5/en/upgrading.html As the others recommended, backups are critical! On Wed, Dec 29, 2010 at 8:10 AM, Bill Moran wmo...@potentialtech.comwrote: In response to Odhiambo Washington odhia...@gmail.com: On Wed, Dec 29, 2010 at 1:57 PM, Nerius Landys nlan...@gmail.com wrote: I read this in /usr/ports/UPDATING today: = 20101227: AFFECTS: users of databases/mysql55-server AUTHOR: a...@freebsd.org MySQL 5.5 has been updated to 5.5.8 GA release. Since layout is changed you should remove mysql55-{client/server/scripts} ports before upgrading. The build system is changed too, so expect failures. = Now that seems pretty scary. Remove all mysql packages from my system?!?! Expect failures?!?!? I have important data in my current mysql install. If there is no reason for you to run it, then keep off. Otherwise backup your DB and follow the instructions:-) Better yet, make a jail, install the version of MySQL you're currently using and copy your data over, then practice upgrading in the jail. Once you have the procedure figured out, you can execute it on the production system with a high level of confidence. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Need info about FreeBSD and interrupted system calls for MySQL code
Dan, thanks for your reply: Dan Nelson wrote: In the last episode (Apr 29), Joerg Bruehe said: For some long, unknown time, the MySQL code contains a variable net_retry_count which is by default set to 10 (ten) for all platforms, but to 100 (1 million) for FreeBSD (during configure phase). The source code comment about this variable reads If a read on a communication port is interrupted, retry this many times before giving up. [[...]] I'm pretty sure this is a holdover from when FreeBSD only had a user pthreads package (libc_r). libc calls that would normally block got converted into non-blocking versions and a select() loop would execute threads as the events they were waiting on occurred. Incoming signals would cause all threads waiting on read() to return EINTR. If you have other threads doing work and sending/receiving signals, this can add up to a lot of extra EINTR's. Interesting information - thanks. I never heard that before, but it explains a lot. FreeBSD 5.0 (released in 2003) was the first version to have kernel-based pthread support, so the original reason for raising net_retry_count has long since disappeared. It is quite possible that nobody checked this: If it ain't broken ... A related question might be, though: Should that variable even exist? EINTR isn't technically a failure, and most programs that read from sockets simply wrap their read()s in a loop that retries when EINTR is received. Only mysql actually counts the number of times through the loop. I know and agree that EINTR is no failure if a system call takes long, like read() or write() from/to a socket (or other slow device) on sufficiently large data. But my current action is not to change the code, rather it is a cleanup in the build system (you may have heard we are changing from the autotools to cmake), so currently I won't change that loop dealing with possible system call interruptions (by not counting). So you are saying it might all be obsolete, and current versions of FreeBSD don't need this special setting. This sounds like I should do a build without it and then run tests. Thanks! Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz Amtsgericht Muenchen: HRB161028 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Need info about FreeBSD and interrupted system calls for MySQL code
In the last episode (Apr 30), Joerg Bruehe said: Dan Nelson wrote: In the last episode (Apr 29), Joerg Bruehe said: For some long, unknown time, the MySQL code contains a variable net_retry_count which is by default set to 10 (ten) for all platforms, but to 100 (1 million) for FreeBSD (during configure phase). The source code comment about this variable reads If a read on a communication port is interrupted, retry this many times before giving up. [[...]] I'm pretty sure this is a holdover from when FreeBSD only had a user pthreads package (libc_r). libc calls that would normally block got converted into non-blocking versions and a select() loop would execute threads as the events they were waiting on occurred. Incoming signals would cause all threads waiting on read() to return EINTR. If you have other threads doing work and sending/receiving signals, this can add up to a lot of extra EINTR's. Interesting information - thanks. I never heard that before, but it explains a lot. This may also have been due to a bug in the early libc_r code. Appropriate use of sigwait() and pthread_sigmask() should let the pthreads library know which read() calls it can silently retry on behalf of threads that are ignoring signals (and thus shouldn't have their syscalls aborted with EINTR). I have email records talking about libc_r problems with signal masking from the FreeBSD 2.2.7 days (~1998). It's possible that later libc_r versions had fixed the bug. I used to have copies of the ancient mysql source code around (3.22 and 3.23 era), but have since deleted them, so I don't know when the 100 workaround was added. -- Dan Nelson dnel...@allantgroup.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Need info about FreeBSD and interrupted system calls for MySQL code
Dan, your info is very valuable - thanks: Dan Nelson wrote: In the last episode (Apr 30), Joerg Bruehe said: Dan Nelson wrote: In the last episode (Apr 29), Joerg Bruehe said: For some long, unknown time, the MySQL code contains a variable net_retry_count which is by default set to 10 (ten) for all platforms, but to 100 (1 million) for FreeBSD (during configure phase). The source code comment about this variable reads If a read on a communication port is interrupted, retry this many times before giving up. [[...]] I'm pretty sure this is a holdover from when FreeBSD only had a user pthreads package (libc_r). [[...]] Interesting information - thanks. I never heard that before, but it explains a lot. This may also have been due to a bug in the early libc_r code. Appropriate use of sigwait() and pthread_sigmask() should let the pthreads library know which read() calls it can silently retry on behalf of threads that are ignoring signals (and thus shouldn't have their syscalls aborted with EINTR). I have email records talking about libc_r problems with signal masking from the FreeBSD 2.2.7 days (~1998). It's possible that later libc_r versions had fixed the bug. I used to have copies of the ancient mysql source code around (3.22 and 3.23 era), but have since deleted them, so I don't know when the 100 workaround was added. The readily available revision control history of the MySQL source code goes back to the year 2000 only (the system used was changed back then, without history transfer), but a colleague checked that this workaround is documented in the manual of 3.22. All this seems to be a good indication we should get rid of this. Thanks for your help, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com (+49 30) 417 01 487 Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz Amtsgericht Muenchen: HRB161028 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Need info about FreeBSD and interrupted system calls for MySQL code
Hi Groggy (whom I didn't contact for too long a time), everybody, following the advice on your page, I include the FreeBSD list, even though I'm not subscribed there (hoping it will allow me to post) - so please, whoever replies, could you please cc: me directly? Of course, I tried Google, but I didn't find any answers to my question. For some long, unknown time, the MySQL code contains a variable net_retry_count which is by default set to 10 (ten) for all platforms, but to 100 (1 million) for FreeBSD (during configure phase). The source code comment about this variable reads If a read on a communication port is interrupted, retry this many times before giving up. The documentation (manual) has this sentence in addition: This value should be set quite high on FreeBSD because internal interrupts are sent to all threads. I read that as On FreeBSD, a thread may receive many more interrupts than on other platforms, so an operation which may take some time (like network I/O) may be interrupted much more often than on other platforms, and hence the retry count should be higher. I trust that this comment was valid at the time it was written - is it still true for current versions of FreeBSD, or did things change? Thanks for all your hints, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com (+49 30) 417 01 487 Sun Microsystems GmbH, Komturstrasse 18a, D-12099 Berlin Geschaeftsfuehrer: Juergen Kunz Amtsgericht Muenchen: HRB161028 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Need info about FreeBSD and interrupted system calls for MySQL code
In the last episode (Apr 29), Joerg Bruehe said: For some long, unknown time, the MySQL code contains a variable net_retry_count which is by default set to 10 (ten) for all platforms, but to 100 (1 million) for FreeBSD (during configure phase). The source code comment about this variable reads If a read on a communication port is interrupted, retry this many times before giving up. The documentation (manual) has this sentence in addition: This value should be set quite high on FreeBSD because internal interrupts are sent to all threads. I read that as On FreeBSD, a thread may receive many more interrupts than on other platforms, so an operation which may take some time (like network I/O) may be interrupted much more often than on other platforms, and hence the retry count should be higher. I trust that this comment was valid at the time it was written - is it still true for current versions of FreeBSD, or did things change? I'm pretty sure this is a holdover from when FreeBSD only had a user pthreads package (libc_r). libc calls that would normally block got converted into non-blocking versions and a select() loop would execute threads as the events they were waiting on occurred. Incoming signals would cause all threads waiting on read() to return EINTR. If you have other threads doing work and sending/receiving signals, this can add up to a lot of extra EINTR's. FreeBSD 5.0 (released in 2003) was the first version to have kernel-based pthread support, so the original reason for raising net_retry_count has long since disappeared. A related question might be, though: Should that variable even exist? EINTR isn't technically a failure, and most programs that read from sockets simply wrap their read()s in a loop that retries when EINTR is received. Only mysql actually counts the number of times through the loop. -- Dan Nelson dnel...@allantgroup.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org