Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread David Gillies
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Voytek Eymont wrote:
> but, one of the commands worked... not sure which one, though... I briefly
> saw dir listing of the CD... before I unmounted it... (finger quicker than
> eye thing)
> I guess I might need to repeat last 150 'mount' commands

save yourself sometime, check out your bash history:

history

or

history|grep mount|tail

Should show you the last 10 mount commands

- --
dave.

- 
reality-distortion field: n.
An expression used to describe the persuasive ability of managers like
Steve Jobs. Those close to these managers become passionately committed
to possibly insane projects, without regard to the practicality of their
implementation or competitive forces in the marketplace.
- 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFEMJCThPPdWeHRgaoRAlokAJ9KieLLoYXHt1D+7iaA5qMlgr4bTQCg7Jcf
jc4MiJBqUdhqLTeCl6RtNJU=
=2y0E
-END PGP SIGNATURE-
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Voytek Eymont

On Mon, April 3, 2006 12:15 pm, [EMAIL PROTECTED] wrote:
> On Monday 03 April 2006 09:26, [EMAIL PROTECTED] wrote:
>
>> On Mon, April 3, 2006 10:41 am, Michael Fox wrote:
>>
>>> On 4/3/06, Voytek Eymont <[EMAIL PROTECTED]> wrote:


>> # mount /dev/sda3 /mnt/cdrom
>> mount: /dev/sda3 is not a valid block device
>>
>
> It can be much more tricky than this thread leads you to suspect:

well, the results I'm getting made me suspect it, ;>)

> The easy way: Never do that (install on IDE the use SCSI)
> Another one:  Boot knoppix and spelunk (find out which modules are used,
> what device the CDROM is)
>
> 1) You need to ensure the modules needed for SCSI CDROM are loaded
> From dim memory sd and/or sr look in your /lib/modules/
> 2) ID which device the CDROM is
> 3) For fun: symlink /dev/cdrom-device /dev/cdrom
> 4) Put an (auto)mount line in /etc/fstab

> If everything is correct, but the module is not loaded, you will get
> error messages. James

but, one of the commands worked... not sure which one, though... I briefly
saw dir listing of the CD... before I unmounted it... (finger quicker than
eye thing)
I guess I might need to repeat last 150 'mount' commands


-- 
Voytek

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread jam
On Monday 03 April 2006 09:26, [EMAIL PROTECTED] wrote:
> On Mon, April 3, 2006 10:41 am, Michael Fox wrote:
> > On 4/3/06, Voytek Eymont <[EMAIL PROTECTED]> wrote:
> >> ahem, how do I enable/mount a SCSI CD ROM ? this RHEL was installed off
> >> an IDE CDROM, but, now I have it in a system with Adaptec 2940 & SCSI
> >> CDROM, I think, the 2940 was picked up on boot
> >
> > Determine what device the cdrom is on the scsi chain, and then use its
> > device name along with suitable mount point to mount it.
>
> is that the same as the SCI ID # ?
> how can I interogate it ?
>
> > mount /dev/sd?? /my/mount/point
>
> I tried 1-7 all with invalid block:
>
> # mount /dev/sda3 /mnt/cdrom
> mount: /dev/sda3 is not a valid block device

It can be much more tricky than this thread leads you to suspect:

The easy way: Never do that (install on IDE the use SCSI)
Another one:  Boot knoppix and spelunk (find out which modules are used, what 
device the CDROM is)

1) You need to ensure the modules needed for SCSI CDROM are loaded
   From dim memory sd and/or sr look in your /lib/modules/
2) ID which device the CDROM is
3) For fun: symlink /dev/cdrom-device /dev/cdrom
4) Put an (auto)mount line in /etc/fstab

If everything is correct, but the module is not loaded, you will get error 
messages. 
James
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: SCSI CDROM, was Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread David Gillies
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Voytek Eymont wrote:
> is it 'sda4' ?
> 
> 
> # mount /dev/sda4 /mnt/cdrom
> mount: /dev/sda4 is not a valid block device

