Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: roots on December 06, 2006, 06:44:12 PM

Title: mysql password for dungog solutions
Post by: roots on December 06, 2006, 06:44:12 PM

hello,
I tried to install joomla with the yum repositories from dungog. everything worked fine. When I have to configure joomla in the web interface, I have to fill in the password for the joomla user to connect to the mysql database.

I'll get the password by typing : config show joomla
the password/user entries won't work.

the password I get is 76 character long / the dungog site says it will be 56 character long. --> Is this the problem?

the config says: Name=Joomla CMS
Dungog says: User = joomla
which one do I have to take

do I have to make new mysql useres?

thanx for any kind of ideas.
roots

Title: mysql password for dungog solutions
Post by: cjensen on December 07, 2006, 07:38:04 AM

I assume you have read- http://www.dungog.net/sme/webapp.php .

The DB user and pass is configured for you by installing the rpm but If you want you can manually assign a user privileges to complete the install:

Code: [Select]


[dude@smefun dude] # mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 829 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on joomla.* to joomlauser@localhost identified by 'o6vRsixFGYGmraXVsko8Bna3J7kNUeiSpBYnATPUEh09MbIVBp4OoMlkBv22/zmbJDsPiqrFUBUi';

mysql> flush privileges;

mysql> \q


Obviously replace the characters in ' ' with the output of your 'config show joomla' password and use whatever you use for 'joomlauser' in your installation.

Craig

Title: mysql password for dungog solutions
Post by: stephen noble on December 09, 2006, 09:14:08 AM

>the password I get is 76 character long

this is correct, I have to fix the documentation
I misread some code, which checks for a password greater than 56 characters


>the config says: Name=Joomla CMS
>Dungog says: User = joomla
>which one do I have to take

Name is just a descriptive setting used elsewhere

>do I have to make new mysql useres?
no
the mysql user is joomla, it has sufficient privleges
if you find it doesn't raise a bug

Title: thanx
Post by: roots on December 09, 2006, 11:48:40 AM

thanks you for your advise

best regards

roots

Title: mysql password for dungog solutions
Post by: stephen noble on December 10, 2006, 12:56:37 PM

Craig has found a bug in all the webapp smeserver-* rpms

The password hadn't been created in the config db before it was attempted to be inserted in mysql. If you removed the rpm and tried again it would have worked as the password now exists

new rpms fix this

Title: Installing mulitple instances of joomla in multiple ibays
Post by: ohendricks on December 26, 2006, 08:56:56 PM

I want to have several different domains running off one sme server. I have built the ibays and want to know do I need a seperate mysql database for each instance of joomla running for each site.

I'm looking at installing 12 seperate domains with seperate domains.

Title: Re: Installing mulitple instances of joomla in multiple ibay
Post by: pfloor on December 27, 2006, 08:45:19 PM

Quote from: "ohendricks"

I want to have several different domains running off one sme server. I have built the ibays and want to know do I need a seperate mysql database for each instance of joomla running for each site.

I'm looking at installing 12 seperate domains with seperate domains.

Yes unless you want all 12 sites to have the same content.

You can name them joomla1, joomla2, etc. or my preferred way is joomla-firstibayname, joomla-secondibayname, etc.  This way you won't get them mixed up.

Then you need to input the correct db name during the joomla setup or manually put it in the correct config file in your joomla application directory.

You can however only have one user/password with access to all 12 databases if you want.