Re: backup and restore mysql

2005-08-27 Thread bob self
Carstea Catalin wrote: how to backup and restore mysql databases? to backup: # mysqldump --opt -u root -p -A dbs.sql to restore: mysql source dbs.sql; ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman

mysql-administrator

2005-08-22 Thread Warren
I have just isntalled mysql-administrator on a FreeBSD 5.4-STABLE machine and for the life of me cant find the file/command to execute the program .. does anyone know where i should be looking or the command? TIA -- Yours Sincerely Shinjii http://www.shinji.nq.nu

Re: mysql-administrator

2005-08-22 Thread [EMAIL PROTECTED]
On Mon, 22 Aug 2005 19:59:28 +1000 Warren [EMAIL PROTECTED] wrote: I have just isntalled mysql-administrator on a FreeBSD 5.4-STABLE machine and for the life of me cant find the file/command to execute the program .. does anyone know where i should be looking or the command? if you

Re: start up command for mysql

2005-08-19 Thread Ed Stover
Andrew L. Gould wrote: On Thu, 18 Aug 2005 13:53:13 -0700 Mick Wilcoxen [EMAIL PROTECTED] wrote: Ok, really new at this FreeBSD Mysql stuff. Which file do i put the startup command and the location of this ? The startup command is as follows /usr/local/mysql/bin/safe_mysqld

Re: start up command for mysql

2005-08-19 Thread Dev FreeBSD
On 8/19/05, Ed Stover [EMAIL PROTECTED] wrote: Dont forget to place it in the /etc/rc.conf as well.. darn rcsubr ;) Hi What is rcsubr ? -- thanks Dev. ___ freebsd-questions@freebsd.org mailing list

Re: start up command for mysql

2005-08-19 Thread Andrew L. Gould
On Fri, 19 Aug 2005 12:36:31 +0530 Dev FreeBSD [EMAIL PROTECTED] wrote: On 8/19/05, Ed Stover [EMAIL PROTECTED] wrote: Dont forget to place it in the /etc/rc.conf as well.. darn rcsubr ;) Hi What is rcsubr ? -- thanks Dev. Good question. I don't feel qualified to give

Re: start up command for mysql

2005-08-19 Thread Andrew L. Gould
don't know what you mean by fill; but if you're looking for the start-up script that works on boot-up, I think you've found the wrong file. The start-up script is a text file used to start MySQL at boot- up and stop it at shutdown. 1. Did you install MySQL from the ports, using pkg_add or manually

Re: start up command for mysql

2005-08-19 Thread Andrew L. Gould
/usr/local/lib/mysql ;; Stop) ;; *) echo echo Usage: 'basename $0' {start | stop} echo exit 64 ;; Esac He is telling me to put this command in the startup /usr/local/mysql/bin/safe_mysqld . Run this with the period at the end.put

problem when starting mysql

2005-08-18 Thread vladone
Hi! I have installed mysql 4.1 from ports. After i run /usr/local/bin/mysql_install_db, i try to start server with: /usr/local/bin/mysqld_safe but i receive this error in host.err: [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist How i can resolv

Re: problem when starting mysql

2005-08-18 Thread vladone
Sorry. Resolved. I dont have right owner for /var/db/mysql ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]

Re: problem when starting mysql

2005-08-18 Thread Nelis Lamprecht
On 8/18/05, vladone [EMAIL PROTECTED] wrote: Sorry. Resolved. I dont have right owner for /var/db/mysql If you used the script that the port installed in /usr/local/etc/rc.d to start mysql you wouldn't have had any problems. The startup script would have run mysql_install_db and set

i can't connect remote to my mysql server

2005-08-18 Thread vladone
I have instaled mysql server succcesfull and started. I set root password, i can login to my server from console but i can't login remote (i use Mysql Control Center for win, for quickly management). I receive this error: host 192.168.100.4 is not allowed to connect to this Mysql server I dont

Re: i can't connect remote to my mysql server

2005-08-18 Thread [EMAIL PROTECTED]
On Thu, 18 Aug 2005 13:52:36 +0300 vladone [EMAIL PROTECTED] wrote: I have instaled mysql server succcesfull and started. I set root password, i can login to my server from console but i can't login remote (i use Mysql Control Center for win, for quickly management). I receive this error

Re: i can't connect remote to my mysql server

2005-08-18 Thread jdyke
vladone wrote: I have instaled mysql server succcesfull and started. I set root password, i can login to my server from console but i can't login remote (i use Mysql Control Center for win, for quickly management). I receive this error: host 192.168.100.4 is not allowed to connect

Re: i can't connect remote to my mysql server

2005-08-18 Thread Nelis Lamprecht
On 8/18/05, vladone [EMAIL PROTECTED] wrote: I have instaled mysql server succcesfull and started. I set root password, i can login to my server from console but i can't login remote (i use Mysql Control Center for win, for quickly management). I receive this error: host 192.168.100.4

Re[2]: i can't connect remote to my mysql server

2005-08-18 Thread vladone
Thanks all! Work. Problem is resolved how present jdyke. (with identifed not work :)) Usefull is and solution for my.cnf. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any

start up command for mysql

2005-08-18 Thread Mick Wilcoxen
Ok, really new at this FreeBSD Mysql stuff. Which file do i put the startup command and the location of this ? The startup command is as follows /usr/local/mysql/bin/safe_mysqld . *** Mick Wilcoxen (530)933-2882

Re: start up command for mysql

2005-08-18 Thread Andrew L. Gould
On Thu, 18 Aug 2005 13:53:13 -0700 Mick Wilcoxen [EMAIL PROTECTED] wrote: Ok, really new at this FreeBSD Mysql stuff. Which file do i put the startup command and the location of this ? The startup command is as follows /usr/local/mysql/bin/safe_mysqld

What versions of PHP / mysql / apache for Mambo?

2005-08-14 Thread Chris Ryan
Hi All What versions of mysql server , apache and php should be run to use the mambo cms on freeBSD 5.4? What advantages of apache2 over 1.3? Php 5 - more secure than php4? Other reasons? Mysql server 4.0 / 4.1 / 5 ? Thanks in advance Chris

MySQL - Cannot access as root

2005-07-28 Thread Gerard Seibert
I have just installed MySQL 5. I can access the program as a regular user, but not as root. As I regular user I have no privileges. If I attempt to access as root, I receive this error message. ERROR 1045 (28000) Access denied for user 'root'@'localhost' (using password: NO) I can access

Re: MySQL - Cannot access as root

2005-07-28 Thread Andrew L. Gould
On Thursday 28 July 2005 04:20 pm, Gerard Seibert wrote: I have just installed MySQL 5. I can access the program as a regular user, but not as root. As I regular user I have no privileges. If I attempt to access as root, I receive this error message. ERROR 1045 (28000) Access denied for user

Problems with MySQl Server port

2005-07-17 Thread perikillo
/mysqld_error.h --name_file=../include/mysqld_ername.h -- state_file=../include/sql_state.h --in_file=../sql/share/errmsg.txt Segmentation fault (core dumped) *** Error code 139 Stop in /usr/ports/databases/mysql50-server/work/mysql-5.0.9-beta/extra. *** Error code 1 Stop in /usr/ports/databases

Problems with postfix / mysql /maildrop / courier-imap

2005-07-15 Thread cell
Hello , i have a problem when i sent a mail with a virtual user.I am on freebsd 5.4 and i use postfix-2.1.5_1,1 , maildrop-1.8.0_3 , courier-authlib-0.56 , courier-authlib-mysql-0.56 and courier-imap-4.0.3,1 . When i sent a mail with a virtual user , i have that in my log : Jul 15 17:56:27

mysql-4.1.12 errors after portupgrade

2005-07-14 Thread Ken Gunderson
Hello: This is driving me bonkers! I portupgraded mysql41 to 4.1.12. Now mysql won't start from the rc.d/mysql-server.sh, either at startup or when I run manually. I didn't change any options in /etc/ rc.conf.local. Mysql error logs whine thusly: [ERROR] Can't find messagefile '/usr/local

Re: mysql-4.1.12 errors after portupgrade

2005-07-14 Thread Tsampros Leonidas
On Thu, Jul 14, 2005 at 11:03:18AM -0600, Ken Gunderson wrote: Hello: This is driving me bonkers! I portupgraded mysql41 to 4.1.12. Now mysql won't start from the rc.d/mysql-server.sh, either at startup or when I run manually. I didn't change any options in /etc/ rc.conf.local. Mysql

Re: mysql-4.1.12 errors after portupgrade

2005-07-14 Thread Ken Gunderson
On Thu, 14 Jul 2005 23:40:06 + Tsampros Leonidas [EMAIL PROTECTED] wrote: On Thu, Jul 14, 2005 at 11:03:18AM -0600, Ken Gunderson wrote: Hello: This is driving me bonkers! I portupgraded mysql41 to 4.1.12. Now mysql won't start from the rc.d/mysql-server.sh, either at startup

Re: mysql-4.1.12 errors after portupgrade

2005-07-14 Thread Tsampros Leonidas
. Hope I helped. mysql won't start from the rc.d/mysql-server.sh, either at startup or when I run manually. I didn't change any options in /etc/ rc.conf.local. Mysql error logs whine thusly: [ERROR] Can't find messagefile '/usr/local/share/mysql/english/ errmsg.sys' snip

Re: mysql-4.1.12 errors after portupgrade

2005-07-14 Thread Ken Gunderson
On Fri, 15 Jul 2005 00:34:12 + Tsampros Leonidas [EMAIL PROTECTED] wrote: On Thu, Jul 14, 2005 at 03:17:52PM -0600, Ken Gunderson wrote: On Thu, 14 Jul 2005 23:40:06 + Tsampros Leonidas [EMAIL PROTECTED] wrote: On Thu, Jul 14, 2005 at 11:03:18AM -0600, Ken Gunderson wrote:

Re: imap-uw / squirrellmail / mysql / postfix / postfixadmin question

2005-07-07 Thread Paul Schmehl
--On Wednesday, July 06, 2005 20:18:37 -0700 M. Goodell [EMAIL PROTECTED] wrote: Hello, I have successfully installed: imap-uw / squirrellmail / mysql / postfix / PostfixAdmin and have setup postfix virtual domain capability. Postfix accepts mail for virtual hosts / accounts that I configured

Re: imap-uw / squirrellmail / mysql / postfix / postfixadmin question

2005-07-07 Thread M. Goodell
The accounts are kept in MySQL via a PostfixAdmin installation. Again, I can deliver mail all day to any virtual host / account I setup in PostfixAdmin but I am not able to get SquirrellMail to login to get the mail. I am using the following group of applicaitons together: imap-uw

imap-uw / squirrellmail / mysql / postfix / postfixadmin question

2005-07-06 Thread M. Goodell
Hello, I have successfully installed: imap-uw / squirrellmail / mysql / postfix / PostfixAdmin and have setup postfix virtual domain capability. Postfix accepts mail for virtual hosts / accounts that I configured with PostfixAdmin very well. Watching the mail log the mail arrives

mysql user did not authenticate by courier-imap

2005-06-29 Thread Muhammad Kashif Yaqoob
Dear Sir, I am working on postfix Mailserver at freebsd.and install the courier Imap (courier-imap-4.0.2,1) and courier-authlib-0.55 in the system.and also Configuration the setting of courier-imap with mysql.When i authenticate the mysql pop user with courier-imap. And run the following

mysql user did not authenticate by courier-imap

2005-06-29 Thread Muhammad Kashif Yaqoob
Dear Sir, I am working on postfix Mailserver at freebsd.and install the courier Imap (courier-imap-4.0.2,1) and courier-authlib-0.55 in the system.and also Configuration the setting of courier-imap with mysql.When i authenticate the mysql pop user with courier-imap. And run the following

mysql user did not authenticate by courier-imap

2005-06-29 Thread Muhammad Kashif Yaqoob
Dear Sir, I am working on postfix Mailserver at freebsd.and install the courier Imap (courier-imap-4.0.2,1) and courier-authlib-0.55 in the system.and also Configuration the setting of courier-imap with mysql.When i authenticate the mysql pop user with courier-imap. And run the following

Re: mysql user did not authenticate by courier-imap

2005-06-29 Thread Brian Candler
On Wednesday 29 June 2005 14:12, Muhammad Kashif Yaqoob wrote: I am working on postfix Mailserver at freebsd.and install the courier Imap (courier-imap-4.0.2,1) and courier-authlib-0.55 in the system.and also Configuration the setting of courier-imap with mysql.When i authenticate the mysql

Re: mysql user did not authenticate by courier-imap

2005-06-29 Thread Brian Candler
On Wednesday 29 June 2005 14:12, Muhammad Kashif Yaqoob wrote: I am working on postfix Mailserver at freebsd.and install the courier Imap (courier-imap-4.0.2,1) and courier-authlib-0.55 in the system. ... authdaemonrc = authmodulelist=authmysql daemons=5 version=

Re: mysql user did not authenticate by courier-imap

2005-06-29 Thread Chad Leigh -- Shire.Net LLC
of courier-imap with mysql.When i authenticate the mysql pop user with courier-imap. I saw your question the first time. I answered it. Simply reposting your query (three times in succession) does *not* make me inclined to help you any more. I suspect it is more a case of twitchy fingers

strange behavior when libnss-mysql is querying a server with tcp

