Discuss

discuss@lists.centos.org

34758 discussions

Start a nNew thread

Do you provide Sendmail help?
by Wang, Mary Y 02 May '10

02 May '10

Hi, Not sure if I'm on the right list. Do you provide Sendmail configuration help? Thanks Mary

3 2

I need some help joining data from 3 MySQL tables, please
by Rudi Ahlers 01 May '10

01 May '10

Hi all, I am trying to display collective data from 3 MySQL tables: The query I have, so far, is SELECT c . * , COUNT( m.id ) AS `members` FROM `jos_mls_teams` AS `c` LEFT JOIN `jos_mls_teams_members` AS `m` ON m.teamid = c.id RIGHT JOIN ( SELECT u.name, u.lastvisitDate FROM `jos_users` AS `u` ) ON u.id = m.userid GROUP BY c.id LIMIT 0 , 30 But get the following error: #1248 - Every derived table must have its own alias A google search results suggested the alias should be put after the bracket. So, I change the code as follow, and move the *AS `u`* outside the right bracket: SELECT c . * , COUNT( m.id ) AS `members` FROM `jos_mls_teams` AS `c` LEFT JOIN `jos_mls_teams_members` AS `m` ON m.teamid = c.id RIGHT JOIN ( SELECT u.name, u.lastvisitDate FROM `jos_users` ) AS `u` ON u.id = m.userid GROUP BY c.id LIMIT 0 , 30 But then I get the error: #1054 - Unknown column 'u.name' in 'field list' Basically, I need to display all the data from the "*jos_mls_teams", total number of members linked to a user from the *"jos_mls_teams_members" (basically counting all the rows where the corresponding user's id is in the userid field. Then I want to display that same corresponding user's name & email from another table. Table structures to follow: CREATE TABLE `jos_mls_teams` ( `id` int(11) NOT NULL auto_increment, `userid` int(5) NOT NULL, `memberid` int(11) NOT NULL, `name` varchar(255) NOT NULL default '', `email` text, `area` text, `arealeader` varchar(150) NOT NULL, `founded` text, `herder` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ; CREATE TABLE IF NOT EXISTS `jos_users` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `username` varchar(150) NOT NULL default '', `email` varchar(100) NOT NULL default '', `password` varchar(100) NOT NULL default '', `usertype` varchar(25) NOT NULL default '', `block` tinyint(4) NOT NULL default '0', `sendEmail` tinyint(4) default '0', `gid` tinyint(3) unsigned NOT NULL default '1', `registerDate` datetime NOT NULL default '0000-00-00 00:00:00', `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00', `activation` varchar(100) NOT NULL default '', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `usertype` (`usertype`), KEY `idx_name` (`name`), KEY `gid_block` (`gid`,`block`), KEY `username` (`username`), KEY `email` (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ; CREATE TABLE IF NOT EXISTS `jos_mls_teams_members` ( `id` int(11) NOT NULL auto_increment, `teamid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `leader` tinyint(1) NOT NULL default '0', `sysid` int(11) NOT NULL, `memberid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 P.S. just to be clear, I want to eventually remove the name & email fields from the `jos_mls_teams` table, since Joomla uses the `jos_users` table for registration purposes and it's easier to use the built-in registration than trying to reinvent the wheel :) -- Kind Regards Rudi Ahlers SoftDux Website: http://www.SoftDux.com Technical Blog: http://Blog.SoftDux.com Office: 087 805 9573 Cell: 082 554 7532

2 1

how to build a centos kernel?
by Robert P. J. Day 01 May '10

01 May '10

a couple folks on the local mailing list were asking about the mechanics of building a kernel for a centos system, and they seemed to suggest that there were some intricacies involved as opposed to other distros. i've never tried it -- is there a trick or something? got a pointer to the canonical web page that has the directions? 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 ========================================================================

2 1

Request for rss feeds
by john maclean 01 May '10

01 May '10

