Topic: Gallery2 install feedback

[wifinetguy]

I know this isn't supposed to be this hard. But I'm being bone-headed, I guess. Anyway, I get to the database connection screen (step 5, I think) and it can't connect. I don't have the db password as SME generates a random password. So how do I connect to my db so I can continue on with  the setup?

Thanks...very frustrated.

[william_syd]

I find the installation of phpmyadmin very helpful in these situations.

There is a contrib by MasterSleepy. Do a search on the forums and you will find it.

Use phpmyadmin to create a new user which has most privileges on a table of the same name (little iffy but works). Then use those details in whatever web app your installing.

Other alternative is to use the mysql client. Same idea, new user and new table. The mysql site has good documentation.

[cactus]

I know this isn't supposed to be this hard. But I'm being bone-headed, I guess. Anyway, I get to the database connection screen (step 5, I think) and it can't connect. I don't have the db password as SME generates a random password. So how do I connect to my db so I can continue on with  the setup?

Thanks...very frustrated.

Login using the terminal or SSH as root and issue the following command:

Code: [Select]

mysqlThis will open mysql as local root user.

Now think of the following:

• a name for the database
• a username for the gallery daemon
• a password for the daemon user

You will have to replace the databasename, username and password values with the ones you have thought of and these values will also have to be entered in the gallery installation screen, most of this can also be found in the user manual and the gallery manual.

Now we can create a database:

Code: [Select]

create database databasename;
and add a user for this database:

Code: [Select]

grant all privileges on databasename to username@localhost identified by 'password';
To be sure all changes will be applied issue the following command:

Code: [Select]

flush privileges;Now we can quit mysql:

Code: [Select]

quit;This could also have been found in the Technicians Manual in the MySQL administration section.

[wifinetguy]

Thank you both for your replies. I see now that I could have done this through the command line interface. However, I didn't even think of that as I was only thinking about getting the correct info on the setup screen, and not thinking "outside". Sorry for the post that should have been fixed without asking the forum.

[mstrangers]

this is my 92gallery2 template created with the gallery security guide
no file browsing allowed

Code: [Select]


Alias /gallery2/ /opt/gallery2/
<Directory /opt/gallery2/>
    AddType application/x-httpd-php .php .php3 .phtml
    php_admin_value open_basedir /opt/gallery2/:/home/e-smith/files/ibays/Primary/html/
    Options None
#    Options +Indexes
    Options +Includes
    AllowOverride None
    order deny,allow
    deny from all
    allow from all
<Files ~ "\.(inc|class)$">
   Deny from all
</Files>
</Directory>