Discuss

discuss@lists.centos.org

5 participants
34752 discussions

RE: [CentOS] centos & mysql
by King, John (Greg) (LMIT-HOU) 02 Jun '06

02 Jun '06

You need to grant the privs to allow the connection. They mysql homepage has a set of docs at http://dev.mysql.com/doc/. More specifically this link which talks about setting up the grant tables http://dev.mysql.com/doc/refman/4.1/en/post-installation.html You could also use phpmyadmin to have a nice frontend to the mysql server system (http://www.phpmyadmin.net/home_page/index.php) Some things to consider: (since you said you were a newbie) 1. If no remote apps are going to be connecting the sql server port (ie only local programs relative to the system), do not open iptables for the sql server port. 1b. configure the /etc/my.cnf file to tell mysql to use local sockets and not listen on a port (skip-networking option). 2. When adding users, never grant a user profile in the mysql table any privs (excluding the default root which you should also rename to something else) as doing so would allow the user those rights across all databases. Instead grant users access via the mysql::db table. Also there is alot of good how-to docs at http://www.hughesjr.com/ for centos, specifically http://www.hughesjr.com/content/view/13/30/Guides -greg ________________________________ From: centos-bounces(a)centos.org [mailto:centos-bounces@centos.org] On Behalf Of Stephen A. Wright Sent: Friday, June 02, 2006 4:47 AM To: centos(a)centos.org Subject: [CentOS] centos & mysql Hi everyone, as a newbie to linux Im having a but of a problem getting up and running. Hopefully one of you you can point me in the right direction. I have installed Centos4 on an old server here at work as a dev box, installation went well, and I have mysql up and running. However when I try and connect from my laptop using mysql administrator I get an error saying "the host is not allowed to connect to this server" I tried disabling the firewall to see if that helped and it made no difference. I also tried pinging the server and that was fine. I tried connecting using the servers ip, name localhost and password as blank. When im logged in a root on the server this allows be to login ok. Any ideas? Thanks in advance Steve

1 0

RE: [CentOS] PERL module woes
by Bowie Bailey 02 Jun '06

02 Jun '06

Jim Perrin wrote: > > In fact, the quality of the perl-related rpms from Red Hat is > > the main reason I'm not using RHEL and using CentOS > > Your logic is confusing to me. It does not resemble what I would > consider to be rational thought. I think I understand what he was trying to say. When I built my last system, I decided to go with rpms for everything. It worked great until I got to the Perl modules and then it fell apart. Every time I have tried to install Perl modules from rpms, it quickly evolves into a massive game of "find the missing dependency". Either the module I want can't be found anywhere, or when I do find it, it depends on a module that can't be found. I finally gave up and decided to use CPAN for Perl modules. It is simple, and work amazingly well. It does cause some annoyance when you get other rpms that have dependencies on Perl modules, but that is a problem that I have only seen once or twice. There is a program that will create rpms from CPAN. I considered it and then rejected it as being WAY too much trouble for the number of modules that I typically deal with. -- Bowie

4 4

getting update details
by Mark Belanger 02 Jun '06

02 Jun '06

I see in CentOS 3.6 - the release notes state that it has "improved support for dual-core processors" I got that from http://www.redhat.com/docs/manuals/enterprise/RHEL-3-Manual/release-notes/a… Where might I get more details about this improved support. Specifically I'd like to see if problems I'm having in 3.5 could be related to the kernel and dual core cpus. -Mark -- Mark Belanger LTX Corporation

2 1

CentOS-announce Digest, Vol 16, Issue 1
by centos-announce-request＠centos.org 02 Jun '06

02 Jun '06