2005-06-20 Thread Oliver Dumat
hi folks iam using freebsd 5.4 with libnss-mysql 1.4 and mysql-client40. libnss-mysql querys on localhost through a socket with no problems. if i want libnss-mysql querys a database host i get errors: - the connection defintivly works to the other server (veryfied with the mysql client

Re: strange behavior when libnss-mysql...

2005-06-20 Thread Oliver Dumat
hi i know that its not a firewallthing cause i verify it with the console mysql-client (same password and username) and it works like it should work. the permission thing wars the first thing i checked because its the cause of the most errors ;) Oliver Dumat On Mon, Jun 20, 2005 at 08:39:47AM

[Fwd: compiling mysql query browser]

2005-06-20 Thread ISP Informatique
Hi, I tried to install mysql query browser from source (1.1.11, get from www.mysql.com) and I get blocked. make hang in Making all in gtksourceview Here is the display. Any help ? /tmp/mysql-query-browser-1.1.11/mysql-query-browser# make Making all in library Making all in source Making all

Re: Stability issues with FreeBSD + MySQL

2005-06-15 Thread Ken Ebling
On Jun 14, 2005, at 9:14 PM, Thomas Hurst wrote: The database server is running FreeBSD 4.11 (had all sorts of problems with MySQL after upgrading to 5.x) with mysql-server (4.0.24_1, installed from ports, compiled with LinuxThreads) I'm running MySQL 4.1 on a 5.3-RELEASE dual Opteron (i386

IPFW, NAT, jailed MySQL connection problem.

2005-06-14 Thread Daniel Nystrom
Hi, I seem to have stumbled upon a tiny problem that just will not go away. I was hoping there would be an answer somewhere before I put my deep-into-the-dirt-boots on. The software setup of the problem: FreeBSD 5.4 Release ipfw natd named jail Mysql 4.1 Server Mysql 4.1 client Hardware 1

Starting MySQL at bootup

2005-06-14 Thread Gerard Seibert
This is probably a dumb question, but I will ask it anyway. I have 'mysql' installed. From what I have deduced from the documentation, I should start it using 'mysqld_safe'. I am assuming that I would use the syntax 'mysqld_safe ' to force the program into the background upon starting. What I

Re: Starting MySQL at bootup

2005-06-14 Thread Tsampros Leonidas
Gerard Seibert wrote: This is probably a dumb question, but I will ask it anyway. I have 'mysql' installed. From what I have deduced from the documentation, I should start it using 'mysqld_safe'. I am assuming that I would use the syntax 'mysqld_safe ' to force the program

Re: Starting MySQL at bootup

2005-06-14 Thread Trevor Sullivan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gerard Seibert wrote: This is probably a dumb question, but I will ask it anyway. I have 'mysql' installed. From what I have deduced from the documentation, I should start it using 'mysqld_safe'. I am assuming that I would use the syntax

Stability issues with FreeBSD + MySQL

2005-06-14 Thread Ken Ebling
Hello everyone, I've been experiencing some issues with FreeBSD + MySQL and I was hoping someone on this list might have some advice. I have two servers that run a web site that receives about 650,000 hits per day (about 15,000 unique visits/day). Both the machines have dual Xeon 3.06

Re: Stability issues with FreeBSD + MySQL

2005-06-14 Thread Thomas Hurst
* Ken Ebling ([EMAIL PROTECTED]) wrote: The database server is running FreeBSD 4.11 (had all sorts of problems with MySQL after upgrading to 5.x) with mysql-server (4.0.24_1, installed from ports, compiled with LinuxThreads) I'm running MySQL 4.1 on a 5.3-RELEASE dual Opteron (i386

Re: error when trying to install mysql 4.1.12.

2005-06-11 Thread Christian Astrup Bakke
Julien Gabel wrote: I upgraded to version 4.1.12 on RELENG_5 without problem. Just a thought: what about using GNU readline? readline-5.0 was installed via ports when i installed 4.1.11 some time ago. i guess this is the port you are referring to. -- christian at asba dot no

Re: error when trying to install mysql 4.1.12

