FBSD4.9 MySQL 4.x

2004-03-15 Thread Pelle Andersson (SPD Systems AB)
Hi List! I have read that MySQL and FreeBSD 4.x is a bad thing due to FreeBSD's bad(?) threading. I have also read that I can enable linux-threads when compiling. Does these LinuxThreads solve all MySQLFreeBSDThreading issues? Thanks ___ [EMAIL

Re: FBSD4.9 MySQL 4.x

2004-03-15 Thread ander Sendzimir
You might want to check out the MySQL installation manual: manual_Installing.html#BSD_Notes I have a relatively standard 4.0.16 installation running under 4.9-STABLE and haven't run into any problems with it. On Mar 15, 2004, at 9:20 AM, Pelle Andersson (SPD Systems AB) wrote: Hi List! I

Re: Recommended GUI manager for MYSQL

2004-03-15 Thread Jonathan Arnold
Gareth Bailey wrote: Can anyone recommend a good GUI manager for MYSQL? In addition to the earlier mentioned ones, WebMin can manage MySQL, as well as pretty much everything else on FreeBSD: http://freebsd.amazingdev.com/blog/archives/64.html -- Jonathan Arnold (mailto:[EMAIL PROTECTED

Re: sasl2--saslauthd--pam--mysql issue

2004-03-09 Thread Aaron Peterson
calls pam, which does a mysql lookup instead, it fails. It opens the correct database and table, and selects the right fields, but it asks for a username of ste, instead of [EMAIL PROTECTED], so it doesn't find the password, and fails. Why is it only asking for ste, and how do I get it to ask

Re: sasl2--saslauthd--pam--mysql issue

2004-03-09 Thread Shaun T. Erickson
Aaron Peterson wrote: If you have plain text passwords in your MySQL database, you don't need PAM to look them up. SASL2 has this ability natively. I'm going through PAM because I don't want to store passwords in plain text. I have everything set up right, as near as I can tell. It's just

sasl2--saslauthd--pam--mysql issue

2004-03-08 Thread Shaun T. Erickson
calls pam, which does a mysql lookup instead, it fails. It opens the correct database and table, and selects the right fields, but it asks for a username of ste, instead of [EMAIL PROTECTED], so it doesn't find the password, and fails. Why is it only asking for ste, and how do I get it to ask

MySQL and FreeBSD 5.x - Using LinuxThreads or not?

2004-03-07 Thread Lasse Laursen
is superior in the new release compared to the 4.x branch. I did some reading on the topic at Jeremy Zawodny's website: http://jeremy.zawodny.com/blog/archives/000697.html and he suggests that the best solution is to use LinuxThreads when compiling MySQL under FreeBSD. His initial article covered

mysql woes (self-inflicted)

2004-03-06 Thread Shaun T. Erickson
I was having trouble getting mysql40 running, so I removed the server and client packages. I then manually cleaned out the files under /var/db/mysql. Then I rebuilt the server and client. Sadly, when I try to start the server, it complains that mysql.host - one of the files I deleted - doesn't

Re: mysql woes (self-inflicted) SOLVED

2004-03-06 Thread Shaun T. Erickson
Shaun T. Erickson wrote: I was having trouble getting mysql40 running, so I removed the server and client packages. I then manually cleaned out the files under /var/db/mysql. Then I rebuilt the server and client. Sadly, when I try to start the server, it complains that mysql.host - one

Re: mysql in a jail

2004-03-05 Thread Uwe Doering
[EMAIL PROTECTED] wrote: I have a system running four jails. MySQL is running in two of the jails and I am trying to add it to a 3rd jail. Starting the server gets the message: 040302 19:34:15 mysql started 040302 19:34:15 Can't start server : Bind on unix socket: Permission denied 040302

Reload of Mysql-server 4.0 on 5.2.1

2004-03-04 Thread Arnoud
Hi, Once again, my question, who should I bugger with this question? I'm having quite a strange problem with mysql on 5.2.1 (releng_5_2) mysql-server (40, latest cvs port) keeps on reloading when snort is connecting. When I put on logging, no query reached the engine before the reload. Well, I

Strange behaviour of mysql on 5.2.1

2004-03-03 Thread a . buurman
Hi, I'm having quite a strange problem with mysql on 5.2.1. mysql-server (40, latest cvs port) keeps on reloading when snort is connecting. When I put on logging, no query reached the engine before the reload. Well, I put on tcpdump, and guess what I find. only 7 packets. Yes, 3 way handshake

mysql in a jail

