RE: Installing Mysql on 9.0

2003-10-17 Thread Jason Staudenmayer
: Installing Mysql on 9.0 I found the mysql.sock under the tmp folder! I ran the mysqld program and saw error saying another mysql might be running. So I did ps -ae and found the follwoing 3056 ?00:00:00 mysqld_safe 3088 ?00:00:00 mysqld I tried to kill them but it's not going

Re: Installing Mysql on 9.0

2003-10-16 Thread Dali Islam
I deleted the mysql directory from the /usr/local folder and re-install. when I tried to run the the following commadn it didn't work. I ran the command from the /usr/local/myssql ./bin.mysqladmin -u root -h cscmail.rchaland.ibm.com password 'test1test' it came with the error: ./bin

RE: Installing Mysql on 9.0

2003-10-16 Thread Jason Staudenmayer
Did you start the server? /etc/rc.d/init.d/mysql start -Original Message- From: Dali Islam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 1:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Installing Mysql on 9.0 I deleted the mysql directory from the /usr

Re: Installing Mysql on 9.0

2003-10-16 Thread Dali Islam
After I ran the command from the /usr/loca/mysql/sql-bench folder perl run-all-tests I got the following error: GOT error: 'Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (2) when connecting to DBI:mysql:database=test;host=localhost with user: '' password

Re: Installing Mysql on 9.0

2003-10-16 Thread Eduardo A. dela Rosa
On Fri, 2003-10-17 at 02:24, Dali Islam wrote: After I ran the command from the /usr/loca/mysql/sql-bench folder perl run-all-tests I got the following error: GOT error: 'Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (2) when connecting to DBI:mysql:database

Re: Installing Mysql on 9.0

2003-10-16 Thread Dali Islam
--- Eduardo A. dela Rosa [EMAIL PROTECTED] wrote: On Fri, 2003-10-17 at 02:24, Dali Islam wrote: After I ran the command from the /usr/loca/mysql/sql-bench folder perl run-all-tests I got the following error: GOT error: 'Can't connect to local MySql server through socket '/var/lib

Re: Installing Mysql on 9.0

2003-10-16 Thread Dali Islam
I found the mysql.sock under the tmp folder! I ran the mysqld program and saw error saying another mysql might be running. So I did ps -ae and found the follwoing 3056 ?00:00:00 mysqld_safe 3088 ?00:00:00 mysqld I tried to kill them but it's not going away. kill 3056 kill 3088

Re: Installing Mysql on 9.0 New Problem

2003-10-16 Thread Dali Islam
--- Eduardo A. dela Rosa [EMAIL PROTECTED] wrote: On Fri, 2003-10-17 at 02:24, Dali Islam wrote: After I ran the command from the /usr/loca/mysql/sql-bench folder perl run-all-tests I got the following error: GOT error: 'Can't connect to local MySql server through socket '/var

Opensource web-based CRM software? ANy suggestions? Must use MySQL as database

2003-10-15 Thread Apollo (Carmel Entertainment)
I need your suggestions. So far I have found OSSuite (ossuite.org), but has some heavy quircks. Here is my situtation: The only thing that is keeping me from moving all desktops to Linux (no need to explain why) is that my Microsoft Access97 based front end (data is on MySQL) has been programmed

Re: Lousy answers [was: Re: Is mysql 4.x in future Redhat release]

2003-10-15 Thread Jim Herrick
Sounds like we need an FAQ! - Original Message - From: R Sánchez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 2:59 AM Subject: Lousy answers [was: Re: Is mysql 4.x in future Redhat release] Hi there list. I just felt something had to be said here

Re: Installing Mysql on 9.0

2003-10-15 Thread Dali Islam
--- Eduardo A. dela Rosa [EMAIL PROTECTED] wrote: shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make shell make install shell scripts/mysql_install_db

Re: Installing Mysql on 9.0

2003-10-15 Thread Eduardo A. dela Rosa
Title: Re: Installing Mysql on 9.0 Hi Dali, mysql dead but subsys locked. Normally this would happen if you've got a previous version of MySQL that was installed along with your RedHat OS. Try to uninstall it and also find the mysql.pid and delete it. If you find any mysql.pid, it may mean

Re: Is mysql 4.x in future Redhat release?

2003-10-14 Thread Edward Dekkers
Wayne Betts wrote: I'd like to know if Redhat has plans to incorporate mysql 4.x into a release sometime soon (instead of the current 3.x version). (I know that I can build/install mysql 4.0x myself if needed -- that's not my question.) Any info on redhat's adoption of mysql 4.x

