Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
mysql woes
View previous topic :: View next topic  
Author Message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Wed Sep 19, 2007 3:51 pm    Post subject: mysql woes Reply with quote

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
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1743
Location: Greece

PostPosted: Wed Sep 19, 2007 4:22 pm    Post subject: Reply with quote

2. That's weird, I just booted to 1.1.2 no problem found when I type that.
Code:
root@sms:~# /etc/rc.d/rc.mysqld
usage /etc/rc.d/rc.mysqld start|stop|restart

Mysql is running from the start, maybe something went wrong on installation...
maybe a permissions issue. Try:
Code:
cd /var/lib/
chown -R mysql.mysql mysql
/etc/rc.d/rc.mysqld restart


I'm not having any issue with mysql, could you please try from Live environment and please reinstall to double check it.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Wed Sep 19, 2007 4:32 pm    Post subject: Reply with quote

will do. thanks
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Wed Sep 19, 2007 4:50 pm    Post subject: Reply with quote

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

thanks
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Wed Sep 19, 2007 7:33 pm    Post subject: Reply with quote

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...
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1743
Location: Greece

PostPosted: Wed Sep 19, 2007 8:23 pm    Post subject: Reply with quote

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.

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Wed Sep 19, 2007 8:57 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1743
Location: Greece

PostPosted: Wed Sep 19, 2007 9:30 pm    Post subject: Reply with quote

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
Code:
create database igsuite;
grant all on igsuite.* to user@localhost identified by 'password';

but I'm sure you had figured out that, you can put them in a text for instance db.txt and run
Code:
mysql < db.txt

for not running all the commands if you have a lot of users and databases.

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Thu Oct 04, 2007 9:51 pm    Post subject: solved Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional