Koozali.org: home of the SME Server

Badly Needs Help in SME 7.2

Offline grisswold

  • **
  • 29
  • +0/-0
Badly Needs Help in SME 7.2
« on: September 25, 2008, 11:15:28 AM »
Hi to all whos reading this! This is my first time posting here, and the reason why im creating this post s bcoz I got big problem with SME 7.2.

I actually got 2 major problems here.
1st is the "how to access the MySQL server" and 2nd is the "how to install PhpMyAdmin in SME 7.2".
I've gone through the whole day searchin in dis forum for answers to those 2 problems that I have and none seem to have helped. My problems are somehow similar to the other posters, but I guess there are just some specific steps I need to know to be able to followthrough this. So anyways lemme tel u guys wat i knw and what I've done in trying to resolve these problems.

First of all, I'm a newbie in Linux, but gettin a little hang of it since some of the commands are similar to windows commands(which I'm very familiar of). Second I'm also a newbie in SME. And have some intermediate lvl of knowledge in MySQL.

Useful Information:
-My friend was the one who setup the SME server 7.2 and we've been using it as our webhost server for our project for a couple of months now. All of our html files that we uploaded to the webserver didnt have any php and database coding. They are just pure html and css. Now we want to upload our php files to the webserver and configure our MySQL database. And my friend dont know how to with the MySQL. The php end on the SME server already works via locally or the internet, also includes the ftp.

1st thing that I did, tried to access the mysql from the OS shell command line. Typed in mysql and it gave me an error message prompting "Access is denied for user 'root'@'localhost' (using Password:no) and returns me to my prompt [root@r10-iserver /]#. Then I followed these steps as to what I've read to some of the posts here. To reset the mysql root password.

Quote
cd /var/service/mysqld
runsvctrl d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
runsvctrl u .


I restarted the service of mysql just to be sure and used the command "service mysqld restart", prints out [OK]. I tried to reset the password, but can't seem to get the commands right. Here's the command that I followed, at the shell i typed in "cd /var/service/mysqld" and pressed enter. Now the command line changes to [root@r10-iserver mysqld]#. Then I typed in "runsvctrl d .", but gets an error of "command not found". So I instead used "sv d ." as to what some posters have said due to the changes of the SME version or sumthin. And after trying that nothin happens. Next, I used this command "expand-template /root/.my.cnf" and also says command not found. I tried removing the hyphen and used this command instead "expand template /root/.my.cnf" and now shows me the 75 alphanumeric character root password. Then I encoded this "expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password", this long command  didnt work. Just kept on giving me command not found. But still encoded the last line in the end "sv u ." and the command line just moves on the next line. I then tried to access mysql again by typin in the mysql just to chek f there were any changes. But to a dissapoint still denied me to access it.

I havent tried accessing the mysql iputting the -uroot and -prootpassword coz I dont know the exact command with it. Like where do I put the 75 characted password. Actually, I have tried it but just gave me a bunch of errors. So this is with my 1st problem, cant access mysql.


Now to my next problem, I don't know how to install a phpmyadmin rpm in the SME server 7.2. I logged in to the Server Manager of SME and checked for the installed softwares in the server and found out that there wasnt any PhpMyAdmin installed. So I checked the updates, and noticed that there werent any PhpMyAdmin in the updates as well. So it came to my mind just to download the file an rpm contrib site. Then it came to me, "Where the hell do I put the downloaded rpm?".  I mean, in accessing the server manager UI console, I use a different computer with xp as its OS. I downloaded the rpm for the PhpMyAdmin using the xp computer. I accessed the server files but I cant seem to find the folder files for the SME. So how do I go about this? Can any of u guys help. I badly need it...

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #1 on: September 25, 2008, 12:13:14 PM »
grisswold

Quote
I've gone through the whole day searchin in dis forum for answers

You would have been better clicking on the Wiki link and the Howto link at the top of these forums.

http://wiki.contribs.org/Main_Page
http://wiki.contribs.org/Category:Howto

http://wiki.contribs.org/MySQL


The Contrib link is unfortunately not at the top of these Forums but is on the main Wiki page

http://wiki.contribs.org/Category:Contrib

Then you find

http://wiki.contribs.org/PHPMyAdmin

http://wiki.contribs.org/Phpmyadminmulti

and a whole lot of other great stuff

Also check out the FAQ

http://wiki.contribs.org/SME_Server:Documentation:FAQ


See if some of that helps you resolve matters.
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Badly Needs Help in SME 7.2
« Reply #2 on: September 25, 2008, 02:02:40 PM »
1st thing that I did, tried to access the mysql from the OS shell command line. Typed in mysql
That should be the proper command considering you are logged in as root user.

and it gave me an error message prompting "Access is denied for user 'root'@'localhost' (using Password:no)
I guess you were root user, if so thi sshould not have happened, you should have been able to access MySQL. Are you sure no one has been tampering with the MySQL configuration on this system?

