Topic: In-place upgrade from 6.0-1 to 7.2

[raem]

markehle

Do a search on backup, and you will find a list of all the files needed for a successful restore.

[mmccarn]

Here's a note that may help you reset your MySQL password: http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password

Otherwise, you can backup and restore user logins using Lazy Admin Tools

[markehle]

Sorry - no method that I have tried has restored root access on mysql. There is no /var/service/mysqld directory or runsvctrl  command on this box, and running msyqld with --skip-grant-tables does not work. It acts like it should - I can gain root access when in this mode, but when you restart mysql, root still doesn't work. I think that mysql on this box was 'upgraded' with the help of some bad advise. I am able to log in as horde and dump the horde database.

Looking for a list of files to backup using 'backup' yields nothing useful. Ray - can you be more specific?

Does lazy admin restore users including passwords?

[raem]

markehle

Looking for a list of files to backup using 'backup' yields nothing useful. Ray - can you be more specific?

Look harder, it has been answered recently and about a dozen times in the last year.

[warren]

markehle

have you done the following to reset the mysql password:
/etc/rc.d/init.d/mysqld stop
/etc/e-smith/events/actions/conf-mysql-password
/etc/rc.d/init.d/mysqld start
 or

/etc/rc.d/init.d/mysqld stop
/sbin/e-smith/expand-template  /root/.my.cnf

[markehle]

Warren -

Thanks for the reply. When I run  '/etc/e-smith/events/actions/conf-mysql-password' I get:

Code: [Select]

071219 13:38:45  Warning: Asked for 196608 thread stack, but got 126976
So, like I said, mysql is hosed on this machine!

