Discuss

discuss@lists.centos.org

34753 discussions

RE: [CentOS] OT: MySQL Help
by Mike Kercher 10 May '06

10 May '06

centos-bounces(a)centos.org <> scribbled on Tuesday, May 09, 2006 8:57 PM: >> -----Original Message----- >> From: centos-bounces(a)centos.org >> [mailto:centos-bounces@centos.org] On Behalf Of Alan Sparks >> Sent: Tuesday, May 09, 2006 9:37 PM >> To: CentOS mailing list >> Subject: Re: [CentOS] OT: MySQL Help >> >> Thomas E Dukes wrote: >>> I ran the following against a table: >>> >>> ALTER TABLE `products` ADD INDEX `idx_products_model` ( >>> `products_model` ); >>> >>> >>> Can this index be removed? If so, how? >>> >> >> Maybe >> DROP INDEX `idx_products_model` >> or >> ALTER TABLE `products` DROP INDEX `idx_products_model` > > Thanks for the help. Wasn't sure if 'DROP' was what I needed > to use. I'm not that MySQL savy. I was following a > suggestion to speed up a process. > The problems I'm having aren't in the same table and I was > was just trying to cover any changes since the problems began. > > I ran mysqlcheck on the database and got an OK on all tables. > Must be something else. > > Thanks!! > > >> >> -- >> Alan Sparks, UNIX/Linux Systems Integration and Administration Are you running mysql-4.x? If so, you might consider using the caching features of 4.x+ It has helped some of my mysql intensive sites quite a bit. Mike

2 1

OT: MySQL Help
by Thomas E Dukes 10 May '06

10 May '06

