SMgateway

[Peter Russell]

    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]

[root at localhost fsmg-1.5]# echo "DROP DATABASE fsmg;" | /usr/bin/mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[root at localhost fsmg-1.5]# service mysqld start
Starting MySQL:                                            [  OK  ]
[root at localhost fsmg-1.5]# echo "DROP DATABASE fsmg;" | /usr/bin/mysql
ERROR 1008 at line 1: Can't drop database 'fsmg'. Database doesn't exist
[root at localhost fsmg-1.5]# /usr/bin/mysql < /opt/Fortress/defaults/fsmg.sql
[root at localhost fsmg-1.5]#

Have a look at that - the machine was sitting there after i had
installed RHEL3update4, installed fsmg and found the error in the
browser, then applied your 2 commands - seems the DB wasnt installed?

Anyway you were right, and it fixed it. Off to play and impress my
colleagues :)
Pete


>>
> It looks like the default data in mysql is not correct;
>
>    echo "DROP DATABASE fsmg;" | /usr/bin/mysql
>
>    /usr/bin/mysql < /opt/Fortress/defaults/fsmg.sql
>
> will reload the defaults. If that doesn't solve the problem, Please let me
> know.
>
> Regards,
>
> Steve Swaney
> President
> Fortress Systems Ltd.
> Phone: 202 338-1670
> Cell: 202 352-3262
> www.fsl.com
> steve.swaney at fsl.com
>
> ------------------------ MailScanner list ------------------------
> To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
> 'leave mailscanner' in the body of the email.
> Before posting, read the MAQ (http://www.mailscanner.biz/maq/) and
> the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
>
> Support MailScanner development - buy the book off the website!
>
>
>

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the MAQ (http://www.mailscanner.biz/maq/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!