2004-03-03 Thread doug
I have a system running four jails. MySQL is running in two of the jails and I am trying to add it to a 3rd jail. Starting the server gets the message: 040302 19:34:15 mysql started 040302 19:34:15 Can't start server : Bind on unix socket: Permission denied 040302 19:34:15 Do you already

Re: MySQL and FreeBSD 4.x.. problems, problems with server

2004-03-02 Thread Uwe Doering
dap wrote: This has happened with enough servers at different locations that I have to believe there is a relationship here. I have servers running the latest release of MySQL. I've run the servers on FreeBSD 4.4., 4.7, and 4.8. I am not using the threaded version. MySQL always uses threads. It's

Re: Problem: postfix 2.0.18 and mysql 4.0.18 on 5.2.1

2004-02-28 Thread Martin Hudec
is hint I wrote above.. cheers, Martin On Fri February 27 2004 14:40, Morten Buhl wrote: Hi, I have run into some problems during compilation of postfix. It only occures when I try to compile in mysql support. snip [src/error] cc -DHAS_MYSQL -I/usr/local/include/mysql -DNO_PCRE -O -pipe

Re: Problem: postfix 2.0.18 and mysql 4.0.18 on 5.2.1

2004-02-28 Thread Morten Grunnet Buhl
something out.. right now all I can offer you is hint I wrote above.. - Thanks, it must have been one of those moments. I recompiled mysql leavign out -DWITH_XCHAR=all and it worked fine. Dont know if that was the actualy fix of if something had gone wrong the first time I compiled. but anyway

MySQL and FreeBSD 4.x.. problems, problems with server

2004-02-28 Thread dap
This has happened with enough servers at different locations that I have to believe there is a relationship here. I have servers running the latest release of MySQL. I've run the servers on FreeBSD 4.4., 4.7, and 4.8. I am not using the threaded version. On all three versions, on different servers

Problem: postfix 2.0.18 and mysql 4.0.18 on 5.2.1

2004-02-27 Thread Morten Buhl
Hi, I have run into some problems during compilation of postfix. It only occures when I try to compile in mysql support. snip [src/error] cc -DHAS_MYSQL -I/usr/local/include/mysql -DNO_PCRE -O -pipe -mcpu=pentiumpro -I. -I../../include -DFREEBSD5 -c error.c cc -DHAS_MYSQL -I/usr/local/include

MySQL Port... [not]missing functions?

2004-02-26 Thread Joe Lewis
Hey, all. I have written an apache module, and it worked fine with MySQL 3.23 compiled from source but not in the 4.x ports (tried 4.1 and 4.0). I have found the problem when I shifted it to a new box. The old one ran 5.1, and this new one runs 5.2. I doubt the OS is the concern, but one

Re: MySQL error 2013

2004-02-22 Thread Gabriel Ambuehl
, and they all have the same DR issue. That leads me to believe that the o/s has the issue, not mysql. DR Does anyone have a clue on what I need to check/upgrade? DR Current system: FreeBSD 4.9-RC #0: Tue Oct 7 Does your MySQL daemon crash (look at /var/db/mysql/*err) ? Because I'm currently

Re: MySQL error 2013

2004-02-22 Thread Erik Greenwald
. That leads me to believe that the o/s has the issue, not mysql. Does anyone have a clue on what I need to check/upgrade? Current system: FreeBSD 4.9-RC #0: Tue Oct 7 yeah, glibc would be linux only... but there're a couple pr's for this issue on freebsd right now. http://www.freebsd.org/cgi/query

MySQL error 2013

2004-02-21 Thread Derrick Ryalls
I have been trying to get a working mysql daemon that allows connections from remote hosts. I can connect via local host just fine, but any time I try from my XP desktop via command center (or another remote client), I get this error immediately: ERROR 2013: Lost connection to MySQL server

Re: problem making p5-Mysql port

2004-02-18 Thread Matthew Seaman
On Tue, Feb 17, 2004 at 04:23:59PM -1000, Baron Fujimoto wrote: I'm trying to build p5-Mysql from ports (as a dependency for bugzilla), but I run into the following error: === p5-Mysql-modules-1.2219 is marked as broken: unknown MySQL version: 323. This is on a 4.8 system with a fresh

problem making p5-Mysql port

2004-02-17 Thread Baron Fujimoto
I'm trying to build p5-Mysql from ports (as a dependency for bugzilla), but I run into the following error: === p5-Mysql-modules-1.2219 is marked as broken: unknown MySQL version: 323. This is on a 4.8 system with a fresh cvsup. Any tips or pointers would be greatly appreciated

phpMyAdmin not loading MySQL extensions

2004-02-16 Thread Tweax Daemon
Hey all, I'm having trouble configuring phpMyAdmin. I guess from when I try to view it in a browser I get the message unable to load mysql extensions the msql link re-directs me to the phpmyadmin site where its states about it can't load mysql.so which is on my system I tried placing

Re: phpMyAdmin not loading MySQL extensions

2004-02-16 Thread Matthew Seaman
On Mon, Feb 16, 2004 at 12:31:28PM -0600, Tweax Daemon wrote: I'm having trouble configuring phpMyAdmin. I guess from when I try to view it in a browser I get the message unable to load mysql extensions the msql link re-directs me to the phpmyadmin site where its states about it can't

Re: phpMyAdmin not loading MySQL extensions

2004-02-16 Thread Kyryll A Mirnenko
Hi Tweax, That's not PHPMyAdmin's problem, your PHP can't find dynamic module (and phpMyAdmin seems to dl() PHP's mysql extension). If you've find mysql.so (if have something like mysql.so.4, just link it to mysql.so to make PHP happy: ln -s mysql.so.4 mysql.so ), try to put

Specify the originating port when connecting to a mysql server.

2004-02-09 Thread [EMAIL PROTECTED]
Hello, And please excuse me for sending previous mail without Subject. Is it possible to specify the originating port when connecting to a mysql server? The problem I have is that the box from which I wish to connect using some script have some ports firewalled, and I want to avoid them. Thank

Re: Specify the originating port when connecting to a mysql server.