Then I followed these steps as to what I've read to some of the posts here. To reset the mysql root password.
The correct steps to reset your MySQL password are here: http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password . The first section is for SME Server 7.3 and up the second section is for SME Server below version 7.3. If you are running 7.2 you should execute the steps in the last section, line by line followed by a enter after each line.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: Badly Needs Help in SME 7.2
« Reply #3 on: September 25, 2008, 03:06:20 PM »
If you are running 7.2 you should execute the steps in the last section, line by line followed by a enter after each line.

SME 7.2 is unmaintained. OP should update his system (thereby applying bugfix and security fixes), in which case he/she will be running SME 7.3.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Badly Needs Help in SME 7.2
« Reply #4 on: September 25, 2008, 03:35:25 PM »
SME 7.2 is unmaintained. OP should update his system (thereby applying bugfix and security fixes), in which case he/she will be running SME 7.3.
I agree with you on that, but I just wanted to make the difference between the two instructions so s/he would use the proper instruction.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline grisswold

  • **
  • 29
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #5 on: September 26, 2008, 04:21:20 AM »
I didnt have the time to chek the release notes of SME server 7.2 since my friend said that it was ok to use it. Gee... what a pain this is gonna be.... Man, I sure hope it wont be that difficult to upgrade to 7.3 coz Im in a tight schedule finishing this project up. And I'm gonna need to backup files for this. And in the meantime I'll try troubleshooting with this 1st and see if I can go somewhere....

Quote
The correct steps to reset your MySQL password are here: http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password . The first section is for SME Server 7.3 and up the second section is for SME Server below version 7.3. If you are running 7.2 you should execute the steps in the last section, line by line followed by a enter after each line.

posted by cactus

That was the link I referred to when I tried doing it. I tried doing this 1st
Quote
cd /var/service/mysqld
runsvctrl d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
runsvctrl u .
but didnt work so I used this

Quote
cd /var/service/mysqld
sv d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
sv u .
. I stated using this in my post which still didnt work.. T_T
Quote
Here's the command that I followed, at the shell i typed in "cd /var/service/mysqld" and pressed enter. Now the command line changes to [root@r10-iserver mysqld]#. Then I typed in "runsvctrl d .", but gets an error of "command not found". So I instead used "sv d ." as to what some posters have said due to the changes of the SME version or sumthin. And after trying that nothin happens. Next, I used this command "expand-template /root/.my.cnf" and also says command not found. I tried removing the hyphen and used this command instead "expand template /root/.my.cnf" and now shows me the 75 alphanumeric character root password. Then I encoded this "expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password", this long command  didnt work. Just kept on giving me command not found. But still encoded the last line in the end "sv u ." and the command line just moves on the next line. I then tried to access mysql again by typin in the mysql just to chek f there were any changes. But to a dissapoint still denied me to access it.

Is this a bug or some sort of this is a messup with the installation?

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #6 on: September 26, 2008, 05:38:06 AM »
grisswold

Upgrading to sme7.3 should not take too long, ie 15 minutes or so and is usually safe to do.
Of course it always safer to do a backup first.
If you are running a 2 disk RAID1 array, just disconnect one disk temporarily (it will act as a backup).

Then log in as root and do

yum update

when finished do
signal-event post-upgrade
signal-event reboot

Then follow the instructions for resetting the mysql password for sme7.3 exactly (don't play around or vary the commands, that's ridiculous) ie

cd /var/service/mysqld
sv d .
expand-template /root/.my.cnf
expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
sv u .

Report back if that works OK or if you get any errors.
If you get an error on one of the commands, there is no point continuing further, report that error here to get resolved before proceeding further.


When all finished (and hopefiully working) reconnect your disconnected drive and rebuild the array from the console menu. Erase the partitions from that "new" drive before reconnecting it using a suitable tool eg delpart.exe

Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: Badly Needs Help in SME 7.2
« Reply #7 on: September 26, 2008, 09:27:40 PM »
So I instead used "sv d ." as to what some posters have said due to the changes of the SME version or sumthin. And after trying that nothin happens.

Wrong, something did happen. mysqld stopped running. You just didn't see that happen.

Quote
Next, I used this command "expand-template /root/.my.cnf" and also says command not found.

Use:

/sbin/e-smith/expand-template /root/.my.cnf

Quote
I tried removing the hyphen and used this command instead "expand template /root/.my.cnf" and now shows me the 75 alphanumeric character root password.

That is irrelevant, and won't have fixed anything.

Quote
Then I encoded this "expand-template /var/service/mysqld/set.password
/usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password", this long command  didnt work. Just kept on giving me command not found.

Again, you need to use /sbin/e-smith/expand-template in place of expand-template (because you are still using SME 7.2).