try

mount /dev/sda /mnt/cdrom

You don't need to specify a partition number.

- --
dave.

- 
reality-distortion field: n.
An expression used to describe the persuasive ability of managers like
Steve Jobs. Those close to these managers become passionately committed
to possibly insane projects, without regard to the practicality of their
implementation or competitive forces in the marketplace.
- 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFEMHsihPPdWeHRgaoRAtjFAJ91RCJjgjzxqnjbcYx0TDkUwbQtHQCfaadb
aHZG/Cy/7FWRwbmAKkkFqUY=
=/ofj
-END PGP SIGNATURE-
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


SCSI CDROM, was Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Voytek Eymont

On Mon, April 3, 2006 11:11 am, Michael Fox wrote:
> On 4/3/06, Voytek Eymont <[EMAIL PROTECTED]> wrote:

> Maybe you could paste us a dmesg output showing it looking into your
> scsi devices (including the scsi cdrom) and we can confirm what to use.

I trimmed some stuff, though, I think I've left all relevant stuff, if
not, I'll post the whole file


Linux version 2.4.21-4.EL ([EMAIL PROTECTED]) (gcc version
3.2.3
20030502 (Red Hat Linux 3.2.3-20)) #1 Fri Oct 3 18:13:58 EDT 2003

Kernel command line: ro root=LABEL=/ hdc=ide-scsi
ide_setup: hdc=ide-scsi

Uniform Multi-Platform E-IDE driver Revision: 7.00beta4-2.4
ide: Assuming 33MHz system bus speed for PIO modes; override with idebus=xx
PIIX4: IDE controller at PCI slot 00:07.1
PIIX4: chipset revision 1
PIIX4: not 100% native mode: will probe irqs later
ide0: BM-DMA at 0xf000-0xf007, BIOS settings: hda:pio, hdb:pio
ide1: BM-DMA at 0xf008-0xf00f, BIOS settings: hdc:pio, hdd:pio
hda: FUJITSU MPE3084AE, ATA DISK drive
blk: queue c0417e80, I/O limit 4095Mb (mask 0x)
ide0 at 0x1f0-0x1f7,0x3f6 on irq 14
hda: attached ide-disk driver.
hda: 16514064 sectors (8455 MB) w/512KiB Cache, CHS=1027/255/63, UDMA(33)
ide-floppy driver 0.99.newide
Partition check:
 hda: hda1 hda2 hda3
ide-floppy driver 0.99.newide


SCSI subsystem driver Revision: 1.00
scsi0 : SCSI host adapter emulation for IDE ATAPI devices
Starting timer : 0 0
IA-32 Microcode Update Driver: v1.11 <[EMAIL PROTECTED]>
parport0: PC-style at 0x378 [PCSPP,TRISTATE]
PCI: Found IRQ 10 for device 00:08.0
scsi1 : Adaptec AIC7XXX EISA/VLB/PCI SCSI HBA DRIVER, Rev 6.2.36

aic7870: Single Channel A, SCSI Id=7, 16/253 SCBs

Starting timer : 0 0
blk: queue d33d9214, I/O limit 4095Mb (mask 0x)
(scsi1:A:4): 5.681MB/s transfers (5.681MHz, offset 15)
  Vendor: SONY  Model: CD-ROM CDU-76SRev: 1.1c
  Type:   CD-ROM ANSI SCSI revision: 02
Starting timer : 0 0
blk: queue d3de1a14, I/O limit 4095Mb (mask 0x)
scsi : 1 host left.

-

is it 'sda4' ?


# mount /dev/sda4 /mnt/cdrom
mount: /dev/sda4 is not a valid block device

-- 
Voytek

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Voytek Eymont

On Mon, April 3, 2006 10:57 am, Del wrote:
> Voytek Eymont wrote:

> RHEL 3 doesn't ship with MySQL server.

