Topic: Howto install MySql

[beeboob]

In sme 7 how can i install MySql?

How to install the newest 4.x of mysql or bette howto install Mysql 5.0

Plz. guide me to it. I am new to SME,,

Hobe you can help...

(((YES i made something stupid)))

[JonB]

MySql 4.1 is already installed

rpm -q mysql
mysql-4.1.12-3.RHEL4.1

Jon

[beeboob]

But every time i try to

mysql

i get

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[JonB]

Your mysql is stopped.

service mysql restart


Jon

[beeboob]

I try also that. But it faild every time i try that...

I can not start it...

I have read many post here and on the net,,,, And i think i have to reinstall it or upgrade to are new one like Mysql 5 or something like that. just it is are newer version, than the standart in SME 7

[byte]

Your mysql is stopped.
service mysql restart

We don't use service no more (and never really should have, as we run in level 7 and doing a service may not run all commands sme need's to, we should use...

/etc/rc7.d/S**mysql restart

** is a number that should be there.

I would also report this to bug tracker as they need to track down why your mysql isn't starting/restarting

Thanks!

[beeboob]

I have look in that folder /etc/rc7.d and i dont have anything that have mysql.

I have:

S00microcode_ctl      S44acpid     S65dhcpd            S86httpd-e-smith
S05syslog             S50dhcpcd    S75smtp-auth-proxy  S90pptpd
S06cpuspeed           S55dnscache  S80clamd            S90radiusd
S10bootstrap-console  S55imap      S80freshclam        S90spamd
S15nut                S55imaps     S80ldap             S90squid
S15raidmonitor        S55ippp      S80ntpd             S91atalk
S26apmd               S55pop3      S80qmail            S91smb
S35oidentd            S55pop3s     S85ftp              S97messagebus
S36masq               S55tinydns   S85qpsmtpd          S98haldaemon
S37network            S57diald     S85sqpsmtpd         S99local
S39irqbalance         S57pppoe     S85sshd
S40crond              S60lpd       S86httpd-admin

But nothing whit mysql...

So can i not just reinstall it or upgrade mysql

[beeboob]

i dont understand it... But do i have to make are new install??

[pfloor]

There is clearly something missing from your server.  You should have S50mysqld and it is not there.

What version of SME7? (current version is rc1)
Is this a fresh install or upgrade?
Is it stock or did you add any contribs or try to upgrade mysql?
Did mysql ever work at all?

If you are running a stock SME7 that you have not modified than you need to report this to the bug tracker.

Paul

[beeboob]

I have make are upgrade to rc1...

I was trying to installe are crm/erp program. That program was not base on mysql, (postsql) I think thats the name. But not sure.

And since i dont have any mysql. I start whit Sme 6 and then since 7pre1, pre2 and so on.

My sql, work. Before i have, Vtiger, Sugarcrm, phpmyadmin etc running. But not now.

I dont have nothing on, my system. Nothing whit mysql.

[pfloor]

I have make are upgrade to rc1...

I was trying to installe are crm/erp program. That program was not base on mysql, (postsql) I think thats the name. But not sure.

And since i dont have any mysql. I start whit Sme 6 and then since 7pre1, pre2 and so on.

My sql, work. Before i have, Vtiger, Sugarcrm, phpmyadmin etc running. But not now.

I dont have nothing on, my system. Nothing whit mysql.

It appears that somewhere along the line you somehow lost (at least) e-smith-mysql. What is the output of:

rpm -qa *mysql*

Paul

[beeboob]

It is:

php-mysql-4.3.9-3.9

Hope i say you something

[pfloor]

It is:

php-mysql-4.3.9-3.9

Hope i say you something

If thats all you see then you are missing some things namely:

mysql-server-4.1.12-3.RHEL4.1
e-smith-mysql-1.12.0-01
mysql-4.1.12-3.RHEL4.1

Run the following:

yum install mysql mysql-server e-smith-mysql
signal-event post-upgrade
signal-event reboot

Then after it reboots, check rpm -qa *mysql* again and see if they installed OK.  If they did, then try loging into mysql.

What I am worried about is why this happened and what else is missing from your system.  Did you maybe do something that could have removed these from your system?

Paul

[beeboob]

OOh so nice, many thanks, I try that...


I think it is only the Mysql i an mising...

After i have hopeful install mysql aging i can install PHPmyadmin...

I was trying to set up some crm/erp to run on the server. So i can show it to my boss and others. (conflux, tiny erp/crm, sugarcrm, vtiger etc)

But one off them was very hard to get woriking(conflux, Tiny). The program want postsql or something like that, instedt off mysql. I try to install postsql and then it was going down.

[beeboob]

Done...

I have do:

yum install mysql mysql-server e-smith-mysql
signal-event post-upgrade
signal-event reboot

rpm -qa *mysql*

I still get:

php-mysql-4.3.9-3.9