Re: Is mysql 4.x in future Redhat release?

2003-10-14 Thread Jim Hayward
On Mon, 2003-10-13 at 12:32, Wayne Betts wrote: I'd like to know if Redhat has plans to incorporate mysql 4.x into a release sometime soon (instead of the current 3.x version). (I know that I can build/install mysql 4.0x myself if needed -- that's not my question.) Any info on redhat's

RE: Is mysql 4.x in future Redhat release?

2003-10-14 Thread Chris W. Parker
Edward Dekkers mailto:[EMAIL PROTECTED] on Monday, October 13, 2003 11:01 PM said: So why ask here? With one exception I know of, nobody here works at RedHat. Umm.. because in case you hadn't noticed, this is a Redhat mailing list. And in case that still doesn't make sense, it's a lot

Re: Is mysql 4.x in future Redhat release?

2003-10-14 Thread Edward Croft
On Tue, 2003-10-14 at 02:01, Edward Dekkers wrote: Wayne Betts wrote: I'd like to know if Redhat has plans to incorporate mysql 4.x into a release sometime soon (instead of the current 3.x version). (I know that I can build/install mysql 4.0x myself if needed -- that's not my question

GUI for MySQL and PHP

2003-10-14 Thread Dali Islam
Hi! Is there any free and good GUI program for MySQL and PHP on redhat 9.0? I just downloaded the Thanks Dali __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto

RE: GUI for MySQL and PHP

2003-10-14 Thread Nick Kishfy
Check out MySQL Control Center (AKA MyCC). http://www.mysql.com/downloads/mysqlcc.html. You can also use WebMin http://www.webmin.com. -Nick -Original Message- From: Dali Islam [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 2:28 PM To: redhat list Subject: GUI for MySQL

RE: GUI for MySQL and PHP

2003-10-14 Thread Mohit Raina - Infrastructure Monitoring Team
Hi, Phpadmin... you will find it on http://www.freshmeat.net Cheers! -Original Message- From: Dali Islam [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 11:58 PM To: redhat list Subject: GUI for MySQL and PHP Hi! Is there any free and good GUI program for MySQL and PHP

Re: GUI for MySQL and PHP

2003-10-14 Thread Ed Wilts
On Tue, Oct 14, 2003 at 11:28:00AM -0700, Dali Islam wrote: Hi! Is there any free and good GUI program for MySQL and PHP on redhat 9.0? phpmyadmin is quite good for working with mysql. I used it change table entries that my app wouldn't let me change, and then did a bulk upload of entries

Installing Mysql on 9.0

2003-10-14 Thread Dali Islam
This is my first time with mysql so bear with me. I installed the mysql-standard-4.0.15-pc-linux-i686.tar.gz and ran the following command, like it show on the mysql website. shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql

Re: Installing Mysql on 9.0

2003-10-14 Thread Eduardo A. dela Rosa
shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make shell make install shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql

Lousy answers [was: Re: Is mysql 4.x in future Redhat release]

2003-10-14 Thread R Sánchez
. Regards, Reven - Original Message - From: Edward Croft [EMAIL PROTECTED] To: Red Hat List [EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 6:36 PM Subject: Re: Is mysql 4.x in future Redhat release? | On Tue, 2003-10-14 at 02:01, Edward Dekkers wrote: | Wayne Betts wrote: | | I'd like

Is mysql 4.x in future Redhat release?

2003-10-13 Thread Wayne Betts
I'd liketo know if Redhat has plans to incorporate mysql 4.x into a releasesometime soon (instead of the current 3.x version). (I know that I can build/install mysql 4.0x myself if needed -- that's not my question.) Any info on redhat's adoption of mysql 4.x will be appreciated. Wayne

Re: Updating Apache/PHP/MySQL on RH8 or RH9

2003-10-12 Thread Paul Rushing
Alan McCoy wrote: Both RH8 and RH9 offer Apache 2.0.40, PHP 4.2.2, and MySQL 3.23.56 as the highest RPM-based upgrades for Apache/PHP/MySQL. How can I upgrade to the latest Apache (2.0.47), PHP (4.3.3), and MySQL (4.0.15) using RPMs on either a RH8 or RH9 without having to replace multitudes

Re: Updating Apache/PHP/MySQL on RH8 or RH9

