Topic: a lil more help plz

[mukii]

hello...
plz need some help...
after setting up users and creating accounts...
i av run into a problem...
now the database does not start up anymore...
which means no access to the email accounts...
plz can i get some help....

also some of the accounts created are locked and the password needs
to be reset... is there a way that i can do that in one process... hard goin thru over 300 accounts and modifying the passwords...

thanx....
mukii

[raem]

mukii

>...now the database does not start up anymore...

It might be easier if you told us what you did to stop the database starting.

[mukii]

i really didnt do anythin...
but i did find a code 2 restart it.../ service mysqld start /
but when i go to .../webmail it tells me it has encountered a fatal error.
plz help.....
thanx...
plus any help with the password???

[raem]

mukii

> i really didnt do anythin...

Something caused the database to stop/crash. Tell us all the things you did do as one of them may have caused the problem.

> ....service mysqld start

You are strongly advised not to use the service command on sme server, it is deprecated & unreliable in many circumstances. Search here for alternatives

> ...when i go to webmail it tells me it has encountered a fatal error.

Saying that you get an error tells us very little. If you quote the complete error you are receiving it will tell us a lot more.

Have you looked in /var/log/messages log file to see if there are any clues ?

[mukii]

hello there 2day...
this is the code from the log...
plz can u see whats wrong??