thanks, Del
aha, that explains it, thanks for pointing that out
when I perused the list of options, I saw the mysql 'section', but just
gave it a quick glance, assuming both server and clinet were there




-- 
Voytek

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Michael Fox
On 4/3/06, Voytek Eymont <[EMAIL PROTECTED]> wrote:
>

Maybe you could paste us a dmesg output showing it looking into your
scsi devices (including the scsi cdrom) and we can confirm what to
use.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Voytek Eymont

On Mon, April 3, 2006 10:41 am, Michael Fox wrote:
> On 4/3/06, Voytek Eymont <[EMAIL PROTECTED]> wrote:


>> ahem, how do I enable/mount a SCSI CD ROM ? this RHEL was installed off
>> an IDE CDROM, but, now I have it in a system with Adaptec 2940 & SCSI
>> CDROM, I think, the 2940 was picked up on boot

> Determine what device the cdrom is on the scsi chain, and then use its
> device name along with suitable mount point to mount it.

is that the same as the SCI ID # ?
how can I interogate it ?

> mount /dev/sd?? /my/mount/point

I tried 1-7 all with invalid block:

# mount /dev/sda3 /mnt/cdrom
mount: /dev/sda3 is not a valid block device


-- 
Voytek

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Michael Fox
On 4/3/06, Matthew Hannigan <[EMAIL PROTECTED]> wrote:
> # mount /dev/cdrom

Will only work if /dev/cdrom has now been symlinked to the cdrom on
the scsi bus. As the install was done on an ide cdrom as poster
stated, so it might be symlinked to the ide bus device.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Del

Voytek Eymont wrote:

I've just installed RHEL3 with 'everything' option, when I tried:


RHEL 3 doesn't ship with MySQL server.

You have to log in to RHN, add the "Red Hat Enterprise Linux ES
(v. 3 for x86) Extras" channel to your list of subscribed channels,
and then do:

up2date -u mysql-server

--
Del
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Matthew Hannigan
On Mon, Apr 03, 2006 at 10:28:23AM +1000, Voytek Eymont wrote:
> 
> # mount cdrom
> mount: can't find cdrom in /etc/fstab or /etc/mtab

# mount /dev/cdrom

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Michael Fox
On 4/3/06, Voytek Eymont <[EMAIL PROTECTED]> wrote:
>
> On Mon, April 3, 2006 9:29 am, Matthew Hannigan wrote:
> > On Mon, Apr 03, 2006 at 08:57:23AM +1000, Voytek Eymont wrote:
> >
> >> I've just installed RHEL3 with 'everything' option, when I tried:
>
> > Er, actually try installing 'mysql-server'
>
> > I think you only have the client bits.
>
> yes, it looks like it. Seems I dumbly assumed that 'everything' @ 5GB
> would include server and client.
>
> ahem, how do I enable/mount a SCSI CD ROM ?
> this RHEL was installed off an IDE CDROM, but, now I have it in a system
> with Adaptec 2940 & SCSI CDROM, I think, the 2940 was picked up on boot

Determine what device the cdrom is on the scsi chain, and then use its
device name along with suitable mount point to mount it.

mount /dev/sd?? /my/mount/point
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Voytek Eymont

On Mon, April 3, 2006 9:29 am, Matthew Hannigan wrote:
> On Mon, Apr 03, 2006 at 08:57:23AM +1000, Voytek Eymont wrote:
>
>> I've just installed RHEL3 with 'everything' option, when I tried:

> Er, actually try installing 'mysql-server'

> I think you only have the client bits.

yes, it looks like it. Seems I dumbly assumed that 'everything' @ 5GB
would include server and client.

ahem, how do I enable/mount a SCSI CD ROM ?
this RHEL was installed off an IDE CDROM, but, now I have it in a system
with Adaptec 2940 & SCSI CDROM, I think, the 2940 was picked up on boot
# mount cdrom
mount: can't find cdrom in /etc/fstab or /etc/mtab