2003-10-09 Thread John Nichel
Alan McCoy wrote: Both RH8 and RH9 offer Apache 2.0.40, PHP 4.2.2, and MySQL 3.23.56 as the highest RPM-based upgrades for Apache/PHP/MySQL. How can I upgrade to the latest Apache (2.0.47), PHP (4.3.3), and MySQL (4.0.15) using RPMs on either a RH8 or RH9 without having to replace multitudes

Re: Updating Apache/PHP/MySQL on RH8 or RH9

2003-10-09 Thread Parker Morse
On Thursday, Oct 9, 2003, at 10:34 US/Eastern, John Nichel wrote: Alan McCoy wrote: How can I upgrade to the latest Apache (2.0.47), PHP (4.3.3), and MySQL (4.0.15) using RPMs on either a RH8 or RH9 without having to replace multitudes of dependencies? Install from source? :) That's what I did

Re: MySql server on RH9

2003-10-08 Thread Nabin Limbu
Hi Parminder, RH 9 comes with both mysql server and mysql client. During installation it may be installed or may not be installed. You can verify by the command rpm -q mysql (for mysql client) rpm -q mysql-server (for mysql server) if both are found then you are done. you can start with them

Updating Apache/PHP/MySQL on RH8 or RH9

2003-10-08 Thread Alan McCoy
Both RH8 and RH9 offer Apache 2.0.40, PHP 4.2.2, and MySQL 3.23.56 as the highest RPM-based upgrades for Apache/PHP/MySQL. How can I upgrade to the latest Apache (2.0.47), PHP (4.3.3), and MySQL (4.0.15) using RPMs on either a RH8 or RH9 without having to replace multitudes of dependencies

Mysql installation problem (endless loop?)

2003-10-08 Thread Michiel v.d. linden
Hi all, I'm trying to install Mysql from the RH80 cd's. Right now it looks like I'm in a endless loop..see install efforts below [EMAIL PROTECTED] RPMS]# rpm -iv mysql-3.23.52-3.i386.rpm warning: mysql-3.23.52-3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e error: Failed dependencies

Re: Mysql installation problem (endless loop?)

2003-10-08 Thread Michael Schwendt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08 Oct 2003 23:06:59 +0200, Michiel v.d. linden wrote: I'm trying to install Mysql from the RH80 cd's. Right now it looks like I'm in a endless loop..see install efforts below [EMAIL PROTECTED] RPMS]# rpm -iv mysql-3.23.52-3.i386.rpm warning

MySql server on RH9

2003-10-06 Thread Parminder Singh Chauhan
Can any one please tell me is the Mysql server package is included in the RH9 when apache server is installed and run. I am using RH9 and not almost a newbee to linux OS systems and trying to learn it. I have setup and run the Apache server. Ineeded the MySql server as well. I could not find

Re: MySql server on RH9

2003-10-06 Thread Klaus Zahradnik
On Mon, Oct 06, 2003 at 11:25:34AM +0100, Parminder Singh Chauhan wrote: Can any one please tell me is the Mysql server package is included in the RH9 when apache server is installed and run. [...snip...] AFAIK you also need the mysql-client rpm installed. Then everything should be as you want

MySql Newbie

2003-10-03 Thread Richard F. Hobson
I am starting to work with MySql 4.x.(have it installed and running on my RH 9 machine) I am not new to relational databases (SqlServer, Informix), but am new to MySql. Can someone recommend the appropriate list when learning MySql from the ground-up? Thanks Rich Hobson -- Richard F. Hobson

Re: MySql Newbie

2003-10-03 Thread Michael Gargiullo
On Fri, 2003-10-03 at 11:15, Richard F. Hobson wrote: I am starting to work with MySql 4.x.(have it installed and running on my RH 9 machine) I am not new to relational databases (SqlServer, Informix), but am new to MySql. Can someone recommend the appropriate list when learning MySql from

Re: MySql Newbie

2003-10-03 Thread Hardy Merrill
I'm betting you can find the list you're looking for here http://lists.mysql.com/ -- Hardy Merrill Red Hat, Inc. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list

startin mysql when booting

2003-10-02 Thread Martin Røpcke
Hi, I am experimenting with mysql for the first time. I have to start mysql every time I boot to do work in my database. My question is where I have to make changes for mysql to start when booting. Also, I would like httpd to start automatically. Thanx Martin -- redhat-list mailing list

RE: startin mysql when booting