I am really close to having this thing nailed, though. My ibays are all set on the new machine. I can tranfer over people's email and files. The problem is I don't know how to grab all the account info. I tried just copying /home/e-smith/files/users/* and group, gshadow, passwd, shadow, and smbpasswd. This did not work. The accounts do not show up in the server-manager. When I set up the accounts beforehand, they work, but I loose the password info, and given the folks that I have to deal with, the less change for them the better!

What am I missing?

Thanks again!

[markehle]

"Look harder, it has been answered recently and about a dozen times in the last year."

Thanks - that is so useful.

[raem]

markehle

The problem is I don't know how to grab all the account info. I tried just copying /home/e-smith/files/users/* and group, gshadow, passwd, shadow, and smbpasswd.

Because you didn't also copy the accounts & configuration & other required databases from home/e-smith/db/... and you didn't do a dump of the mysql tables (which have basic config for webmail by default, plus anything else you may have added), and you forgot a few other files that are also needed.


After copying all the required files you need to also do
signal-event post-upgrade
reboot


Before you do the backup & restore, the
signal-event pre-backup
command needs to be run on the old server to dump the mysql tables, and you then need to copy that dump file to the new server ie from
/home/e-smith/db/mysql

but that should be included if you copy all of /home/e-smith
as per the list below.


This link will give you clues as to the general process to follow
http://wiki.contribs.org/UpgradeDisk

which refers to this long thread that has lot's of inteersting tid bits
http://forums.contribs.org/index.php?topic=30745.0

and as you cannot seem to find the correct list of files that must be transferred here is the list

/etc/e-smith/templates-custom
/etc/e-smith/templates-user-custom
/etc/group
/etc/gshadow
/etc/passwd
/etc/samba/secrets.tdb
/etc/samba/smbpasswd
/etc/shadow
/etc/smbpasswd
/etc/ssh
/etc/sudoers
/home/e-smith
/root

and add in
/opt
if you have stuff installed there.




Now there is a fairly simple procedure outlined in a Howto, which uses the standard desktop backup & restore  functions, but can exclude ibay and user data etc. You can delete any unwanted users or ibays after the restore is complete.
It's easy to do, and is essentially the same as you would do by doing it all manually (and possibly getting it wrong).
See
http://wiki.contribs.org/Backup_server_config

[raem]

markehle

"Look harder, it has been answered recently and about a dozen times in the last year."
Thanks - that is so useful.

And if you took that advice you would find what you needed, but you are being lazy.

This is not kindergarten school stuff here, if you can install sme server then you are capable of reading all the FAQ's and searching the forums on keywords.

But as you seemed to still be struggling I have provided all the answers you need in my previous post.

[markehle]

/etc/e-smith/templates-custom
/etc/e-smith/templates-user-custom
/etc/group
/etc/gshadow
/etc/passwd
/etc/samba/secrets.tdb
/etc/samba/smbpasswd
/etc/shadow
/etc/smbpasswd
/etc/ssh
/etc/sudoers
/home/e-smith
/root

Copied them all.

signal-event pre-backup DOES NOT WORK on this machine. I cannot restore root access to mysql. lat-tools did not install correctly on my new server.

Look, guys - I guess that I am on my own with this one. I am sorry to be a pest, but honestly, the documentation is not the best. Ray - you can go stuff it. I have worked hard on this project. I contribute (or did, I will say) to this project. I don't think that your comments will make me want to keep that up.

Good day, Gentlemen.

Library Mark

[CharlieBrady]

I am really close to having this thing nailed, though. My ibays are all set on the new machine. I can tranfer over people's email and files. The problem is I don't know how to grab all the account info. I tried just copying /home/e-smith/files/users/* and group, gshadow, passwd, shadow, and smbpasswd. ...

You are going about this in a quite laborious way. I note that the Subject of this thread still refers to "in-place upgrade". Did you decide not to do that?

[raem]

markehle

...but honestly, the documentation is not the best. Ray - you can go stuff it.

That's not nice, considering that earlier you said "Man - you guys are the best!"

As Charlie has suggested you have taken a difficult approach to this task of upgrading.

You could have just pulled one drive out of the old server and did a disk upgrade using this method
http://wiki.contribs.org/UpgradeDisk

and then did a disk grow using this method
http://wiki.contribs.org/Raid#Upgrading_the_Hard_Drive_Size

If you have a problem with root & mysql on your old server, then you should sort that out first as it's obviously interfering with your attempts to upgrade.

[warren]

markehle

Thanks for the reply. When I run  '/etc/e-smith/events/actions/conf-mysql-password' I get:


Code:
071219 13:38:45  Warning: Asked for 196608 thread stack, but got 126976
So, like I said, mysql is hosed on this machine!

This does not mean its hosed, only that the mysql was looking for 196Kb thread stack but only got 126kb.
 did you run, /etc/rc.d/init.d/mysqld start after the error warning ? followed by :
[root]# mysql
to actually check wether root could now access mysql ?

check here for details on this issue :
http://bugs.contribs.org/show_bug.cgi?format=multiple&id=262
This bug pointed to the cause of this problem been a non standard upgrade to mysql.

[markehle]

To all who are trying to help -

I apologize for my earlier comments. I am very frustrated with this process and took it out on you guys. That was stupid and I am sorry.  I do love SME and I know you guys work hard on it.

No - I have a new server to move into. I can't remember what I did to mysql on the old server. It was many years ago, and I have tried many things to fix it to no avail.

"This does not mean its hosed, only that the mysql was looking for 196Kb thread stack but only got 126kb.
 did you run, /etc/rc.d/init.d/mysqld start after the error warning ? followed by :
[root]# mysql
to actually check wether root could now access mysql ?"

Yup - sure did. Root still busted.

I am able to log in as horde and get that database. Ditto with the various other db's that the old server had. I just can't get there with root.

At this point, all I need is to be able to keep the old user's passwords. I can create the user accounts by hand (there is only 20 or so) and pull their email over.

Again - Sorry for my poor behavior, especially toward Ray. You didn't deserve it.

[raem]

markehle

At this point, all I need is to be able to keep the old user's passwords.

The passwords are in various files and those files contain more than just passwords, and it is not a simple task to only extract user passwords. All the files mentioned are needed. You have been told what these files are a few times in this thread now, and how to correctly use them, so I don't see what your current issue is with "getting" users passwords.