2005-06-11 Thread Christian Astrup Bakke
-DMYSQLD_NET_RETRY_COUNT=100 -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o -lreadline -lncurses ../libmysql/.libs/libmysqlclient.so -lcrypt -lm -lz -Wl,--rpath -Wl,/usr/local/lib/mysql mysql.o: In function `new_mysql_completion(char const *, int, int)': mysql.o(.text+0x18b0

Re: error when trying to install mysql 4.1.12.

2005-06-11 Thread Julien Gabel
I upgraded to version 4.1.12 on RELENG_5 without problem. Just a thought: what about using GNU readline? readline-5.0 was installed via ports when i installed 4.1.11 some time ago. i guess this is the port you are referring to. Yes it is, in particular since i saw this post yesterday at:

Re: error when trying to install mysql 4.1.12.

2005-06-11 Thread Christian Astrup Bakke
on and required by mysql41-server? since i uninstalled mysql yesterday, i would presume i'm not able to upgrade or such using portupgrade. too bad i deinstalled it before trying with -R option (i only tried -arv). i'll try installing it with WITH_LINUXTHREADS=yes USE_GNU_READLINE=yes together just

Re: error when trying to install mysql 4.1.12.

2005-06-11 Thread Julien Gabel
by mysql41-server? since i uninstalled mysql yesterday, i would presume i'm not able to upgrade or such using portupgrade. too bad i deinstalled it before trying with -R option (i only tried -arv). You can reinstall it using one of the following: # portinstall -rR mysql41-server # portupgrade -rRN

Re: error when trying to install mysql 4.1.12.

2005-06-11 Thread Christian Astrup Bakke
on and required by mysql41-server? since i uninstalled mysql yesterday, i would presume i'm not able to upgrade or such using portupgrade. too bad i deinstalled it before trying with -R option (i only tried -arv). You can reinstall it using one of the following: # portinstall -rR mysql41-server

Re: Upgrading MySQL Without Wrecking Bacula

2005-06-11 Thread Drew Tomlinson
On 6/10/2005 10:25 PM Kevin Kinsey wrote: Drew Tomlinson wrote: I am a total noob regarding MySQL. I have version 3.23 installed on my 4.10 system. The only thing it's been used for and by is Bacula. I have never used it directly. But now I have reason to learn MySQL and feel it would

Re: error when trying to install mysql 4.1.12

2005-06-11 Thread Jason Taylor
/linuxthreads -I/usr/local/include -O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -I/usr/local/include -felide-constructors -fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=100 -o .libs/mysql

error when trying to install mysql 4.1.12

2005-06-10 Thread Christian Astrup Bakke
-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=100-o mysql mysql.o readline.o sql_string.o completion_hash.o -lreadline -lncurses ../libmysql/libmysqlclient.la -lcrypt -lm -lz mkdir .libs cc -DDBUG_OFF -O -pipe -D_THREAD_SAFE -I/usr

Re: error when trying to install mysql 4.1.12.

2005-06-10 Thread Julien Gabel
-fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=100-o mysql mysql.o readline.o sql_string.o completion_hash.o -lreadline -lncurses ../libmysql/libmysqlclient.la -lcrypt -lm -lz mkdir .libs cc -DDBUG_OFF -O -pipe -D_THREAD_SAFE -I

Re: error when trying to install mysql 4.1.12

2005-06-10 Thread Jason Taylor
/include -felide-constructors -fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=100-o mysql mysql.o readline.o sql_string.o completion_hash.o -lreadline -lncurses ../libmysql/libmysqlclient.la -lcrypt -lm -lz mkdir .libs cc -DDBUG_OFF -O

Analyzing SNORT logs stored in mysql

2005-06-10 Thread Brent Wiese
Anyone know of any good packages that can create reports (preferably HTML) for snort logs stored in mysql? Thanks, Brent ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send

Re: Analyzing SNORT logs stored in mysql

2005-06-10 Thread Alec Berryman
Brent Wiese on 2005-06-10 10:21:03 -0700: Anyone know of any good packages that can create reports (preferably HTML) for snort logs stored in mysql? Acidlab produces nice graphs. pgpxArBS7ThFM.pgp Description: PGP signature

Re: Analyzing SNORT logs stored in mysql

2005-06-10 Thread Remington L
I am very pleased with ACID On 6/10/05, Alec Berryman [EMAIL PROTECTED] wrote: Brent Wiese on 2005-06-10 10:21:03 -0700: Anyone know of any good packages that can create reports (preferably HTML) for snort logs stored in mysql? Acidlab produces nice graphs

Re: Analyzing SNORT logs stored in mysql

2005-06-10 Thread Paul Schmehl
--On Friday, June 10, 2005 10:21:03 -0700 Brent Wiese [EMAIL PROTECTED] wrote: Anyone know of any good packages that can create reports (preferably HTML) for snort logs stored in mysql? BASE - secureideas.sourgeforge.net Paul Schmehl ([EMAIL PROTECTED]) Adjunct Information Security Officer

Upgrading MySQL Without Wrecking Bacula

2005-06-10 Thread Drew Tomlinson
I am a total noob regarding MySQL. I have version 3.23 installed on my 4.10 system. The only thing it's been used for and by is Bacula. I have never used it directly. But now I have reason to learn MySQL and feel it would be appropriate to start with a newer version. I see there's 4.1

Re: Upgrading MySQL Without Wrecking Bacula

2005-06-10 Thread Kevin Kinsey
Drew Tomlinson wrote: I am a total noob regarding MySQL. I have version 3.23 installed on my 4.10 system. The only thing it's been used for and by is Bacula. I have never used it directly. But now I have reason to learn MySQL and feel it would be appropriate to start with a newer version

Re: re-setting root password for MYSQL win 2003

2005-06-08 Thread Remington L
On Tue, 2005-06-07 at 03:48 -0500, Nikolas Britton wrote: On 6/6/05, John Andrews [EMAIL PROTECTED] wrote: in order to access the MYSQL control centre and MYSQL administrator I need to be able to re-set the root userpassword, can someone please advise on how this is done in win2003 server

Re: re-setting root password for MYSQL win 2003

2005-06-07 Thread Nikolas Britton
On 6/6/05, John Andrews [EMAIL PROTECTED] wrote: in order to access the MYSQL control centre and MYSQL administrator I need to be able to re-set the root userpassword, can someone please advise on how this is done in win2003 server admin tools/computer management/ local users and groups

MySQL auto login problem

2005-06-06 Thread Derrick Ryalls
Greetings, I installed mysql on my friend's laptop (remotely) via ports, and now he has a strange issue when he boots into freebsd. As the screen is going through its normal checks it mentions it is starting mysql, then it goes to a bash prompt. When I have him type 'whoami' it responds

re-setting root password for MYSQL win 2003

2005-06-06 Thread John Andrews
in order to access the MYSQL control centre and MYSQL administrator I need to be able to re-set the root userpassword, can someone please advise on how this is done in win2003 server admin tools/computer management/ local users and groups does not disclose the MYSQL root user see print screen

Re: re-setting root password for MYSQL win 2003

2005-06-06 Thread Sarath ER
John Andrews wrote: in order to access the MYSQL control centre and MYSQL administrator I need to be able to re-set the root userpassword, can someone please advise on how this is done in win2003 server admin tools/computer management/ local users and groups does not disclose the MYSQL root

Mysql vs /var partition...

2005-05-26 Thread Matt Virus
Hi All: My mysql database is growing, it has subsequently filled the /var/db partition to capacity. I tried moving the mysql dir and symlinking it to /var/db/mysql which didn't work. I also tried mount_null from the /usr partition to the /var/db/mysql folder...in both instances, the mysql

RE: Mysql vs /var partition...

2005-05-26 Thread Barry Byrne
-Original Message- From: [EMAIL PROTECTED] My mysql database is growing, it has subsequently filled the /var/db partition to capacity. I tried moving the mysql dir and symlinking it to /var/db/mysql which didn't work. I also tried mount_null from the /usr partition to the /var

Re: Mysql vs /var partition...

2005-05-26 Thread Mathieu CHATEAU
Hello, in your /etc/rc.conf: mysql_dbdir=/data/mysql cheers, Mathieu CHATEAU Thursday, May 26, 2005, 7:18:43 PM, you wrote: MV Hi All: MV My mysql database is growing, it has subsequently filled the /var/db MV partition to capacity. MV I tried moving the mysql dir and symlinking it to /var

Re: Mysql vs /var partition...

2005-05-26 Thread Bjoern Koenig
Matt Virus wrote: I tried moving the mysql dir and symlinking it to /var/db/mysql which didn't work. I also tried mount_null from the /usr partition to the /var/db/mysql folder...in both instances, the mysql server will not start. It should work. I've done this already. If you are still

RE: Mysql vs /var partition...

2005-05-26 Thread Joe Wood
I'm not entirely sure if this was mentioned already but it's worth a look. Usually as a rule of thumb, as soon as I complete an installation of mysql I do the following...note that mysql is indeed running during this procedure: cd /var/db mv mysql /usr/local/ ln -s /usr/local/mysql mysql Then I

Mysql startup question

2005-05-24 Thread Philip Wege
Hi When i run /usr/local/etc/rc.d/mysql-server.sh start i get the following error : touch /var/db/mysql/mail.int.diesel-electric.com err: Permission denied chown /var/db/mysql/mail.int.diesel-electric.com cannot create /var/db/mysql/mail.int.diesel-electric.com Permission denied Running

Re: Mysql startup question

2005-05-24 Thread Steven Enderle
Are you sure you did run this as root? Regards Steven -- ++ message delivered by gizm0.org http://gizm0.org/ ++ free webmail - imap, pop3, ssl secured Philip Wege wrote: Hi When i run /usr/local/etc/rc.d/mysql-server.sh start i get the following error : touch /var/db/mysql/mail.int.diesel

Re: Mysql startup question

2005-05-24 Thread Philip Wege
/local/etc/rc.d/mysql-server.sh start i get the following error : touch /var/db/mysql/mail.int.diesel-electric.com err: Permission denied chown /var/db/mysql/mail.int.diesel-electric.com cannot create /var/db/mysql/mail.int.diesel-electric.com Permission denied Running freebsd

Re: Mysql startup question

2005-05-24 Thread Steven Enderle
Could you check the directory by hand? ls -aol /var/db/mysql/ and touch /var/db/mysql/mail.int.diesel-electric.com Regards, Steven -- ++ message delivered by gizm0.org http://gizm0.org/ ++ free webmail - imap, pop3, ssl secured Philip Wege wrote: Yes i am logged in as root directly

Re: Mysql startup question

2005-05-24 Thread Philip Wege
No problems there , and all files and folders owned by root. touch command no errors, goes to next blank line. On Tue, 2005-05-24 at 15:50 +0200, Steven Enderle wrote: Could you check the directory by hand? ls -aol /var/db/mysql/ and touch /var/db/mysql/mail.int.diesel-electric.com Regards

Re: Mysql startup question

2005-05-24 Thread Gerhard Schmidt
On Tue, May 24, 2005 at 04:02:45PM -0700, Philip Wege wrote: No problems there , and all files and folders owned by root. That's the problem /var/db/mysql should be owned by mysql:mysql because mysqld is started as user mysql. bye Estartu

Re: Mysql startup question

2005-05-24 Thread Philip Wege
Thanks done mysql is started. On Tue, 2005-05-24 at 16:15 +0200, Gerhard Schmidt wrote: On Tue, May 24, 2005 at 04:02:45PM -0700, Philip Wege wrote: No problems there , and all files and folders owned by root. That's the problem /var/db/mysql should be owned by mysql:mysql because mysqld

Re: FreeBSD 5.4-RELEASE, PHP 5, MySQL 4.1 (and ftpd)

2005-05-20 Thread Can Berk Guder
OK, both of my problems are now resolved: 1. I didn't know I needed to restart inetd. I don't know what I was thinking... =) 2. I used the ports collection to reinstall MySQL, PHP and all the PHP libraries I need. I thought it was gonna become a nightmare but it didn't. Only the MySQL

FreeBSD 5.4-RELEASE, PHP 5, MySQL 4.1 (and ftpd)

2005-05-19 Thread Can Berk Guder
Hi there, I have two trivial questions: 1. I've just installed these packages on my fresh 5.4-RELEASE system using pkg_add -r: * apache-1.3.33_1 * mysql-server-4.1.10a * php5-5.0.3_2 However, since php5-mysqli isn't in the 5.4-RELEASE packages collection, I can't install php5-mysqli

FreeBSD 5.4-RELEASE, PHP 5, MySQL 4.1 (and ftpd)

2005-05-19 Thread Can Berk Guder
Hi there, I have two trivial questions: 1. I've just installed these packages on my fresh 5.4-RELEASE system using pkg_add -r: * apache-1.3.33_1 * mysql-server-4.1.10a * php5-5.0.3_2 However, since php5-mysqli isn't in the 5.4-RELEASE packages collection, I can't install php5-mysqli

Re: FreeBSD 5.4-RELEASE, PHP 5, MySQL 4.1 (and ftpd)

2005-05-19 Thread [EMAIL PROTECTED]
On Wed, 18 May 2005 05:56:14 +0300 Can Berk Guder [EMAIL PROTECTED] wrote: 1. I've just installed these packages on my fresh 5.4-RELEASE system using pkg_add -r: * apache-1.3.33_1 * mysql-server-4.1.10a * php5-5.0.3_2 However, since php5-mysqli isn't in the 5.4-RELEASE packages

can't connect to mysql

2005-05-15 Thread Eric Cheney
Hello. I'm trying to get MySQL4.0 working. I've installed it using /stand/systinstall (as well as ports method on another attempt). I got a report from sysinstall that MySQL was installed. That's both the client and the server (it caught the dependencies.) But here's the problem: I can't

Re: can't connect to mysql

2005-05-15 Thread Chris Knipe
vi /etc/rc.conf mysql_enable=YES :wq /usr/local/etc/rc.d/mysql-server.sh start mysql and you should be fine. read what the port installation says the next time you install a port ;-) -- Chris. I love deadlines. I especially love the whooshing sound they make as they fly by... - Douglas Adams

Re: can't connect to mysql

2005-05-15 Thread [EMAIL PROTECTED]
On Sun, 15 May 2005 15:37:11 -0400 Eric Cheney [EMAIL PROTECTED] wrote: Here's the error I get begin error message** max# mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cut So then I did

Re: can't connect to mysql

2005-05-15 Thread Eric Cheney
On Sunday, 15 May 2005 at 21:53:01 +0200, [EMAIL PROTECTED] wrote: On Sun, 15 May 2005 15:37:11 -0400 Eric Cheney [EMAIL PROTECTED] wrote: Here's the error I get begin error message** max# mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL

Re: can't connect to mysql

2005-05-15 Thread [EMAIL PROTECTED]
On Sun, 15 May 2005 16:17:01 -0400 Eric Cheney [EMAIL PROTECTED] wrote: you have to specifically enable it in /etc/rc.conf : mysql_enable=YES it's documented in /usr/local/etc/rc.d/mysql-server.sh Thank you; that did it! My apologies for not reading the documentation---but I

MySQL port building solution: -O is required

2005-05-11 Thread Clifton Royston
the build of this port will consistently fail. The problem appears to be, from some cursory digging through the sources, that a number of MySQL functions including MySQL's internal interfaces to the thread libraries are defined only via inlining if the OS *platform* is known to support

Re: starting mysql server automatically

2005-05-10 Thread Paul Keyes
Thanks! I re-made and reinstalled the ports and things are working now. --- Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (May 09), Paul Keyes said: I tried adding mysql_enable=YES to /etc/rc.conf and rebooted but sockstat -4 | grep mysql showed nothing and mysql server wasn't

Re: starting mysql server automatically

2005-05-09 Thread Paul Keyes
--- Chris Hodgins [EMAIL PROTECTED] wrote: On 5/6/05, Paul Keyes [EMAIL PROTECTED] wrote: Hi All, I'm setting up a server running Freebsd 5.3 I have mysql running well but I can't seem to get it to start automatically at boot time. I can only start it as root with the command

Re: starting mysql server automatically

2005-05-09 Thread Dan Nelson
In the last episode (May 09), Paul Keyes said: I tried adding mysql_enable=YES to /etc/rc.conf and rebooted but sockstat -4 | grep mysql showed nothing and mysql server wasn't running. Some information about my system: $uname -r 5.3-RELEASE $pkg_info | grep mysql mysql-client-5.0.3_1

Re: starting mysql server automatically

2005-05-07 Thread Chris Hodgins
On 5/6/05, Paul Keyes [EMAIL PROTECTED] wrote: Hi All, I'm setting up a server running Freebsd 5.3 I have mysql running well but I can't seem to get it to start automatically at boot time. I can only start it as root with the command: mysqld_safe --user=mysql (when I do

starting mysql server automatically

2005-05-06 Thread Paul Keyes
Hi All, I'm setting up a server running Freebsd 5.3 I have mysql running well but I can't seem to get it to start automatically at boot time. I can only start it as root with the command: mysqld_safe --user=mysql (when I do this everything works fine) I tried installing the mysql.server

Re: starting mysql server automatically

2005-05-06 Thread Jerry McAllister
Hi All, I'm setting up a server running Freebsd 5.3 I have mysql running well but I can't seem to get it to start automatically at boot time. I can only start it as root with the command: mysqld_safe --user=mysql (when I do this everything works fine) I tried installing

MySQL Server died yesterday !

2005-04-20 Thread Graham Bentley
Hello All ! I made quite a few changes to my system recently but havent touched any MySQL specific stuff. When I came to check my forum it was dead with an unable to connect error :( This is in the logs and is recorded every time I reboot or start manaully with /usr/local/etc/rc.d/mysql-server.sh

Re: MySQL Server died yesterday !

2005-04-20 Thread Bob Hall
On Wed, Apr 20, 2005 at 12:14:19PM +0100, Graham Bentley wrote: Hello All ! I made quite a few changes to my system recently but havent touched any MySQL specific stuff. When I came to check my forum it was dead with an unable to connect error :( This is in the logs and is recorded

Re: MySQL Server died yesterday !

2005-04-20 Thread Kees Plonsz
Bob Hall wrote on Wednesday 20 April 2005 13:49 in the group list.freebsd.questions: This is a very MySQL specific question. You should post it to the MySQL mailing list. It's been a while since I used MySQL. The host table is in the MySQL database. There should be a directory called data

<    5   6   7   8   9   10   11   12   13   14   >