Who would be the right person(s) to ask for rss feeds on the main centos website? -- John Maclean 07739 171 531 MSc (DIC) Enterprise Linux Systems Engineer

1 0

CentOS 5.4 off-center on SuperMicro console
by Rudi Ahlers 30 Apr '10

30 Apr '10

I have a weird situation with a new installation of CentOS 5.4 x64, on a SuperMicro X7SBI server. The server has a <a href=" http://www.supermicro.com/products/motherboard/Xeon3000/3210/X7SBi.cfm" target="_new">SuperMicro X7SBi motherboard</a>, board ATI ES1000 and Core2Quad Q9505 CPU. The kernel is When I login to the console, using a "17 CRT monitor (haven't tested others), the screen is off-center to the right. This happens as soon as the boot loaders gets to: "waiting for driver initialization" Below are asome photos to show what happens. http://blog.softdux.com//everything-todo-with-linux/centos-5-4-off-center-o… http://blog.softdux.com//everything-todo-with-linux/centos-5-4-off-center-o… http://blog.softdux.com//everything-todo-with-linux/centos-5-4-off-center-o… Other Linux distro's, including Fedora Core 11, FC 12, Ubuntu 9.10 and OpenFiler 2.3 works fine though. The only thing I can think of is the video driver, but I don't have X installed, so it can't be that. And I've reinstalled CentOS 3 times already thinking I did something wrong with the installation. It's not the monitor, since I have another CentOS 5.4 server, running on an Intel motherboard that looks normal with this setup. They're connected to the same monitor via a KVM switch. -- Kind Regards Rudi Ahlers SoftDux Website: http://www.SoftDux.com Technical Blog: http://Blog.SoftDux.com Office: 087 805 9573 Cell: 082 554 7532

5 7

Reverse engineering USB devices
by Stephen Harris 30 Apr '10

30 Apr '10

I'm pretty sure this is the wrong list, but maybe some clever people here can redirect me... I have a "RCA RS2100 Bookshelf Audio System" http://www.woot.com/blog/viewentry.aspx?id=2744 This is radio/CD/mp3 player... PLUS it can stream audio wirelessly. You plug a USB device into your PC and you can remote control what gets played from the RS2100 remote control ("Wireless Musiclink"). BUT only with Windows Media Center. When I plugged the device in it appears to look like 3 devices; a HID, an audio device and something else I can't remember (I'm not at that machine at the moment). My feeling is that the HID is used to inject commands from the RS2100 (eg "play track <x>"), the audio device is for streaming and the third device is feedback for the remote display. The question I have... how can I reverse engineer the protocol used so that I can make this work on my CentOS machine? (I don't want to run a Windows instance just for remote audio!). Any hints, tips, pointers etc much appreciated. Thanks! -- rgds Stephen

3 2

need help: about remove space
by adrian kok 30 Apr '10

30 Apr '10

Hi all I have big file as below and would like to know how many line eg: wc -l file but can't figure out how to know If I type wc -l file, I only get the 1023 but it includes the space When I use cat file | tr -d "\r \n". it gives me "adrian alice......" I need it as fileB and then wc -l fileB. Thank you so much file ==== adrian alice Patrick file B ====== adrian alice Patrick

5 4

C5: correct place for routing scripts?
by Kimmo Koivisto 30 Apr '10

30 Apr '10

Hello I have several Centos 4 and Centos 5 servers. Because of the nature of the environment, there are some static arp entries made with arp command and then source routing made with "ip rule/ip route" -commands. Those commands are now placed at /etc/rc.d/rc.local which is bad: if server is rebooted, those commands will be done correctly but if administrator restarts network with "/etc/init.d/network restart", source routes will disappear. RedHat/Centos qualified admin knows only about network restart init script, so I try to avoid doing any hacks. I could edit the init script (/etc/init.d/network) but changes could disappear with updates. So, what is the correct place for different commands (arp, ip, whatever) that is executed (a) once when network started (b) once when network stopped (I don't need but nice to know) (c) once per every interface (I don't need but nice to know) Best Regards, Kimmo