Offline grisswold

  • **
  • 29
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #8 on: September 28, 2008, 03:54:32 AM »
I'm not able to work on the server till tomorrow since Im bc finishin up our work. This should have been my partners job to fix coz I got other still got other stuffs to work on. But if I wont do anythin about this, Im gonna get in to trouble as well..... Syked!

Well I ges I'll just have to finish up my part of our work fast so I could assist in fixin the server tomorrow and so we could get this all to work.

I wanna thank all you guys for the help and Im gonna do em al the help u guys instructed tomorrow..

Offline grisswold

  • **
  • 29
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #9 on: October 06, 2008, 12:18:25 PM »
Hello again guys!

I wanted to remove my previous post, but it seems that I cnt do that. So anyways I hope I wont be accounted for spamming in replying to my previous post....

I've got a question... This would be about updating from SME 7.2 to SME 7.3... And yes I wasn't successful in doing the steps u guys posted coz it gave some other problems with it... So what we did was we just uploaded our files to a paid hosted server so we could present our work and get it over with.... And now that thats done... I wanted to test out updating our SME and continue on with the trouble I am having and see to way to resolve this.... So I'm gonna ask help from u guys again and hope u guys cud pave a way from my dillema.....

My question(questions rather):
1. Are the updates available in the software installer from the server manager the same to as what the yum update is gonna be installing??

Coz i checked from the "Topic: SME Server 7.3 Updates"; it stated there that "All updates can be installed with the Software Installer from the Server Manager." -- so are they the same? I noticed that smeserver-release.noarch 26:76.3-1.el4.sme - smeos was available there in the Software Installer from the Server Manager, is that the 1 that I'm gonna be installing/updating only or do I have to update all to what's available for updates?

2. Whats the difference between  "yum update --enablerepo=smecontribs" and "yum update"? What do they update?

By the way, when i try the "yum update" it always says "header is not complete from all the mirrors and says no more mirrors to try..."


I thought of trying it first before asking u guys.... but I figured asking u guys 1st before doing it coz I've so little knowledge about this and hell I dnt know what I might destroy from trying.... =)

I rily hope u guys can help me with this....

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #10 on: October 06, 2008, 02:34:20 PM »
grisswold

Quote
1. Are the updates available in the software installer from the server manager the same to as what the yum update is gonna be installing??

Yes.
Updating either way will achieve the same end result.


Quote
yum update

That will update all "standard" packages that form part of the base system, assuming you have not permanently enabled additional respositories.


Quote
yum update --enablerepo=smecontribs

That command will do the same as yum update, but in addition it will update any packages you already have installed on your system that are found in the smecontribs repository.


Quote
when i try the "yum update" it always says "header is not complete from all the mirrors and says no more mirrors to try..."

Do
yum clean all
yum update

Also please read all of this carefully
http://wiki.contribs.org/SME_Server:Documentation:FAQ#Yum_Updates
« Last Edit: October 06, 2008, 03:48:20 PM by mary »
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Badly Needs Help in SME 7.2
« Reply #11 on: October 06, 2008, 03:26:17 PM »
Code: [Select]
yum update --enablerepo=smecontribs
That command will only update any packages you already have installed on your system that are found in the smecontribs repository.
No, it will update all already installed packages and available upgrades on your server when it finds an update in the additional enabled repositories and the repositories enabled by default through the yum.conf file, normally the ones listed in the FAQ in the wiki (the URL is in the previous post).
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #12 on: October 06, 2008, 03:46:20 PM »
cactus

You're right, I got mixed up with yum install
I've corrected my original post to avoid confusion later.

Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline grisswold

  • **
  • 29
  • +0/-0
Re: Badly Needs Help in SME 7.2
« Reply #13 on: October 07, 2008, 03:28:57 AM »
Did this....

yum clean all
yum update

still have the problem...

also did the software installer in the server manager

still have the same problem.....

we were able to find this, it showed the same problem we were having and answered to some of our questions, why was it doing that....
http://bugs.contribs.org/show_bug.cgi?id=3654

ive been also checking the wiki about the firewall but doesnt seem to help, doesnt have the procedure how to disable "web resume download block" and "comfort clients block" on the firewall
http://wiki.contribs.org/Firewall#DB_Settings

The only question now is where do we go to configure this? we dont have a firewall router or any firewall software installed... Been checking the sme server manager, console and shell and I cnt seem to find any firewall..... U guys know where this could be?
« Last Edit: October 07, 2008, 06:30:50 AM by grisswold »

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Badly Needs Help in SME 7.2
« Reply #14 on: October 07, 2008, 07:37:43 AM »
Did this....

yum clean all
yum update

still have the problem...

also did the software installer in the server manager

still have the same problem.....

we were able to find this, it showed the same problem we were having and answered to some of our questions, why was it doing that....
http://bugs.contribs.org/show_bug.cgi?id=3654
Are you sure your server is able to access the internet? You can test by loging in as admin, in the menu you should see an option to test internet access.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)