Hello, I know this is off-topic for this list but I know someone here may be able to help me out of a jam. I ran the following against a table: ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` ); Some things now appear broken but don't know if this was the culprit or not. If I can revert it back it its original state I may be able to determine if it's the cause of some new problems. I did make a back up of the entire database before I made the change on 05-06-06 which I could restore but would lose all data from then til now. Can this index be removed? If so, how? TIA

3 3

yum, dag and xawtv
by Damian Sobieralski 10 May '06

10 May '06

Hi, I'm a newbie with CentOS. Actually, with this generation Linux. I used it back in the middle 90's (Debian and Slackware) but migrated over to FreeBSD. I got tired of the dependency nightmares and wanted a system that "just worked". The FreeBSD ports system did just that for me. I HATE doing the rpm soup thing. RPM finders are nice but I'd rather just use something like the FreeBSD port system to handle all dependency issues for me. But I've slid back into Linux and found CentOS. Boy, have things changed a bit since I was last here :) I have to admit, yum gives me that functionality that I was very happy with FreeBSD - the ports system. It's not exactly the same but I LIKE yum a lot! I am noticing a couple of problems dealing with YUM that I hope you can help me with. I noticed that the default CentOS repositories that came on an install had a lot of the common packages but stuff like audacity and xawtv weren't there. But I figured that there was a repository that did have these. After some web searching, I found about the dag repository. I added the following into /etc/yum.repos.d/dag.repo as stated at http://dag.wieers.com/home-made/apt/FAQ.php : [dag] name=Dag RPM Repository for Red Hat Enterprise Linux baseurl=http://apt.sw.be/redhat/el$releasever/en/$basearch/dag gpgcheck=1 enabled=1 Now when I do a "yum list" I can find lots of the apps that I am looking for. But when I try to install packages I get things like: warning: rpmts_HdrFromFdno: V3 DSA signature: NOKEY, key ID 6b8d79e6 Public key for libquicktime-0.9.8-2.el4.rf.i586.rpm is not installed I can get installs to happen by changing the line in /etc/yum.respon.d/dag.repo from one to zero on the gpgcheck line. Questions: 1) Is dag a good repository to get me these apps that aren't part of the stock CentOS repository file? If not, which one should I use? I don't need bleeding edge (even two versions behind for an app would be fine). 2) What's up with the gpg failures? Should I be worried? 3) Finally, I'm trying to get xawtv to work. I ran "yum install xawtv" and all seemed to go fine. It found a bunch of dependencies and downloaded them from dag. Cool! But when I try to run xawtv I get: This is xawtv-3.94, running on Linux/i686 (2.6.9-34.EL) load_codec_info_from_plugin: dlopen failed for /usr/lib/libquicktime/lqt_ffmpeg.so: /usr/lib/libquicktime/lqt_ffmpeg.so: undefined symbol: avcodec_init Searching for this error has been less than fruitful. I realize this message has several questions in it. If you have opinions on ANY of the questions please feel free to respond. Yum and CentOS have me wanting to go back to Linux. If I can be taught how to use yum to install things "correctly" I think I'll be very happy back here. :-) Thanks in advance. - Damian

8 11

Troubleshooting "too many open files'
by Michael Rock 09 May '06

09 May '06

ulimit -n was 1024, so I am assuming that is likely the problem. So if I understand your reply correctly, I can do a 'ulimit -n 8192' to increase the value, but that is only for the session? Since I have the program starting at bootup what you are saying is I need to edit these files and reboot, Then ulimit -n should show whatever I set it to below? FD_SETSIZE defined in: /usr/include/linux/posix_types.h /usr/include/bits/typesizes.h #define __FD_SETSIZE 8192 Do I have that right? thx __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 2

How to capture/process ksymoops?
by Dave Hatton 09 May '06

09 May '06

Hi all, Can anyone point to some documentation on the recommended way to capture and process ksymoops for Centos 4.3? Many thanks Daveh

1 0

auctex-11.82 el4 RPMs
by Henk van Lingen 09 May '06

09 May '06

Hi, Has someone managed to build auctex-11.82 RPMs for el4/i386? A rpmbuild -ta on the tarball from gnu.org gives me: RPM build errors: File not found: /var/tmp/auctex-root/usr/share/emacs/site-lisp/preview Regards, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

2 1

kernel source rpm
by PV Juliet 09 May '06

09 May '06

Hi All, I attaching a source code kernel 2.6.9.tar.gz . I want to make the source rpm of this file which is patched and also includes the SATA driver controller . Is it possible to get source rpm of this ,so if i reuired to change the kernel , i can do that make the rpm out of this src.rpm which creates the initrd .img . I want to attach the source code . But it gives some problem Please help me to solve this problem . Thanks in advance Regards juliet

2 2

Battery applet missing Compaq R3000
by P Marvin Eberly 09 May '06

09 May '06

Hello list, I recently loaded CentOS 4.2 x86_64 on a Compaq R3000 laptop and then fully updated to 4.3. The battery applet on other installs always just showed up and worked, not so here. It is not in the applet choices at all, it is available here on my desktop. I suspect it is something simple I'm missing but I need a point in the right direction. I did try: yum remove and yum install gnome-applets, no difference. any ideas much appreciated, Marvin -- P Marvin Eberly <eberlyml(a)wjtl.net>

1 0

Uselib24/bindz - owned!
by Nick 09 May '06

09 May '06

So pretty sure one of my boxes has been owned. Just wanted some advise on what to do next. Obviously, i'll need to nuke the fecker and start over but it would be really nice to find out how they got in as its a CentOS 4.3 which is bang up to date. So i found: PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND 7052 apache 25 0 27320 5348 8 R 99.0 0.5 736:52 0 uselib24 [root@box tmp]# netstat -lnp |more Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:32768 0.0.0.0:* LISTEN 3012/rpc.statd tcp 0 0 127.0.0.1:32769 0.0.0.0:* LISTEN 3138/xinetd tcp 0 0 0.0.0.0:66 0.0.0.0:* LISTEN 3124/sshd tcp 0 0 0.0.0.0:9865 0.0.0.0:* LISTEN 7031/bindz tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 14534/mysqld tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 2993/portmap tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 7031/bindz tcp 0 0 0.0.0.0:113 0.0.0.0:* LISTEN 3138/xinetd tcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN 3578/vsftpd tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 10707/sendmail: acc tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN 7031/bindz Bindz.... hmm. telnetting to the port gave me a root shell - nice. My firewall scripts should block that port but i don't know if they're working now :( contents of /var/tmp was: -rwxrwxr-x 1 apache apache 19429 Jan 10 16:20 bindz -rw-r--r-- 1 apache apache 2100 Jan 8 21:32 dc.txt -rwxrwxr-x 1 apache apache 479843 Aug 3 2005 uselib24 dc.txt started: #!/usr/bin/perl use IO::Socket; #IRAN HACKERS SABOTAGE Connect Back Shell #code by:LorD #We Are :LorD-C0d3r-NT #Email:LorD@ihsteam.com # #lord@SlackwareLinux:/home/programing$ perl dc.pl #--== ConnectBack Backdoor Shell vs 1.0 by LorD of IRAN HACKERS SABOTAGE ==-- # #Usage: dc.pl [Host] [Port] # #Ex: dc.pl 127.0.0.1 2121 #lord@SlackwareLinux:/home/programing$ perl dc.pl 127.0.0.1 2121 #--== ConnectBack Backdoor Shell vs 1.0 by LorD of IRAN HACKERS SABOTAGE ==-- # #[*] Resolving HostName #[*] Connecting... 127.0.0.1 #[*] Spawning Shell #[*] Connected to remote host i might e-mail him and thank him. So what next?

7 7

Cannot access windows shared folder from CentOS 4.3
by Simon 09 May '06

09 May '06

Dear members, Recently I encountered a problem on accessing windows shared folder from CentOS 4.3. I'm quite wondering why I couldn't access since I already allow all or even switch off my windows firewall. What I did is I just type smb://my_windows_ip and the error message saying that "You do not have the permission necessary to view the contents of "windows Network: my_windows_ip". Did I miss anything when I try to access my windows shared folder? I would like to say sorry if this question had been asked previously..i had try to find the solution on the internet but I fail to find one. Thanks in advance Best Regards Simon Teh Univerisiti Sains Malaysia

2 1

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Discuss