Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. Two other possible options appeared to present

RE: Trouble starting MySQL

2005-01-12 Thread Walker, Michael
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven Sent: Wednesday, January 12, 2005 9:30 AM To: FreeBSD Questions Subject: Trouble starting MySQL Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing

Re: Trouble starting MySQL

2005-01-12 Thread Darksidex
Colin J. Raven wrote: Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. Two other possible options

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 09:35, Walker, Michael launched this into the bitstream: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven Sent: Wednesday, January 12, 2005 9:30 AM To: FreeBSD Questions Subject: Trouble starting MySQL Greetings all, I

Re: Trouble starting MySQL

2005-01-12 Thread Matteo Santori
you SHOULD set a password root but that's not the problem releated with this error. (mysqladmin -u root password 'yourpassword') it looks like your mysqld is not started trought.. mysqld_safe --user=mysql your should check this. hope this help, M Colin J. Raven wrote: Greetings all, I installed

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. snip Read

RE: Trouble starting MySQL

2005-01-12 Thread Walker, Michael
Colin J. Raven wrote: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 10:20, Walker, Michael then said: Colin J. Raven wrote: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error

RE: Trouble starting MySQL [SOLVED?]

2005-01-12 Thread Colin J. Raven
On Jan 12 at 11:17, Colin J. Raven launched this into the bitstream: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error

Re: Trouble starting MySQL

2005-01-12 Thread Eric F Crist
On Jan 12, 2005, at 4:23 AM, Colin J. Raven wrote: On Jan 12 at 10:20, Walker, Michael then said: Colin J. Raven wrote: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
line to /etc/rc.conf to enable mysql: # mysql_enable (bool): Set to NO by default. # Set it to YES to enable MySQL. Is that wrong? *Should* it be mysqld_enable-YES within the script? If so, that's a kind of major oversight on the mysql/freebsd teams' part

Re: Trouble starting MySQL

