Install Gallery v3 mysql database hostname, localhost doesn't work

[erik33]

Hi I'm trying to install gallery v3 on my site but I can't find the database i created's hostname. localhost does not work. Thanks for any help.

[PL281]

@erik33 

If you got to MySQL Databases in the cPanel admin is the database listed. Localhost "should" work

[erik33]

localhost doesn't work. I had godaddy a long time ago and back then the hostname was something like fsffvfd.secureserver.net

[PL281]

@erik33 

Can you post a screen capture of what you are getting - and could it be a user / permissions issue

[erik33]

[PL281]

@erik33 

Can you show the settings for Gallery where the database information is set (feel free to block out the password)

[erik33]

[PL281]

@erik33 

Based on your previous screen you need to do 

mikelevinhome for the user and levingallery fro the database

and the password is whatever you setup when you created the database - if you don't remember is you should be able to reset the password from the screen where you got the screen capture in cPanel

[erik33]

When I try that I get this error.

[PL281]

@erik33 

In cPanel file manager you should be able to view the error log in the root of the site and see what the error is

[erik33]

Theres too much info on the logz.

[PL281]

@erik33

If you look at the last line or two it should be time stamped for today and that should tell you what the error is

[erik33]

nothing related to mysql etc... is on the logs. Its all file uploads.

[PL281]

@erik33

The error log may not say anything about MySQL but it will tell you what the 500 error is referring to as in it may be something for out of memory or a missing file or something else

[erik33]

How about we start from scratch? Can you link me to the right database creator?

[PL281]

@erik33
When you are in cPanel you can do a search for database and select my SQL database wizard

[erik33]

You have created a MariaDB/MySQL database named “gallerynew”.

then when i click submit i get this error

A fatal error or timeout occurred while processing this directive.

click show and:

Template::Exception:
	[TYPE]=[undef]
	[INFO]=[Mysql::get_privileges_on_database(HASH(0x38a2770)) failed: The system user “tmvwtvyfg8vh” does not control a MySQL user named “admin”.
]
	[TEXT]=[

]
 at cpanel.pl line 1078.
	cpanel::cpanel::cptt_exectag("/usr/local/cpanel/base/frontend/paper_lantern/sql/wizard3.htm"..., 1) called at cpanel.pl line 4411
	cpanel::cpanel::run_standard_mode() called at cpanel.pl line 879
	cpanel::cpanel::script("cpanel::cpanel", "./frontend/paper_lantern/sql/wizard3.html.tt") called at cpanel.pl line 322

I set all folders to 777 with filezilla that didn't help.