2003-10-02 Thread pwallett
I'll assume you are using runtime 3 rename /etc/rc3.d/K15httpd to S15httpd rename /etc/rc3.d/K12mysqld to S12mysqld You get the Idea Hi, I am experimenting with mysql for the first time. I have to start mysql every time I boot to do work in my database. My question is where I have to make

RE: startin mysql when booting

2003-10-02 Thread mr
I am very new to linux AND computers so please bear with me I'll assume you are using runtime 3 Don't know. How do I find out? rename /etc/rc3.d/K15httpd to S15httpd rename /etc/rc3.d/K12mysqld to S12mysqld You get the Idea No! Sorry, but you will have to guide me quite a bit. A

Re: startin mysql when booting

2003-10-02 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 02 October 2003 10:55 pm, [EMAIL PROTECTED] wrote: No! Sorry, but you will have to guide me quite a bit. A reference to where I can do my own studies is perfect. Don't want to be of any nuisance. Thankx Martin An introductory book

Re: startin mysql when booting

2003-10-02 Thread damovand
the Idea No! Sorry, but you will have to guide me quite a bit. A reference to where I can do my own studies is perfect. Don't want to be of any nuisance. Thankx Martin Hello, There's an easier way to start your mysql as a service that you won't have to change any files by hand. I remember

Re: startin mysql when booting

2003-10-02 Thread Jim Herrick
chkconfig mysql on chkconfig httpd on - Original Message - From: Martin Røpcke [EMAIL PROTECTED] To: RedHat List [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:56 AM Subject: startin mysql when booting Hi, I am experimenting with mysql for the first time. I have to start mysql

Re: startin mysql when booting

2003-10-02 Thread Reuben D. Budiardja
On Thursday 02 October 2003 05:56 am, Martin Røpcke wrote: Hi, I am experimenting with mysql for the first time. I have to start mysql every time I boot to do work in my database. My question is where I have to make changes for mysql to start when booting. Also, I would like httpd to start

Re: startin mysql when booting

2003-10-02 Thread Reuben D. Budiardja
On Thursday 02 October 2003 06:13 am, [EMAIL PROTECTED] wrote: I'll assume you are using runtime 3 rename /etc/rc3.d/K15httpd to S15httpd rename /etc/rc3.d/K12mysqld to S12mysqld Why would you do that? running chkconfig and setup is much preferred that dont require you to change around files

Re: startin mysql when booting

2003-10-02 Thread Michael Gargiullo
On Thursday 02 October 2003 05:56 am, Martin Rpcke wrote: Hi, I am experimenting with mysql for the first time. I have to start mysql every time I boot to do work in my database. My question is where I have to make changes for mysql to start when booting. Also, I would like httpd

Re: startin mysql when booting

2003-10-02 Thread Michael Schwendt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 2 Oct 2003 08:30:01 -0400, Reuben D. Budiardja wrote: On Thursday 02 October 2003 06:13 am, [EMAIL PROTECTED] wrote: I'll assume you are using runtime 3 rename /etc/rc3.d/K15httpd to S15httpd rename /etc/rc3.d/K12mysqld to S12mysqld

Re: startin mysql when booting

2003-10-02 Thread Reuben D. Budiardja
On Thursday 02 October 2003 10:15 am, Michael Schwendt wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 2 Oct 2003 08:30:01 -0400, Reuben D. Budiardja wrote: On Thursday 02 October 2003 06:13 am, [EMAIL PROTECTED] wrote: I'll assume you are using runtime 3 rename

Re: startin mysql when booting

2003-10-02 Thread Klaus Zahradnik
running level 5. I think it's more foolproof also. [...snip...] I was wondering... when you compile MySQL yourself, they provide a startup script which is supported by chkconfig. But building apache2 results in not having a proper chkconfig capable service on your box. And there are a billion

RH8.0 MySQL issues?

2003-09-07 Thread Kalin Mintchev
hi everybody, i have a redhat 8.0 with php and mysql. all the mysql functions that php uses run fine when called with a browser but when i try to run a script on the command line i get: # ./meLoop.php br / bFatal error/b: Call to undefined function: mysql_connect() in b~/meLoop.php/b on line b4

Re: RH8.0 MySQL issues?

2003-09-07 Thread Sean Estabrooks
On Sun, 7 Sep 2003 13:33:15 -0400 (EDT) Kalin Mintchev [EMAIL PROTECTED] wrote: i have a redhat 8.0 with php and mysql. all the mysql functions that php uses run fine when called with a browser but when i try to run a script on the command line i get: # ./meLoop.php br / bFatal error/b

Re: RH8.0 MySQL issues?

2003-09-07 Thread Kalin Mintchev
) Kalin Mintchev [EMAIL PROTECTED] wrote: i have a redhat 8.0 with php and mysql. all the mysql functions that php uses run fine when called with a browser but when i try to run a script on the command line i get: # ./meLoop.php br / bFatal error/b: Call to undefined function

