Topic: smeserver7.1.2 - jinzora installation stopped??

[daley]

Hi,

Just followed the guide at the http://www.dungog.net/sme/webapp.php for fresh installation, when i reached "Install Steps 6 - Backend Setup", the installation stopped.

== "Install Steps 6 - Backend Setup" ==
Creating Database
    - jinzora2 - Failed!

could not connect to database.

User name, database name and database password are entered accordingly, is it anything that i have missed look?

Please help....

Regards,
Daley

[bpivk]

Did you install both contribs smeserver-joomla and joomla?
Did you enter config show joomla and pasted the password in step 6?
Did you use localhost for the database location?

[pfloor]

Did you install both contribs smeserver-joomla and joomla?
Did you enter config show joomla and pasted the password in step 6?
Did you use localhost for the database location?

Did you try posting this in the correct forum?
You will get more help there so I will move it for you.

Moving to contribs section.

[daley]

Sorry, i have posted it to the wrong forum.

Thanks,
Daley

[RedBeard]

Ran into the same problem.  For the password if you are installing this for the first time do you enter a new password?  That what I did.

I was confused by this wording in Step 6:

"- find mysql password with 'config show jinzora' [see extra settings below]"

Why do I need to find the password, if I am entering it for the first time

Everything up to that point worked fine . . .

[bpivk]

Well you have to ssh into your server and then enter this command. Server generates a password and you can view it with this command. Then just copy/paste to your setup and that should do it.

[RedBeard]

Well you have to ssh into your server and then enter this command. Server generates a password and you can view it with this command. Then just copy/paste to your setup and that should do it.

Thanks bpivk, that is good to know.  Newbie Alert I would still like to know why this has to be done, if it does not require too much explanation.

 Well not sure this is a MySQL thing but I would like to know if there is a good MySQL for Dummies that you might recomend.  I would like to start working with it.
 
THANKS!!

[bpivk]

I would still like to know why this has to be done

Well because the server creates a random password when you install smeserver-joomla contrib. And this command shows this random string which you copy into the setup.

Well why has to be done?
Because someone could hack your php website and get your password and then inject other commands trough mysql. This is why dungog's contribs make a user with random password and minimal privileges.

And this is the way to do it.
You have to create a user with minimal privileges (only ones that need to be enabled and only for the site it uses) and a random password.

The most stupid thing would be to create a power user (with all privileges) and give him global rights and then install a script into ibay with this user's name and password.

And here is a good MySQL for Dummies
http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION0002000000

This explains exactly what i have told you (I found this just after i wrote that text).

[RedBeard]

Thanks!  Good to know.

[Bassi6]

Hi I am having the same problem

== "Install Steps 6 - Backend Setup" ==
Creating Database
- jinzora2 - Failed!

could not connect to database.
 
The out put of "config show jinzora"is

jinzora=service
    DbPassword=yxyxyxyxyxyxyxyxyxyyxyxyxyxyxy
    Name=Jinzora Jukebox
    PublicAccess=local

here is my "backend setup"

 Database User:       Jinzora Jukebox    
Database Password:yxyxyxyxyxyxyxyxyxyxxyyx        
Confirm Password: yxyxyxyxyxyxyxyxyxyyxyxyx        
Database Name: jinzora2        
Database Server:localhost         
Database Type:    MySQL     
Create Database:  True

So what am I doing wrong ???