Can't get mysql to start - permission error

2010-04-10 Thread Gene
Hi all: I'm running FBSD 8.0, amd64. After installing the mysql port: Mysql55-server and mysql55-client I've attempted to start using mysql_safe --user=mysql. It craps out and in the error log I find: 100410 7:25:36 InnoDB: Operating system error number 13 in a file operation. InnoDB

Re: Can't get mysql to start - permission error

2010-04-10 Thread Malcolm Kay
On Sun, 11 Apr 2010 08:58 am, Gene wrote: Hi all: I'm running FBSD 8.0, amd64. After installing the mysql port: Mysql55-server and mysql55-client I've attempted to start using mysql_safe --user=mysql. It is probably better to add: mysql_enable=YES to /etc/rc.conf and then run # /usr/local

Re: pure-ftpd with mysql authentication

2010-03-29 Thread Jerry
On Mon, 29 Mar 2010 11:28:49 +0700, m.anis m.a...@arc.itb.ac.id articulated: Hi all, I have problem with my pure-ftpd with mysql auth I don't know where the error I look on the database with phpmyadmin, and everything goes well here my config: pureftpd-mysql.conf /MYSQLSocket /tmp

Re: pure-ftpd with mysql authentication

2010-03-29 Thread m.anis
On 29/03/2010 16:55, Jerry wrote: On Mon, 29 Mar 2010 11:28:49 +0700, m.anism.a...@arc.itb.ac.id articulated: Hi all, I have problem with my pure-ftpd with mysql auth I don't know where the error I look on the database with phpmyadmin, and everything goes well here my config: pureftpd

pure-ftpd with mysql authentication

2010-03-28 Thread m.anis
Hi all, I have problem with my pure-ftpd with mysql auth I don't know where the error I look on the database with phpmyadmin, and everything goes well here my config: pureftpd-mysql.conf /MYSQLSocket /tmp/mysql.sock MYSQLServer localhost MYSQLPort 3306 MYSQLUser mysqluser

mysql can't running

2010-03-23 Thread m.anis
Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status it says mysql is not running when i tried /usr/local/bin/mysqld_safe startting mysqld daemon with database from /var/db/mysql STOPPING server from pid file /var/db/mysql/myhost.pid

Re: mysql can't running

2010-03-23 Thread Jorge Biquez
Hello. WHat version of Freebsd are you using? I hacve the same issue in a recnet installed and updated Freebsd 7.3 At 09:15 a.m. 23/03/2010, you wrote: Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status it says mysql

Re: mysql can't running

2010-03-23 Thread Cristiano Deana
On Tue, Mar 23, 2010 at 4:15 PM, m.anis m.a...@arc.itb.ac.id wrote: Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status it says mysql is not running if you installed it from ports you must have and use /usr/local/etc/rc.d/mysql

Re: mysql can't running

2010-03-23 Thread Odhiambo Washington
I thought mysql is controlled from /usr/local/etc/rc.d/mysql-server. At least that is what I have. I am running FreeBSD 8.0, 7.x and some 6.x and 5.5 and all are the same. It runs! You need some lines in /etc/rc.conf to make the syatem start mysql server! On Tue, Mar 23, 2010 at 6:24 PM, Jorge

Re: mysql can't running

2010-03-23 Thread Alejandro Imass
On Tue, Mar 23, 2010 at 10:45 AM, m.anis m.a...@arc.itb.ac.id wrote: Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status it says mysql is not running when i tried /usr/local/bin/mysqld_safe startting mysqld daemon with database

Re: mysql can't running

2010-03-23 Thread m.anis
On 23/03/2010 22:32, Alejandro Imass wrote: On Tue, Mar 23, 2010 at 10:45 AM, m.anism.a...@arc.itb.ac.id wrote: Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status it says mysql is not running when i tried /usr/local/bin

Re: mysql can't running

2010-03-23 Thread m.anis
On 23/03/2010 22:32, Alejandro Imass wrote: On Tue, Mar 23, 2010 at 10:45 AM, m.anism.a...@arc.itb.ac.id wrote: Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status it says mysql is not running when i tried /usr/local/bin

Re: mysql can't running

2010-03-23 Thread Alejandro Imass
on your my.cnf configuration (listen param). Anway, check that you have in fact /var/db/mysql and check the error file inthere and tell me if you see something of interest there. -- -- Terima Kasih Muhammad Anis Teknik Informatika Institut Teknologi Bandung

