Discuss May 2010

discuss@lists.centos.org

270 participants
215 discussions

32-bit boot CD for 64-bit install using kickstart
by Carlos S 02 May '10

02 May '10

Hi, I am using kickstart method for CentOS installation. The install is done using mirror site URL and not CD/DVD ISOs. However, the system is initially booted from 32-bit CentOS CD. When the install process starts I get errors as: - package rpm not found - abort/continue? - package lvm2 not found - abort/continue? - package grub not found - abort/continue? - ... - ... If I change install URL to 32-bit ISOs then everything works fine. Do I need to use 64-bit boot CD for this install? -- CS.

4 5

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

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 May 2010