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

[beeboob]

I get this:

yum install mysql mysql-server e-smith-mysql
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Setting up Install Process
Setting up repositories
smeaddons                 100% |=========================|  951 B    00:00
smeos                     100% |=========================|  951 B    00:00
smeupdates                100% |=========================|  951 B    00:00
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql-server.i386 0:4.1.12-3.RHEL4.1 set to be updated
---> Package e-smith-mysql.noarch 0:1.12.0-01 set to be updated
---> Package mysql.i386 0:4.1.12-3.RHEL4.1 set to be updated
--> Running transaction check
--> Processing Dependency: mysql-client for package: MySQL-test-standard
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package perl-DBD-MySQL.i386 0:2.9004-3.1 set to be updated
--> Running transaction check
--> Processing Dependency: mysql-client for package: MySQL-test-standard
--> Finished Dependency Resolution
Error: Missing Dependency: mysql-client is needed by package MySQL-test-standard
================================================================
No new rpms were installed. No additional commands are required.


But what is the mysql-client I can not find any thing about it??

[beeboob]

It is are hard job this one...

is it better just to give up or??? I have use so many hours on this whit no result. It is not nice...

[pfloor]

It is are hard job this one...

is it better just to give up or??? I have use so many hours on this whit no result. It is not nice...

It loos like you have installed some Non-Standard packages.  Do you know EXACTLY what you did or even why you did it?

let's see what you might have that doesn't belong:

rpm -qa *My*

Paul

[beeboob]

I dont know EXACTLY,

But i try this

1. yum install e-smith-mysql

2. signal-event post-upgrade

3. signal-event reboot

4. rpm -qa *my*

And get this

MySQL-client-standard-5.0.19-0.rhel4
MySQL-test-standard-5.0.19-0.rhel4
MySQL-server-standard-5.0.19-0.rhel4
MySQL-devel-standard-5.0.19-0.rhel4
MySQL-standard-debuginfo-5.0.19-0.rhel4
MySQL-shared-compat-5.0.19-0.rhel4
MySQL-shared-standard-5.0.19-0.rhel4

[beeboob]

Is this good???

So i want to try to go to mysql..

I try

mysql

and get

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

So now i have are new problem  

[pfloor]

I dont know EXACTLY,

But i try this

1. yum install e-smith-mysql

2. signal-event post-upgrade

3. signal-event reboot

This won't work because you have extra packages installed that should not be there.  It looks like you tried to install mysql5.  Don't try things like this if you don't know what you are doing.  Adding and upgrading packages on SME is dangerous...DON"T DO IT!!!

4. rpm -qa *my*

And get this

MySQL-client-standard-5.0.19-0.rhel4
MySQL-test-standard-5.0.19-0.rhel4
MySQL-server-standard-5.0.19-0.rhel4
MySQL-devel-standard-5.0.19-0.rhel4
MySQL-standard-debuginfo-5.0.19-0.rhel4
MySQL-shared-compat-5.0.19-0.rhel4
MySQL-shared-standard-5.0.19-0.rhel4

These all must be removed on at a time.  Try this:

rpm -e MySQL-client-standard-5.0.19-0.rhel4
rpm -e MySQL-test-standard-5.0.19-0.rhel4
rpm -e MySQL-server-standard-5.0.19-0.rhel4
rpm -e MySQL-devel-standard-5.0.19-0.rhel4
rpm -e MySQL-standard-debuginfo-5.0.19-0.rhel4
rpm -e MySQL-shared-compat-5.0.19-0.rhel4
rpm -e MySQL-shared-standard-5.0.19-0.rhel4

You might have to use the --nodeps option for this like

rpm -e --nodeps MySQL-client-standard-5.0.19-0.rhel4

[pfloor]

STOP trying things.  You need to do this a step at a time or you will get nowhere.

Trying things without knowing what you are doing is how you messed your server up in the first place.

[beeboob]

Thanks...

I have done it now...

Do you now, what to do now

[beeboob]

root@server ~]# rpm -qa *my*

php-mysql-4.3.9-3.9

e-smith-mysql-1.12.0-01

[pfloor]

Now try to install mysql4 back onto your system like this:

yum install mysql mysql-server e-smith-mysql

It should ask you if you want to install 3 or 4 packages, answer yes.

Then finish with:

signal-event post-upgrade
signal-event reboot

Paul

[beeboob]

Nice...

I try it now....

[beeboob]

yeeeeeeeeeeeeeeeeeeeeeeeees:::: Try and look:::::