Send CentOS-announce mailing list submissions to centos-announce(a)centos.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.centos.org/mailman/listinfo/centos-announce or, via email, send a message with subject or body 'help' to centos-announce-request(a)centos.org You can reach the person managing the list at centos-announce-owner(a)centos.org When replying, please edit your Subject line so it is more specific than "Re: Contents of CentOS-announce digest..." Today's Topics: 1. CESA-2006:0525 Moderate CentOS 4 ia64 quagga - security update (Pasi Pirhonen) 2. CESA-2006:0525 Moderate CentOS 3 ia64 quagga - security update (Pasi Pirhonen) 3. CESA-2006:0525 Moderate CentOS 4 axp quagga - security update (Pasi Pirhonen) 4. CESA-2006:0541 Moderate CentOS 4 ia64 dia - security update (Pasi Pirhonen) 5. CESA-2006:0525 Moderate CentOS 3 s390(x) quagga - security update (Pasi Pirhonen) 6. CESA-2006:0541 Moderate CentOS 4 axp dia - security update (Pasi Pirhonen) 7. CESA-2006:0525 Moderate CentOS 4 s390(x) quagga - security update (Pasi Pirhonen) 8. CESA-2006:0541 Moderate CentOS 4 s390(x) dia - security update (Pasi Pirhonen) 9. CESA-2006:0525 Moderate CentOS 3 i386 quagga - security update (Tru Huynh) 10. CESA-2006:0525 Moderate CentOS 3 x86_64 quagga - security update (Tru Huynh) 11. CESA-2006:0541 Moderate CentOS 4 i386 dia - security update (Johnny Hughes) 12. CESA-2006:0541 Moderate CentOS 4 x86_64 dia - security update (Johnny Hughes) 13. CESA-2006:0525 Moderate CentOS 4 i386 quagga - security update (Johnny Hughes) 14. CESA-2006:0525 Moderate CentOS 4 x86_64 quagga - security update (Johnny Hughes) ---------------------------------------------------------------------- Message: 1 Date: Thu, 1 Jun 2006 21:15:40 +0300 From: Pasi Pirhonen <upi(a)centos.fi> Subject: [CentOS-announce] CESA-2006:0525 Moderate CentOS 4 ia64 quagga - security update To: centos-announce(a)centos.org Message-ID: <20060601181540.GA14240(a)centos.fi> Content-Type: text/plain; charset="us-ascii" CentOS Errata and Security Advisory 2006:0525 https://rhn.redhat.com/errata/RHSA-2006-0525.html The following updated files have been uploaded and are currently syncing to the mirrors: files: updates/ia64/RPMS/quagga-0.98.3-2.4E.ia64.rpm updates/ia64/RPMS/quagga-contrib-0.98.3-2.4E.ia64.rpm updates/ia64/RPMS/quagga-devel-0.98.3-2.4E.ia64.rpm -- Pasi Pirhonen - upi(a)iki.fi - http://pasi.pirhonen.eu/ Top-postings silently ignored

1 0

centos & mysql
by Stephen A. Wright 02 Jun '06

02 Jun '06

Hi everyone, as a newbie to linux Im having a but of a problem getting up and running. Hopefully one of you you can point me in the right direction. I have installed Centos4 on an old server here at work as a dev box, installation went well, and I have mysql up and running. However when I try and connect from my laptop using mysql administrator I get an error saying "the host is not allowed to connect to this server" I tried disabling the firewall to see if that helped and it made no difference. I also tried pinging the server and that was fine. I tried connecting using the servers ip, name localhost and password as blank. When im logged in a root on the server this allows be to login ok. Any ideas? Thanks in advance Steve

2 2

RPM install vs. NFS mount and code versioning
by Alfred von Campe 02 Jun '06

02 Jun '06

The ongoing discussion regarding Perl modules and RPMs, prompted me to post an issue I am currently facing. I support a development team that uses various third party tools, some free, some not, some of which are installed via RPMs, and some that are not. The development cycle is 18-24 months long, and then there are many years of support (continuing engineering) after that, for which the various versions of the tools need to be available. There are a few dozen engineers on the project. Let say that I want to install SuperTool V1.1, and it's available to install only via RPMs. After thorough testing/qualification on one workstation, I need to install it on the few dozen workstations, which is straightforward but possibly time consuming (and you have to deal with workstations that may be down when you are doing the installs). When V1.2 comes out, I can again test it on one workstation, and then deploy it on the remaining workstations. But what if I there is a bug, and we need to test it against the old version of the tool? With RPMs, it is cumbersome to go back and forth between versions. Contrast that with a tar based install, where I can untar the tool in a directory that includes a version number in the path, and then automount that directory to all the workstations. There is only one install, and I can easily move back and forth among the various versions. Now I understand the benefits of RPMs, but when it comes to supporting tool vendors, dealing with tar based installations and using automounts really simplifies things. I am thinking about installing the RPM based tools on one system, and then copying the entire install tree to a NAS and automount it. I know this is not ideal, but I can't think of a better solution. Any thoughts from the members of this list? Have you tried to solve similar problems in the past? If so, how did you do it? Alfred

2 1

