Topic: Badly Needs Help in SME 7.2

[grisswold]

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.

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...

[janet]

grisswold

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.

[cactus]

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.

[CharlieBrady]

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.

[cactus]

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.

[grisswold]

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....

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

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

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

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?

[janet]

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

[CharlieBrady]

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.

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

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.

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).

[grisswold]

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..

[grisswold]

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....

[janet]

grisswold

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.

yum update

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

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.

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

[cactus]

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).

[janet]

cactus

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

[grisswold]

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?

[cactus]

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.

[grisswold]

yep... Im accessing the server-manager via internet coz our sme server is just a dedicated server... we dont have any computers, hubs, switches connected to the lan to our server...
I was even able to download and install PHPmyadmin using the wget command in the shell from the server...

And making it double sure I did the test internet access... it returned to be success and was able to communicate with contribs.org.....

I wish I could post a print screen to the result updating via the server-manager, but it seems that I dont have the option to paste the image....

[mercyh]

It might be the simplest to download the ISO and upgrade from CD.

[grisswold]

yep thought of that as well since I was running out of options and help....

Quick Question....In updating to 7.3 using the cd, shall I be performing the same steps as to updating SME 7.2 via cd?

 

  1.  Insert the CD into your server and issue a reboot, follow the instructions presented to you on the server screen to update to SME Server 7.2.
   2. Reset yum to the new default configuration as described here: Adding_Software#Restoring_Default_Yum_Repositories
   3. Reset other settings to new defaults as shown here: Updating_to_SME_7.2#Updating_Configuration_Database_with_New_Default_Values
   4. Perform a final yum update to obtain updates or patches released after the generation of the 7.2 iso.

[janet]

grisswold

Only steps 1 & 4 are needed, the CD upgrade should correct your other issues.

[grisswold]

ey thanks mary... U know a weird thing just happened.... I tried the yum clean all and yum update the 4th time without the cd... and now its updating fine... weird.....

The only thing is, its taking more than 15 minutes as expected..... Well at least its updating now... Just have to be patient for it.....

Again, I wanna thank all of u guys for the elp!

[janet]

grisswold

....and make sure you do

signal-event post-upgrade
signal-event reboot

when the yum update is finished.

[grisswold]

the update took about 8hrs and it says that its completed...

now I've got a new problem....   This command doesnt work...

signal-event post-upgrade
signal-event reboot

It would give me an error "bash:signal-event: command not found"
Is there an alternative command for that?

[janet]

grisswold

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

[grisswold]

ey mary, how do I go about in changing my bash as my default shell? They say I have to edit this file ".profile", but where can I locate that file and how do I open it to do some editing from the shell command line?

[CharlieBrady]

ey mary, how do I go about in changing my bash as my default shell?

Upgrade to 7.3 and /sbin/e-smith will already be included in the path.

[grisswold]

I've already updated to 7.3.. Yahooooo! But my bash didn't change to default T_T

After the signal-event reboot

I followed this to reset my mysql password coz I still cnt logon to mysql by just typing mysql to the command shell.. "Access denied root@localhost Password:NO"..

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 .

when I typed this "expand-template /root/.my.cnf" it still said that "bash:expand-template: command not found"....
So Im just gonna do "/sbin/e-smith/expand-template /root/.my.cnf" for the meantime.. But again, how do I go about in changing my bash as my default shell?

[janet]

grisswold

From
http://wiki.contribs.org/MySQL

As you are now on 7.3 use this instead

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 .

[grisswold]

o yeah! I just followed ur post that I printed las time... kk.. will do and hope this'll work.. X fingers crossed....
=)

----------------Addtional Message-------------
tried this and it doesnt work in SME 7.3

runsvctrl d .
runsvctrl u .

quoted from http://wiki.contribs.org/MySQL "Since SME Server 7.3 the runsvctrl command was replaced by the sv command so for SME Server 7.2 and earlier releases use the following:"

[cactus]

o yeah! I just followed ur post that I printed las time... kk.. will do and hope this'll work.. X fingers crossed....
=)

----------------Addtional Message-------------
tried this and it doesnt work in SME 7.3

quoted from http://wiki.contribs.org/MySQL "Since SME Server 7.3 the runsvctrl command was replaced by the sv command so for SME Server 7.2 and earlier releases use the following:"

You are logged in as root user on the console or through putty I presume or did you promote your user account to be superuser using sudo or su?

[grisswold]

nope.. I'm logged in as root user...

It wont reset my password so I just logged in to mysql typing the dam long password... I created another user with all the grant options so I'm ok for now. mydamin works too now..  But I sure do wish to know in how to be able to reset my bash to the default....
I still have to insert this before a command "/sbin/e-smith/" and this is already 7.3.... T_T


Oh yeah, got another question...
Is mysql 5 compatible with SME 7.3?

[janet]

grisswold

Maybe this will help

db commands are used now
eg
db accounts setprop joe Shell /bin/bash
refer
http://forums.contribs.org/index.php?topic=33570.0

also

the generic command
chsh -s /bin/bash

The command is
chsh -s /bin/csh xxxxx
where csh is the shell you want to use and xxxxx is the user account name

man chsh
to get info on shells

pick ONE of the following

chsh -s /bin/csh xxxxx
chsh -s /bin/sh xxxxx
chsh -s /bin/bash xxxx
chsh -s /bin/bash2 xxxx

[cactus]

Oh yeah, got another question...
Is mysql 5 compatible with SME 7.3?

No it is not. Is this your way of telling us you installed MySQL version 5 on your system? If you did so that might be the cause of the MySQL problem.

[CharlieBrady]

It wont reset my password ...

It will if you do it properly.

