Discuss March 2010

discuss@lists.centos.org

295 participants
260 discussions

Connect to MySQL monitor on another host in the LAN ?
by Niki Kovacs 23 Mar '10

23 Mar '10

Hi, I'm running a medical application on a local network, using MySQL as a database. The application can also connect to remote hosts, so the idea is to install it on one machine acting as a "server", and then install it on the other machines on the LAN, but configure these to use the database on the "server". I guess before doing that, I'll better try and get comfortable with connecting remotely using the MySQL monitor itself, that is, without any application or some other frontend. Up until now, I've only configured MySQL in two situations. Either on standalone desktop workstations, or on a web server (LAMP). After installing MySQL (yum install mysql-server), the default setup has a few accounts without any password. First thing I usually do (correct me if this is wrong) is clean up these accounts and only keep one main root@localhost account. Something like this : [root@raymonde:~] # mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.0.77 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select user, host, password from user; +------+-----------+----------+ | user | host | password | +------+-----------+----------+ | root | localhost | | | root | raymonde | | | root | 127.0.0.1 | | | | localhost | | | | raymonde | | +------+-----------+----------+ 5 rows in set (0.00 sec) mysql> delete from user where user = ''; Query OK, 2 rows affected (0.01 sec) mysql> delete from user where host = 'raymonde'; Query OK, 1 row affected (0.00 sec) mysql> delete from user where host = '127.0.0.1'; Query OK, 1 row affected (0.01 sec) mysql> select user, host, password from user; +------+-----------+----------+ | user | host | password | +------+-----------+----------+ | root | localhost | | +------+-----------+----------+ 1 row in set (0.00 sec) mysql> set password for root@localhost = password('********'); Query OK, 0 rows affected (0.00 sec) mysql> select user, host, password from user; +------+-----------+------------------+ | user | host | password | +------+-----------+------------------+ | root | localhost | 2d97271980b60f82 | +------+-----------+------------------+ 1 row in set (0.00 sec) mysql> quit; So much for the standalone setup. Now what would be an orthodox (and somewhat secure) configuration to be able to connect to this MySQL server on 'raymonde' from another machine in the LAN ? Do I have to (re)create a root@raymonde MySQL account and eventually give it the same password than root@localhost ? Cheers, Niki

3 2

fsck problems
by sync 23 Mar '10

23 Mar '10

hi , guys: when i reboot the server today ,the screen displays this ; --------------------------------------------------------------------------------------- Setting hostname xxx [OK] Your system appears to have shut down uncleanly Press Y within 1 seconds to force file system integrity check... Checking root filesystem /dev/VolGroup00/LogVol 00: UNEXPECTED INCONSISTENCY: RUN fsck MANUALLY. (i.e., without -a or -p options) [FAILED] *** An error occured during the file system check. *** Droping you to a shell; the system will reboot *** when you leave the shell. Give root password for maintenance (or type Control-D to continue) ---------------------------------------------------------------------------------------- is it the disk error ? What should i do to repair the disk ? Thanks in advance ......

7 13

Ruby-1.9.1+ rpm for CentOS-5
by James B. Byrne 23 Mar '10

23 Mar '10

Does anyone have the url of a repository that provides Ruby-1.9.1+ for CentOS-5 and which they consider a trustworthy and reliable source? I really do not what to have to build this software if I can avoid it. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3

2 1

Upgrading Python with Yum
by Susan Day 23 Mar '10

23 Mar '10

Hi; I have an old version of Python (2.4.3) and I'm trying to upgrade (to 2.6); however, when I try yum upgrade python it tells me that it's already got the latest and greatest...presumably of 2.4.3. I've tried yum list python and it only gives me the 2.4.3. Are there no others? Do I have to build from a tarball? I'm surprised I don't find a version of Python 3 either. In what folder are the rpms kept? TIA, Susan

5 8

gimp - aalib
by Frank Cox 23 Mar '10

23 Mar '10

I want to use the aalib plugin to save some graphics out of gimp. But... I can't find it as an option in Gimp. I have both gimp and aalib installed on this computer. Is there some additional piece that I also need to install? -- MELVILLE THEATRE ~ Melville Sask ~ http://www.melvilletheatre.com

1 0

how to push the bounds and get newer packages for centos 5.4?
by Robert P. J. Day 22 Mar '10

22 Mar '10

i've just started looking after a (virtual) centos 5.4 server that's hosted at rackspace and, unsurprisingly, it was set up with all the standard defaults. part of the work i'll be doing involves php and, as i read it, the standard php version with centos 5.4 is php-5.1. if i *wanted* to move up to a more recent version (say, php-5.3), obviously, i'd need to go outside the limits of the standard centos yum repos. in my travels, i ran across this site: http://blog.famillecollet.com/pages/Config-en with the corresponding instructions: wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.r… wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm i'm suitably leery of 3rd-party repos but i recall that someone else (on this list?) recommended that site. and i can see that it has an x86_64 version of php-5.3 ready to go for centos 5.4: http://rpms.famillecollet.com/enterprise/5/remi/x86_64/repoview/php.html what are the recommendations for well-respected 3rd-party repos for centos 5.4 if i want to get newer packages? the centos 5.4 system in question is purely an internal development system so i have the freedom to customize it to some extent if newer packages are called for. thanks. rday -- ======================================================================== Robert P. J. Day Waterloo, Ontario, CANADA Linux Consulting, Training and Kernel Pedantry. Web page: http://crashcourse.ca Twitter: http://twitter.com/rpjday ========================================================================