Re: mysql can't running

2010-03-23 Thread Sergio Tam
hei i just restart my system and it goes well but i still don't know why thanks for all your answer -- -- Hi You dont need restart your system just type rehash. Check on the handbook; Note: Some shells keep a cache of the commands that are available in the directories listed in the

Re: mysql can't running

2010-03-23 Thread Michael Powell
m.anis wrote: Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status it says mysql is not running phpMyAdmin will not work until you have configured config.inc.php correctly. when i tried /usr/local/bin/mysqld_safe startting

Re: mysql can't running

2010-03-23 Thread Michael Powell
Michael Powell wrote: m.anis wrote: Please help, mysql can't running i had installed it and using phpmyadmin when i check /etc/rc.d/mysql-server status ^ This indicates to me that you just unzipped a tarball and did ./configure make make

mysql,postgresql,client,server

2010-03-08 Thread n dhert
MySQL and Postgresql appear in the freebsd with many different versions. Normally ports have only one version (the latest) and you upgrade with portupgrade. Sometimes a mysql-client or postgresql-client is installed as a dependency of another port, (e.g. a Davical install today installed

Re: mysql,postgresql,client,server

2010-03-08 Thread Matthew Seaman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/03/2010 12:23:04, n dhert wrote: MySQL and Postgresql appear in the freebsd with many different versions. Normally ports have only one version (the latest) and you upgrade with portupgrade. Sometimes a mysql-client or postgresql-client

Re: mysql,postgresql,client,server

2010-03-08 Thread Антон Клесс
# pkg_db -F - that will auto-fix versions collisions between dependencies - it may help you. 2010/3/8 n dhert ndhert...@gmail.com MySQL and Postgresql appear in the freebsd with many different versions. Normally ports have only one version (the latest) and you upgrade with portupgrade

Re: mysql,postgresql,client,server

2010-03-08 Thread Polytropon
On Mon, 8 Mar 2010 15:52:29 +0300, Антон Клесс antoniok@gmail.com wrote: # pkg_db -F - that will auto-fix versions collisions between dependencies - it may help you. I'm sure you need the command pkgdb -F (without underscore) here; for automated run, use pkgdb -aF. Note that pkgdb program

Re: mysql,postgresql,client,server

2010-03-08 Thread Антон Клесс
surely, pkgdb. not pkg_db. I have misspelled. 2010/3/8 Polytropon free...@edvax.de On Mon, 8 Mar 2010 15:52:29 +0300, Антон Клесс antoniok@gmail.com wrote: # pkg_db -F - that will auto-fix versions collisions between dependencies - it may help you. I'm sure you need the command

sorry, email program ate my subject: Can't compile MySQL 5.0 server on 7.2

2010-03-01 Thread Len Conrad
make blah blah mv -f .deps/ha_example.Tpo .deps/ha_example.Po c++ -DEMBEDDED_LIBRARY -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DMYSQL_DATADIR=\/var/db/mysql\ -DSHAREDIR=\/usr/local/share/mysql\ -I. -I../include -I../bdb/build_unix -I../innobase/include -I../innobase/include -I

Re: sorry, email program ate my subject: Can't compile MySQL 5.0 server on 7.2

2010-03-01 Thread Greg Larkin
fetch update cd /usr/ports/databases/mysql50-server make configure make blah blah mv -f .deps/ha_example.Tpo .deps/ha_example.Po c++ -DEMBEDDED_LIBRARY -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DMYSQL_DATADIR=\/var/db/mysql\ -DSHAREDIR=\/usr/local/share/mysql\ -I. -I

Re: sorry, email program ate my subject: Can't compile MySQL 5.0server on 7.2

2010-03-01 Thread Len Conrad
/ha_example.Po c++ -DEMBEDDED_LIBRARY -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DMYSQL_DATADIR=\/var/db/mysql\ -DSHAREDIR=\/usr/local/share/mysql\ -I. -I../include -I../bdb/build_unix -I../innobase/include -I../innobase/include -I../include -I../include -I../sql -I../sql -I../sql

Re: mysql silently failing to start - suggestions? (FIXED!)

2010-02-04 Thread Ruben de Groot
On Mon, Feb 01, 2010 at 09:13:40PM -0600, John typed: Good job, Mike! You nailed it, though what some of the other helpful folks wrote had me on the right path, too. For some reason, the binary-configure after the pkg_add left everything owned by root:wheel. cd /mysql ; chown -R

Re: mysql silently failing to start - suggestions?

2010-02-01 Thread Greg Larkin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John wrote: If this isn't the right list - if I should try another let me know - but since this is the mysql-server-5.4.2 package, and since you folks have been so helpful, I thought I'd give it a go. Anyway, the system is 8.0-RELEASE

Re: mysql silently failing to start - suggestions?

2010-02-01 Thread Manolis Kiagias
On 01/02/2010 5:34 π.μ., John wrote: If this isn't the right list - if I should try another let me know - but since this is the mysql-server-5.4.2 package, and since you folks have been so helpful, I thought I'd give it a go. Anyway, the system is 8.0-RELEASE and that package is installed

Re: mysql silently failing to start - suggestions? (FIXED!)

2010-02-01 Thread John
On Sun, Jan 31, 2010 at 11:35:22PM -0500, Michael Powell wrote: John wrote: If this isn't the right list - if I should try another let me know - but since this is the mysql-server-5.4.2 package, and since you folks have been so helpful, I thought I'd give it a go. Anyway, the system

mysql silently failing to start - suggestions?

2010-01-31 Thread John
If this isn't the right list - if I should try another let me know - but since this is the mysql-server-5.4.2 package, and since you folks have been so helpful, I thought I'd give it a go. Anyway, the system is 8.0-RELEASE and that package is installed, and I can't start the server. Not only can

Re: mysql silently failing to start - suggestions?

2010-01-31 Thread Adam Vande More
On Sun, Jan 31, 2010 at 9:34 PM, John j...@starfire.mn.org wrote: If this isn't the right list - if I should try another let me know - but since this is the mysql-server-5.4.2 package, and since you folks have been so helpful, I thought I'd give it a go. Anyway, the system is 8.0-RELEASE

Re: mysql silently failing to start - suggestions?

2010-01-31 Thread Dan Nelson
In the last episode (Jan 31), John said: If this isn't the right list - if I should try another let me know - but since this is the mysql-server-5.4.2 package, and since you folks have been so helpful, I thought I'd give it a go. Anyway, the system is 8.0-RELEASE and that package

Re: mysql silently failing to start - suggestions?

2010-01-31 Thread Michael Powell
John wrote: If this isn't the right list - if I should try another let me know - but since this is the mysql-server-5.4.2 package, and since you folks have been so helpful, I thought I'd give it a go. Anyway, the system is 8.0-RELEASE and that package is installed, and I can't start

Re: Problem w/ mysql extension installation

2010-01-16 Thread Matthew Seaman
jaymax wrote: phpmyadmin requires the mysql extension which is apparently not included in the mysql54 ports Well, PHP modules aren't provided at all by the mysqlNN-{client,server,scripts} ports. You want databases/php5-mysql or databases/php5-mysqli I have certainly been able to install

Problem w/ mysql extension installation

2010-01-15 Thread jaymax
phpmyadmin requires the mysql extension which is apparently not included in the mysql54 ports Installing it from /usr/ports/databases/php5-mysql == --- --- --- In file included from /usr/local/include/php/main/../main/php_config.h:2839, from /usr/local/include/php/Zend

Re: Problem w/ mysql extension installation

2010-01-15 Thread jaymax
A couple of hours later I return to this problem at the file is there and the extension installed RATHER BIZARE jaymax wrote: phpmyadmin requires the mysql extension which is apparently not included in the mysql54 ports Installing it from /usr/ports/databases/php5-mysql

Re: mySQL 5.4 server Post installation SNAFUs

2010-01-09 Thread Matthew Seaman
jaymax wrote: Post installation SNAFUS [i] support-files/mysql.server are apparently in /usr/local/share/mysql am I correct, all of them? Yes, except that mysql-server is the rc.subr(8) script to start up mysql on boot, and that is to be found in /usr/local/etc/rc.d

Re: mySQL 5.4 server Post installation SNAFUs

2010-01-09 Thread jaymax
to give it. Conversely, if you've got a password set in /root/.my.cnf or some other my.cnf file but this is a brand new mysql install with no root password yet, then you need to temporarily move that file aside: mysql doesn't let you in if you try and supply a password for a no-password account. I

Setting root password on mysql 5.4

2010-01-09 Thread jaymax
Does anyone know how to set root password on a new mysql installation from the post? Can it be performed after starting the server with /usr/local/bin/mysqld_safe Or for that matter with /usr/local/bin/mysql_secure_installation Thanks! -- View this message in context: http://old.nabble.com

Re: Setting root password on mysql 5.4

2010-01-09 Thread Sergio Tam
2010/1/9 jaymax jayma...@gmail.com: Does anyone know how to set root password on a new mysql installation from the post? Can it be performed after starting the server with /usr/local/bin/mysqld_safe Or for that matter with /usr/local/bin/mysql_secure_installation Hi http

Re: Setting root password on mysql 5.4

2010-01-09 Thread Michael Powell
jaymax wrote: Does anyone know how to set root password on a new mysql installation from the post? This is the very first thing performed on a brand new fresh install. The canonical procedure (and I haven't had to do it in a while so it is possible it may have changed) looks something like

mySQL 5.4 server Post installation SNAFUs

2010-01-08 Thread jaymax
Installed mysql-server54 from the ports 7.2-RELEASE FreeBSD 7.2-RELEASE #0: O/S running Apache/2.2.11 (FreeBSD) installed PHP 5.2.12 configure options used == make pager=more prompt=mysql54 socket=/usr/tmp/mysql.sock localstatedir=/disk02/db/mysql/DATA with_linuxthreads=yes with_ssl=yes install

mysql not starting on boot

2010-01-06 Thread Rob
Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting on boot anymore. It starts fine once the system has booted, and looking at the mysql log I see: 100105 17:46:56 mysqld_safe Starting mysqld daemon with databases from /var/db/m ysql 100105 17:46:56 [ERROR] Can't start

Re: mysql not starting on boot

2010-01-06 Thread Matthew Seaman
Rob wrote: Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting on boot anymore. It starts fine once the system has booted, and looking at the mysql log I see: 100105 17:46:56 mysqld_safe Starting mysqld daemon with databases from /var/db/m ysql 100105 17:46:56 [ERROR

Re: mysql not starting on boot

2010-01-06 Thread P.
Qua, 2010-01-06 às 16:16 +, Matthew Seaman escreveu: Rob wrote: Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting on boot anymore. It starts fine once the system has booted, and looking at the mysql log I see: 100105 17:46:56 mysqld_safe Starting mysqld

Re: mysql not starting on boot

2010-01-06 Thread Samuel Martín Moro
About apache, maybe it's the ServerName option that's missing. On Wednesday, January 6, 2010, Dário P. fbsd.questions.l...@gmail.com wrote: Qua, 2010-01-06 às 16:16 +, Matthew Seaman escreveu: Rob wrote: Since I upgraded to FreBSD 8.0, I'm noticing that mysql isn't starting on boot

Re: mysql not starting on boot

2010-01-06 Thread P.
Qua, 2010-01-06 às 18:03 +0100, Samuel Martín Moro escreveu: About apache, maybe it's the ServerName option that's missing. I don't think so, because I have it on httpd.conf. # # ServerName gives the name and port that the server uses to identify itself. # This can often be determined

Re: mysql not starting on boot

2010-01-06 Thread Matt
On Wed, Jan 6, 2010 at 11:20 AM, Dário P. fbsd.questions.l...@gmail.com wrote: Qua, 2010-01-06 às 18:03 +0100, Samuel Martín Moro escreveu: About apache, maybe it's the ServerName option that's missing. I don't think so, because I have it on httpd.conf. # # ServerName gives the name and

Re: mysql not starting on boot

2010-01-06 Thread Rob
To the mysql init script, I added: # REQUIRE: dhclient And to the dhclient init script I added: # REQUIRE: NETWORKING In addition to changing DHCP to SYNCDHCP in rc.conf, mysql now starts up on boot. I would think the dhclient change should be required in the default setup since NETWORKING

FreeBSD 8.0 and MySQL 5.1.x

2010-01-01 Thread Abdullah Ibn Hamad Al-Marri
Hey there, I was curious if it's the right time to move to MySQL 5.1.x instead MySQL 5.0.x. with FreeBSD 8.x Any bench marks with FreeBSD 8.x? Or shall we stick to MySQL 5.0.x for now? Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net

Re: FreeBSD 8.0 and MySQL 5.1.x

2010-01-01 Thread Matthew Seaman
Abdullah Ibn Hamad Al-Marri wrote: Hey there, I was curious if it's the right time to move to MySQL 5.1.x instead MySQL 5.0.x. with FreeBSD 8.x Any bench marks with FreeBSD 8.x? Or shall we stick to MySQL 5.0.x for now? We can't really answer that for you. If performance is your

Re: APACHE/PHP/MYSQL Password Hash

2009-10-30 Thread Matthew Seaman
Monty Pyth wrote: I have inherited a website to work on that users authenticate to using a login and password from a login page. The server is FreeBSD 6.2 running APACHE/PHP/MYSQL. There is a MYSQL table that maintains all of the users. The table has a users name and password. The password

APACHE/PHP/MYSQL Password Hash

2009-10-29 Thread Monty Pyth
I have inherited a website to work on that users authenticate to using a login and password from a login page. The server is FreeBSD 6.2 running APACHE/PHP/MYSQL. There is a MYSQL table that maintains all of the users. The table has a users name and password. The password is hashed and some

Re: APACHE/PHP/MYSQL Password Hash

2009-10-29 Thread Olivier Nicole
Hi, The password is hashed and some examples are: 02SvtVJnRLzuQ 42jhVP6kxUBX6 Can anyone tell me what file I would look at to see what hash algorithm is being used to store the passwords in the table? Any help would be great. As a hint, to help make it easier to reply, where are the

Re: APACHE/PHP/MYSQL Password Hash

2009-10-29 Thread APseudoUtopia
On Thu, Oct 29, 2009 at 8:52 PM, Monty Pyth freebsdn...@yahoo.com wrote: I have inherited a website to work on that users authenticate to using a login and password from a login page. The server is FreeBSD 6.2 running APACHE/PHP/MYSQL. There is a MYSQL table that maintains all of the users

Using bash with MySQL

2009-10-27 Thread carmel_ny
I am in the process of writting a script that will use MySQL as a back end. For the most part, I have gotten things to work correctly. I am having one problem though. Assume a data base: database: MyDataBase table: MyTable field: defaults Now, I have populated the 'defaults' fields

Re: Using bash with MySQL

2009-10-27 Thread Matthew Seaman
carmel_ny wrote: I am in the process of writting a script that will use MySQL as a back end. For the most part, I have gotten things to work correctly. I am having one problem though. Assume a data base: database: MyDataBase table: MyTable field: defaults Now, I have populated the 'defaults

Re: Using bash with MySQL

2009-10-27 Thread carmel_ny
On Tue, 27 Oct 2009 16:17:55 + Matthew Seaman m.sea...@infracaninophile.co.uk replied: carmel_ny wrote: I am in the process of writting a script that will use MySQL as a back end. For the most part, I have gotten things to work correctly. I am having one problem though. Assume a data

incorrect info in mysql docs

2009-10-25 Thread Chris Whitehouse
pattern. Any other files or directories present within the directory are silently ignored. In other words, on FreeBSD, you should install the mysql.server script as /usr/local/etc/rc.d/mysql.server.sh to enable automatic startup. That's not actually right is it? My mysql is started by /usr/local

Re: incorrect info in mysql docs

2009-10-25 Thread Roman Neuhauser
mysql is started by /usr/local/etc/rc.d/mysql-server. rc(8) says *.sh is for older style startup scripts or for scripts that are to be read into the current shell. yup, third-party documentation tends to be stale. ___ freebsd-questions@freebsd.org

Re: incorrect info in mysql docs

2009-10-25 Thread Michael Powell
of the rc.subr subsystem from NetBSD. Sounds like the docs may be a trifle stale. That's not actually right is it? My mysql is started by /usr/local/etc/rc.d/mysql-server. rc(8) says *.sh is for older style startup scripts or for scripts that are to be read into the current shell. The rc.subr start up

Re: incorrect info in mysql docs

2009-10-25 Thread Jerry
. That's not actually right is it? My mysql is started by /usr/local/etc/rc.d/mysql-server. rc(8) says *.sh is for older style startup scripts or for scripts that are to be read into the current shell. A start-up script is install automatically when using the ports system. You do need to activate

Re: incorrect info in mysql docs

2009-10-25 Thread Polytropon
On Sun, 25 Oct 2009 15:11:17 -0400, Jerry ges...@yahoo.com wrote: A start-up script is install automatically when using the ports system. You do need to activate it via /etc/rc.conf however. Or in /etc/rc.conf.local, to illustrate the concept of the /usr/local/ subtrees in relation to the

Re: MySQL + SSL

2009-10-08 Thread Matthew Seaman
Olivier Nicole wrote: Hi, I have been strugling to find the correct syntax for the mysql(1) command to connect with SSL. My server is accepting SSL connections: db2root: mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection

MySQL + SSL

2009-10-07 Thread Olivier Nicole
Hi, I have been strugling to find the correct syntax for the mysql(1) command to connect with SSL. My server is accepting SSL connections: db2root: mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version

measuring mysql usage

2009-08-31 Thread John Almberg
Anyone know of a tool that can measure mysql usage per mysql user? My database is getting hammered by something, but I'm having a hard time figuring out what. It seems to come and go. Perhaps I have one or two websites that are just getting a lot of traffic, and maybe they just need

Re: measuring mysql usage

2009-08-31 Thread APseudoUtopia
On Mon, Aug 31, 2009 at 12:20 PM, John Almbergjalmb...@identry.com wrote: Anyone know of a tool that can measure mysql usage per mysql user? My database is getting hammered by something, but I'm having a hard time figuring out what. It seems to come and go. Perhaps I have one or two websites

Re: measuring mysql usage

2009-08-31 Thread Peter Boosten
John Almberg wrote: Anyone know of a tool that can measure mysql usage per mysql user? My database is getting hammered by something, but I'm having a hard time figuring out what. It seems to come and go. Perhaps I have one or two websites that are just getting a lot of traffic, and maybe

Re: measuring mysql usage

2009-08-31 Thread John Almberg
Check out mTop. http://mtop.sourceforge.net/ Okay, got this running from ports. Cool tool, but after reading the man page and fooling around with it for a bit, I don't see how you can monitor usage by user with it. Am I missing something? -- John ___

mysql error

2009-06-28 Thread thanos trompoukis
Hi all, I am new with FreeBSD and I have a problem with mysql. I have 6.2Release i386 I am running mysql 5.0.27 and It worked perfectly until the time that I formated /tmp (for some other reason) and now when I am trying to connect on mysql *I get this:* *[r...@leonidas:/]$ mysql ERROR 2002

Re: mysql error

2009-06-28 Thread Morgan Wesström
thanos trompoukis wrote: Hi all, I am new with FreeBSD and I have a problem with mysql. I have 6.2Release i386 I am running mysql 5.0.27 and It worked perfectly until the time that I formated /tmp (for some other reason) and now when I am trying to connect on mysql *I get this:* *[r

Re: mysql error

2009-06-28 Thread Manolis Kiagias
thanos trompoukis wrote: Hi all, I am new with FreeBSD and I have a problem with mysql. I have 6.2Release i386 I am running mysql 5.0.27 and It worked perfectly until the time that I formated /tmp (for some other reason) and now when I am trying to connect on mysql *I get this:* *[r

Re: mysql error

2009-06-28 Thread Matthew Seaman
thanos trompoukis wrote: Hi all, I am new with FreeBSD and I have a problem with mysql. I have 6.2Release i386 I am running mysql 5.0.27 and It worked perfectly until the time that I formated /tmp (for some other reason) and now when I am trying to connect on mysql *I get this:* *[r

Re: mysql error

2009-06-28 Thread thanos trompoukis
2009/6/28 Matthew Seaman m.sea...@infracaninophile.co.uk thanos trompoukis wrote: Hi all, I am new with FreeBSD and I have a problem with mysql. I have 6.2Release i386 I am running mysql 5.0.27 and It worked perfectly until the time that I formated /tmp (for some other reason) and now

Re: Advices for a jailed MySQL server

2009-05-11 Thread Martin Turgeon
Bill Moran a écrit : In response to Martin Turgeon free...@optiksecurite.com: Hi everyone, I'm starting to build a new dedicated MySQL server. I will be using FreeBSD 7.2-REL. My plan is to jail the latest version of MySQL 5.0 and to put the MySQL data outside the jail. My objective

Re: Advices for a jailed MySQL server

2009-05-11 Thread Bill Moran
In response to Martin Turgeon free...@optiksecurite.com: Bill Moran a écrit : In response to Martin Turgeon free...@optiksecurite.com: Hi everyone, I'm starting to build a new dedicated MySQL server. I will be using FreeBSD 7.2-REL. My plan is to jail the latest version of MySQL

Re: Advices for a jailed MySQL server

2009-05-11 Thread Doug Poland
On Mon, May 11, 2009 14:19, Martin Turgeon wrote: Bill Moran a écrit : In response to Martin Turgeon free...@optiksecurite.com: Hi everyone, I'm starting to build a new dedicated MySQL server. I will be using FreeBSD 7.2-REL. My plan is to jail the latest version of MySQL 5.0 and to put

Re: Advices for a jailed MySQL server

2009-05-11 Thread Doug Poland
On Mon, May 11, 2009 14:19, Martin Turgeon wrote: Bill Moran a écrit : In response to Martin Turgeon free...@optiksecurite.com: Hi everyone, I'm starting to build a new dedicated MySQL server. I will be using FreeBSD 7.2-REL. My plan is to jail the latest version of MySQL 5.0 and to put

Advices for a jailed MySQL server

2009-05-06 Thread Martin Turgeon
Hi everyone, I'm starting to build a new dedicated MySQL server. I will be using FreeBSD 7.2-REL. My plan is to jail the latest version of MySQL 5.0 and to put the MySQL data outside the jail. My objective is to be able to update MySQL without down time. My objective would be to create

Re: Advices for a jailed MySQL server

2009-05-06 Thread Bill Moran
In response to Martin Turgeon free...@optiksecurite.com: Hi everyone, I'm starting to build a new dedicated MySQL server. I will be using FreeBSD 7.2-REL. My plan is to jail the latest version of MySQL 5.0 and to put the MySQL data outside the jail. My objective is to be able to update

Re: mysql hiding from top

2009-05-03 Thread Wayne Sierke
On Mon, 2009-04-27 at 18:49 +0200, Zbigniew Szalbot wrote: hello, Today I have finally upgraded my system to 7.1-RELEASE and just noticing that mysql process is not being shown via the top command. PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND 1612 root

mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
hello, Today I have finally upgraded my system to 7.1-RELEASE and just noticing that mysql process is not being shown via the top command. PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND 1612 root1 200 9212K 6716K pause 2 0:26 0.00% perl5.8.9 966

Re: mysql hiding from top

2009-04-27 Thread Chuck Swiger
Hi-- On Apr 27, 2009, at 9:49 AM, Zbigniew Szalbot wrote: However, if you grep processes, you can see it should be displayed in the top entries. $ ps ax |grep mysql 32880 p0- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe... 32906 p0- S 1:33.72 /usr/local/libexec/mysqld... I can

Re: mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
want to see) that includes enough that mysqld will show up. Thank you Paul! Yes, I know that. Prior to upgrade mysql was always on top as it used most time. And I can see it now when it is active but it is quite strange that it does not get displayed when the system is idle. Not even when I do

Re: mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
470 40260K 29336K select 2 0:03 2.49% httpd 89632 www 1 440 33648K 23352K CPU0 0 0:00 0.78% httpd 89290 www 1 200 25456K 17760K lockf 2 0:01 0.68% httpd 89074 www 1 440 26384K 17696K select 2 0:00 0.20% httpd 32906 mysql 37 40

Re: mysql hiding from top

2009-04-27 Thread Chuck Swiger
On Apr 27, 2009, at 10:22 AM, Zbigniew Szalbot wrote: PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND [ ... ] 32906 mysql 37 40 76636K 41664K sbwait 1 0:00 0.10% mysqld It does appear at times but it is showing 0:00 TIME. But compare

Re: mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
Ah-- I've heard rumors that top or something doesn't handle accounting for CPU time used by multithreaded processes very well... OK. Well I have never had any problem with that on FreeBSD 7.0-RELEASE. It started misbehaving today right after an upgrade to 7.1-RELEASE. Like I said, I can really

Re: mysql hiding from top

2009-04-27 Thread Chuck Swiger
On Apr 27, 2009, at 10:33 AM, Zbigniew Szalbot wrote: Ah-- I've heard rumors that top or something doesn't handle accounting for CPU time used by multithreaded processes very well... OK. Well I have never had any problem with that on FreeBSD 7.0- RELEASE. It started misbehaving today right

Re: mysql hiding from top

2009-04-27 Thread Paul Schmehl
--On Monday, April 27, 2009 11:49:55 -0500 Zbigniew Szalbot z.szal...@lcwords.com wrote: hello, Today I have finally upgraded my system to 7.1-RELEASE and just noticing that mysql process is not being shown via the top command. PID USERNAME THR PRI NICE SIZERES STATE C TIME

Re: mysql hiding from top

2009-04-27 Thread Zbigniew Szalbot
True, although if it's readily reproducible, it would be good to fix. I'd be happy to test but I do not know what to do/where to start. I know it is a permanent issue, because I even restarted the mysql server thinking that something is wrong that it is not being shown in top but the history

MySQL without Innodb

2009-04-23 Thread Mark
Hello, I'm trying to compile MySQL 5.1.34, but I can't find options to not compile in innodb database support. Have these been removed? And, if so, why? Thanks, - Mark ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org

Re: MySQL without Innodb

2009-04-23 Thread Odhiambo ワシントン
On Thu, Apr 23, 2009 at 3:59 PM, Mark asar...@xs4all.nl wrote: Hello, I'm trying to compile MySQL 5.1.34, but I can't find options to not compile in innodb database support. Have these been removed? And, if so, why? Why does it bother you? It will be built but if your tables are MyISAM

MySQL without Innodb

2009-04-23 Thread Mark
Hello, I'm trying to compile MySQL 5.1.34, but I can't find options to not compile in innodb database support. Have these been removed? And, if so, why? Thanks, - Mark ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org

Re: MySQL without Innodb

2009-04-23 Thread Matt
On Thu, Apr 23, 2009 at 8:31 AM, Mark ad...@asarian-host.net wrote: Hello, I'm trying to compile MySQL 5.1.34, but I can't find options to not compile in innodb database support. Have these been removed? And, if so, why? Can't comment on if/why the options were removed, but adding skip

RE: MySQL without Innodb

2009-04-23 Thread Mark
On Thu, Apr 23, 2009 at 3:59 PM, Mark wrote: Hello, I'm trying to compile MySQL 5.1.34, but I can't find options to not compile in innodb database support. Have these been removed? And, if so, why? Why does it bother you? It will be built but if your tables are MyISAM type, the InnoDB

Re: MySQL without Innodb

2009-04-23 Thread Chuck Swiger
On Apr 23, 2009, at 7:08 AM, Mark wrote: I'm getting a weird compilation error (see below); hence, I figured I skip as much engines as possible during the compilation process. Done with gcc 2.95.4, btw. Really...why such an old compiler version? I think that even FreeBSD-5.0 shipped with

Re: Multiple instances of MySQL

2009-04-12 Thread Mel Flynn
On Thursday 09 April 2009 21:43:36 Brent Bloxam wrote: Mel Flynn wrote: Any reason a jail can't be used? This would allow sharing the binary using null or union fs, little overhead, yet seperated from host install and no maintenance of port installed files, like rc.d/mysql-server. Unionfs

Re: Multiple instances of MySQL

2009-04-09 Thread Brent Bloxam
Mel Flynn wrote: Any reason a jail can't be used? This would allow sharing the binary using null or union fs, little overhead, yet seperated from host install and no maintenance of port installed files, like rc.d/mysql-server. Unionfs, unix sockets and flush operations don't like each other

Re: Mysql make question

2009-04-08 Thread Mel Flynn
On Wednesday 08 April 2009 02:30:03 Lars Eighner wrote: On Tue, 7 Apr 2009, Dave Stegner wrote: I am venturing into Mysql. I am trying to install it from the port, 5.1.33. Simple question: Immediately after the start of make, you are presented with a list of options. Are those

Re: Multiple instances of MySQL

2009-04-08 Thread Mel Flynn
On Tuesday 07 April 2009 14:55:26 DAve wrote: However, I would suggest that you provide, as you suggest, a separate instance of mysql just for this client as well. If they screw up the instance they won't affect other customers. To run a separate instance, I would suggest using

mysql memory

2009-04-08 Thread Valentin Bud
Hello community, I have mysql installed on FreeBSD 7.0 i386. I am using mysqltuner.pl from ports to check for tuning parameters. Now my problem, sort of speak, is that mysqltuner.pl shows the following: [OK] Maximum possible memory usage: 1.6G (53% of installed RAM) So as far as i understand

<    1   2   3   4   5   6   7   8   9   10   >