I still have to insert this before a command "/sbin/e-smith/" and this is already 7.3.... T_T

Please open a bug report so that can be investigated and fixed.

Is mysql 5 compatible with SME 7.3?

Not without complications (e.g. problems when you upgrade to SME8).

[grisswold]

I hvnt installed mysql 5 in my server... Like I said last time, I'll be asking 1st before doing it coz I might mess up the system...

Somehow I think I've done it right in reseting the password to the mysql, i've been following the steps posted in the wiki for the SME 7.3. Doesnt give me any errors but doesnt changes anythin either.... But, I ges I'll just leave it that way... Besides I was already able to create a new user in MYSQL with all the rights and I'm able to manage my databases and tables so I ges dats alryt....

I'll try opening a bug report if it still doesnt fix it once I've tried mary's suggestion.... And I might do it later coz right now, I'm focusing on a different matter.... I've got a problem in making changes with joomla..... Everytime I save changes to my global configuration I get the error "could not make the configuration.php writable/unwritable"... I was able to find some help with regards to this concern, and was suppose to key in a command to give read/write access to a user(www-data:www-data)... but was having another problem with an invalid user "www-data:www-data"... Ges I didnt have that kind of user and I dont know how to add that kind of user... So I just tried making the file readable/writable by doing "sudo chmod 600 /var/www/joomla/configuration.php"... And ges what? My page just shows a white screen.... WAAAAAAW! I messed up pretty bad... Good thing is, when I deleted my joomla folder and reuploaded the folder again.... It went back to normal.... Phew.... I ges this aint an SME concern anymore, I'll find other means to get this through.... I just wanted to say this coz my problems with SME just doesnt end... They just keep popping out.... And I wonder how u guys get done with ease....  Maybe its just experience..... Yeah, ges dats it...

Ey again, Thank you guys for replyin and assisting me with this probssss.... Stay well....

[janet]

grisswold

I've got a problem in making changes with joomla.....

The correct way to change permissions on a Joomla configuration.php is like this

cd to the folder where configuration.php is located eg if in an ibay called joomla then do

cd /home/e-smith/files/ibays/joomla/html/

to see the current permissions (and make a note of them)
ls -al configuration.php

to TEMPORARILY change to a suitable value to allow Joomla control panel to make and save changes

chmod 770 configuration.php

make & save your changes in Joomla

Then you MUST change permissions back to safe values to prevent anyone from accessing the config file eg

chmod 640 configuration.php

[grisswold]

Holy COW! Ur d best mary! Im now able to save it.. Yahoooooooo! Thanks so much! U've made my day... ^_^

[janet]

grisswold

Now you have saved so much time fixing the Joomla issue, please report the other path and mysql issues to bugzilla as Charlie has suggested. That way they can get fixed.

[grisswold]

db commands are used now
eg
db accounts setprop joe Shell /bin/bash
refer
http://forums.contribs.org/index.php?topic=33570.0

also

the generic command
chsh -s /bin/bash

The command is
chsh -s /bin/csh xxxxx
where csh is the shell you want to use and xxxxx is the user account name

man chsh
to get info on shells

I dont know where to start from this... coz I dnt knw what shell do i want to use... I just want it as the default... I dnt knw either if its the default but I just want this command "expand-template /root/.my.cnf" to work without typing the whole path "/sbin/e-smith/expand-template /root/.my.cnf"...


tried this "chsh --list-shells"
got this

/bin/bash
/bin/bash2
/sbin/e-smith/console
/bin/csh
/bin/false
/usr/bin/rssh
/bin/sh
[root@vmsme ~]#

are these the only choices bellow?

pick ONE of the following

chsh -s /bin/csh xxxxx
chsh -s /bin/sh xxxxx
chsh -s /bin/bash xxxx
chsh -s /bin/bash2 xxxx

what if I do this "chsh -s /sbin/e-smith/console root", what'll happen?

[cactus]

Since he installed MySQL 5 reporting a bug is of not much use as he has taken an unsupported approach on SME Server 7.x, his bug is likely to be closed as WONTFIX as it is not a stock SME Server anymore.

MySQL 5 will be available on SME Server 8, the SME Server 7.x tree will have MySQL 4 as the parent distro has MySQL 4.

Grissworld, next time please give all details as I could have already have explained to you in one of the first posts that this method most likely would not work if you manually install MySQL 5, would have saved you, me and others a lot of hassle. Also please open a post for new issues, this makes thefrum more readable and makes others find solutions easier in the future.

Oops, overread the nt in his post. Sorry.

[grisswold]

Also please open a post for new issues, this makes thefrum more readable and makes others find solutions easier in the future.

will do nxt time....

[janet]

grisswold

I dont know where to start from this... coz I dnt knw what shell do i want to use...

If you don't know what to do or why, then you should NOT be making random changes to your system, you will only get yourself and your system into a bigger mess.
You don't even know exactly what the problem is yet, but you propose a fix that you are not even sure of !!!!

Your best approach is to lodge a bug report as asked by Charlie, please do that immediately. Thank you.

...I just want this command "expand-template /root/.my.cnf" to work without typing the whole path "/sbin/e-smith/expand-template /root/.my.cnf"...

There are links in sme that do that for you, obviously something is wrong, perhaps with those links. Bugzilla is the place to sort that out.

[CharlieBrady]

what if I do this "chsh -s /sbin/e-smith/console root", what'll happen?

Bad things - you'll lose the ability to do anything other than what you can already do by logging in as 'admin'.

I'd strongly advise you not to use any shell but /bin/bash.

[grisswold]

I opened a bug report, took me awhile to do it coz I to search all problems that cud've been familiar to mine....