Re: [CentOS] [CSL #301925] centosplus kernel xfs patches and CVE-2006-1855
by David Thompson 01 Jun '06

01 Jun '06

Johnny Hughes wrote: > >There is a centosplus kernel that has that errata ... it is version: > kernel-2.6.9-34.107.plus.c4 Excellent. Is there a general way to map from upstream errata kernels to centosplus kernels? The (apparently??) previous convention of suffixing .106.unsupported to the upstream release number seemed to work well, and I don't want to either guess or take up mailing list bandwidth asking every time upstream revs. >However ... if the only thing you need from the centosplus kernel is the >xfs ... you should use the normal (non-centosplus) kernel and the >kernel-xfs-module that matches it from here: > >http://dev.centos.org/centos/4/testing/i386/RPMS/ > >or > >http://dev.centos.org/centos/4/testing/x86_64/RPMS/ Ooooh. That would be cool. I'll look into it. Thanks again. Dave Thompson UW-Madison

2 1

Installing el3 packages on CentOS 4
by José Alburquerque 01 Jun '06

01 Jun '06

Is it possible to install el3 packages on CentOS 4? I'm wondering because there are some packages on dag (for example ac3dec) that are built for el3 and not for el4. Is it better to rebuild the source rpm? Thanks. Sincerely Jose Alburquerque

2 4

[CSL #301925] centosplus kernel xfs patches and CVE-2006-1855
by David Thompson 01 Jun '06

01 Jun '06

Hi All, we've run into a problem with the xfs component in the centosplus kernel (2.6.9-34.106.unsupportedsmp) where synchronous writes sometimes fail with EAGAIN. It's causing headaches for DB2 installs and for our database research group. There is a fix reported at: http://marc.theaimsgroup.com/?l=linux-xfs&m=110808122904352&w=2 ...that's supposed to take care of things. If there is any way these patches could be included in a future centosplus kernel, we would greatly appreciate it. We are enjoying the performance lift from xfs on many systems, and hate to throw it away to get a database to work. Also, are there plans to produce a centosplus kernel that corresponds to the newest RHEL errata kernel (2.6.9-34.0.1.EL)? Cheers and thanks, Dave Thompson UW-Madison

2 1

Re: [CentOS] libtiff build error
by Robert Moskowitz 01 Jun '06

01 Jun '06

At 04:24 PM 6/1/2006, Jim Perrin wrote: >>But there is no rpm for libtiff v 3.8.2 for Centos. Every indication >>is that I need this. Well we will see what is supplied in the new >>Trixbox (Asterisk@home's new name). > >Very true, but you can always build your own. In any even, I won't >preach about this one too much. Thanks for your pointers. Almost time to quit for holiday (Shavous), so this will be resumed monday. I think I see how to proceed. I have two A@H systems, replace one wiht Trixbox and see what if haves, if not shotgun everything I need onto other box, move the files over and make install.... And figure out the necessary symbolic links. Gee I have not done any of that since working on Suns 12+ years ago..... >> >> But the make had the following error: >> >> >> >> ./libtool: line 837: g++: command not found >> > >> >This one line has your winner. You lack the proper build tools to >> >complete your desired task. You're missing the gcc-c++, and probably >> >several other things you'll need. >> >>?? yum groupinstall gcc-c++ > >There's no group by that name. If you're going to do the shotgun >approach like that then >yum groupinstall "Development Tools" is probably what you want > >> >> >> make[2]: Leaving directory `/root/tiff-3.8.2/libtiff' > >>So I log in as user foo. I do all the makes as foo. But everything >>in /usr/var is owned by root... ?? > >configure and make are run as your user. Make install (which should >really just be moving files to their final location) is the only thing >you need to run as root or with sudo. > > >>I have looked for some reasonable howtos but so far have come up short. > >I don't really have any to offer. Maybe someone else on the list will. > >> >>1104 -r--r--r-- 1 root root 1126338 May 9 07:38 libtiff.a >> 0 lrwxrwxrwx 1 root root 14 May 24 11:07 libtiff.so -> >>libtiff.so.3.6 >> 0 lrwxrwxrwx 1 root root 14 May 24 11:07 libtiff.so.3 -> >>libtiff.so.3.6 >> 308 -rwxr-xr-x 1 root root 311088 May 9 07:38 libtiff.so.3.6 > >This may not be as obvious as you think. The way you're doing things >right now would install libtiff in /usr/local/ so you'd end up with >both versions. and your asterisk application would have to be >specifically told which one to use, as it'll probably link against the >files in /usr before the files in /usr/local > > >-- >This message has been double ROT13 encoded for security. Anyone other >than the intended recipient attempting to decode this message will be >in violation of the DMCA >_______________________________________________ >CentOS mailing list >CentOS(a)centos.org >http://lists.centos.org/mailman/listinfo/centos

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Discuss