4 5

NFS automount failure
by Trevor Cooper 30 Apr '10

30 Apr '10

I'm having a problem with automount (autofs) from a server running CentOS 5.4 to clients (example is CentOS 5.4). Client pulls automount maps from NIS. THIS particular server is also used for login so it is NIS bound as well (other servers are NOT). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NIS Server Side... (content shortened) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ $ ypcat -k auto.master | sort | grep auto.mdkm1 /storage/mdkm1 auto.mdkm1 --timeout=600 $ ypcat -k auto.mdkm1 | sort 1 137.110.179.254:/mdkm1/1 . . . 10 137.110.179:254:/mdkm1/10 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NFS Server Side... (content shortened) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ $ cat /etc/exports /mdkm1/1 ###.###.172.0/25(rw,sync) ###.###.179.192/26(rw,async) . . . /mdkm1/10 ###.###.172.0/25(rw,sync) ###.###.179.192/26(rw,async) $ cat /etc/fstab /dev/MDKM1/MDKM1-1 /mdkm1/1 ext3 defaults 1 2 . . . /dev/MDKM1/MDKM1-10 /mdkm1/10 ext3 defaults 1 2 # mount /dev/mapper/MDKM1-MDKM1--1 on /mdkm1/1 type ext3 (rw) . . . /dev/mapper/MDKM1-MDKM1--10 on /mdkm1/10 type ext3 (rw) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NIS/NFS Client Side... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ $ cat /etc/auto.master | egrep -v "^#" /misc /etc/auto.misc /net -hosts +auto.master # service autofs status automount (pid 3714) is running... $ ls /storage/mdkm1/1 kmdev lost+found $ ls /storage/mdkm1/10 <--- wait here forever [CTRL-C] to abort ls: /storage/mdkm1/10: Interrupted system call *NOTE: Above command never completes and will hang the shell from multiple clients. # mkdir -p /mnt/mdkm1/10 # mount -t nfs ###.###.179.254:/mdkm1/10 /mnt/mdkm1/10 $ ls /mnt/mdkm1/10 kmdev lost+found # umount /mnt/mdkm1/10 NOTE: During mount/umount the NFS server logs show the requests for the automount of mdkm1/1 AND the manual mount of mdkm1/10. The server log never shows an attempt to mount mdkm1/10 in the 'stalled' automount attempt. For example... Apr 27 13:14:50 rilkm01 mountd[8002]: authenticated mount request from ###.###.172.70:730 for /mdkm1/1 (/mdkm1/1) Apr 27 13:15:24 rilkm01 mountd[8002]: authenticated unmount request from ###.###.172.70:771 for /mdkm1/1 (/mdkm1/1) Apr 27 13:16:17 rilkm01 mountd[8002]: authenticated mount request from ###.###.172.70:785 for /mdkm1/10 (/mdkm1/10) Apr 27 13:16:31 rilkm01 mountd[8002]: authenticated unmount request from ###.###.172.70:794 for /mdkm1/10 (/mdkm1/10) I've restarted the Server NFS services, Client autofs services AND the systems as a whole multiple times to no avail. Any ideas? Thanks, Trevor Cooper -- Trevor Cooper, M.Sc. Data Systems Programmer / System Administrator University of California, San Diego Multimodal Imaging Laboratory 8950 Villa La Jolla Dr., Suite C101 La Jolla, CA 92037 Phone: (858) 534-8259 Fax: (858) 534-1078

3 8

Xenserver installation problem
by Georghy 29 Apr '10

29 Apr '10

Hi all, I'm trying to install xenserver on a 64bit processor server but I'm experiencing an error, take a look : http://img641.imageshack.us/i/capturebg.png/ what should I do ? -- Cordialement, / Greetings, Georghy FUSCO

3 4

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