RE: Installing Mysql on 9.0
/etc/rc.d/init.d/mysqld stop Or mysqladmin shutdown And then start the server back up /etc/rc.d/init.d/mysqld start Or safe_mysqld -Original Message- From: Dali Islam [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 9:09 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: 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 away. kill 3056 kill 3088 --- 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/mysql/mysql.sock' (2) when connecting to DBI:mysql:database=test;host=localhost with user: '' password '' Go check and edit the /etc/my.cnf: 1. look for the line that contains the following: [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock 2. in both section (client mysql) replace the value of socket to: socket = /tmp/mysql.sock 3. try running the mysqld (folder /usr/local/mysql/bin should be in your $PATH) 4. then check the file /tmp/mysql.sock (it should exist) 5. your run-all-test should post no problem. Cheers! -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Installing Mysql on 9.0
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/mysqladmin: connect to server at 'cscmail.rchland.ibm.com' failed error: 'Lost coonection to MySql server during query' What is miising? If i need to do anything with the hosts table! --- Eduardo A. dela Rosa [EMAIL PROTECTED] wrote: 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 that a previously running mysqld failed to shutdown properly. HTH. -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RE: Installing Mysql on 9.0
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/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/mysqladmin: connect to server at 'cscmail.rchland.ibm.com' failed error: 'Lost coonection to MySql server during query' What is miising? If i need to do anything with the hosts table! --- Eduardo A. dela Rosa [EMAIL PROTECTED] wrote: 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 that a previously running mysqld failed to shutdown properly. HTH. -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Installing Mysql on 9.0
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 '' --- Dali Islam [EMAIL PROTECTED] wrote: 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/mysqladmin: connect to server at 'cscmail.rchland.ibm.com' failed error: 'Lost coonection to MySql server during query' What is miising? If i need to do anything with the hosts table! --- Eduardo A. dela Rosa [EMAIL PROTECTED] wrote: 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 that a previously running mysqld failed to shutdown properly. HTH. -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Installing Mysql on 9.0
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=test;host=localhost with user: '' password '' Go check and edit the /etc/my.cnf: 1. look for the line that contains the following: [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock 2. in both section (client mysql) replace the value of socket to: socket = /tmp/mysql.sock 3. try running the mysqld (folder /usr/local/mysql/bin should be in your $PATH) 4. then check the file /tmp/mysql.sock (it should exist) 5. your run-all-test should post no problem. Cheers! -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein
Re: Installing Mysql on 9.0
--- 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/mysql/mysql.sock' (2) when connecting to DBI:mysql:database=test;host=localhost with user: '' password '' Go check and edit the /etc/my.cnf: 1. look for the line that contains the following: [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock 2. in both section (client mysql) replace the value of socket to: socket = /tmp/mysql.sock 3. try running the mysqld (folder /usr/local/mysql/bin should be in your $PATH) 4. then check the file /tmp/mysql.sock (it should exist) 5. your run-all-test should post no problem. Cheers! -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein Thanks a lot to help me solve this mysqld problem! I looked for the mysql.sock under the tmp folder and didn't see it. What should I do? Why that file is not there? Can I copy it from somewhere else? __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: 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 away. kill 3056 kill 3088 --- 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/mysql/mysql.sock' (2) when connecting to DBI:mysql:database=test;host=localhost with user: '' password '' Go check and edit the /etc/my.cnf: 1. look for the line that contains the following: [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock 2. in both section (client mysql) replace the value of socket to: socket = /tmp/mysql.sock 3. try running the mysqld (folder /usr/local/mysql/bin should be in your $PATH) 4. then check the file /tmp/mysql.sock (it should exist) 5. your run-all-test should post no problem. Cheers! -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Installing Mysql on 9.0 New Problem
--- 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/mysql/mysql.sock' (2) when connecting to DBI:mysql:database=test;host=localhost with user: '' password '' Go check and edit the /etc/my.cnf: 1. look for the line that contains the following: [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock 2. in both section (client mysql) replace the value of socket to: socket = /tmp/mysql.sock 3. try running the mysqld (folder /usr/local/mysql/bin should be in your $PATH) 4. then check the file /tmp/mysql.sock (it should exist) 5. your run-all-test should post no problem. Cheers! -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein I got further now, now I got a differetn error: [EMAIL PROTECTED] sql-bench]# ./run-all-tests install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at (eval 51) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. I did a rpm -q perl and it shows the perl-5.8.0-88.3 is installed. Please advise! Also I had to go in the sql-bench to run the run-all-parts even though I have the /usr/local/mysql/bin in my path. Thanks Dali __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Opensource web-based CRM software? ANy suggestions? Must use MySQL as database
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 in 1998 and has tons of VB code. So I will need to go from ground up on our customer data/contracts, good timing to put in a new system. Basicly I am looking for web-based (Linux server with MySQL for database is a must) CRM opensource software. Anyone has ideas? My budget is $0. Salesforce.com about $200 per user per year for 7 users was rejected by my DirofOps, they hate monthly cost for something that does not fit us 100% and will take a lot of time in training, but they also don't want to spend money upfront. It is understandable, since we are a 7 people company and all of us still have jobs, cause we are cheap on our operations :-( Just as a background, this is what our Access frontend does: 1. Clietn contact information and billing 2. Products information - bookings for our artists (musicians), so they usualy have several configuration 3. Contracts 4. Simple mailmerge stuff for mailings and some reports. Contracts is the hardest part. Also, I must use MySQL since I am planning to tie in QuickBooks into this whole thing so there is no double entering. Since our accountant only does QuickBooks and there is no way we can afford to get somebody new and train them I will have to stick with quickbooks. Thank you in advance, Apolinaras Apollo Sinkevicius - Visit CARMEL MUSIC ENTERTAINMENT website http://carmelme.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Lousy answers [was: Re: Is mysql 4.x in future Redhat release]
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. In the last few weeks I've seen a lot of really lousy answers, the most of them with the Red Hat 10/Fedora stuff, but there have been others. Every now and then someone new stops in to the list and asks a question everybody else has already made. Of course google'n before asking would reduce mail load on the list, but maybe a newbie is stunned by 23 results, most of them speaking of things he/her doesn't really understand yet. Maybe it's easier to get a direct and simple answer form someone who had/has the same problem and has already solved it. As far as I remember, it's not mandatory for someone to answer. So if you don't have anything intelligent to say, just shut your mouth. I'm sure if we check the list's stats, absurd answers talking about google, any other search engine or references like check a post from 1967 when this was already..., might sum the same load than all the questions made twice. The point is: if talking (again) about a subject really annoys you, then simply don't talk. You'll be more polite that way. Maybe your crappy answers annoy the list even more that a repeated question annoys you. 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 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 will be appreciated. | | Wayne | | So why ask here? With one exception I know of, nobody here works at RedHat. | | Regards, | Ed. | | Well, gee Ed, I think the fact that this is a Red Hat list and that maybe just maybe, | someone in a Red Hat list might just know something. Really! I love how some people in | this group spout off about netiquette and such. Don't top post, no html, don't ask questions | unless you have googled, alta vista'ed, yahooed, wrote the pope, gotten | thirteen signatures and kissed someones arse. Just the other day, | someone came back into the group and asked about RHL 10. He got jumped | on and told that before he asked a question to go to the archives, | google, etc. Sorry, I am not that rude... [trimmed] -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Installing Mysql on 9.0
--- 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 shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql hi Dali, What you've just followed are procedures for the impatients. You may miss some essential explanations if you don't read them. Nonetheless, I would advise you take the binary distribution to not complicate things further. After all, you would only require source distribution if you need to tweak or modify MySQL DB Server. Using binary distribution: 1. I presume that you've been installing as root; 2. After creating group and user for mysql account, unzip the package using the command: shell tar -xzf mysql-version.tar.gz; 3. Rather than creating link to your /usr/local/mysql, I suggest moving the unzipped folder to /usr/local as mysql itself: shell mv mysq-version /usr/local/mysql 4. cd to /usr/local/mysql; 5. Run the script to initialize the database: shell scripts/mysql_install_db 6. Change ownership of mysql folder to root and mysql: shell chown -R root:mysql /usr/local/mysql 7. change ownership of data to mysql: shell chown -R mysql:mysql /usr/local/mysql/data 8. copy support-files/my-xxx.cnf to /etc/my.cnf; 9. I would suggest including /usr/local/mysql/bin to your $PATH; 10. Try to run mysql server using: shell mysqld 11. For security purposes, never forget to change password for the superuser of your mysql. HTH. -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list Yep! It worked good. I never thought about moving the file. Thanks. One problem I'm seeing now is after when I ran the 'mysqld' command, it ave me the following error: mysqld dead but subsys locked I had the mysql partially loaded last time, I thinkit is doing it because of that. How can I uninstall the package and tru it again or is there any other way to fix it? Thanks Dali __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Installing Mysql on 9.0
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 that a previously running mysqld failed to shutdown properly. HTH. -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein
Re: Is mysql 4.x in future Redhat release?
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 will be appreciated. Wayne So why ask here? With one exception I know of, nobody here works at RedHat. Regards, Ed. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Is mysql 4.x in future Redhat release?
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 adoption of mysql 4.x will be appreciated. Check the list archives this has been discussed before. MySQL changed their licensing policy for the 4.x releases and this licensing change is preventing Red Hat from shipping the 4.x releases. I don't recall what the exact problem is, but I believe it had something to do with linking against the 4.x libraries. Regards, Jim H -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RE: Is mysql 4.x in future Redhat release?
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 more likely that someone on a Redhat sponsored mailing list would know what's going on at Redhat than would a basket weaving mailing list. That's why you'd ask here. And besides, you don't have to work somewhere to know what's going on at that place. People have friends you know. c. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
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 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 will be appreciated. Wayne So why ask here? With one exception I know of, nobody here works at RedHat. Regards, Ed. Well, gee Ed, I think the fact that this is a Red Hat list and that maybe just maybe, someone in a Red Hat list might just know something. Really! I love how some people in this group spout off about netiquette and such. Don't top post, no html, don't ask questions unless you have googled, alta vista'ed, yahooed, wrote the pope, gotten thirteen signatures and kissed someones arse. Just the other day, someone came back into the group and asked about RHL 10. He got jumped on and told that before he asked a question to go to the archives, google, etc. Sorry, I am not that rude. A buddy of mine walks into the bar and sits down with me and asks how I am doing, I don't tell him to check the paper first to see if I am in the obits! Sheesh, with the length of the response, the person could have just been told that there was no RHL10, that Fedora Project was the replacement and given the URL. Really, I think a little common courtesy and a little less rudeness can go a long way, especially with the newbies that come in here for help. We snap their heads off and tell them to google first, or tell them that the question has been answered go search the archives. Damn! I know I wouldn't stick around if I was a newbie. I know I couldn't count on the people here for help. Sheesh, if I want rude help, I would contact Verizon or M$. If you don't want to answer a question, then don't. There is no need to be rude to people. Stepping off of soapbox, tripping, falling face first into a vat of strawberry jello. H, now where is that whipped cream? Ed -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
GUI for MySQL and PHP
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:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RE: GUI for MySQL and PHP
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 and PHP 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:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RE: GUI for MySQL and PHP
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 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:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: GUI for MySQL and PHP
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. No problems at all. I'm not a DBA but even I can work with phpmyadmin. webmin is also not too bad, but not in the phpmyadmin class. -- Ed Wilts, Mounds View, MN, USA mailto:[EMAIL PROTECTED] Member #1, Red Hat Community Ambassador Program -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Installing Mysql on 9.0
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-VERSION shell ./configure --prefix=/usr/local/mysql shell make shell make install shell scripts/mysql_install_db shell chown -R root /usr/local/mysql but when I triend to run the followng command it didn't work as I do not have the files in the /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql Then I tried to create a ln shell cd /software/mysql-standard-4.0.15-pc-linux-i686.tar.gz shellln -s mysql-standard-4.0.15-pc-linux-i686.tar.gz /usr.local/mysql Still it didn't fix it! Then I went to /usr/local/mysql I just see one file mysql-standard-4.0.15-pc-linux-i686.tar.gz highlighted. What am I missing? __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Installing Mysql on 9.0
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 /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql hi Dali, What you've just followed are procedures for the impatients. You may miss some essential explanations if you don't read them. Nonetheless, I would advise you take the binary distribution to not complicate things further. After all, you would only require source distribution if you need to tweak or modify MySQL DB Server. Using binary distribution: 1. I presume that you've been installing as root; 2. After creating group and user for mysql account, unzip the package using the command: shell tar -xzf mysql-version.tar.gz; 3. Rather than creating link to your /usr/local/mysql, I suggest moving the unzipped folder to /usr/local as mysql itself: shell mv mysq-version /usr/local/mysql 4. cd to /usr/local/mysql; 5. Run the script to initialize the database: shell scripts/mysql_install_db 6. Change ownership of mysql folder to root and mysql: shell chown -R root:mysql /usr/local/mysql 7. change ownership of data to mysql: shell chown -R mysql:mysql /usr/local/mysql/data 8. copy support-files/my-xxx.cnf to /etc/my.cnf; 9. I would suggest including /usr/local/mysql/bin to your $PATH; 10. Try to run mysql server using: shell mysqld 11. For security purposes, never forget to change password for the superuser of your mysql. HTH. -- EDUARDO A. DELA ROSA MCOM/2414 http://www.smart.com.ph Anyone who has never made a mistake has never tried anything new. -- Albert Einstein -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Lousy answers [was: Re: Is mysql 4.x in future Redhat release]
Hi there list. I just felt something had to be said here. In the last few weeks I've seen a lot of really lousy answers, the most of them with the Red Hat 10/Fedora stuff, but there have been others. Every now and then someone new stops in to the list and asks a question everybody else has already made. Of course google'n before asking would reduce mail load on the list, but maybe a newbie is stunned by 23 results, most of them speaking of things he/her doesn't really understand yet. Maybe it's easier to get a direct and simple answer form someone who had/has the same problem and has already solved it. As far as I remember, it's not mandatory for someone to answer. So if you don't have anything intelligent to say, just shut your mouth. I'm sure if we check the list's stats, absurd answers talking about google, any other search engine or references like check a post from 1967 when this was already..., might sum the same load than all the questions made twice. The point is: if talking (again) about a subject really annoys you, then simply don't talk. You'll be more polite that way. Maybe your crappy answers annoy the list even more that a repeated question annoys you. 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 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 will be appreciated. | | Wayne | | So why ask here? With one exception I know of, nobody here works at RedHat. | | Regards, | Ed. | | Well, gee Ed, I think the fact that this is a Red Hat list and that maybe just maybe, | someone in a Red Hat list might just know something. Really! I love how some people in | this group spout off about netiquette and such. Don't top post, no html, don't ask questions | unless you have googled, alta vista'ed, yahooed, wrote the pope, gotten | thirteen signatures and kissed someones arse. Just the other day, | someone came back into the group and asked about RHL 10. He got jumped | on and told that before he asked a question to go to the archives, | google, etc. Sorry, I am not that rude... [trimmed] -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Is mysql 4.x in future Redhat release?
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
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 of dependencies? Difficult question without knowing why you need to upgrade those packages?Redhat's packages are supposed to be stable, not the latest version. Are you worried about vulnerabilities in the older versions ? Redhat back ports most security fixes into their current version as updates / errata, so that's not really an issue. Are you needing some new feature in MySQL or php? Then you probably need to install from source or make a src.rpm for the package. Once you install something like that from source, you have to provide updates for it. You'll need to monitor the support lists for those packages and fix any security issues that arise. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Updating Apache/PHP/MySQL on RH8 or RH9
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 of dependencies? Or should I bite the bullet and dig through all the dependencies needed to upgrade? What's the best/easiest/cleanest way to do this? Install from source? :) -- By-Tor.com It's all about the Rush http://www.by-tor.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Updating Apache/PHP/MySQL on RH8 or RH9
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, actually. For what it's worth, the MySQL installation was using binary tarballs, not source, which made it a chunk easier. This page was helpful: http://www.devside.net/ pjm -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: MySql server on RH9
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. You should find mysqladmin also. if both are not installed then you can install them from CD. but this process demands you lots of other dependencies programs also. So the easier way is to go to Add Remove program and inside database, click Mysql and install Mysql server. This will ease your work. Nabin Limbu On 6 Oct 2003 at 11:25, 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. 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 mysqladmin commands anywhere in my system so i downloaded the rpms MySQL-server-4.0.15-0.i386.rpm and MySQL-shared-compat-4.0.15-0.i386.rpm and installed with the command rpm -U rpms even after installing the I can't find these commands to manage MySql. Now I tried to rpm -e rpm wihich complains about some dependency problems. Can anyone please help me to sort this out as I am not very good on linux. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Updating Apache/PHP/MySQL on RH8 or RH9
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? Or should I bite the bullet and dig through all the dependencies needed to upgrade? What's the best/easiest/cleanest way to do this? Alan -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Mysql installation problem (endless loop?)
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: perl-DBD-MySQL is needed by mysql-3.23.52-3 [EMAIL PROTECTED] RPMS]# rpm -iv perl-DBD-MySQL-2.1017-3.i386.rpm warning: perl-DBD-MySQL-2.1017-3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e error: Failed dependencies: libmysqlclient.so.10 is needed by perl-DBD-MySQL-2.1017-3 [EMAIL PROTECTED] RPMS]# rpm -iv mysql-server-3.23.52-3.i386.rpm warning: mysql-server-3.23.52-3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e error: Failed dependencies: mysql = 3.23.52 is needed by mysql-server-3.23.52-3 libmysqlclient.so.10 is needed by mysql-server-3.23.52-3 I read in the archive that the libmysqlclient.so.10 is in the mysql-server-3.23.52-3.i386.rpm package, but I cannot install that because before i can install the mysql-server-3.23.52-3.i386.rpm I must install perl-DBD-MySQL-2.1017-3.i386.rpm package but that I cannot install because it depends on libmysqlclient.so.10 !!! Any suggestion very much appreciated. Regards Michiel -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Mysql installation problem (endless loop?)
-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-3.23.52-3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.52-3 [EMAIL PROTECTED] RPMS]# rpm -iv perl-DBD-MySQL-2.1017-3.i386.rpm [snip] Install all packages _at once_, that means tell rpm -ivh about all package file names at once. E.g. rpm -ivh mysql-3.23.52-3.i386.rpm perl-DBD-MySQL-2.1017-3.i386.rpm [and so on...] Or move all packages in a separate directory and then let the shell work for you: rpm -ivh *.i386.rpm - -- Michael, who doesn't reply to top posts and complete quotes anymore. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQE/hI8e0iMVcrivHFQRAtBmAJ91dE4R86iIGcK+wdMRYd9YpWCYzwCfQyPQ hlOADabWCMo5noHZ4SwBJ2U= =i0i4 -END PGP SIGNATURE- -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
MySql server on RH9
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 mysqladmin commands anywhere in my system so i downloaded the rpms MySQL-server-4.0.15-0.i386.rpm and MySQL-shared-compat-4.0.15-0.i386.rpm and installed with the command rpm -U rpms even after installing the I can't find these commands to manage MySql. Now I tried to rpm -e rpm wihich complains about some dependency problems. Can anyone please help me to sort this out as I am not very good on linux. -- Parminder Singh Chauhan
Re: MySql server on RH9
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 it. Can anyone please help me to sort this out as I am not very good on linux. -- Parminder Singh Chauhan best regards Klaus -- Klaus Zahradnik Systemadministrator iNet Gruppe T: +43 2622 244 8032 H: +43 6991 444 8006 I: www.inetgruppe.at -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
MySql Newbie
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 [EMAIL PROTECTED] Hobson Renaissance Solutions LLC www.rhobson.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: MySql Newbie
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 the ground-up? Thanks Rich Hobson -- Richard F. Hobson [EMAIL PROTECTED] Hobson Renaissance Solutions LLC www.rhobson.com CHeck the MySQL site http://lists.mysql.com -- Michael Gargiullo [EMAIL PROTECTED] Warp Drive Networks -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: MySql Newbie
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
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 unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RE: startin mysql when booting
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 changes for mysql to start when booting. Also, I would like httpd to start automatically. Thanx Martin -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RE: startin mysql when booting
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 reference to where I can do my own studies is perfect. Don't want to be of any nuisance. Thankx Martin -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
-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 on how unix initializes and starts its system would be good. But, maybe you can find one of the topic in http://tldp.org, www.linux-mandrake.com, www.redhat.com - -- Fajar http://linux.arinet.org Linux mdk91.sistek.kom 2.4.21-0.13mdk GNU/Linux 18:01:38 up 10:25, 10 users, load average: 3.66, 2.97, 2.05 Quote of the day: Q: How many Microsoft support staff does it take to change a light bulb? A: Four. One to ask What is the registration number of the light bulb?, one to ask Have you tried rebooting it?, another to ask Have you tried reinstalling it? and the last one to say It must be your hardware because the light bulb in our office works fine... -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/fAYIMai9kCFqACoRAhxHAKC/CUqOWu7cqwPxXcZ6aOq4Yo9OJgCfdRws lVy3pdhhCXwp9izocZBwMoc= =h4sQ -END PGP SIGNATURE- -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
On Thursday 02 October 2003 07:55 am, [EMAIL PROTECTED] wrote: 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 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 when I installed (upgraded) my MySQL I found some detailed instructions on MySQL sites on setting it as service (meaning it'll come up at boot time). Briefly, there's is executable that comes with your installation if you run it it'll set the necessary files. I did this last year for my Linux and then again for XP windows so the details of each system are a bit fuzzy but I'm confident there's something that you can run to change your set up. Leila -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
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 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 unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
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 automatically. Thanx Martin if you installed mysql and httpd from RPM, you can control it using redhat's chkconfig. As root in console: $ chkconfig mysqld on $ chkconfig mysqld off see also: man chkconfig RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
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 in rc3.d. And it will take care of it even if you running level 5. I think it's more foolproof also. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ - Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. - -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
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 to start automatically. Thanx Martin Type #ntsysv This will pull up a menu that will allow you to select what services you want to start at boot time. -- Michael Gargiullo [EMAIL PROTECTED] Warp Drive Networks -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
-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 Why would you do that? running chkconfig and setup is much preferred that dont require you to change around files in rc3.d. And it will take care of it even if you running level 5. I think it's more foolproof also. K15 - S15 would also start httpd much earlier than many other services. S85 would be the default. - -- Michael, who doesn't reply to top posts and complete quotes anymore. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQE/fDL40iMVcrivHFQRAmd9AJ98lS0tWNebRGky6SkZ9IasPN/WIACeL8n4 /O5vhrah+1qd5KCL11z7rzg= =DuyB -END PGP SIGNATURE- -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
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 /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 in rc3.d. And it will take care of it even if you running level 5. I think it's more foolproof also. K15 - S15 would also start httpd much earlier than many other services. S85 would be the default. But for what purpose? few second earlier during reboot does not matter much. chkconfig handles the services more cleanly and nicely, why bother renaming files. I still don't see the point. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: startin mysql when booting
Am Donnerstag, 2. Oktober 2003 16:15 schrieb Michael Schwendt: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [...snip...] Why would you do that? running chkconfig and setup is much preferred that dont require you to change around files in rc3.d. And it will take care of it even if you 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 reasons why I need to compile apache rather than using an rpm. How or where can I get a chkconfig compatible apache startup script? best regards Klaus -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RH8.0 MySQL issues?
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/bbr / the php is compiled with mysql support and it runs fine (again) when called with a browser only the mysql functions within php are not working everything else seems to be fine... any ideas? pleas help - this is the last piece of a very large project i have to deliver tomorrow, monday thank you... -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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: Call to undefined function: mysql_connect() in b~/meLoop.php/b on line b4/bbr / Pretty hard to help without seeing an example script you're trying to run. Please post the smallest script you can write that demonstrates the problem. For instance, the following works properly here: #!/usr/bin/php -q ? $db = mysql_connect(localhost, test, password); mysql_select_db(zorum,$db); $result = mysql_query(SELECT * FROM box_zorum,$db); printf(l1: %s\n, mysql_result($result,0,content)); ? prints: l1: DB_test_content1 Also please post the output of these two commands: php -v php -i | grep -i mysql support Cheers, Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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 mysql_connect(localhost, 'user', 'pass'); _ just this now i get this: # ./meLoop.php ./meLoop.php: line 5: syntax error near unexpected token `localhost,' ./meLoop.php: line 5: `mysql_connect(localhost, 'user', 'pass');' please help thanks... On Sun, 7 Sep 2003, Sean Estabrooks wrote: 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: Call to undefined function: mysql_connect() in b~/meLoop.php/b on line b4/bbr / Pretty hard to help without seeing an example script you're trying to run. Please post the smallest script you can write that demonstrates the problem. For instance, the following works properly here: #!/usr/bin/php -q ? $db = mysql_connect(localhost, test, password); mysql_select_db(zorum,$db); $result = mysql_query(SELECT * FROM box_zorum,$db); printf(l1: %s\n, mysql_result($result,0,content)); ? prints: l1: DB_test_content1 Also please post the output of these two commands: php -v php -i | grep -i mysql support Cheers, Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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 mysql_connect(localhost, 'user', 'pass'); _ just this now i get this: # ./meLoop.php ./meLoop.php: line 5: syntax error near unexpected token `localhost,' ./meLoop.php: line 5: `mysql_connect(localhost, 'user', 'pass');' please help thanks... 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 ? Anyway, you're script needs quotations around localhost. Cheers, Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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 ? Anyway, you're script needs quotations around localhost. i did try single and double - same thing... same error... Cheers, Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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 the php commands would have been useful. Perhaps that's what lead to your discovery ? Anyway, you're script needs quotations around localhost. i did try single and double - same thing... same error... 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. Good luck, Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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: #!/usr/local/bin/php -q ? $db = mysql_connect(localhost, myuser, mypass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM mytable,$db); printf(l1: %s\n, mysql_result($result,0,content)); ? __this is all of it i get this: # ./LL.php ./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);' why ? should be a file. thanks... Good luck, Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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 again ok... now i'm using your code with my user and pass. the script looks like this: #!/usr/local/bin/php -q ? $db = mysql_connect(localhost, myuser, mypass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM mytable,$db); printf(l1: %s\n, mysql_result($result,0,content)); ? __this is all of it i get this: # ./LL.php ./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 versioins of php. You still haven't mentioned what version of php you're using. You might try replacing ? with ?php and see if that works for you. Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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 versioins of php. You still haven't mentioned what version of php you're using. You might try replacing ? with ?php and see if that works for you. thanks Sean here 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) 1998-2002 Zend Technologies with ?php in it i get that there isn't any file calld ?php... Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: RH8.0 MySQL issues?
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) 1998-2002 Zend Technologies Looks like you've compiled or installed a non redhat version of php that is configured for command line interface. Notice the (CLI) in the version information. We're probably off topic for this list at this point but here are a couple of notes: ./LL.php: line 3: ?: No such file or directory This is not a php error. This is a shell script error. Your file is not being interpreted by php at this point. The first line is failing to invoke the php interpreter: #!/usr/local/bin/php -q Make sure it is the very first line with no space above it and you may not need the -q with php CLI version. You may just want to (re) install php from redhat and use it instead. Good Luck, Sean -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Make connection to MySQL Server from another server
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 into is that you'd need to open the mysql port in the firewall on the box running mysql. The port is 3306 by default. *NOTE:* If you are going to do this, I would *highly* recommend that the firewall rule that you write specifically open the port *only* to the machine running the PHP app! 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 3306 --syn -j ACCEPT -A RH-Lokkit-0-50-INPUT -p udp -m udp -s 192.168.1.100/32 --dport 3306 -j ACCEPT I haven't tried this out, so I can't vouch for it, but that's how I *think* it should look. Ben -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Make connection to MySQL Server from another server
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 3306 --syn -j ACCEPT -A RH-Lokkit-0-50-INPUT -p udp -m udp -s 192.168.1.100/32 --dport 3306 -j ACCEPT I don't believe you need UDP for anything, so it should only be the first rule. What is the -m tcp in there? As an aside, and since we were on the subject yesterday, just for fun the Shorewall rule is something like (in the form action from to protocol port): ACCEPT loc:192.168.1.100 loc:192.168.1.101 tcp 3306 -- Rodolfo J. Paiz [EMAIL PROTECTED] -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Make connection to MySQL Server from another server
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 3306 --syn -j ACCEPT -A RH-Lokkit-0-50-INPUT -p udp -m udp -s 192.168.1.100/32 --dport 3306 -j ACCEPT I don't believe you need UDP for anything, so it should only be the first rule. What is the -m tcp in there? As an aside, and since we were on the subject yesterday, just for fun the Shorewall rule is something like (in the form action from to protocol port): ACCEPT loc:192.168.1.100 loc:192.168.1.101 tcp 3306 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. Ben -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Make connection to MySQL Server from another server
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 (just before the packet is REJECTed). This will help you to find out which ports have to be opened, too :-) Steffen -- Steffen Grunewald * * * Merlin cluster admin (http://pandora.aei.mpg.de) MPI für Gravitationsphysik (Albert-Einstein-Institut) Am Mühlenberg 1, 14476 Golm, Germany (http://www.aei.mpg.de) e-mail: steffen.grunewald(*)aei.mpg.de * +49-331-567-{fon:7233,fax:7298} -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
PostgreSQL or MySQL on RedHat
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:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: PostgreSQL or MySQL on RedHat
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 be offended, but your question really shouldn't be on this list. Yes, both run on Red Hat, but that's like asking which desktop (Gnome vs. KDE) that people like best. Everyone has their favorite. I will say that PostgreSQL has some very nice features and datatypes that MySQL doesn't yet, but that hasn't kept me from using MySQL on all of my sites. Your choice is completely dependent on what your needs are. Other folks' needs and experiences aren't necessarily the same as yours. Let's hope this thread dies before it gets out of control. -- Jason Dixon, RHCE DixonGroup Consulting http://www.dixongroup.net -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: PostgreSQL or MySQL on RedHat
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 for postgres mysql will yield lots of history. If your geek friend is any good he will give you specifics as to why PosgreSQL is better. Depending on what you're doing, it might not matter, or it might matter a lot. Note that both databases are constantly improving, so old comparisons may no longer be valid. -- Ed Wilts, Mounds View, MN, USA mailto:[EMAIL PROTECTED] Member #1, Red Hat Community Ambassador Program -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: PostgreSQL or MySQL on RedHat
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 question. Both will run find in Redhat. I've used both and developed with both in Redhat. Research on what you think you need, features comparison of the two DBs, etc. But, if you asked me to give opinion, IMHO I like PostgreSQL better RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ - Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. - -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: PostgreSQL or MySQL on RedHat [SOLVED]
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
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, Perl, Python, or Tcl) * views * better transaction handling * support for custom data types * support for nested SQL statements * support for query rewrite rules * support for indexes on function results * support for database-enforced constraints (MySQL may have this) * support for triggers * support for rtree indexes for geographical information * other cool stuff Jon nick marsh [EMAIL PROTECTED] -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: PostgreSQL or MySQL on RedHat
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) Referential integrity 3) Transactions 4) Procedural Language etc -- 18:05:01 up 12 days, 9:55, 4 users, load average: 0.47, 0.54, 0.37 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Make connection to MySQL Server from another server
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-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: MYSQL Question Database Location
Hi Can any one aswer my question pls ? --- Sambit Nanda [EMAIL PROTECTED] wrote: 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, 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-3424 (O) -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: MYSQL Question Database Location
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 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, 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-3424 (O) -- Aly S.P Dharshi [EMAIL PROTECTED] Southern Alberta Digital Library Project A good speech is like a good dress that's short enough to be interesting and long enough to cover the subject -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: MYSQL Question Database Location
On Tue, 2003-09-02 at 15: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 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. 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. -- NfoCipher [EMAIL PROTECTED] ChickenWare, LLC Co-lo or dedicated Linux box as low as $35/month - www.SpeedWorks.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
MYSQL Question Database Location
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, Sambit Nanda 203-553-3424 (O) -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: MySQL Problem , Please Help
I cant find /usr/lib/libmyodbc.ini [EMAIL PROTECTED] /]# ls -alh /usr/lib/libmyodbc.so ls: /usr/lib/libmyodbc.so: No such file or directory [EMAIL PROTECTED] /]# find . -name libmyodbc.so [EMAIL PROTECTED] /]# which unixODBC are you running ? I went here http://at.rpmfind.net/opsys/linux/RPM/redhat.com/dist/linux/9/en/os/i386/unixODBC-2.2.3-6.i386.html and they say the unixodbc package doesnt include linmyodbc.so , it gives * unixODBC http://at.rpmfind.net/opsys/linux/RPM/unixODBC.html * libboundparam.so.1 http://at.rpmfind.net/opsys/linux/RPM/libboundparam.so.1.html * libesoobS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libesoobS.so.1.html * libgtrtst.so.1 http://at.rpmfind.net/opsys/linux/RPM/libgtrtst.so.1.html * libnn.so.1 http://at.rpmfind.net/opsys/linux/RPM/libnn.so.1.html * libodbc.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbc.so.1.html * libodbccr.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbccr.so.1.html * libodbcdrvcfg1S.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcdrvcfg1S.so.1.html * libodbcdrvcfg2S.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcdrvcfg2S.so.1.html * libodbcextras.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcextras.so.1.html * libodbcinst.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcinst.so.1.html * libodbcminiS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcminiS.so.1.html * libodbcmyS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcmyS.so.1.html * libodbcnnS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcnnS.so.1.html * libodbcpsql.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcpsql.so.1.html * libodbcpsql.so.2 http://at.rpmfind.net/opsys/linux/RPM/libodbcpsql.so.2.html * libodbcpsqlS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbcpsqlS.so.1.html * libodbctxt.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbctxt.so.1.html * libodbctxtS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libodbctxtS.so.1.html * liboplodbcS.so.1 http://at.rpmfind.net/opsys/linux/RPM/liboplodbcS.so.1.html * liboraodbcS.so.1 http://at.rpmfind.net/opsys/linux/RPM/liboraodbcS.so.1.html * libsapdbS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libsapdbS.so.1.html * libtdsS.so.1 http://at.rpmfind.net/opsys/linux/RPM/libtdsS.so.1.html * 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 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 set up and looked like this: [myodbc] Description = MySQL Driver Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libmyodbcmyS.so.1 FileUsage = 1 CPTimeout = CPReuse = I set up an entry in my /etc/odbc.ini (which I later realized that isql wasn't using, so I copied /etc/odbc.ini to ~/.odbc.ini) that looks like (using the menagerie example database): [menagerie] Description = menagerie Driver = myodbc (this is how it was labeled in /etc/odbcinst.ini) Server = localhost Database= menagerie Port= 3306 Socket = Option = Stmt= This config worked for me. -Steve -Original Message- From: administrator [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 10:48 AM To: [EMAIL PROTECTED] Subject: MySQL Problem , Please Help 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 = /usr/lib.libmyodbc.so or Setup= /usr/lib/libodbcmyS.so Instead i used : Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 So My /etc/odbcinst.ini : [MySQL] Description = ODBC driver for MySQL Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 FileUsage = 1 CPTimeout = CPReuse = And then There is /etc/odbc.ini [IGSohba] Description = IgSohba Driver = MySQL Server = localhost Database= igsohba Port= 3306 Socket = Option = Stmt= * When i was adding from the GUI tool , the DB entry is a drop down menu , and there was test and mysql , but not my DB i created which is igsohba , but i added it manually anyway . it is also mentioned that to test this : [EMAIL PROTECTED] root]# isql IGSohba Segmentation fault So my questions are : 1) Are the libs i added in /etc
Re: PHP? MySQL? Or both?
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 sites that have the problem? Look at the logs while you do this. Generally, when it goes down, I've been most interested in bringing my sites back up ASAP. :-( So I haven't tried any diagnostics while they're down, except for verifying that mysqld is running. Try to have something ready (just a simple SELECT count(*) FROM table_name to know how things are working) so when the SQL server fails you can fastly execute the script to know if the problem is there or some place else. You should also check with another client that is not PHP (maybe the mysql shell). Assuming I can run a test connection script, which log should I be watching? There is a mysql.log IIRC. Look there. Also look at where PHP is logging. How's the load on the mysql server? Pings are OK between the servers? It's all one box, so the load is the same for both machines. Pinging is, well, irrelevant. :-) I should have mentioned this. Thought about putting the DB server on another machine? Sorry if I'm not that helpfull, but I have experience with Informix (in the past) and PostgreSQL (in the present), and have only done some tests on mysql servers (I don't have one handy right now). -- 08:50:01 up 8 days, 40 min, 3 users, load average: 0.62, 0.37, 0.27 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
PHP? MySQL? Or both?
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 sites. (I checked, and the function is identical, except for user/password/database arguments, between the three sites.) mysqld is still running on the server; however, if I restart mysqld, the sites resume working. I haven't been able to deliberately crash the sites, nor have I been able to confirm absolutely that it only affects the two sites. System load doesn't appear to be an issue; the only time I've seen load average approach 1.0 was when I did the initial fcheck run. I also checked the users in mysql, and all three have identical permissions. Nothing helpful in any error logs. Right now I have a kludge going where the failure case in the database connect function drops a file in a particular path (much like a lockfile) and a perl script (run every five minutes by cron) restarting mysql (and deleting the file) if it finds that file present. Not a real good option for long-term site operation (but handy, I suppose...) How can I figure out if the problem resides with MySQL (suggested by the fact that a mysqld restart helps - resource issue?) or with PHP (suggested by how it doesn't affect all three sites)? I'd like to get this sorted before I move the two last (and biggest) sites out of shared hosting. Thanks for any hints... pjm -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: PHP? MySQL? Or both?
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 Morse escribió: 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 sites. (I checked, and the function is identical, except for user/password/database arguments, between the three sites.) mysqld is still running on the server; however, if I restart mysqld, the sites resume working. I haven't been able to deliberately crash the sites, nor have I been able to confirm absolutely that it only affects the two sites. System load doesn't appear to be an issue; the only time I've seen load average approach 1.0 was when I did the initial fcheck run. I also checked the users in mysql, and all three have identical permissions. Nothing helpful in any error logs. Right now I have a kludge going where the failure case in the database connect function drops a file in a particular path (much like a lockfile) and a perl script (run every five minutes by cron) restarting mysql (and deleting the file) if it finds that file present. Not a real good option for long-term site operation (but handy, I suppose...) How can I figure out if the problem resides with MySQL (suggested by the fact that a mysqld restart helps - resource issue?) or with PHP (suggested by how it doesn't affect all three sites)? I'd like to get this sorted before I move the two last (and biggest) sites out of shared hosting. Thanks for any hints... pjm -- 08:45:01 up 7 days, 35 min, 4 users, load average: 0.62, 0.61, 0.55 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: PHP? MySQL? Or both?
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? Can I change the settings to have it log more?) 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. Generally, when it goes down, I've been most interested in bringing my sites back up ASAP. :-( So I haven't tried any diagnostics while they're down, except for verifying that mysqld is running. Assuming I can run a test connection script, which log should I be watching? How's the load on the mysql server? Pings are OK between the servers? It's all one box, so the load is the same for both machines. Pinging is, well, irrelevant. :-) I should have mentioned this. Brief summary of my problem for those who missed the original: El Jue 28 Ago 2003 20:29, Parker Morse escribió: Intermittently, the database connection function in PHP will fail for two of those three sites. mysqld is still running on the server; however, if I restart mysqld, the sites resume working. pjm -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
MySQL Problem , Please Help
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 = /usr/lib.libmyodbc.so or Setup= /usr/lib/libodbcmyS.so Instead i used : Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 So My /etc/odbcinst.ini : [MySQL] Description = ODBC driver for MySQL Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 FileUsage = 1 CPTimeout = CPReuse = And then There is /etc/odbc.ini [IGSohba] Description = IgSohba Driver = MySQL Server = localhost Database= igsohba Port= 3306 Socket = Option = Stmt= * When i was adding from the GUI tool , the DB entry is a drop down menu , and there was test and mysql , but not my DB i created which is igsohba , but i added it manually anyway . it is also mentioned that to test this : [EMAIL PROTECTED] root]# isql IGSohba Segmentation fault So my questions are : 1) Are the libs i added in /etc/odbcinst.ini correct . 2) is there a missing package . 3) where did i go wrong ? Thanks In advance . good day -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
RE: MySQL Problem , Please Help
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 set up and looked like this: [myodbc] Description = MySQL Driver Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libmyodbcmyS.so.1 FileUsage = 1 CPTimeout = CPReuse = I set up an entry in my /etc/odbc.ini (which I later realized that isql wasn't using, so I copied /etc/odbc.ini to ~/.odbc.ini) that looks like (using the menagerie example database): [menagerie] Description = menagerie Driver = myodbc (this is how it was labeled in /etc/odbcinst.ini) Server = localhost Database= menagerie Port= 3306 Socket = Option = Stmt= This config worked for me. -Steve -Original Message- From: administrator [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 10:48 AM To: [EMAIL PROTECTED] Subject: MySQL Problem , Please Help 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 = /usr/lib.libmyodbc.so or Setup= /usr/lib/libodbcmyS.so Instead i used : Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 So My /etc/odbcinst.ini : [MySQL] Description = ODBC driver for MySQL Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 FileUsage = 1 CPTimeout = CPReuse = And then There is /etc/odbc.ini [IGSohba] Description = IgSohba Driver = MySQL Server = localhost Database= igsohba Port= 3306 Socket = Option = Stmt= * When i was adding from the GUI tool , the DB entry is a drop down menu , and there was test and mysql , but not my DB i created which is igsohba , but i added it manually anyway . it is also mentioned that to test this : [EMAIL PROTECTED] root]# isql IGSohba Segmentation fault So my questions are : 1) Are the libs i added in /etc/odbcinst.ini correct . 2) is there a missing package . 3) where did i go wrong ? Thanks In advance . good day -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
MySQL/ODBC Help needed
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 = /usr/lib.libmyodbc.so or Setup= /usr/lib/libodbcmyS.so Instead i used : Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 So My /etc/odbcinst.ini : [MySQL] Description = ODBC driver for MySQL Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 FileUsage = 1 CPTimeout = CPReuse = And then There is /etc/odbc.ini [IGSohba] Description = IgSohba Driver = MySQL Server = localhost Database= igsohba Port= 3306 Socket = Option = Stmt= * When i was adding from the GUI tool , the DB entry is a drop down menu , and there was test and mysql , but not my DB i created which is igsohba , but i added it manually anyway . it is also mentioned that to test this : [EMAIL PROTECTED] root]# isql IGSohba Segmentation fault So my questions are : 1) Are the libs i added in /etc/odbcinst.ini correct . 2) is there a missing package . 3) where did i go wrong ? Thanks In advance . good day -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Installing/Configuring unixODBC with MySQL over Redhat 9
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 = /usr/lib.libmyodbc.so or Setup = /usr/lib/libodbcmyS.so Instead i used : Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 So My /etc/odbcinst.ini : [MySQL] Description = ODBC driver for MySQL Driver = /usr/local/lib/libmyodbc3.so Setup = /usr/lib/libodbcmyS.so.1 FileUsage = 1 CPTimeout = CPReuse = And then There is /etc/odbc.ini [IGSohba] Description = IgSohba Driver = MySQL Server = localhost Database= igsohba Port= 3306 Socket = Option = Stmt= * When i was adding from the GUI tool , the DB entry is a drop down menu , and there was test and mysql , but not my DB i created which is igsohba , but i added it manually anyway . it is also mentioned that to test this : [EMAIL PROTECTED] root]# isql IGSohba Segmentation fault So my questions are : 1) Are the libs i added in /etc/odbcinst.ini correct . 2) is there a missing package . 3) where did i go wrong ? Thanks In advance . good day -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
mysql dead but subsys locked = ?
*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 didnt get any + result. does anyone knows how to work around this? thanks. Fatih Olcer -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: mysql dead but subsys locked = ?
*This message was transferred with a trial version of CommuniGate(tm) Pro* hi Stephen i solve the problem. thank you. On Sat, 2003-08-09 at 10:07, Stephen Kuhn wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* 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/mysql/mysql.sock' (111) i tried lots of things (googled). but i didnt get any + result. does anyone knows how to work around this? thanks. Fatih Olcer What if you try opening a term and typing: service mysql restart ?? Does that do anything? -- Sat Aug 9 17:05:00 EST 2003 17:05:00 up 5 days, 20:53, 1 user, load average: 1.02, 0.96, 0.90 - |____ |kuhn media australia| | /-oo /| |'-. |http://kma.0catch.com | | .\__/ || | | || | _ / `._ \|_|_.-' |stephen kuhn| | | / \__.`=._) (_ | email: [EMAIL PROTECTED] | - linux user #:267497 linux machine #:194239 * MDK 9.1+ RH 9 Mandrake Linux Kernel 2.4.21-11mdk Cooker for i586 - * This message was composed on a 100% Microsoft free computer * Real children don't go hoppity-skip unless they are on drugs. -- Susan, the ultimate sensible governess (Terry Pratchett, Hogfather) -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: mysql dead but subsys locked = ?
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/mysql/mysql.sock' (111) i tried lots of things (googled). but i didnt get any + result. does anyone knows how to work around this? thanks. Fatih Olcer What if you try opening a term and typing: service mysql restart ?? Does that do anything? -- Sat Aug 9 17:05:00 EST 2003 17:05:00 up 5 days, 20:53, 1 user, load average: 1.02, 0.96, 0.90 - |____ |kuhn media australia| | /-oo /| |'-. |http://kma.0catch.com | | .\__/ || | | || | _ / `._ \|_|_.-' |stephen kuhn| | | / \__.`=._) (_ | email: [EMAIL PROTECTED] | - linux user #:267497 linux machine #:194239 * MDK 9.1+ RH 9 Mandrake Linux Kernel 2.4.21-11mdk Cooker for i586 - * This message was composed on a 100% Microsoft free computer * Real children don't go hoppity-skip unless they are on drugs. -- Susan, the ultimate sensible governess (Terry Pratchett, Hogfather) -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Apache, Mysql central-european charset
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, but I don't know how to modify and what should I modify in mysql. Alex, phpBB offers multilingual support, and installing different languages is pretty easy. For more info and help go to http://www.phpbb.com and check out the phpBB documentation and also the user forums. The folks there will help you with any further questions if you can't figure out from the docs how to install a language pack. --Lee -- What The...? http://www.what-the.com -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Apache, Mysql central-european charset
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 I modify in mysql. Some help? Thanks. Alex -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Pre-make 'configure' program can't find mysql libraries?
-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, configure isn't finding the libraries. The configure program said to check the ld.so.conf file for entries for the libraries. It looks right to me (file shown at the bottom of the post). So, I ran ldconfig and then cleared the cache again, and still no dice. I have the following RedHat RPMs installed: mysql-devel-3.23.56-1.80 mysql-3.23.56-1.80 mysql-server-3.23.56-1.80 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 /usr/include/mysql with /usr/lib/mysql Then run ldconfig again. Hope that helps, - -- - -Michael pgp key: http://www.tuxfan.homeip.net:8080/gpgkey.txt Red Hat Linux 7.{2,3}|8.0|9 in 8M of RAM: http://www.rule-project.org/en/ - -- -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE/K9Gmn/07WoAb/SsRAhoPAJ433IMTZdOqx3Z9Ow7KuLLjU6GzOACeK9f1 skjv5/Ax7AoKykanGePIIzs= =8PLH -END PGP SIGNATURE- -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Pre-make 'configure' program can't find mysql libraries?
-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 /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 /usr/include/mysql with /usr/lib/mysql Then run ldconfig again. Oops, pre coffee answer, sorry. I missed the /usr/lib/mysql line that is already there. - -- - -Michael pgp key: http://www.tuxfan.homeip.net:8080/gpgkey.txt Red Hat Linux 7.{2,3}|8.0|9 in 8M of RAM: http://www.rule-project.org/en/ - -- -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE/K9LDn/07WoAb/SsRAnkDAJ0a7KzTji3p2bi/2/WIqbSJ+GjUtQCcCqlV 7pkSa8T0kQ2EnuqwNDxurAs= =1iqY -END PGP SIGNATURE- -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Pre-make 'configure' program can't find mysql libraries?
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 /usr/include/mysql with /usr/lib/mysql Then run ldconfig again. Um../usr/lib/mysql is the second from the bottom line. Ben -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Pre-make 'configure' program can't find mysql libraries?
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 option to let you tell it where to find the mysql lib. If that doesn't work, then probably you get better luck asking at the software (Nagio) mailing list, if such exists. HTH RDB Well, I used the manual switches to tell the configure program where to find the MySQL libraries. I still don't know it couldn't find them via the ld.so.conf file. That bugs me, but I don't know much about the c programming side of linux yet. *sigh* Ben -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Pre-make 'configure' program can't find mysql libraries?
All, This one's a bit long, but I'm trying to give all the info I have and everything I've tried, so please be patient with me. *grin* Okay, I'm implementing nagios (http://www.nagios.org), which is a very cool network services monitoring system. I installed it with all of the defaults, 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), and the nagios install I had done uses text file configs. 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. 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, configure isn't finding the libraries. The configure program said to check the ld.so.conf file for entries for the libraries. It looks right to me (file shown at the bottom of the post). So, I ran ldconfig and then cleared the cache again, and still no dice. I have the following RedHat RPMs installed: mysql-devel-3.23.56-1.80 mysql-3.23.56-1.80 mysql-server-3.23.56-1.80 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 I don't know what else to check... Thanks! Ben -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: Pre-make 'configure' program can't find mysql libraries?
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 the configuration option? Usually there is a configure option to let you tell it where to find the mysql lib. If that doesn't work, then probably you get better luck asking at the software (Nagio) mailing list, if such exists. HTH RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ - Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. - -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
mysql backup?
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-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: mysql backup?
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 while the copy is being made. This ensures the integrity. If want a more robust solution, I would recommend creating replica(mirror) db server and making backups of the replica server. Saqib Ali - http://www.xml-dev.com On Fri, 18 Jul 2003, Michael Sorrentino wrote: 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-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: My 1st C MySQL program
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 tried so far won't even work on my Linux box. Can anyone point me to a good generic, or even unix centric C programming site as I want to learn C too. Thanks all -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: My 1st C MySQL program
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 Regards, Mike Klinke -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
My 1st C MySQL program
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 is implicit declaration of function and sometimes is something like undeclared function. I search the MySQL site about undefined reference and find an explanation of the problem ... The fix for this is to tell your system to search after shared libraries where the library is located by one of the following methods: - Add the path to the directory where you have `libmysqlclient.so' the LD_LIBRARY_PATH environment variable. - Add the path to the directory where you have `libmysqlclient.so' the LD_LIBRARY environment variable. - Copy `libmysqlclient.so' to some place that is searched by your system, like `/lib', and update the shared library information by executing ldconfig. Another way to solve this problem is to link your program statically, with -static, or by removing the dynamic MySQL libraries before linking your code. In the second case you should be sure that no other programs are using the dynamic libraries! I exported, i copied, i ldconfig bot not seams to work at all. I don't want to use a preprocessor like prec of Just Logic, but if it doesn't have any other choice them I'll try the MySQL++ so. Can anybody help me, or tell me about an mail list or forum about MySQL with C/C++. Thanks. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list
Re: My 1st C MySQL program
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 suggested, your `libmysqlclient.so' is not in the correct place for use by the C API. But I'm really don't recall the exact fix well enough to do anything but confuse both of us. Good luck regis On Tue, 2003-07-08 at 12:43, Ricardo Striquer Soares wrote: 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 is implicit declaration of function and sometimes is something like undeclared function. I search the MySQL site about undefined reference and find an explanation of the problem ... The fix for this is to tell your system to search after shared libraries where the library is located by one of the following methods: - Add the path to the directory where you have `libmysqlclient.so' the LD_LIBRARY_PATH environment variable. - Add the path to the directory where you have `libmysqlclient.so' the LD_LIBRARY environment variable. - Copy `libmysqlclient.so' to some place that is searched by your system, like `/lib', and update the shared library information by executing ldconfig. Another way to solve this problem is to link your program statically, with -static, or by removing the dynamic MySQL libraries before linking your code. In the second case you should be sure that no other programs are using the dynamic libraries! I exported, i copied, i ldconfig bot not seams to work at all. I don't want to use a preprocessor like prec of Just Logic, but if it doesn't have any other choice them I'll try the MySQL++ so. Can anybody help me, or tell me about an mail list or forum about MySQL with C/C++. Thanks. -- rm [EMAIL PROTECTED] -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list