Aug  1 08:26:24 mail1 rc.e-smith: Starting haldaemon:  succeeded
Aug  1 08:26:25 mail1 mysql.init: Waiting for mysql to startup
Aug  1 08:26:25 mail1 squid[3563]: Loaded Icons.
Aug  1 08:26:25 mail1 squid[3563]: Accepting HTTP connections at 0.0.0.0, port 3128, FD 11.
Aug  1 08:26:25 mail1 squid[3563]: Accepting ICP messages at 0.0.0.0, port 3130, FD 12.
Aug  1 08:26:25 mail1 squid[3563]: WCCP Disabled.
Aug  1 08:26:25 mail1 squid[3563]: Ready to serve requests.
Aug  1 08:26:25 mail1 fstab-sync[3692]: removed all generated mount points
Aug  1 08:26:27 mail1 squid[3563]: Done scanning /var/spool/squid swaplog (0 entries)
Aug  1 08:26:27 mail1 squid[3563]: Finished rebuilding storage from disk.
Aug  1 08:26:27 mail1 squid[3563]:         0 Entries scanned
Aug  1 08:26:27 mail1 squid[3563]:         0 Invalid entries.
Aug  1 08:26:27 mail1 squid[3563]:         0 With invalid flags.
Aug  1 08:26:27 mail1 squid[3563]:         0 Objects loaded.
Aug  1 08:26:27 mail1 squid[3563]:         0 Objects expired.
Aug  1 08:26:27 mail1 squid[3563]:         0 Objects cancelled.
Aug  1 08:26:27 mail1 squid[3563]:         0 Duplicate URLs purged.
Aug  1 08:26:27 mail1 squid[3563]:         0 Swapfile clashes avoided.
Aug  1 08:26:27 mail1 squid[3563]:   Took 6.9 seconds (   0.0 objects/sec).
Aug  1 08:26:27 mail1 squid[3563]: Beginning Validation Procedure
Aug  1 08:26:27 mail1 squid[3563]:   Completed Validation Procedure
Aug  1 08:26:27 mail1 squid[3563]:   Validated 0 Entries
Aug  1 08:26:27 mail1 squid[3563]:   store_swap_size = 0k
Aug  1 08:26:28 mail1 squid[3563]: storeLateRelease: released 0 objects
Aug  1 08:26:30 mail1 ntpd: logging to file /dev/stdout
Aug  1 08:26:32 mail1 atalkd[3587]: zip_getnetinfo for eth0
Aug  1 08:26:43 mail1 last message repeated 9 times
Aug  1 08:26:45 mail1 rc.e-smith: Starting mysql.init:  failed
Aug  1 08:26:45 mail1 esmith::event[3818]: Processing event: local  
Aug  1 08:26:45 mail1 esmith::event[3818]: Running event handler: /etc/e-smith/events/actions/generic_template_expand
Aug  1 08:26:45 mail1 esmith::event[3818]: expanding /boot/grub/grub.conf  
Aug  1 08:26:45 mail1 esmith::event[3818]: generic_template_expand=action|Event|local|Action|generic_template_expand|Start|1154417205 470966|End|1154417205 787698|Elapsed|0.316732
Aug  1 08:26:45 mail1 esmith::event[3818]: Running event handler: /etc/e-smith/events/local/S50clear-pptp-interfaces
Aug  1 08:26:45 mail1 esmith::event[3818]: S50clear-pptp-interfaces=action|Event|local|Action|S50clear-pptp-interfaces|Start|1154417205 788702|End|1154417205 893221|Elapsed|0.104519
Aug  1 08:26:45 mail1 esmith::event[3818]: Running event handler: /etc/e-smith/events/local/S90yum-update-dbs
Aug  1 08:26:45 mail1 esmith::event[3818]: S90yum-update-dbs=action|Event|local|Action|S90yum-update-dbs|Start|1154417205 894341|End|1154417205 923192|Elapsed|0.028851
Aug  1 08:26:42 mail1 atalkd[3587]: zip_getnetinfo for eth0
Aug  1 08:26:52 mail1 atalkd[3587]: config for no router
Aug  1 08:26:53 mail1 atalkd[3587]: ready 0/0/0
Aug  1 08:26:53 mail1 atalk: atalkd startup succeeded
Aug  1 08:26:59 mail1 atalk:   Registering mail1:Workstation: succeeded
Aug  1 08:27:05 mail1 atalk:   Registering mail1:netatalk: succeeded
Aug  1 08:27:05 mail1 papd[3855]: restart (2.0.3)
Aug  1 08:27:05 mail1 atalk: papd startup succeeded
Aug  1 08:27:05 mail1 atalk: cnid_metad startup succeeded
Aug  1 08:27:05 mail1 afpd[3863]: Registering CNID module [last]
Aug  1 08:27:05 mail1 afpd[3863]: Registering CNID module [cdb]
Aug  1 08:27:05 mail1 afpd[3863]: Registering CNID module [dbd]
Aug  1 08:27:05 mail1 afpd[3863]: Loading ConfigFile
Aug  1 08:27:05 mail1 atalk: afpd startup succeeded
Aug  1 08:27:08 mail1 kernel: eth1: Setting full-duplex based on MII #24 link partner capability of 41e1.
Aug  1 08:27:11 mail1 afpd[3863]: mail1:AFPServer@* started on 65280.157:128 (2.0.3)
Aug  1 08:27:11 mail1 afpd[3863]: ASIP started on 192.168.0.10:548(6) (2.0.3)
Aug  1 08:27:11 mail1 afpd[3863]: uam: loading (/usr/lib/uams_dhx.so)
Aug  1 08:27:11 mail1 afpd[3863]: uam: uams_dhx.so loaded
Aug  1 08:27:11 mail1 afpd[3863]: uam: loading (/usr/lib/uams_pgp.so)
Aug  1 08:27:11 mail1 afpd[3863]: uam: uam not found (status=-1)
Aug  1 08:27:11 mail1 afpd[3863]: uam: "DHCAST128" available
Aug  1 08:27:11 mail1 afpd[3863]: Finished parsing Config File
Aug  1 08:27:59 mail1 login(pam_unix)[3824]: session opened for user root by LOGIN(uid=0)
Aug  1 08:27:59 mail1  -- root[3824]: ROOT LOGIN ON tty1
Aug  1 08:28:38 mail1 HORDE[3775]: [horde] DB Error: connect failed:  [nativecode=Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] ** Array [on line 1329 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Aug  1 08:57:53 mail1 HORDE[3777]: [horde] DB Error: connect failed:  [nativecode=Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] ** Array [on line 1329 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Aug  1 08:59:53 mail1 hal.hotplug[5873]: DEVPATH is not set
Aug  1 08:59:53 mail1 hal.hotplug[5890]: DEVPATH is not set
Aug  1 08:59:53 mail1 kernel: input: AT Translated Set 2 keyboard on isa0060/serio0
Aug  1 09:01:01 mail1 crond(pam_unix)[5983]: session opened for user root by (uid=0)
Aug  1 09:01:01 mail1 crond(pam_unix)[5983]: session closed for user root
Aug  1 09:28:05 mail1 HORDE[3778]: [horde] DB Error: connect failed:  [nativecode=Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)] ** Array [on line 1329 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Aug  1 10:01:01 mail1 crond(pam_unix)[9540]: session opened for user root by (uid=0)
Aug  1 10:01:01 mail1 crond(pam_unix)[9540]: session closed for user root
Aug  1 10:13:38 mail1 kernel: psmouse.c: bad data from KBC - timeout

[raem]

mukii

You could try selecting Reconfigure and then do a Reboot.
See the Reboot/Reconfigure/Shutdown menu.

[byte]

Aug  1 08:26:45 mail1 rc.e-smith: Starting mysql.init:  failed

This is your reason why you cannot connect to the DB and futher down it's the reason why you have to sock error's.

Try doing what Ray say's, if that doesn't work please open a Bug Report and give us a full history of what occured on this server.

Thanks!

[mukii]

hellooo...
thanx 4 all the help... the reconfiguration sorted out the problem...
u guyz r heroes... thanx a mill... at least i can hand over the project..
plz do u know y i had the error in the 1st place...
didnt do anythin out of the ordinary...
thanx again...
p.s do u know how i can change all the users password at once..
so i can give them a generic password they can change when they want..
once again... thanx alot... so very greatful 2 u...
mukii...

[raem]

mukii

> plz do u know y i had the error in the 1st place...
> didnt do anythin out of the ordinary...

You still didn't say what you DID do though.
The Reconfigure option does
signal-event post-upgrade
reboot
which will expand templates & read database settings & recreate config files etc
Obviously you changed something, and that change did not get correctly implemented by the system, therefore causing problems.

>... do u know how i can change all the users password at once..

See the Lazy Admin Tools (lat) contrib, although I'm not sure if a version compatible with sme7 has been released yet.

http://mirror.contribs.org/smeserver//contribs/mblotwijk/Contribs/

[byte]

Here is the version 7 of the LAT tool...

http://mirror.contribs.org/smeserver/contribs//jbennett/sme7/lat/

[raem]

byte

> Here is the version 7 of the LAT tool...

Thanks byte
A warning to others though.

On careful review the old sme6-mblotwijk-version filename is
e-smith-lazy_admin_tools-0.9.0-1.noarch.rpm

and the new sme7-jbennett-version filename is
e-smith-lazy_admin_tools-0_9_1-0_noarch.rpm