Koozali.org: home of the SME Server

Mysql root Password SME7

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Mysql root Password SME7
« Reply #15 on: November 30, 2006, 11:00:43 AM »
Quote from: "pcp20us"

I tried to go to the irc links in you last post it didn't work. What is an irc link.


Internet Relay Chat.

You will need a IRC client

Try

http://www.mirc.com/

or

http://www.mozilla.org/projects/rt-messaging/chatzilla/
Regards,
William

IF I give advise.. It's only if it was me....

pcp20us

Mysql root Password SME7
« Reply #16 on: November 30, 2006, 11:12:58 AM »
Jee your quick, I just realised i forgot the link, and just found master sleep page in another post.

Will dowmload and try

is noarch.rpm the file and is yum to install that file ?

I got to do a crash course in unix !!

Cheers

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Mysql root Password SME7
« Reply #17 on: November 30, 2006, 12:51:35 PM »
The steps will be...

Code: [Select]
cd /tmp
wget http://www.vhconsult.com/download/sme70/phpmyadmin-multiuser/smeserver-phpmyadmin-multiuser-2.9.1.1-1.noarch.rpm
yum localinstall smeserver-phpmyadmin-multiuser-2.9.1.1-1.noarch.rpm
signal-event post-upgrade
signal-event reboot


You are changing to the temp directory.
wget will download the file to the tmp directory similar to how a browser will do it.
yum will install the downloaded file. Because we already have the file we use the localinstall command.
Next is some sme magic to ensure the system is in a known state.
Regards,
William

IF I give advise.. It's only if it was me....

pcp20us

Mysql root Password SME7
« Reply #18 on: December 01, 2006, 01:05:07 AM »
Thanks william.

I got it flying last night. Though the way i ve seen it done before and the way i was doing it prevoiusly was installing phpmyadmin into an ibay, then configureing things from there.

Doing this way (which does work) it seems to install phpmyadmin into phpadmin, as displayed by the browser, but this doesnot diplay under the ibays ??. Is it instslled in the guts of linux somewhere. just want to understand so i know how to fix it when/if it breaks.

What the differnece in the php myadmin's available  is interesting. I was looking on the contribs site for something that listed what was compatiable with sme 7.0 but had no luck


Thanks for your help

Pete :lol:

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Mysql root Password SME7
« Reply #19 on: December 01, 2006, 01:43:38 AM »
Quote from: "pcp20us"


Doing this way (which does work) it seems to install phpmyadmin into phpadmin, as displayed by the browser, but this doesnot diplay under the ibays ??. Is it instslled in the guts of linux somewhere. just want to understand so i know how to fix it when/if it breaks.



Correct. It is not in an iBay. It's located under /opt/administration

The 86PhpmyadminmultiAlias script in /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf which gets incorporated into /etc/httpd/conf/httpd.conf is what tells the webserver what to give to the browser.
Regards,
William

IF I give advise.. It's only if it was me....

Offline william_syd

  • ****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Mysql root Password SME7
« Reply #20 on: December 01, 2006, 01:52:23 AM »
Quote from: "pcp20us"

What the differnece in the php myadmin's available  is interesting. I was looking on the contribs site for something that listed what was compatiable with sme 7.0 but had no luck


List of contribs.
http://no.longer.valid/phpwiki/index.php/SME7Contribs
Maybe when the new Wiki arrives they will get updated.
Regards,
William

IF I give advise.. It's only if it was me....

ryanb006

Mysql root Password SME7
« Reply #21 on: December 11, 2006, 06:05:47 AM »
pcp20us, you need to create a user for yourself within mysql. Don't change the root password.

Code: [Select]
# mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO myuser@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> quit