2004-02-09 Thread Ion-Mihai Tetcu
Please wrap at 72 chars, thanks On Mon, 9 Feb 2004 12:39:16 +0200 [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello, And please excuse me for sending previous mail without Subject. Is it possible to specify the originating port when connecting to a mysql server? The problem I have

Re: Specify the originating port when connecting to a mysql server.

2004-02-09 Thread [EMAIL PROTECTED]
-Mesaj Inclus-- Date: 9-Feb-2004 13:15:59 +0200 From: Ion-Mihai Tetcu [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Specify the originating port when connecting to a mysql server. Please wrap at 72 chars, thanks Sorry for this too

Error installing MySQL server from ports

2004-02-09 Thread Martyn Hill
Dear list I have upgraded the ports tree on our FreeBSD 4.5 box this morning in preparation to install MySQL. Running make fetch in the databases/mysql5-server directory gives the following error and then stops. Makefile, line 156: Malformed conditional (exists(${DB_DIR}) defined(OVERWRITE_DB

Re: Error installing MySQL server from ports

2004-02-09 Thread Lowell Gilbert
Martyn Hill [EMAIL PROTECTED] writes: I have upgraded the ports tree on our FreeBSD 4.5 box this morning in preparation to install MySQL. Running make fetch in the databases/mysql5-server directory gives the following error and then stops. Makefile, line 156: Malformed conditional

Mysql question (sorry if wrong Maililning List)

2004-02-09 Thread hugle
Hello all. I've got into some problem... I've been running one of mysql databases for almost a year.. and now met some problems.. I have working mysql database.. it has lots of fields (columns) and now.. when I trie to add autoid column.. it puts value 1 everywhere.. i did it auto incremental

SOLVED: Re: phpBB problems with mysql? [OT?]

2004-02-04 Thread Eric F Crist
Thanks for all the help. Someone suggested I install phpMyAdmin and use that to play with the tables. I did a repair on the php_sessions table and it's been working fine ever since. Thanks! -- Eric F Crist AdTech Integrated Systems, Inc (612) 998-3588 pgp0.pgp Description: signature

Starting MySQL

2004-02-04 Thread John Adams
Hi, folks, I added MySQL with portupgrade today, but don't find mysqld anywhere on the machine. How do I start this silly thing? Thanks, John A ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions

Re: Starting MySQL

2004-02-04 Thread Mike Maltese
I added MySQL with portupgrade today, but don't find mysqld anywhere on the machine. How do I start this silly thing? /usr/local/etc/rc.d/mysql-server.sh mysqld resides in /usr/local/libexec, which could be why you didn't find it. That doesn't really matter because a wrapper is used to start

imp and mysql

2004-02-02 Thread RJ45
Hello, I have problems with imp and mysql. I have a very high traffic web mail server. after 3 weeks happens that mysql stop responding and imp gives an error when it tries to access the database. I compiled mysql with LINUX_THREADS enabled. The only solution is to restart mysql from time to time

phpBB problems with mysql? [OT?]

2004-02-02 Thread Eric F Crist
This may be a little off-topic, if so, I apologize. I'm running phpBB2 on my webserver. I finally got it working, and it's been great since Friday. This afternoon, when I try to load the page, I get the following error: phpBB : Critical Error Error creating new session DEBUG MODE SQL

Re: phpBB problems with mysql? [OT?]

2004-02-02 Thread Kevin D. Kinsey, DaleCo, S.P.
Eric F Crist wrote: This may be a little off-topic, if so, I apologize. I'm running phpBB2 on my webserver. I finally got it working, and it's been great since Friday. This afternoon, when I try to load the page, I get the following error: Which page? phpBB : Critical Error Error

Re: phpBB problems with mysql? [OT?]

2004-02-02 Thread Jon-Eirik Pettersen
Eric F Crist wrote: This may be a little off-topic, if so, I apologize. I'm running phpBB2 on my webserver. I finally got it working, and it's been great since Friday. This afternoon, when I try to load the page, I get the following error: phpBB : Critical Error Error creating new session

Re: MySQL 4.x questions...

2004-01-30 Thread Eric F Crist
Thanks for all your help with this problem. Both apps seemed to have successfully installed now, but they both have errors. PostNuke keeps telling me it's 'Failed to Initialize' and I can't get away from the phpBB install script, no matter where I go. I can try to trouble shoot these on my

Re: MySQL 4.x questions...

2004-01-30 Thread Peter Risdon
, and there should be. #mysqlshow -u username -p databasename will show the tables, if there are any... #mysql -u username -p databasename mysql select * from tablename\G will show what is in the tables. If this isn't changing during initialisation/install then there's probably a permissions prob. You can

Mysql socket security (Was: Re: i found something ugly about freeBSD)

2004-01-30 Thread Melvyn Sopacua
On Friday 30 January 2004 10:20, Jorn Argelo wrote: It's up to the administrator of the server to make sure that users can't reach the /tmp partition then. Ehm, you really don't want to advise this. A proper solution: /etc/my.cnf: [mysqld] socket = /var/run/mysql/socket Then: mkdir /var/run

Re: [Fwd: Re: PHP-Perl-MySQL-Apache (was: hi from california)]

2004-01-29 Thread Kevin D. Kinsey, DaleCo, S.P.
From: Kevin D. Kinsey, DaleCo, S.P. [EMAIL PROTECTED] To: ZZerver ZZserver [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: [Fwd: Re: PHP-Perl-MySQL-Apache (was: hi from california)] Date: Wed, 28 Jan 2004 11:55:22 -0600 MIME-Version: 1.0 Received: from ns1.tiadon.com ([69.27.132.161]) by mc8

Re: i found something ugly about mysql

2004-01-29 Thread Kris Kennaway
On Thu, Jan 29, 2004 at 05:59:04PM -0800, [EMAIL PROTECTED] wrote: Am probably wrong i hope but mysqld creates a file call /tmp/mysql.sock but this file got to be 777??? ...i loging with a other useran call a rm /ytmp/mysql.sock and mysql stop working ...O_o ..but then i did

MySQL 4.x questions...

2004-01-29 Thread Eric F Crist
Hey all, I installed MySQL server 4.1.0_1 to support the PostNuke CMS and the phpBB bulletin board system. For the life of me, I can't get a database setup for either of them to use. Both users groups tell me that there's a mysql problem with configuration. Here are the errors: phpBB

Re: MySQL 4.x questions...

2004-01-29 Thread Saint Aardvark the Carpeted
Eric F Crist disturbed my sleep to write: Content-Description: signed data I installed MySQL server 4.1.0_1 to support the PostNuke CMS and the phpBB bulletin board system. For the life of me, I can't get a database setup for either of them to use. Both users groups tell me that there's

Re: MySQL 4.x questions...

2004-01-29 Thread Andrew Boothman
Eric F Crist wrote: Hey all, I installed MySQL server 4.1.0_1 to support the PostNuke CMS and the phpBB bulletin board system. For the life of me, I can't get a database setup for either of them to use. Both users groups tell me that there's a mysql problem with configuration. Here

Re: PHP-Perl-MySQL-Apache (was: hi from california)

2004-01-28 Thread Kevin D. Kinsey, DaleCo, S.P.
From: Kevin D. Kinsey, DaleCo, S.P. [EMAIL PROTECTED] To: ZZerver ZZserver [EMAIL PROTECTED] Subject: Re: PHP-Perl-MySQL-Apache (was: hi from california) Date: Wed, 28 Jan 2004 09:48:42 -0600 MIME-Version: 1.0 Received: from ns1.tiadon.com ([69.27.132.161]) by mc10-f2.hotmail.com with Microsoft

[Fwd: Re: PHP-Perl-MySQL-Apache (was: hi from california)]

2004-01-28 Thread Kevin D. Kinsey, DaleCo, S.P.
2. Figure out what configuration option you chose that requires gds.1 as a dependency, and build PHP *without* it Good luck, Kevin Kinsey That option, BTW, appears to be the one for InterBase. Trying not checking InterBase in the options screen when you are asked what

Re: PHP-Perl-MySQL-Apache (was: hi from california)

2004-01-27 Thread Kevin D. Kinsey, DaleCo, S.P.
servers) to be freeBSD , i think its a great Os, but i had try to get php+perl+apache+mysql to work togather but some how i cant! ...i try searching your help documents and found zero topics about, i dont know withs port will do the job for me, i try i did recompile my apache from scratch

Re: upgrading mysql

2004-01-23 Thread Dinesh Nair
On Thu, 22 Jan 2004, Christer Solskogen wrote: I was wondering upgrading the mysql ports to 4.x series. should this be okay? gallery-1.4.1 ,p5-Mysql-modules-1.2219, php4-4.3.4_5, phpMyAdmin-2.5.4, phpSysInfo-2.1 and squirrelmail-1.4.2_1 seems to like mysql-3, and i was wondering

mysql

2004-01-23 Thread Brian H
Is it possible for mysql 3.x and mysql 4.x to co-exist on the same machine. I currently have mysql 4.x installed and some ports require mysql 3.x. thanks, brian _ Scope out the new MSN Plus Internet Software — optimizes dial-up

RE: mysql

2004-01-23 Thread Sunil Sunder Raj
Hi, Yes. You need to change the port on which both listen to. Regards SSR From: Brian H [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysql Date: Fri, 23 Jan 2004 16:25:37 -0600 Is it possible for mysql 3.x and mysql 4.x to co-exist on the same machine. I currently have mysql 4.x installed

upgrading mysql

2004-01-22 Thread Christer Solskogen
It seems like some port i want to install depend on mysql4, but i have some programs that depends on mysql-client-3.23.58_1 ( I also have mysql-server-3.23.58_1 installed) I was wondering upgrading the mysql ports to 4.x series. should this be okay? gallery-1.4.1 ,p5-Mysql-modules-1.2219, php4

Re: upgrading mysql

2004-01-22 Thread Andrew L. Gould
On Thursday 22 January 2004 10:51 am, Christer Solskogen wrote: It seems like some port i want to install depend on mysql4, but i have some programs that depends on mysql-client-3.23.58_1 ( I also have mysql-server-3.23.58_1 installed) I was wondering upgrading the mysql ports to 4.x series

Re: upgrading mysql

2004-01-22 Thread Christer Solskogen
On Thursday 22 January 2004 10:51 am, Christer Solskogen wrote: It seems like some port i want to install depend on mysql4, but i have some programs that depends on mysql-client-3.23.58_1 ( I also have mysql-server-3.23.58_1 installed) I was wondering upgrading the mysql ports to 4.x series

Re: upgrading mysql

2004-01-22 Thread Matthew Seaman
On Thu, Jan 22, 2004 at 05:51:52PM +0100, Christer Solskogen wrote: It seems like some port i want to install depend on mysql4, but i have some programs that depends on mysql-client-3.23.58_1 ( I also have mysql-server-3.23.58_1 installed) I was wondering upgrading the mysql ports to 4.x

mysql files

2004-01-19 Thread Kostya Odnoralov
Hello! Could you please tell me, am i able to view mysql database files (3 - *.myd, *.frm, *.myi) without mysqld running? Is there any progie for this? Thanks. -- Best regards, Kostya mailto:[EMAIL PROTECTED] ___ [EMAIL

mysql and slow_query_log

2003-12-17 Thread Will Prater
List, I also have 'log-long-format' enabled, but this should have no affect. Thanks for any ideas. --will ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL

mysql and slow_query_log

2003-12-17 Thread Will Prater
List, I have log-slow-queries on and set my slow query time to 5. Weird thing is, all the queries are being logged hostname-slow.log. Even the ones at 0 seconds. Here is an example. What am I missing here? select alias from virtual where username = '[EMAIL PROTECTED]' and status = '1'

Re: MySQL 4.0.16 + PHP 4.3.4

2003-12-16 Thread The Bean
Thank you Jez! This was still a bit of a battle . . . until I grasped that mod_php was expecting Apache to have been build from a port! Or, at least it was expecting Apache's files to be located thus. So I killed my existing Apache, installed a new one from a port, and that's that. I hate the GNU

MySQL 4.0.16 + PHP 4.3.4

2003-12-15 Thread Chris
Hello all, I decided to upgrade to little test server to a more recent PHP MySQL (as well as Apache 2.0.48). Everything is working, but I still have a problem. I installed mysql from the port. I installed PHP from source, but no matter what I tried giving ./configure for the --with-mysql

Re: MySQL 4.0.16 + PHP 4.3.4

2003-12-15 Thread Josh Paetzel
On Mon, Dec 15, 2003 at 10:35:54AM -0800, Chris wrote: Hello all, I decided to upgrade to little test server to a more recent PHP MySQL (as well as Apache 2.0.48). Everything is working, but I still have a problem. I installed mysql from the port. I installed PHP from source

Re: MySQL 4.0.16 + PHP 4.3.4

2003-12-15 Thread Chris
makes perfect sense now that I think about it). Is it possible that I need to do ./configure --with-mysql=/usr/ports/mysql4-client/work to get it to work? Or, download the mysql 4.0.16 client source code, untar it, and point ./configure there? Seems wasteful. I'd happily do something more efficient

Re: MySQL 4.0.16 + PHP 4.3.4

2003-12-15 Thread Jez Hancock
On Mon, Dec 15, 2003 at 01:38:21PM -0800, Chris wrote: You know, it never occured to me that there were individual Apache modules in the ports. Thanks Josh! Doesn't look like it would help in this case, though, as the mod_php port is for Apache 1.3, and I need 2.0. I believe you can force

I'm having a hell of a time with mysql/apache/php

2003-12-10 Thread chip . wiegand
I installed 5.1 and need to install apache2/mysql/php. I did this a month ago and it worked great. Now I cannot get any of them to install. (I'm using the same cd, on a computer that is the same as the previous one). The errors keep coming back to the compiler. It says Checking if conversion

Re: I'm having a hell of a time with mysql/apache/php

2003-12-10 Thread Kevin D. Kinsey, DaleCo, S.P.
[EMAIL PROTECTED] wrote: I installed 5.1 and need to install apache2/mysql/php. I did this a month ago and it worked great. Now I cannot get any of them to install. (I'm using the same cd, on a computer that is the same as the previous one). The errors keep coming back to the compiler. It says

Re: I'm having a hell of a time with mysql/apache/php

2003-12-10 Thread Kevin D. Kinsey, DaleCo, S.P.
[EMAIL PROTECTED] wrote: I installed 5.1 and need to install apache2/mysql/php. I did this a month ago and it worked great. Now I cannot get any of them to install. (I'm using the same cd, on a computer that is the same as the previous one). The errors keep coming back to the compiler. It says

MySQL question...

2003-11-30 Thread Xpression
Hi all, I've finished installing MySQL on FreeBSD-4.5 RELEASE, now I've to add the users to control their databases, but I'm confused...where they will write their databases or do I have to create each one, I'm running as mysql user, they will have access to /mysql sub-dir ??? Can I create

Re: MySQL question...

2003-11-30 Thread Melvyn Sopacua
On Sunday 30 November 2003 17:36, Xpression wrote: Hi all, I've finished installing MySQL on FreeBSD-4.5 RELEASE, now I've to add the users to control their databases, but I'm confused... Right. Because this is not a FreeBSD issue but a MySQL issue. MySQL users have nothing to do

RE: MySQL question...

2003-11-30 Thread DG
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Melvyn Sopacua Sent: Monday, 1 December 2003 3:54 AM To: FreeBSD-questions Cc: Xpression Subject: Re: MySQL question... snip All databases will go under /var/db/mysql and the quick and dirty answer

Re: MySQL question...

2003-11-30 Thread Melvyn Sopacua
On Sunday 30 November 2003 22:57, DG wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Melvyn Sopacua Sent: Monday, 1 December 2003 3:54 AM To: FreeBSD-questions Cc: Xpression Subject: Re: MySQL question... snip All databases

MySQL question...

2003-11-28 Thread Xpression
Hi list, I've installed mysql-4.0.16.tar.gz on a FreeBSD-4.5 server, at least it compile, then I edit and copy the my-medium.cnf file to /etc/my.cnf location...when I reboot MySQL doesn't start...anyone running it ??? Or I have to do some steps to make running

Re: MySQL question...

2003-11-28 Thread ScaryG
On Fri, 28 Nov 2003 10:42:40 -0500 Xpression [EMAIL PROTECTED] wrote: |O|Hi list, I've installed mysql-4.0.16.tar.gz on a |O|FreeBSD-4.5 server, at least it compile, then I edit and |O|copy the my-medium.cnf file to /etc/my.cnf location...when I |O|reboot MySQL doesn't start...anyone

Can't start MySQL...

2003-11-28 Thread Xpression
Hi all, after install MySQL-4.0.16 it show me the following error: Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist...do I need to create such table ??? I'm testing it with mysqld_safe --user=mysql, usr/local/mysql/var is owned by mysql | mysql and chmod to 750...any

MySQL v3.23 and C API

2003-11-27 Thread Steve Blair
Hello: I'm working on a server running FreeBSD 4.7-RELEASE. I've developed a C server program that works fine. I want to add code to read from and update fields in a MySQL database to the original program. When I do I get compilation errors that I cannot seem to resolve. I have a number

Re: MySQL v3.23 and C API

2003-11-27 Thread Jean-Baptiste Quenot
* Steve Blair: The errors I get are as follows. I get these if using cc or gcc to compile the program. host# cc -o locserv locserv.c /tmp/ccJdDxg3.o: In function `main': /tmp/ccJdDxg3.o(.text+0x6ca): undefined reference to `mysql_init' /tmp/ccJdDxg3.o(.text+0x7bc): undefined reference

MySQL question...

2003-11-27 Thread Xpression
Hi list, I'm trying to install MySQL-4.0.16 on my FreeBSD-4.5 Server and always give me ERROR, anyone running it can help me ??? ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any

Re: mysql can't finf shared library

2003-11-17 Thread Ryan Merrick
object libmysqlclient.so.10 not found [EMAIL PROTECTED]:/etc# locate libmysql /usr/local/lib/mysql/libmysqlclient.a /usr/local/lib/mysql/libmysqlclient.so /usr/local/lib/mysql/libmysqlclient.so.10 Anybody know what's going on here? Is this a known bug? thanks, people, gary Hello, I have been

Re: mysql can't finf shared library

2003-11-17 Thread Uwe Doering
/local/lib/mysql/libmysqlclient.a /usr/local/lib/mysql/libmysqlclient.so /usr/local/lib/mysql/libmysqlclient.so.10 Anybody know what's going on here? Is this a known bug? Well, at least up to MySQL 3.23.58 a startup script '000.mysql-client.sh' gets installed under '/usr/local/etc/rc.d' which runs

Re: mysql can't finf shared library

2003-11-17 Thread Gary Kline
.10 not found [EMAIL PROTECTED]:/etc# locate libmysql /usr/local/lib/mysql/libmysqlclient.a /usr/local/lib/mysql/libmysqlclient.so /usr/local/lib/mysql/libmysqlclient.so.10 Anybody know what's going on here? Is this a known bug? Well, at least up to MySQL 3.23.58 a startup script

mysql can't finf shared library

2003-11-16 Thread Gary Kline
After upgrading to the latest mysql323-client and reinstalling my root password, here is what happens: mysqladmin -u root password 'fooobar1234' /usr/libexec/ld-elf.so.1: Shared object libmysqlclient.so.10 not found [EMAIL PROTECTED]:/etc# locate libmysql /usr/local/lib/mysql

Re: mysql can't finf shared library

2003-11-16 Thread Scott W
/local/lib/mysql/libmysqlclient.a /usr/local/lib/mysql/libmysqlclient.so /usr/local/lib/mysql/libmysqlclient.so.10 Anybody know what's going on here? Is this a known bug? thanks, people, gary Try the following: # export LD_LIBRARYPATH=$LD_LIBRARY_PATH:/usr/local/lib/mysql and then try

Re: mysql can't finf shared library

2003-11-16 Thread Mark
- Original Message - From: Gary Kline [EMAIL PROTECTED] To: FreeBSD Mailing List [EMAIL PROTECTED] Sent: Monday, November 17, 2003 1:07 AM Subject: mysql can't finf shared library After upgrading to the latest mysql323-client and reinstalling my root password, here is what happens

Re: mysql can't finf shared library

2003-11-16 Thread Ryan Merrick
/local/lib/mysql/libmysqlclient.a /usr/local/lib/mysql/libmysqlclient.so /usr/local/lib/mysql/libmysqlclient.so.10 Anybody know what's going on here? Is this a known bug? thanks, people, gary Hello, I have been seeing this too. I originaly fixed it with #mdconfig -m /usr/local/lib/mysql The LD

Re: mysql can't finf shared library

2003-11-16 Thread Gary Kline
On Mon, Nov 17, 2003 at 12:21:07AM +, Mark wrote: - Original Message - From: Gary Kline [EMAIL PROTECTED] To: FreeBSD Mailing List [EMAIL PROTECTED] Sent: Monday, November 17, 2003 1:07 AM Subject: mysql can't finf shared library After upgrading to the latest mysql323-client

Re: mysql can't finf shared library

2003-11-16 Thread Gary Kline
libmysqlclient.so.10 not found [EMAIL PROTECTED]:/etc# locate libmysql /usr/local/lib/mysql/libmysqlclient.a /usr/local/lib/mysql/libmysqlclient.so /usr/local/lib/mysql/libmysqlclient.so.10 Anybody know what's going on here? Is this a known bug? thanks, people, gary Hello, I

FreeBSD+Spamassassin+MySQL

2003-11-05 Thread whizkid
I cannot seem to get SpamAssassin working with MySQL 4 I have setup the MySQL database, have given a saconfig user full access to this database. But SA does not seem to Query the SQL database. I have a SquirrelMail plugin that connects to the DataBase just fine, and writes data

Problems using mysql-4.0 under 5.1-RELEASE

2003-10-28 Thread Frank Bartels
Heya all, I have big problems using mysql. I really tried so many different combinations of software and configurations, but it's always the same: mysqld crashes. My preferred setup: FreeBSD 5.1-RELEASE-p10 /usr/ports cvsupped daily perl-5.8.0_8 (will try 5.8.1 soon) mysql-server-4.0.16 mysql

Re: error with mysql when doing mysql -u root

2003-10-19 Thread Ion-Mihai Tetcu
On Sat, 20 Sep 2003 10:31:43 -0700 Shawn Guillemette [EMAIL PROTECTED] wrote: is there a way to reset the mysql root user passwd? I'm starting to wonder if I finger mumbled the passwd or something.. Start mysql with --skip-grant-tables Please red the docs. IOnut -- IOnut FreeBSD

Users mySQL User

2003-09-23 Thread H. Bartel
Hi, I have installed mySQL-Server on my freeBSD 4.8, and now I want to set it up. I can connect to the database with [EMAIL PROTECTED] and the according password, but I would like to add another user, which would then only be used to connect to the database server. Does this need to be another

Re: Users mySQL User

2003-09-23 Thread Technical Director
Holgar, No. MySQL supports users through the database manager itself. Once MySQL is running on the system you can add users to the user table found in the mysql database. Remember to 'flush privileges' once this is done to make the changes apply. It would also be a really good idea to think

Re: fBSD5.1 and pam-mysql troubles

2003-09-22 Thread Joe Lewis
I apologize - I forgot to request an off-list answer - I'm not on the list. Can anyone reply - again - directly to me this time? In addition - I hunted around quite a bit - I can't find the pam source code, there's not a pam package installed (except for pam-mysql), and there is a library

Re: error with mysql when doing mysql -u root

2003-09-22 Thread Sunil Sunder Raj
Hi, Hi, If you have set a root password, but forgot what it was, you can set a new password with the following procedure: 1) Take down the mysqld server by sending a kill (not kill -9) to the mysqld server. The pid is stored in a `.pid' file, which is normally in the MySQL database directory

mysql 4.0.14 LOAD DATA INFILE problems on freebsd 4.8

2003-09-21 Thread george donnelly
hi all, is anyone else having problems with importing data files into mysql 4? Regular users (who have all privs on their db's and usage on *.*) are unable to import files into a mysql 4.0.14 install on freebsd 4.8. the error is 1045 access denied, when using LOAD DATA INFILE. I have tried

error with mysql when doing mysql -u root

2003-09-20 Thread Shawn Guillemette
After setting the mysql root user passwd I get this when trying to log in. # mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Just after the install of mysql I had created a database as a test successfully

Re: error with mysql when doing mysql -u root

2003-09-20 Thread Shawn Guillemette
like this ? # mysql -u root -p password Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) if so is there a way I can reset the root' passwd for mysql? I have tried mysqladmin -u root passowrd newpassword and get this Shawn - Original Message

Re: error with mysql when doing mysql -u root

2003-09-20 Thread Kevin Kinsey
On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote: After setting the mysql root user passwd I get this when trying to log in. # mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) Just after the install of mysql I had created

Re: error with mysql when doing mysql -u root

2003-09-20 Thread Jan van Stekelenburg
On Sat, Sep 20, 2003 at 08:55:30AM -0700, Shawn Guillemette wrote: After setting the mysql root user passwd I get this when trying to log in. # mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) You forgot the -p option. For more info: http

<    10   11   12   13   14   15   16   17   >