2005-01-12 Thread Eric F Crist
the script: # Add the following line to /etc/rc.conf to enable mysql: # mysql_enable (bool): Set to NO by default. # Set it to YES to enable MySQL. Is that wrong? *Should* it be mysqld_enable-YES within the script? If so, that's a kind of major oversight

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 05:36, Eric F Crist then said: On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: I would check the /var/log/messages log file for anything related to mysql, in this case. There's a reason it won't start, and it'll be indicated there. There is nothing related to mysql in /var

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 12:46, I said: PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 both installed from ports FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention that MySQL exists. AFAIK this ought not to be so. I installed php last night (again, from

Re: Trouble starting MySQL

2005-01-12 Thread Andy Firman
On Wed, Jan 12, 2005 at 09:35:21AM -, Walker, Michael wrote: Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running

RE: Trouble starting MySQL

2005-01-12 Thread Walker, Michael
[EMAIL PROTECTED] wrote: On Jan 12 at 12:46, I said: PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 both installed from ports FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention that MySQL exists. AFAIK this ought not to be so. I installed

Re: Trouble starting MySQL [SOLVED?]

2005-01-12 Thread Andy Firman
On Wed, Jan 12, 2005 at 11:33:21AM +0100, Colin J. Raven wrote: On Jan 12 at 11:17, Colin J. Raven launched this into the bitstream: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 14:12, Walker, Michael said (somewhat confusingly): [EMAIL PROTECTED] wrote: On Jan 12 at 12:46, I said: PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 both installed from ports FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention

Re: Trouble starting MySQL

2005-01-12 Thread Nico Meijer
Hi Colin, I missed part of the thread, so I'm sorry if I'm dead wrong here. Do you mean that one (or other, or both) must *also* be installed for php to have any clue that MySQL exists? You need php4-mysql for that. php4-extensions is a meta-port. Read the pkg-descr in /usr/ports/lang/php4

Re: Trouble starting MySQL

2005-01-12 Thread whitevamp
- Original Message - From: Colin J. Raven [EMAIL PROTECTED] To: Walker, Michael [EMAIL PROTECTED] Cc: Freebsd-Questions (E-mail) freebsd-questions@freebsd.org Sent: Wednesday, January 12, 2005 6:25 AM Subject: RE: Trouble starting MySQL On Jan 12 at 14:12, Walker, Michael said (somewhat

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 15:41, Nico Meijer launched this into the bitstream: Hi Colin, I missed part of the thread, so I'm sorry if I'm dead wrong here. Do you mean that one (or other, or both) must *also* be installed for php to have any clue that MySQL exists? You need php4-mysql for that. php4

Re: Trouble starting MySQL [SOLVED?]

2005-01-12 Thread Jerry McAllister
/usr/local/bin/mysqld_safe --user=mysql mysql1347 0.0 2.5 55852 25832 ?? S11:26AM 0:00.14 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ colin1359 0.0 0.1 1476 896 p2 S+ 11:26AM 0:00.00 grep mysql Good, but I'm just puzzled why/how

Re: Trouble starting MySQL

2005-01-12 Thread Nico Meijer
Hi Colin, Hey Nico, long time, no see! Happy New Year. Ah, indeed! It took a while, but now my brain said click!. Same to you, thanks. Hope you are well (apart from the php/mysql problem) I have *no* idea what to do next, none. As far as I can see, phpinfo.php shows no sign of MySQL. Thus

Re: Trouble starting MySQL

2005-01-12 Thread Jerry McAllister
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven Sent: Wednesday, January 12, 2005 9:30 AM To: FreeBSD Questions Subject: Trouble starting MySQL Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start

Re: Trouble starting MySQL [SOLVED] [CLOSED]

2005-01-12 Thread Colin J. Raven
Earlier today I said: Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. You may need to set

Re: Trouble starting MySQL

2005-01-12 Thread Eric F Crist
On Jan 12, 2005, at 5:46 AM, Colin J. Raven wrote: On Jan 12 at 05:36, Eric F Crist then said: On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: I would check the /var/log/messages log file for anything related to mysql, in this case. There's a reason it won't start, and it'll be indicated

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 10:28, Eric F Crist said: mysql-4.1.7 installed from ports FreeBSD 5.3-RELEASE If you haven't changed your syslog.conf file, you should have a /var/log/all.log. Take a look in there to see if you see anything related to mysql. This is interesting. No I didn't change

apache1.3 mysql and php

2005-01-12 Thread dick hoogendijk
I'd like to give phpBB (kind of a php driven userboard) a change. This means I'll have to change my apache 1.3.33 server into a PHP, MySQL Apache1.3.33 server. I will do the reading, but I appreciate some links on how to set up this combination from ports. I googled but got lost

MySQL

2005-01-05 Thread Joshua Lokken
From: Joshua Lokken [EMAIL PROTECTED] Date: Wed, 5 Jan 2005 18:16:40 -0600 Subject: Re: MySQL To: Leon [EMAIL PROTECTED] Cc: Questions freebsd-questions@freebsd.org On Wed, 05 Jan 2005 16:03:08 -0500, Leon [EMAIL PROTECTED] wrote: Hi, I have a 5.3 version of FreeBSD. I want to install MySQL

migrating from mysql 4.0 to 4.1 best practice?

2005-01-04 Thread Jev
Hi All, What is the best practice to upgrade from Mysql 4.0.X to 4.1.X, using the ports system naturally? I have searched, but not come up with any definitive solutions. Is the solution to backup, un-install, then install the other? Please cc, as I'm not subscribed to questions. Thanks, -Jev

Re: migrating from mysql 4.0 to 4.1 best practice?

2005-01-04 Thread Doug Poland
Hi All, What is the best practice to upgrade from Mysql 4.0.X to 4.1.X, using the ports system naturally? I have searched, but not come up with any definitive solutions. Is the solution to backup, un-install, then install the other? I've followed this documentation with success: http

Re: Problems with MySQL and SNORT after Reboot

2004-12-31 Thread Mattias Björk
mysql and snort but that does not help either. Thanks in advance and a happy new year! Hello, You need to login to mysql command prompt and do a REPAIR TABLE event; in that database, and it will clear it right up. Sincerely, Scott Kupferschmidt ISPrime, Inc. 866.502.4678 ext. 3 AIM: Scott ISPrime

Problems with MySQL and SNORT after Reboot

2004-12-30 Thread Mattias Björk
('1', '10', '4', '2004-12-28 19:50:52.597+001') Im not an expert on SQL and database servers etc and have followed this guide to make snort work with MySQL: http://bsdguides.org/guides/freebsd/security/snortreport.php I didn't find that too hard and it worked when I did it some months ago

Re: Problems with MySQL and SNORT after Reboot

2004-12-30 Thread Scott Kupferschmidt
Hello, You need to login to mysql command prompt and do a REPAIR TABLE event; in that database, and it will clear it right up. Sincerely, Scott Kupferschmidt ISPrime, Inc. 866.502.4678 ext. 3 AIM: Scott ISPrime - ICQ: 174337249 On Fri, 31 Dec 2004, [ISO-8859-1] Mattias Björk wrote: Dear list

mysql setup question

2004-12-22 Thread bob
I'm running 4.10 stable. I copied /usr/local/share/mysql/my-medium.cnf to /etc/my.cnf. I uncommented the lines about innodb and restarted mysqld by running /usr/local/etc/rc.d/mysql-server.sh I'm running a web server that accesses a mysql database. Is there a way that I can verify that mysql

bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth

2004-12-19 Thread tethys ocean
Hmmzz yep, I want to do this but my packet version conflicted.. FreeBSD 5.3 stable Mysql-server-5.0.1 Bind9-9.3.0 (for only dns cahe) Postfix-2.2.20041008,2 (also for GUI postfix-admin) Courier-Imap-3.0.8.1 Cyrus-sasl-2.1.20 Apache-2.0.52_3 Amavisd (clamav + spamassassin) Sqwebmail

bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth

2004-12-18 Thread tethys ocean
Hi all, I want to setup a mail server Freebsd 5.3 bind 9.0 (dnscahce) +mysql4.0+postfix2.2.20040829,2+courier+sasl etc in the beginning of my installation I am taking such error message courier-mysql-0.45.4 conflicts with installed pakages(s) postfix-2.2.20040829,2 They install files

bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth

2004-12-18 Thread martin hudec
Hello, On Sat, Dec 18, 2004 at 09:38:52PM +0200 or thereabouts, tethys ocean wrote: I want to setup a mail server Freebsd 5.3 bind 9.0 (dnscahce) +mysql4.0+postfix2.2.20040829,2+courier+sasl etc in the beginning of my installation I am taking such error message courier-mysql

bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth

2004-12-18 Thread tethys ocean
Hi, I check confiliction package mysql pakages confilict and I found this document http://www.syntheticzero.com/howto/vmail.php and also in this paragraph Notes for FreeBSD users: The courier-imap port in freebsd is kinda messed up with regards to getting the mysql auth stuff to compile

recover from var deletion; mysql apache

2004-12-18 Thread Sean Ellis
Hello, 4.10-PRERELEASE FreeBSD 4.10-PRERELEASE #0: Mon May 3 16:59:48 PDT 2004 I am working to recover a computer whose /var filesystem, a separate mount point, was entirely deleted. I've put in a new /var using mergemaster, and I'm now trying to restore the mysql databases from dumps

bind+postfix+courier+sals+amavis+spamassian+pop3+mysql+apache+smtp-auth

2004-12-18 Thread martin hudec
and POP3, both with secure variants. You can use mysql as authentication backend with sasl. I am using this solution with postfix as smtp server (also with user and virtual data in mysql), amavisd (clamav + spamassassin) as spam/virus filter. I am just bit sad that openwebmail is not working

Re: recover from var deletion; mysql apache

2004-12-18 Thread Sean Ellis
On Sat, Dec 18, 2004 at 12:20:27PM -0800, Sean Ellis wrote: I am working to recover a computer whose /var filesystem, a separate mount point, was entirely deleted. sudo mysql mysql mySQL.mysql.dump I get an error of ERROR 1049: Unknown database 'mysql' Also, although the web server

Re: recover from var deletion; mysql apache

2004-12-18 Thread Sean Ellis
On Sat, Dec 18, 2004 at 01:26:13PM -0800, Sean Ellis wrote: On Sat, Dec 18, 2004 at 12:20:27PM -0800, Sean Ellis wrote: /usr/libexec/ld-elf.so.1: Shared object libmm.so.13 not found mysql is now cooperating after running mysql_install_db and then being restarted, . But I am left

Re: postfix mysql 4.0.22

2004-12-17 Thread Daniel S. Haischt
did you also try WITH_MYSQL_VER=4 ? It's pretty uncommon that one has to include the minor version if building a port ... Cristi Tauber schrieb: Hello people, I have a little problem setting up postfix with mysql. My ports.cvs looks like this : madalina# cat /root/ports.cvs *default host

MySQL cluster on FreeBSD AMD-64 ?

2004-12-17 Thread Olaf Greve
Hi guys, A few days ago I asked for experiences you all might have with optimising MySQL for large DB applications under FreeBSD. Well, the plot thickens, and hardware and OS-wise I think I now am well on my way of finding a very promising solution. The idea is to use FreeBSD 5.3 AMD-64, using

Re: Is Mysql accessible through Jailshell??

2004-12-16 Thread Peter Pentchev
On Thu, Dec 16, 2004 at 09:26:11PM +0530, Akhthar Parvez. K wrote: Hi all, I am not able to access mysql from jailshell. Is it allowed or a bug? I got mysql error 61( Connection refused) when I tried the same. Comments are welcomed. Quick question: are you trying to access MySQL on a TCP

Mysql 4.0 startup script

2004-12-16 Thread Mike Grissom
I have mysql 4.0.22 installed on FreeBSD 4.10-RELEASE-p5. Whenere I run /usr/local/etc/rc.d/mysql-server.sh start, it drops into a shell under the username of mysql and does not start. Anyone else having this problem or know how to fix it? -- No virus found in this outgoing message

postfix mysql 4.0.22

2004-12-16 Thread Cristi Tauber
Hello people, I have a little problem setting up postfix with mysql. My ports.cvs looks like this : madalina# cat /root/ports.cvs *default host=cvsup7.freebsd.org *default base=/usr *default prefix=/usr *default release=cvs tag=. *default compress *default delete use-rel-suffix ports

Is Mysql accessible through Jailshell??

2004-12-16 Thread Akhthar Parvez. K
Hi all, I am not able to access mysql from jailshell. Is it allowed or a bug? I got mysql error 61( Connection refused) when I tried the same. Comments are welcomed. -- With Regards, Akhthar Parvez.K - I was brilliant when I was born, Education spoiled

How to distribute MySQL over various machines (or otherwise up its performance)?

2004-12-13 Thread Olaf Greve
Hi, I have been asked to assist in a most interesting challenge: getting rid of a Win2K server (running MySQL) on which MySQL takes up around 100% of the CPU. :) I have near total freedom in suggesting a replacement architecture (within some reasonable finacial limits, of course), and I am

Re: mysql connect problems

2004-12-11 Thread John DeStefano
On Sat, 11 Dec 2004 09:23:52 +, Peter Risdon [EMAIL PROTECTED] wrote: When I specify a value for MySQL server and for DB root password on the MediaWiki 1.3.8 installation page, I get Couldn't connect to database with a script note MySQL error 1250: Client does not support

Re: mysql connect problems

2004-12-11 Thread Peter Risdon
John DeStefano wrote: [...] When I specify a value for MySQL server and for DB root password on the MediaWiki 1.3.8 installation page, I get Couldn't connect to database with a script note MySQL error 1250: Client does not support authentication protocol requested by server; consider upgrading

Re: mysql won't start on boot

2004-12-10 Thread Vonleigh Simmons
Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. I'm going from memory here as I'm not in front of my BSD machine but isn't it mysqld_enable=YES? Not according to the script, but I'll try

Re: mysql won't start on boot

2004-12-10 Thread Markus Hoenicka
Vonleigh Simmons [EMAIL PROTECTED] was heard to say: Nope, still no dice. Changed it back to mysql_enable but it still won't start up on boot. Anyone have any other ideas of what it could be? I can't help you any further if you want to understand what's going wrong. However, if you

Re: mysql won't start on boot

2004-12-10 Thread Gary Hayers
Vonleigh Simmons wrote: After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing

Re: mysql won't start on boot

2004-12-10 Thread Vonleigh Simmons
It still won't start up on its own after I reboot. However doing: # /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/my_hostname.pid Ok forget that last question, I found the answer, check the startup script is running the correct command, I found

Re: mysql connect problems

2004-12-10 Thread John DeStefano
On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2 anon entries (localhost and host name), 2 'mtuser' entries (one

Re: mysql connect problems

2004-12-10 Thread Jorn Argelo
On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2 anon

Re: mysql connect problems

2004-12-10 Thread Peter Risdon
Jorn Argelo wrote: On Fri, 10 Dec 2004 14:13:40 -0500, John DeStefano wrote On Fri, 10 Dec 2004 18:08:48 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: select user, password, host from user; on 'mysql' returned 3 'root' entries using 2 different passwords (localhost, %, and the actual host name), 2

Re: mysql won't start on boot

2004-12-10 Thread Gary Hayers
Vonleigh Simmons wrote: Yes, was in my original message but you caught us half-way: # grep mysql /etc/rc.conf mysql_enable=YES I'm using the mysql from ports. I'm going from memory here as I'm not in front of my BSD machine but isn't it mysqld_enable=YES? Not according

Re: mysql connect problems

2004-12-10 Thread John DeStefano
On Fri, 10 Dec 2004 00:15:10 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote [snip] At a prompt, if I try to connect to mysql using the '-p' option like this: # mysql -u root -p ... I can connect. Which makes sense. Because

Re: mysql connect problems

2004-12-10 Thread Jorn Argelo
On Fri, 10 Dec 2004 09:54:56 -0500, John DeStefano wrote On Fri, 10 Dec 2004 00:15:10 +0100, Jorn Argelo [EMAIL PROTECTED] wrote: On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote [snip] At a prompt, if I try to connect to mysql using the '-p' option like this: # mysql -u

Re: mysql connect problems

2004-12-10 Thread John DeStefano
that, you won't have problems with permissions and such, but people who put security at a top priority will not like this method. I logged into mysql as root over a PuTTy/SSH connection and performed this command, specifying a new password. But the result was Query OK, 0 rows affected (0.01 sec

Re: mysql connect problems

2004-12-10 Thread Jorn Argelo
like this: set password = password(yournewpassword); Like that, you won't have problems with permissions and such, but people who put security at a top priority will not like this method. I logged into mysql as root over a PuTTy/SSH connection and performed this command, specifying

Re: mysql connect problems

2004-12-10 Thread John DeStefano
want to grant the privileges on before issuing the GRANT command. This doesn't seem to be the way it's documented, but it works for me. You might also consider using passwords... mysql\u wikidb mysqlGRANT ALL on wikidb.* to [EMAIL PROTECTED] IDENTIFIED BY 'password'; mysql\u mtdb

Re: mysql won't start on boot

2004-12-09 Thread CHris Rich
On Wed, 8 Dec 2004 12:22:53 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: Since you didn't mention which mysql version you are using..I will say this. In the /usr/ports/UPDATING...there is a paragraph. 20041031: AFFECTS: users of databases/mysql40-server AUTHOR: [EMAIL

mysql connect problems

2004-12-09 Thread John DeStefano
and tinkering, I made some advances but seem to have come up against a problem in the vein of a very common theme: MySQL connections in FreeBSD. Not that I'm blaming the operating system; I'm quite aware this is more an 'operator error' than anything else. Just appears that a lot of FBSD users just

Re: mysql connect problems

2004-12-09 Thread Jorn Argelo
On Thu, 9 Dec 2004 17:18:38 -0500, John DeStefano wrote [snip] At a prompt, if I try to connect to mysql using the '-p' option like this: # mysql -u root -p ... I can connect. Which makes sense. Because the -p option is for entering a password. And I don't think you'll have an empty

Re: mysql won't start on boot

2004-12-08 Thread Markus Hoenicka
Vonleigh Simmons [EMAIL PROTECTED] was heard to say: After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its

Re: mysql won't start on boot

2004-12-08 Thread Vonleigh Simmons
After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: I'm sitting in front

Re: mysql won't start on boot

2004-12-08 Thread Markus Hoenicka
Vonleigh Simmons writes: /usr/local/etc/init.d/ which you have to rename to mysql.sh. I do have a file in rc.d: Ah, sure. init.d is linuxish. It just so happened that I installed a 5.3 box from scratch in the last couple of days. MySQL wasn't installed yet, so I grabbed

Re: mysql won't start on boot

2004-12-08 Thread Vonleigh Simmons
What happens if you run /usr/local/etc/rc.d/mysql-server.sh start manually? Does the log file enlighten you (/var/db/mysql/[boxname].err)? I think you may have found it. I was able to stop mysql using the rc script. However starting it back up did nothing: # /usr/local/etc/rc.d/mysql-server.sh

RE: mysql won't start on boot

2004-12-08 Thread Haulmark, Chris
Someone broke the silence: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start manually? Does the log file enlighten you (/var/db/mysql/[boxname].err)? I think you may have found it. I was able to stop mysql using the rc script. However starting it back up did nothing

Re: mysql won't start on boot

2004-12-08 Thread Vonleigh Simmons
Since you didn't mention which mysql version you are using..I will say this. In the /usr/ports/UPDATING...there is a paragraph. 20041031: AFFECTS: users of databases/mysql40-server AUTHOR: [EMAIL PROTECTED] The MySQL Daemon must now be enabled / disabled in rc.conf. See the script

Re: mysql won't start on boot

2004-12-08 Thread Joshua Lokken
On Wed, 8 Dec 2004 12:05:13 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never started up, here is the error log: --- 041208 14:07:26 mysqld

Re: mysql won't start on boot

2004-12-08 Thread Markus Hoenicka
Joshua Lokken [EMAIL PROTECTED] was heard to say: On Wed, 8 Dec 2004 12:05:13 -0800, Vonleigh Simmons [EMAIL PROTECTED] wrote: What happens if you run /usr/local/etc/rc.d/mysql-server.sh start # /usr/local/etc/rc.d/mysql-server.sh start Starting mysql. Yet mysql never

mlock setgid mail mysql

2004-12-07 Thread Vonleigh Simmons
After updating to 5.3 I'm running into the following two problems: 1. I'm getting the following error in my mail log over and over: usr/local/libexec/mlock[755]: (64) not setgid mail I'm assuming it's an ownership problem, but what of? 2. MySQL won't start at boot time. I read

mysql won't start on boot

2004-12-07 Thread Vonleigh Simmons
After updating to 5.3 MySQL won't start at boot time. I read UPDATING and it says to include a line in /etc/rc.conf. But even after adding that line: # grep mysql /etc/rc.conf mysql_enable=YES It still won't start up on its own after I reboot. However doing: # /usr/local/bin

Re: FreeRadius and Mysql server ports

2004-12-03 Thread Lowell Gilbert
Jermaine McBean [EMAIL PROTECTED] writes: I have problem adding MySQL server to FreeBSD with FreeRadius. Since I already installed FreeRadius /w Mysql client, I cannot do a pkg_add Mysql-server because of the FreeRadius' dependancy on a older mysql client (mysql-client-4.0.21). Is there a way

Suport for MySQL and Postgresql in PHP

2004-12-03 Thread Mário Gamito
Hi, Sorry for this newbie question :( I've installed Apache-PHP sucessfully, but PHP lacks suport for MySQL and Postgresql. Are there any ports for that, or must i edit PHP's Makefile to include suport for both databases ? I've searched all around the ports colection, but didn't find anything

Re: Suport for MySQL and Postgresql in PHP

2004-12-03 Thread Kevin D. Kinsey, DaleCo, S.P.
Mário Gamito wrote: Hi, Sorry for this newbie question :( I've installed Apache-PHP sucessfully, but PHP lacks suport for MySQL and Postgresql. Are there any ports for that, or must i edit PHP's Makefile to include suport for both databases ? I've searched all around the ports colection

FreeRadius and Mysql server ports

2004-12-02 Thread Jermaine McBean
I have problem adding MySQL server to FreeBSD with FreeRadius. Since I already installed FreeRadius /w Mysql client, I cannot do a pkg_add Mysql-server because of the FreeRadius' dependancy on a older mysql client (mysql-client-4.0.21). Is there a way to upgrade the client so I can install

MYSQL connection problem

2004-12-01 Thread mario . lobo
Hello Everyone; I have two machines: 1) Free 4.10 / mysql (5.0.0) listening on port 5006 2) Free 5.3 Release / mysql (5.0.0) listening on port 5007 On both, no firewalls, blocks or anything of that sort. Both machines have the same configuration. Both mysql were compiled from the ports

MYSQL connection problem (added info)

2004-12-01 Thread mario . lobo
Adding the tcpdump output after changing mysqld to port 5004 (just a try :(( ) and issuing: [~]mysql --port=5004 --host=127.0.0.1 --user=xxx database -p [~]tcpdump -vv -i lo0 port 5004 tcpdump: listening on lo0, link-type NULL (BSD loopback), capture size 96 bytes 08:57:04.755597 IP (tos

Re: MYSQL connection problem (added info)

2004-12-01 Thread David Jenkins
On Wed, 1 December, 2004 12:16, [EMAIL PROTECTED] said: Adding the tcpdump output after changing mysqld to port 5004 (just a try :(( ) and issuing: [~]mysql --port=5004 --host=127.0.0.1 --user=xxx database -p [~]tcpdump -vv -i lo0 port 5004 tcpdump: listening on lo0, link-type NULL

Re: MYSQL connection problem

2004-12-01 Thread Daniel Bye
On Wed, Dec 01, 2004 at 08:23:51AM -0300, [EMAIL PROTECTED] wrote: Hello Everyone; I have two machines: 1) Free 4.10 / mysql (5.0.0) listening on port 5006 2) Free 5.3 Release / mysql (5.0.0) listening on port 5007 On both, no firewalls, blocks or anything of that sort. Both machines

Re: MYSQL connection problem (SOLVED)

2004-12-01 Thread Daniel Bye
On Wed, Dec 01, 2004 at 10:40:14AM -0300, [EMAIL PROTECTED] wrote: YSS !!! IT WORKED !! Thanks a million Daniel. What exactly does with-liwrap do? It causes the MySQL package to be linked against the libwrap library - which is used for host access control through the /etc

how to (automatically) start MySQL server?

2004-11-30 Thread Matthias F. Brandstetter
Hi all, after successfully compiling installing MySQL server 4.0 I wanted to start it ... but there is no mysql.sh (or similar) in /usr/local/etc/rc.d/ So I have some questions: - what's the FreeBSD (4.10) way to start MySQL server? - how to setup initial mysql database under FreeBSD? - how

Re: how to (automatically) start MySQL server?

2004-11-30 Thread Matthias F. Brandstetter
-- quoting Matthias F. Brandstetter -- Hi all, after successfully compiling installing MySQL server 4.0 I wanted to start it ... but there is no mysql.sh (or similar) in /usr/local/etc/rc.d/ So I have some questions: - what's the FreeBSD (4.10) way to start MySQL server

Re: Mysql Error 1135

2004-11-28 Thread Lowell Gilbert
Akhthar Parvez. K [EMAIL PROTECTED] writes: I am getting following error message while accessing mysql. ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug What could be the problem? I know

Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords

2004-11-28 Thread klr
password (which cyrus-sasl should then crypt and check vs the database). -- Meaning the patch is having no effect, it is only checking the password feeded vs the database... Is there any way to have SMTP auth working with MySQL / crypt-stored passwords using postfix+cyrus-sasl2

RE: Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords

2004-11-28 Thread Marcel de Reuver
password (which cyrus-sasl should then crypt and check vs the database). -- Meaning the patch is having no effect, it is only checking the password feeded vs the database... Is there any way to have SMTP auth working with MySQL / crypt-stored passwords using postfix+cyrus-sasl2

RE: Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords

2004-11-28 Thread klr
the database... Is there any way to have SMTP auth working with MySQL / crypt-stored passwords using postfix+cyrus-sasl2 ? smtpd.conf pwcheck_method: auxprop mech_list: PLAIN LOGIN auxprop_plugin: sql srp_mda: md5 password_format: crypt sql_engine: mysql

RE: Cyrus-SASL2-2.1.20 MySQL crypt'ed passwords

2004-11-28 Thread klr
it doesn't work :/ The password_format directive was incorporated on 2.1.20 ? smtpd.conf pwcheck_method: auxprop mech_list: PLAIN LOGIN auxprop_plugin: sql srp_mda: md5 password_format: crypt sql_engine: mysql sql_hostnames: localhost sql_database

Mysql Error 1135

2004-11-27 Thread Akhthar Parvez. K
Hi All, I am getting following error message while accessing mysql. ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug What could be the problem? I know that the problem is due to resources

Re: mailinglist with postfix+mysql

2004-11-22 Thread Shantanoo Mahajan
+++ Martin Hudec [freebsd] [22-11-04 17:49 +0100]: | Hello, | | I am using postfix with mysql backend to provide mail | delivery services. Is there any mailinglist with support | for mysql stored subscribers addresses, and if is, which one | can you generally recommend to me? http

RE: MySQL problems on FBSD 5.2.1

2004-11-22 Thread steveb99
I have it working, but don't know if it is the right answer. Some of the info I got hinted at rebuilding in a different order. So I uninstall apache2, mod_php4, and mysql4. Then rebuilt the ports in this order MySQL, then apache, and last mod_php. The problem still existed. I found another

MySQL problems on FBSD 5.2.1

2004-11-19 Thread steveb99
I installed mod_PHP which installed Apache 2 from ports. All that works fine. I then install MySQL4 port and have it working fine standalone. What I can't get to work is calling MySQL from PHP code. The code hits the call to MySQL functions and does nothing, just stops at that line

Re: MySQL problems on FBSD 5.2.1

2004-11-19 Thread Zeroke
Don't know if the ports automaticly compile PHP with MySQL support. Maybe install PHP from source with the --with-mysql parameter? (Since version 5 of PHP it does not include MySQL support from its own.) Good luck, Zeroke [EMAIL PROTECTED] - Original Message - From: steveb99 [EMAIL

Re: MySQL problems on FBSD 5.2.1

2004-11-19 Thread Daniel Bye
On Fri, Nov 19, 2004 at 06:49:37PM +0100, Zeroke wrote: Don't know if the ports automaticly compile PHP with MySQL support. No - it doesn't. Look for the entry tagged 20040719 in /usr/ports/UPDATING. It will tell you all about it. Dan -- Daniel Bye PGP Key: ftp://ftp.slightlystrange.org

<    7   8   9   10   11   12   13   14   15   16   >