Re: RH8.0 MySQL issues?

2003-09-07 Thread Sean Estabrooks
On Sun, 7 Sep 2003 14:57:26 -0400 (EDT) Kalin Mintchev [EMAIL PROTECTED] wrote: thanks for replying still notworking but i figured something out... apache is using the php under /usr/local/bin/php which is 4.3.0... so i changed my code to this: #!/usr/local/bin/php -q

Re: RH8.0 MySQL issues?

2003-09-07 Thread Kalin Mintchev
On Sun, 7 Sep 2003, Sean Estabrooks wrote: On Sun, 7 Sep 2003 14:57:26 -0400 (EDT) Kalin Mintchev [EMAIL PROTECTED] wrote: I suspected you had multiple versions of php which is why it the output of the php commands would have been useful. Perhaps that's what lead to your discovery ?

Re: RH8.0 MySQL issues?

2003-09-07 Thread Sean Estabrooks
On Sun, 7 Sep 2003 15:12:42 -0400 (EDT) Kalin Mintchev [EMAIL PROTECTED] wrote: On Sun, 7 Sep 2003, Sean Estabrooks wrote: On Sun, 7 Sep 2003 14:57:26 -0400 (EDT) Kalin Mintchev [EMAIL PROTECTED] wrote: I suspected you had multiple versions of php which is why it the output of

Re: RH8.0 MySQL issues?

2003-09-07 Thread Kalin Mintchev
Ok.. would have helped to have a slightly larger snippet of code. You will need the quotes.. and you'll also need ? ? brackets surrounding your script as in the example i sent earlier. thanks again ok... now i'm using your code with my user and pass. the script looks like this:

Re: RH8.0 MySQL issues?

2003-09-07 Thread Sean Estabrooks
On Sun, 7 Sep 2003 15:40:49 -0400 (EDT) Kalin Mintchev [EMAIL PROTECTED] wrote: Ok.. would have helped to have a slightly larger snippet of code. You will need the quotes.. and you'll also need ? ? brackets surrounding your script as in the example i sent earlier. thanks

Re: RH8.0 MySQL issues?

2003-09-07 Thread Kalin Mintchev
On Sun, 7 Sep 2003, Sean Estabrooks wrote: ./LL.php: line 3: ?: No such file or directory ./LL.php: line 4: syntax error near unexpected token `(' ./LL.php: line 4: ` $db = mysql_connect(localhost, myuser, mypass);' Kalin, Looks like now you're running into differences between

Re: RH8.0 MySQL issues?

2003-09-07 Thread Sean Estabrooks
On Sun, 7 Sep 2003 15:59:08 -0400 (EDT) Kalin Mintchev [EMAIL PROTECTED] wrote: Kalin, After some head scratching i finally see what it is... # /usr/local/bin/php -v PHP 4.3.0 (cli) (built: Apr 5 2003 06:38:17) Copyright (c) 1997-2002 The PHP Group Zend Engine v1.3.0, Copyright (c)

Re: Make connection to MySQL Server from another server

2003-09-04 Thread Benjamin J. Weiss
Hi all, can someone know how could i setup MySQL Server, so my PHP Application on another server can connect to MySQL Server A quick google for php mysql connect found http://us2.php.net/function.mysql-connect, which explains it pretty well. The only thing that they don't go

Re: Make connection to MySQL Server from another server

2003-09-04 Thread Rodolfo J. Paiz
At 08:19 9/4/2003 -0500, you wrote: For instance (and somebody please verify this, as I'm just learning to craft my own iptables rules): php machine: 192.168.1.100 mysql machine: 192.168.1.101 iptables rule on the mysql machine: -A RH-Lokkit-0-50-INPUT -p tcp -m tcp -s 192.168.1.100/32 --dport

Re: Make connection to MySQL Server from another server

2003-09-04 Thread Benjamin J. Weiss
At 08:19 9/4/2003 -0500, you wrote: For instance (and somebody please verify this, as I'm just learning to craft my own iptables rules): php machine: 192.168.1.100 mysql machine: 192.168.1.101 iptables rule on the mysql machine: -A RH-Lokkit-0-50-INPUT -p tcp -m tcp -s 192.168.1.100

Re: Make connection to MySQL Server from another server

2003-09-04 Thread steffen . grunewald
On Thu, Sep 04, 2003 at 11:32:07AM -0500, Benjamin J. Weiss wrote: Actually, I don't know whether MySQL uses udp or not, but the /etc/services file shows both tcp and udp ports for mysql, so I put them both in. Just a hint: insert a line with target LOG at the end of the iptables config file

PostgreSQL or MySQL on RedHat

2003-09-03 Thread Nick Marsh
I have been using MySQL on RedHat for about a year now. My hardcode geek friends keep telling me that PostgreSQL is better. Can anyone offer some insight as to the advantages of using one over the other? Thanks. nick marsh [EMAIL PROTECTED] -- redhat-list mailing list unsubscribe mailto

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Jason Dixon
On Wed, 2003-09-03 at 11:48, Nick Marsh wrote: I have been using MySQL on RedHat for about a year now. My hardcode geek friends keep telling me that PostgreSQL is better. Can anyone offer some insight as to the advantages of using one over the other? Thanks. Hi Nick. Please don't

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Ed Wilts
On Wed, Sep 03, 2003 at 10:48:16AM -0500, Nick Marsh wrote: I have been using MySQL on RedHat for about a year now. My hardcode geek friends keep telling me that PostgreSQL is better. Can anyone offer some insight as to the advantages of using one over the other? Start with Google. A search

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Reuben D. Budiardja
On Wednesday 03 September 2003 11:48 am, Nick Marsh wrote: I have been using MySQL on RedHat for about a year now. My hardcode geek friends keep telling me that PostgreSQL is better. Can anyone offer some insight as to the advantages of using one over the other? Thanks. This is more a database

Re: PostgreSQL or MySQL on RedHat [SOLVED]

2003-09-03 Thread Nick Marsh
Bad question for this list. Sorry. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Jonathan Bartlett
I have been using MySQL on RedHat for about a year now. My hardcode geek friends keep telling me that PostgreSQL is better. Can anyone offer some insight as to the advantages of using one over the other? Thanks. PostgreSQL has the following: * user-defined functions (can be defined from C

Re: PostgreSQL or MySQL on RedHat

2003-09-03 Thread Martin Marques
El Mié 03 Sep 2003 12:48, Nick Marsh escribió: I have been using MySQL on RedHat for about a year now. My hardcode geek friends keep telling me that PostgreSQL is better. Can anyone offer some insight as to the advantages of using one over the other? Thanks. Why use postgresql? 1) Triggers 2

Make connection to MySQL Server from another server

2003-09-03 Thread Anton NG
Hi all, can someone know how could i setup MySQL Server, so my PHP Application on another server can connect to MySQL Server thanks __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- redhat

Re: MYSQL Question Database Location

2003-09-02 Thread Sambit Nanda
and err-log. i am very much new to MYSQL. Can any one guide me with example pls. = Thanks, Sambit Nanda 203-553-3424 (O) -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list = Thanks, Sambit Nanda 203-553

Re: MYSQL Question Database Location

2003-09-02 Thread Aly Dharshi
Hi, I thought that they were in /var/lib/mysql if I am not wrong ! Cheers, Aly. On Tue, 2003-09-02 at 14:45, Sambit Nanda wrote: Hi Can any one aswer my question pls ? --- Sambit Nanda [EMAIL PROTECTED] wrote: I want to keep Multi instance of DB and log

Re: MYSQL Question Database Location

2003-09-02 Thread NfoCipher
that, and what should i define for different datadir and err-log. i am very much new to MYSQL. Can any one guide me with example pls. Just setup a rsync job to do this now and then. Add /var/lib/mysql to rsync.conf and just copy it straight off to another machine for backup

MYSQL Question Database Location

2003-09-01 Thread Sambit Nanda
I want to keep Multi instance of DB and log in different file system, I know i can keep or configure multi my.cnf but i am not sure how to configure that, and what should i define for different datadir and err-log. i am very much new to MYSQL. Can any one guide me with example pls. = Thanks

Re: MySQL Problem , Please Help

2003-08-31 Thread administrator
* libtemplate.so.1 http://at.rpmfind.net/opsys/linux/RPM/libtemplate.so.1.html So is it the same as libodbc.so.1 ? please give me version or more help , thanks alot Rigler, Steve wrote: As a disclaimer, I've never used ODBC with MySQL on RH, but I stepped through what you described and, with some

Re: PHP? MySQL? Or both?

2003-08-30 Thread Martin Marques
To start, I am not a MySQL user, though I had to test a couple of those servers once, so I don't have much experience on it. But lets see. El Vie 29 Ago 2003 12:46, Parker Morse escribió: Did you try to execute some small php script (just make a connection without a query) from the web

PHP? MySQL? Or both?

2003-08-29 Thread Parker Morse
I'm using RH 9.0 to run our web server. We set it up in the colocation center on Monday and moved eight of our ten sites in on Monday and Tuesday. Three of the sites already moved are PHP/MySQL sites. Intermittently, the database connection function in PHP will fail for two of those three

Re: PHP? MySQL? Or both?

2003-08-29 Thread Martin Marques
What do your mysql logs say? Did you try to execute some small php script (just make a connection without a query) from the web sites that have the problem? Look at the logs while you do this. How's the load on the mysql server? Pings are OK between the servers? El Jue 28 Ago 2003 20:29, Parker

Re: PHP? MySQL? Or both?

2003-08-29 Thread Parker Morse
Thanks for the clues, Martin: On Friday, Aug 29, 2003, at 07:47 US/Eastern, Martin Marques wrote: What do your mysql logs say? They only show the startup and shutdown. (I'm looking at host.example.com.err in the data directory, which is all I can find in the way of a log. Should there be more

MySQL Problem , Please Help

2003-08-28 Thread administrator
Hello I wanna use ODBC with MySQL over Redhat 9 , So i was following the OpenOffice.org 1.0, ODBC, and MySQL 'How-to' http://pbs.linux.net.pl/ksiazki/OOoMySQL.pdf As They stated , I should Add these Entries to /etc/odbcinst.ini Using The GUI utility ODBCconfig But i didnt find Driver

RE: MySQL Problem , Please Help

2003-08-28 Thread Rigler, Steve
As a disclaimer, I've never used ODBC with MySQL on RH, but I stepped through what you described and, with some adjustments, was able to successfully attach to a database with isql. First: /usr/lib/libmyodbc.so is on my system and came with the MyODBC package. my /etc/odbcinst.ini was already

MySQL/ODBC Help needed

2003-08-27 Thread administrator
Hello I wanna use ODBC with MySQL over Redhat 9 , So i was following the OpenOffice.org 1.0, ODBC, and MySQL 'How-to' http://pbs.linux.net.pl/ksiazki/OOoMySQL.pdf As They stated , I should Add these Entries to /etc/odbcinst.ini Using The GUI utility ODBCconfig But i didnt find Driver

Installing/Configuring unixODBC with MySQL over Redhat 9

2003-08-26 Thread administrator
Hello I wanna use ODBC with MySQL over Redhat 9 , So i was following the OpenOffice.org 1.0, ODBC, and MySQL 'How-to' http://pbs.linux.net.pl/ksiazki/OOoMySQL.pdf As They stated , I should Add these Entries to /etc/odbcinst.ini Using The GUI utility ODBCconfig But i didnt find Driver

mysql dead but subsys locked = ?

2003-08-14 Thread [EMAIL PROTECTED]
*This message was transferred with a trial version of CommuniGate(tm) Pro* hi, i'm getting an error : ~ mysql dead but subsys locked. when i try to run mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) i tried lots of things (googled). but i

Re: mysql dead but subsys locked = ?

2003-08-10 Thread [EMAIL PROTECTED]
] wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* hi, i'm getting an error : ~ mysql dead but subsys locked. when i try to run mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) i tried lots

Re: mysql dead but subsys locked = ?

2003-08-09 Thread Stephen Kuhn
On Fri, 2002-08-09 at 16:56, [EMAIL PROTECTED] wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* hi, i'm getting an error : ~ mysql dead but subsys locked. when i try to run mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib

Re: Apache, Mysql central-european charset

2003-08-08 Thread Lee Flier
On Tue, 2003-08-05 at 10:10, Alex wrote: I have a rh9 installed on a server that runs a forum (phpbb) and I need to use local translation (romanian). The thing is that I can't see special caracters like and such... I understand that I have to modify the settings for mysql and maybe apache

Apache, Mysql central-european charset

2003-08-06 Thread Alex
I have a rh9 installed on a server that runs a forum (phpbb) and I need to use local translation (romanian). The thing is that I can't see special caracters like â and such... I understand that I have to modify the settings for mysql and maybe apache, but I don't know how to modify and what should

Re: Pre-make 'configure' program can't find mysql libraries?

2003-08-02 Thread Michael Fratoni
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 01 August 2003 10:07 am, Benjamin J. Weiss wrote: [...] I'm runnning RedHat 8.0, with everything up2date. I hadn't had mysql-devel installed, so I installed that with up2date, cleared the config cache and tried it again. Again

Re: Pre-make 'configure' program can't find mysql libraries?

2003-08-02 Thread Michael Fratoni
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 02 August 2003 10:58 am, Michael Fratoni wrote: On Friday 01 August 2003 10:07 am, Benjamin J. Weiss wrote: my /etc/ld.so.conf looks like: /usr/kerberos/lib /usr/X11R6/lib /usr/lib/qt-3.0.5/lib /usr/lib/sane /usr/lib/mysql

Re: Pre-make 'configure' program can't find mysql libraries?

2003-08-02 Thread Benjamin J. Weiss
snip my /etc/ld.so.conf looks like: /usr/kerberos/lib /usr/X11R6/lib /usr/lib/qt-3.0.5/lib /usr/lib/sane /usr/lib/mysql /usr/include/mysql The mysql directory above looks suspect. It should be the path to the mysql libraries, not to the mysql include directory. Try replacing

Re: Pre-make 'configure' program can't find mysql libraries?

2003-08-02 Thread Benjamin J. Weiss
All, snip I set out to recompile Nagios with MySQL support. The first step is to run ./configure --with-mysql-xdata, but it's not finding the mysql libraries. Never used any of the software you mentioned, but did you check all the configuration option? Usually there is a configure

Pre-make 'configure' program can't find mysql libraries?

2003-08-01 Thread Benjamin J. Weiss
, and everything worked great. The only issue was that setting up all of the configuration files for each object was a serious pain in the neck. I then found Nagmin, a webmin module for Nagios. I got it installed, and it works great! Unfortunately, Nagmin uses MySQL (which I had installed

Re: Pre-make 'configure' program can't find mysql libraries?

2003-08-01 Thread Reuben D. Budiardja
On Friday 01 August 2003 10:07 am, Benjamin J. Weiss wrote: All, snip I set out to recompile Nagios with MySQL support. The first step is to run ./configure --with-mysql-xdata, but it's not finding the mysql libraries. Never used any of the software you mentioned, but did you check all

mysql backup?

2003-07-18 Thread Michael Sorrentino
Greetings list Currently, I'm using tar to backup the /var/lib/mysql directory four times a day. Is this sufficient or is it possible for tar to skip over some files that may be in use? There are a lot of DB's and I need to make sure I'm not missing data on backup. Any suggestions? -- redhat

Re: mysql backup?

2003-07-18 Thread SAQIB
we run mysqlhotcopy script to copy the database to a different slice on the disk, and then make the backup of that slice to a magnetic tape. /usr/local/mysql/bin/mysqlhotcopy password=your_passwd databasename /path/to/backup/dir mysqlhotcopy is a perl script that locks the table for updates

Re: My 1st C MySQL program

2003-07-09 Thread Gary Stainburn
On Tuesday 08 July 2003 7:40 pm, rm wrote: [snip] This is an excellent c programming board. Several very good programmers there. I'm sure that one of these two can help you. http://www.cprogramming.com/ [snip] This site seems to be very Windows centric - in fact all of the examples I've

Re: My 1st C MySQL program

2003-07-09 Thread MKlinke
On Wednesday 09 July 2003 14:06, Gary Stainburn wrote: Can anyone point me to a good generic, or even unix centric C programming site as I want to learn C too. Thanks all A number of suggestions in this recent thread ... http://marc.theaimsgroup.com/?l=redhat-listm=105674455408012w=2

My 1st C MySQL program

2003-07-08 Thread Ricardo Striquer Soares
Hi there .. I just copy-past the test program at the chapter 9 (MySQL APIs the test_libmysqld.c) and have the undefined reference to mysql_server_init error at that, no problem, i added the declaration at the program itself, but it still don't work, sometimes is undefined reference other times

Re: My 1st C MySQL program

2003-07-08 Thread rm
The mysql mailing list is: [EMAIL PROTECTED] You have to first sign up at the mysql site (I think) This is an excellent c programming board. Several very good programmers there. I'm sure that one of these two can help you. http://www.cprogramming.com/ My hunch is that, as your search

  1   2   3   4   5   6   7   8   >