2 Questions

mckinleysh · 01-20-2006, 10:14 AM

I am running a SuSe 10 for a documentation server running phpbb with MySQL.

Question1:
MySQL is set in the services to start on runlevel 3 & 5 and is enabled in YaST.

However it never starts on its own. How can I ensure that MySQL will start on its own? When I watch verbose bootup I see MySQL....start, but YaST says MySQL is enabled but not running. After clicking enable, MySQL starts fine.

Question2:
I am also running VNC on this machine and it runs fine. However I would like to learn how to set this as a service so it starts when booting the machine.

Let me know if I need to post any logs as I don't want to clutter the post if I don't have to.

Mirag3 · 01-20-2006, 05:31 PM

1)try using this command

Code:

modprobe mysql

2)same thing (but the need to start vnc as root may become a problem, i dont know)

Code:

modprobe vncserver

To check that both of these worked use

Code:

lsmod

Note: All need to be run as root(su)

mckinleysh · 01-23-2006, 07:21 AM

1) Returned:

Code:

FATAL: Module mysql not found.

2) Returned:

Code:

FATAL: Module vncserver not found.

3) Returned:

Code:

Module                  Size  Used by
iptable_filter          2816  0
ip_tables              19456  1 iptable_filter
hfsplus                75140  0
vfat                   12800  0
fat                    49692  1 vfat
subfs                   7552  1
speedstep_lib           4228  0
freq_table              4612  0
ipv6                  242752  29
snd_pcm_oss            59168  0
snd_mixer_oss          18944  1 snd_pcm_oss
snd_seq                51984  0
snd_seq_device          8588  1 snd_seq
button                  7056  0
battery                10244  0
ac                      5252  0
edd                     9824  0
3c59x                  40360  0
snd_intel8x0           33504  1
snd_ac97_codec         91004  1 snd_intel8x0
i2c_i801                8844  0
i2c_core               20368  1 i2c_i801
mii                     5504  1 3c59x
snd_ac97_bus            2432  1 snd_ac97_codec
snd_pcm                93064  3 snd_pcm_oss,snd_intel8x0,snd_ac97_codec
snd_timer              24452  2 snd_seq,snd_pcm
snd                    60420  10 snd_pcm_oss,snd_mixer_oss,snd_seq,snd_seq_device,snd_intel8x0,snd_ac97_codec,snd_pcm,snd_timer
soundcore               9184  1 snd
snd_page_alloc         10632  2 snd_intel8x0,snd_pcm
uhci_hcd               32016  0
usbcore               112512  2 uhci_hcd
generic                 4484  0 [permanent]
intel_agp              22044  1
agpgart                33096  1 intel_agp
hw_random               5268  0
shpchp                 88676  0
pci_hotplug            26164  1 shpchp
parport_pc             38980  1
lp                     11460  0
parport                33864  2 parport_pc,lp
dm_mod                 54972  0
reiserfs              250480  1
ide_cd                 39684  0
cdrom                  36896  1 ide_cd
fan                     4996  0
thermal                14472  0
processor              24380  1 thermal
piix                    9988  0 [permanent]
ide_disk               17152  3
ide_core              122380  4 generic,ide_cd,piix,ide_disk

Mirag3 · 01-23-2006, 09:09 PM

sorry, im not quite sure - try checking the names of the shell scripts used to start the programs, i may be wrong about their names. also, what method of vnc are you using (tightvnc, realvnc, etc.)

onjoo · 01-24-2006, 04:49 AM

There has been problems with MySql on the suse10.
Modprobe wont help here.

Try updating Mysql with YOU to newest one, its listed as optional, not critical.
That will fix some on boot problems.

One problem with MySQL is that when shutting down the computer SUSE can't allways kill the process, so next time it tries to enable it on boot it gets locked.

One thing you could try is to disable the mysql-service and then
DELETE var/lib/mysql/mysql.sock and enable it again.

For the Remote administration thing I haven't got any tips. Sorry

mckinleysh · 01-24-2006, 07:11 AM

I am using Krfb:

http://dot.kde.org/1044482230/