[SMS]

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

Just thought I would share difficulty that I am having with mysql.

1. Using 1.1.2 sms release

2. If I type '/etc/rc.d/rc.mysqld', I get an error message that says process is already running. But when I type 'netstat -tap' it shows no mysql running on port 3306 or any other port.

3. On pristine install of sms 1.1.2 I typed the commands that you gave me in previous mysql posting. I get an error message saying that it can not connect to root@localhost.

4. So, I cannot get the two apps I am trying to run because so far I have failed at making mysql work for me.

5. A side note. Back when I had 1.1 release installed, if I typed 'netstat -tap' it showed mysql running. Also, I was able to install igsuite as long as I did not change hostname. I still have not figured out hostname issue but have not given up on it.

thanks

gerasimos_h · Posted: Wed Sep 19, 2007 4:22 pm Post subject:

2. That's weird, I just booted to 1.1.2 no problem found when I type that.

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

will do. thanks

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

okay, I tried changing permissions and that did not work. So, I will try livecd and then re-install sms.

thanks

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

Livecd does not give me an error message when I restart mysqld. But, it does not show mysql running on port 3306 or any port for that matter. If you type netstat -tap, you will not see mysql running.

I re-installed sms 1.1.2 and restart works without error message but netstat -tap does not show mysql running on port and if you install igsuite or simple-groupware, I get an error message that can not connect to root@localhost.

maybe I'm just unlucky Smile

...

gerasimos_h · Posted: Wed Sep 19, 2007 8:23 pm Post subject:

I just install igsuite no error mysql is running...
Maybe it's my.cnf that makes the difference, but I doubted.
I didn't change anything in mysql.
Is there any chance that you may doing something wrong or you might forgot some step from your configuration?
It's weird.
'netstat -tap' doesn't show it but it's running.

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I installed sms. Then I copy igsuite to sms server. You told me to type the following:

mysql
mysql create database igsuite;
mysql grant all on igsuite.* to user@localhost identified by 'password';
exit

and then cd to igsuite package and type
perl install.pl and answer the questions.

But when the script runs, I get an error message ' Panic! I tried to connect to mysql and create 'igsuite' database, but an unknown error occurred, perhaps I haven't right privileges to access or to create database in mysql!!!

So, that is what happens. Maybe I am doing something wrong but I don't know what. I really hate taking your time up with this.

regards

gerasimos_h · Posted: Wed Sep 19, 2007 9:30 pm Post subject:

OK! 'netstat -tap' doesn't shows mysqld cause it's starting with --skip-networking but still that shouldn't bother you.
Regarding Igsuite, have you changed your localhost hosts, HOSTNAME?
The commands after typing mysql are

baboo · Senior Member Joined: 04 Sep 2007 Posts: 676

I finally figured out how to change hostname and have mysql work.

I did the following steps:

1. mysql
2. use mysql;
3. grant all *.* on 'rocky'@'%' identified by 'password''
4. flush privileges;
5. grant all *.* on 'rocky'@localhost identified by 'password';
6. flush privileges;

This allows you now to creat a root user with a new password.

Thanks for all your help