yum install mysql mysql-server e-smith-mysql
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Setting up Install Process
Setting up repositories
smeaddons                 100% |=========================|  951 B    00:00
smeos                     100% |=========================|  951 B    00:00
smeupdates                100% |=========================|  951 B    00:00
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql-server.i386 0:4.1.12-3.RHEL4.1 set to be updated
---> Package mysql.i386 0:4.1.12-3.RHEL4.1 set to be updated
--> Running transaction check
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package perl-DBD-MySQL.i386 0:2.9004-3.1 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 mysql                   i386       4.1.12-3.RHEL4.1  smeos             2.8 M
 mysql-server            i386       4.1.12-3.RHEL4.1  smeos             6.7 M
Installing for dependencies:
 perl-DBD-MySQL          i386       2.9004-3.1       smeos             111 k

Transaction Summary
=============================================================================
Install      3 Package(s)
Update       0 Package(s)
Remove       0 Package(s)
Total download size: 9.6 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): mysql-server-4.1.1 100% |=========================| 6.7 MB    01:01
(2/3): perl-DBD-MySQL-2.9 100% |=========================| 111 kB    00:01
(3/3): mysql-4.1.12-3.RHE 100% |=========================| 2.8 MB    00:25
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: mysql                                                  [1/3]warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
  Installing: mysql                        ######################### [1/3]
  Installing: perl-DBD-MySQL               ######################### [2/3]
  Installing: mysql-server                 ######################### [3/3]

Installed: mysql.i386 0:4.1.12-3.RHEL4.1 mysql-server.i386 0:4.1.12-3.RHEL4.1
Dependency Installed: perl-DBD-MySQL.i386 0:2.9004-3.1
Complete!
==============================================================
WARNING: You now need to run BOTH of the following commands
to ensure consistent system state:

signal-event post-upgrade; signal-event reboot

You should run these commands unless you are certain that
yum made no changes to your system.
==============================================================

[pfloor]

Looks good so far...

DON"T FORGET THIS:

signal-event post-upgrade
signal-event reboot

Paul

[beeboob]

The server have just restart...

Is there are next step... Something i have to do, so i can test it is running... And want about the root password for the mysql server... Is that ok..

[pfloor]

The server have just restart...

Is there are next step... Something i have to do, so i can test it is running... And want about the root password for the mysql server... Is that ok..

The root password is automatic and should be set by the system.  try to log into mysql first and see what happens:

mysql

If it gives you a password error, I can give you the steps to fix that.

Paul

[beeboob]

mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[pfloor]

Here is how to reset the password:

cd /service/mysqld
runsvctrl d .
cat set.password | /usr/libexec/mysqld --bootstrap \
  --user=mysql --skip-grant-tables
runsvctrl u .

Try loging in again.

If you find that webmail does not work then you need to re-initialize mysql and all the underlying systems.

CAUTION!!! The commands BELOW will delete any databases and return the server to it's original configuration. CAUTION!!!

cd /service/mysqld
runsvctrl d .
/etc/e-smith/events/actions/mysql-delete-db-files
signal-event post-upgrade
signal-event reboot

[beeboob]

Ok,, i will try the first one..

And hope that i not have to use

cd /service/mysqld
runsvctrl d .
/etc/e-smith/events/actions/mysql-delete-db-files
signal-event post-upgrade
signal-event reboot

[beeboob]

This is the best,,,, So many, many thanks... Try and look. It so great,,,, uhhh nice    My head...

]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


Try and look, i come in to, mysql. Jubbbbbbiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

[beeboob]

I hope this i ok...

I get the fil

smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

then go to the folder, That have the file.. I use just cd /tmp

rpm -Uvh smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

And i come in the PhpMyadmin control panel via:

https://server1/phpmyadmin/

Nice. and many, many thanks.

[gregswallow]

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

This 3 page story is a perfect example of why you shouldn't upgrade components that are in SME7.  SME uses the CentOS rpms because Redhat and CentOS will provide security updates for mysql and php, etc, until 2012.  "Because it's there" may be a good reason to climb Everest, but not a good reason to install the newest mysql 4.x or 5.

[beeboob]

Yes it is right. Never do that.

It is very stupid.. Newver just trust are howto. Next time i have to follow are HowTo, i am looking in the forum first..

[MSmith]

Wouldn't it have been simpler to just install a fresh copy of SME Server?  I understand wanting to try out various CRM/ERP packages but why not start fresh with each one?