9 10

Mounting a Mac OS Extended (Journaled) Hard Drive
by Keith Beeby 22 Mar '10

22 Mar '10

Hi, I need to migrate about 8Tb of data from a Mac Fibre Channel RAID to by LVM Ext3 Linux Fibre Channel RAID. For speed I planned to connect both RAID's to my CentOS Server and copy the data directly. The Mac volume is formatted as Mac OS Extended (Journaled) it seems that CentOS 5.4 supports reading HFS volumes but not HFSPlus volumes. Is there a way of getting this volume to mount so I can copy of the data? I see Fedora has HFSPlus support Thanks Keith

5 8

VSFTPD accepting same user/session from different IP addresses
by Dirk H. Schulz 22 Mar '10

22 Mar '10

Hi folks, I have found the following in my logs: Wed Mar 10 15:52:33 2010 [pid 15232] [uploaduser] OK MKDIR: Client "195.200.70.*40*", "/04 LV gelieferte Daten 04_2010/04 LV Seiten/Jungz?chter" Wed Mar 10 15:52:33 2010 [pid 15231] [uploaduser] FAIL MKDIR: Client "195.200.70.*41*", "/04 LV gelieferte Daten 04_2010/04 LV Seiten/Jungz?chter" Wed Mar 10 15:52:36 2010 [pid 15232] [uploaduser] OK UPLOAD: Client "195.200.70.*40*", "/04 LV gelieferte Daten 04_2010/04 LV Seiten/Jungz?chter/Kooperationsseminar.doc", 23552 bytes, 13.89Kbyte/sec Wed Mar 10 15:52:37 2010 [pid 15231] [uploaduser] OK UPLOAD: Client "195.200.70.*41*", "/04 LV gelieferte Daten 04_2010/04 LV Seiten/Jungz?chter/Veranstaltungen der Jungz?chter im Jahr 2010.doc", 23552 bytes, 9.07Kbyte/sec Wed Mar 10 15:52:38 2010 [pid 15232] [uploaduser] OK UPLOAD: Client "195.200.70.*40*", "/04 LV gelieferte Daten 04_2010/04 LV Seiten/Jungz?chter/Foto Kooperationsseminar von laura weber.JPG", 13445 bytes, 9.90Kbyte/sec What I am concerned about is the fact that the client sends out using various gateways at once. Is there some configuration item in VSFTPD which can prevent this and reject packets from the additional ip addresses? Any hint or help is appreciated. Dirk

2 3

Re: [CentOS] Looking for experiences with filesystem choices....
by Tom Bishop 22 Mar '10

22 Mar '10

So I tried XFS last night and it cut my copy times down substantially, so I need someone to verify that XFS in centos 5.4 has barriers enabled by default, I am not using LVM just the old fashion partitions and mount points. It appears that reading from the centos wiki that xfs is enabled in the kernel due to upstream vendor doing so for the first timeI loaded up xfsprogs and xfsdump but it was not clear about the barrier details.... Thanks...in advance. :) On Mon, Mar 22, 2010 at 9:26 AM, Brent L. Bates <blbates(a)vigyan.com> wrote: > If you want dependability, reliability, robustness, and a fast file > system the only choice is XFS. It is the ONLY file system I will > use/trust. > I've been using it since it first came out on SGI's under IRIX and have > been > using it under Linux for a number of years. It survives system crashes and > disk hardware problems and just keeps on going. You will not find a better > file system out there. > > -- > > Brent L. Bates (UNIX Sys. Admin.) > M.S. 912 Phone:(757) 865-1400, x204 > NASA Langley Research Center FAX:(757) 865-8177 > Hampton, Virginia 23681-0001 > Email: B.L.BATES(a)larc.nasa.gov http://www.vigyan.com/~blbates/<http://www.vigyan.com/%7Eblbates/> > >

1 0

sendmail sending out on port 587
by Gregory P. Ennis 22 Mar '10

22 Mar '10

Dear List, I recently spent some time out of the USA, and found myself in a hotel that blocked port 25 which prevented my laptop's ability to connect to my office mail server. I did a scan on the internet and made the observation that this was a common problem. I had port 22 available so I was able to get my office server set up to accept mail on 25 and 587 without difficulty. The command "telnet mail.server.com 587" to my office mail server connects without difficulty. However, I have not been able to get sendmail on my laptop to connect to sendmail on my mail server at home using port 587. I have added the following to sendmail.mc on my laptop without success : define(`RELAY_MAILER_ARGS', `TCP $h 587') define(`ESMTP_MAILER_ARGS', `TCP $h 587') I finally made it back home, but have decided to change my configuration to use 587 by default so that this problem will be avoided, but I have been unable to get my laptop to connect. Anyone having ideas would be appreciated. Greg Ennis

7 14

← Newer
1
...
7
8
9
10
11
12
13
...
26
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Discuss March 2010