Koozali.org: home of the SME Server

I killed my MYSQL database

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
I killed my MYSQL database
« Reply #30 on: September 29, 2006, 12:33:14 PM »
Quote from: "teviot"
Quote
$mosConfig_user = 'www';
$mosConfig_password = 'some-password';
$mosConfig_db = 'Mambo';


If you use phpMyAdmin do you see a user 'www' ?
Regards,
William

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

Offline Teviot

  • *
  • 610
  • +0/-0
I killed my MYSQL database
« Reply #31 on: September 29, 2006, 12:42:08 PM »
I didn't ... but i added it ... thinking you would say that ...

Please check www.teviot.net to see the error i now get.


If i could have a guess ... recreate the database using the install instructions?
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
I killed my MYSQL database
« Reply #32 on: September 29, 2006, 12:50:34 PM »
Quote from: "teviot"
I didn't ... but i added it ... thinking you would say that ...

Please check www.teviot.net to see the error i now get


Does the mos_session table exist in the Mambo db ?

Did you give your user access to the Mambo db?
Regards,
William

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

Offline Teviot

  • *
  • 610
  • +0/-0
I killed my MYSQL database
« Reply #33 on: September 29, 2006, 12:58:05 PM »
nothing is in the database ... i'll take a punt and try reinstalling the database ... if i can't do that, I'll reinstall mambo with the rpm i have.   There was nothing on the web site i really need or can't recreate
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
I killed my MYSQL database
« Reply #34 on: September 29, 2006, 01:01:13 PM »
Hey it's working. Did you reinstall? You have todo something with the installation directory.
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
I killed my MYSQL database
« Reply #35 on: September 29, 2006, 01:04:31 PM »
Quote from: "teviot"
nothing is in the database ... i'll take a punt and try reinstalling the database ... if i can't do that, I'll reinstall mambo with the rpm i have.   There was nothing on the web site i really need or can't recreate


Nothing in the db, that will do it eveytime. :)

You might want to get rid of that warning in PhpMyAdmin.
Regards,
William

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

Offline Teviot

  • *
  • 610
  • +0/-0
I killed my MYSQL database
« Reply #36 on: September 29, 2006, 01:04:46 PM »
going to reinstall ... unless you think that Joomla is easier to use and configure

Where do i get Joomla from???
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline Teviot

  • *
  • 610
  • +0/-0
I killed my MYSQL database
« Reply #37 on: September 29, 2006, 01:06:20 PM »
Quote
You might want to get rid of that warning in PhpMyAdmin.


Can you talk me though this please
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
I killed my MYSQL database
« Reply #38 on: September 29, 2006, 01:14:17 PM »
Quote from: "teviot"
Quote
You might want to get rid of that warning in PhpMyAdmin.


Can you talk me though this please


I don't have that problem here.

It's probably in your httpd.conf or php.ini

Code: [Select]
/etc/httpd/conf/httpd.conf
/etc/php.ini


Search through both for
Code: [Select]
mbstring.func_overload

What did you do to your site.. I now get a directory listing?
Regards,
William

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

Offline Teviot

  • *
  • 610
  • +0/-0
I killed my MYSQL database
« Reply #39 on: September 29, 2006, 01:37:18 PM »
Quote
going to reinstall ... unless you think that Joomla is easier to use and configure

Where do i get Joomla from???
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
I killed my MYSQL database
« Reply #40 on: September 29, 2006, 01:51:54 PM »
Quote from: "teviot"
Quote
going to reinstall ... unless you think that Joomla is easier to use and configure

Where do i get Joomla from???


Yeah.. Go Joomla.

dungog has made it easy.

Code: [Select]
SME 7.0
1. From the command line enter the following, (or copy and paste into your ssh client)

db yum_repositories set dungog repository \
 BaseURL http://sme.dungog.net/packages/smeserver/7.0/i386/dungog/ \
 EnableGroups yes \
 GPGCheck no \
 Name 'SME Server 7 - dungog' \
 Visible no \
 status disabled


Then...
Code: [Select]
/sbin/e-smith/expand-template /etc/yum.conf

Doh.. their site had gone down on me...

Anyway, it's dungog.net

their command will be something like
Code: [Select]
yum install joomla smeserver-joomla

you want to use
Code: [Select]
yum --enablerepo=dungog install joomla smeserver-joomla


Check their site for the exact file name.


EDIT: One minute later Joomla
Regards,
William

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

Offline Teviot

  • *
  • 610
  • +0/-0
I killed my MYSQL database
« Reply #41 on: September 29, 2006, 02:31:32 PM »
Joomla installed ... just rebooting the server

Thank you for all your help.  I just hope that if the same thing happens again ( Hope Not ), I can remember what to do

Thanks Again william_syd
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
I killed my MYSQL database
« Reply #42 on: September 29, 2006, 02:36:41 PM »
Quote from: "teviot"
Joomla installed ... just rebooting the server

Thank you for all your help.  I just hope that if the same thing happens again ( Hope Not ), I can remember what to do

Thanks Again william_syd


Are you rebooting 'cause yum told you too?

Remember how to get your password for the Joomla install?

Quote from: "dungog.net"
During installation you will be asked for your mysql details
databasename 'joomla'
user 'joomla'
password 'config show joomla'

[root@kiwi bin]# config show joomla
joomla=service
DbPassword=N9RPYCxC5CX+1DuxChoiv96tb987adtb9afbt98a7fbeYakJ6Z8mxsCbXB78P
URL=cms

after installed, rm -rf /opt/joomla/installation

The installation questions are so easy, it's not possible to have a problem !!

Setup of joomla will take some time, change the default template and visit joomlahelp.org

to add a more memorable URL eg. YourServer.net/site
config setprop joomla URL site
/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
/etc/rc.d/init.d/httpd-e-smith restart
pico -w /opt/joomla/configuration.php and
edit $mosConfig_live_site from joomla to site


Did you find your phpmyadmin problem?
Regards,
William

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