# cat /etc/fstab
LABEL=/ /   ext3defaults1 1
LABEL=/boot /boot   ext3defaults1 2
none/dev/ptsdevpts  gid=5,mode=620  0 0
none/proc   procdefaults0 0
none/dev/shmtmpfs   defaults0 0
/dev/hda3   swapswapdefaults0 0
/dev/fd0/mnt/floppy autonoauto,owner,kudzu
0 0
/dev/cdrom  /mnt/cdrom  udf,iso9660
noauto,owner,kudzu,ro 0 0

# cat /etc/mtab
/dev/hda2 / ext3 rw 0 0
none /proc proc rw 0 0
usbdevfs /proc/bus/usb usbdevfs rw 0 0
/dev/hda1 /boot ext3 rw 0 0
none /dev/pts devpts rw,gid=5,mode=620 0 0
none /dev/shm tmpfs rw 0 0



-- 
Voytek

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Voytek Eymont

On Mon, April 3, 2006 9:06 am, Ben Donohue wrote:
> Hi Voytek,
> i'm no pro but has the "/etc/rc.d/init.d/mysqld start" been given a go?


[EMAIL PROTECTED] bin]# /etc/rc.d/init.d/mysqld start
-bash: /etc/rc.d/init.d/mysqld: No such file or directory

> also i've installed everything before and had to reinstall mysql server
> before it would work. This is on Redhat.

seems I'll need likewise

-- 
Voytek

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Voytek Eymont

On Mon, April 3, 2006 9:06 am, Matthew Hannigan wrote:
> On Mon, Apr 03, 2006 at 08:57:23AM +1000, Voytek Eymont wrote:

> Try
> chkconfig --add mysqld then/or chkconfig --list | grep mysql
>
> And let us know what happens


[EMAIL PROTECTED] bin]#  chkconfig --add mysqld
error reading information on service mysqld: No such file or directory
[EMAIL PROTECTED] bin]# chkconfig --list | grep mysql
[EMAIL PROTECTED] bin]#


-- 
Voytek

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Matthew Hannigan
On Mon, Apr 03, 2006 at 08:57:23AM +1000, Voytek Eymont wrote:
> I've just installed RHEL3 with 'everything' option, when I tried:

Er, actually try installing 'mysql-server'

I think you only have the client bits.

matt

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Ben Donohue

Hi Voytek,
i'm no pro but has the "/etc/rc.d/init.d/mysqld start" been given a go?
also i've installed everything before and had to reinstall mysql server 
before it would work.

This is on Redhat.
Ben


Voytek Eymont wrote:

I've just installed RHEL3 with 'everything' option, when I tried:

'service mysqld' it says: unrecognized service

in /usr/bin I have these:

mysql   mysqld_multimysql_install_db
mysqlaccess mysqldump   mysql_setpermission
mysqlbinlog mysqldumpslow   mysqlshow
mysqlbugmysql_find_rows mysqltest
mysqlcheck  mysql_fix_privilege_tables  mysql_zap
mysql_configmysqlhotcopy
mysql_convert_table_format  mysqlimport

trying mysqld_multi gives

[EMAIL PROTECTED] bin]# mysqld_multi
Couldn't find the mysqld binary! Tried: /usr/libexec/mysqld
Couldn't find the mysqladmin binary! Tried: /usr/bin/mysqladmin
Error with an option, see mysqld_multi --help for more info!

-

I'm trying toggogle for anwser, but, if anyone knows where to point me,
pls do

  

--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html


Re: [SLUG] MySQL in RHEL3 ?

2006-04-02 Thread Matthew Hannigan
On Mon, Apr 03, 2006 at 08:57:23AM +1000, Voytek Eymont wrote:
> I've just installed RHEL3 with 'everything' option, when I tried:
> 
> 'service mysqld' it says: unrecognized service

Try
chkconfig --add mysqld
then/or
chkconfig --list | grep mysql

And let us know what happens
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html