Installation running forever, errors, warnings, etc...

[Murayama]

Hello!

I'm new to Joomla. Not exacty new because I used it a long time ago (Joomla2), and at that time
Joomla had an assistant program, a kind of CPanel on the website I'm using, which disappeared
in the meantime. So I would like to install it manually.
What I did is as follows. I will try to be as accurate as possible.

1. Preliminary work
1.1. Access to the domain:
I can login to my server using a ssh correction. We will assume here that my username is
murayama and my password is murayama_pswd. Let's assume furthermore that my domainnname is
murayama_domain.com. I can therefore connect to my domain with ssh as follows:

sudo ssh murayama_domain.com -l murayama

I'm asked for my password, and I key in murayama_pswd
At this point, I can access to murayama_domain and do shell operation, ls, etc...
This works, so I don't think the problem is here.
Not sure why I have to sudo ssh rather than simply ssh, but hey, it works.
Just to be sure if it can be installed / is compatible, I also ran php --version and found
out that the version is 8.2.5 and that Zend's version is 4.2.15. Not sure why php gives the
Zend version, but just in case, here it is.

1.2. Database creation. As a my_sql database is necessary, I have also created one. The
parameters are as follows:
Database Name: MurayamaDB
Use Hostname: mysql.murayama.com
New Hostname: // Ignored this one

New Username: murayama_sql
New Password: murayama_sql_pswd
New Password again: murayama_sql_pswd

Database Comment: this is a joomla5 test.

Not sure how to test it, but as it created the database successfully, I guess everything is fine.

2. Joomla installation
2.1. I have downloaded Joomla 5.0.3 and uploaded it to the server.
2.2. Archive uncompress. All the necessary folders seem to be created
2.3. I can connect my browser to murayama.com, and it displays the first page asking me for my
Joomla site.

00WebSite.png

2.4. Enter the parameters of the website.
I have entered the parameters I use to ssh to my website (see above). Is this right?

01SiteSetup.png

2.5. Entre the database parameters

02DBSetup.png

I have entered the parameters I used to create a MySQL database. Is this right?
2.6 Result
I get the following page:

Error.png

Nothing moves, I had dinner, nothing moved after dinner.
As for the credentials, I'm not sure of MySQL version.
Can anyone give me a few hints?

Thanks!

[Per Yngve Berg]

Try Table Prefix "mur".

[Murayama]

Hello!
Thanks for your reply.
In fact, these are not the real data otherwise somebody would probably hijack my server, one never knows.
The default prefix was about 4~5 characters + underscore. I changed it with a similar size prefix. I think it
was something like mu_sql_. Is the 2 underscore a problem?
Thanks!

[ceford]

What sort of server? Most people using a hosting service would use something like cPanel to create a database and database user and to manage files. Your installation stopped because the database credentials are not correct. The data entry form offers a randomly generated prefix such as xyzab_ so don't create anything more complicated.

After creating your database try accessing it with phpMyAdmin - it will be empty but you need to know it exists and is accessible. cPanel (and similar) offer phpMyAdmin by default - and you need to be aware of the difference between Admin login and the user account used by the Joomla instance.

[Murayama]

Hello again!

I changed the prefix so that it has a single underscore. Now the installer stops at a different point.
It displays an error message "Could not connect to the database.Connector returned error message:
No such file or directory".
Which file is it talking about? Is it the database file? The database file exists for sure. I copied & pasted
the database name to be sure.

Error.png

As for the location of the file, I don't know exactly, but in my previous experience, a long time ago,
there was no need to care about it, it could be found automatically.

Thanks

[Murayama]

Hello!

What sort of server?

Not sure of what exactly you mean, but it's a server on dreamhost. There is no cpanel, but something
having this role. I don't know what exactly "credentials" mean. I thought it only means the login details.
-> Is this right? Is there anything more than the login and password?
I have the impression that from the beginning on, after I unzipped joomla package, everything should work.
There was an issue probably due to my 2 underscores in the prefix, but I'm one step further now.
So I'm not sure what was the credential issue, but it may have been solved with a simple prefix change.
But to be frank, I'm not even sure whether I'm one step further, or whether my new prefix made the system
block one step before. I hope it's one step further.
Now the question remains, "no such file or directory" could be better explained, for example by writing
the name of the file that was not found.

Thanks,

[ceford]

What sort of server?

Not sure of what exactly you mean, but it's a server on dreamhost. There is no cpanel, but something
having this role. I don't know what exactly "credentials" mean. I thought it only means the login details.
-> Is this right? Is there anything more than the login and password?

Dreamhost says:

Super Easy to Use

Our custom control panel is simple to use and removes the headache of managing your web hosting.

So use the custom control panel to create a database and database user. It should have phpMyAdmin too.

What sort of Dreamhost plan? Shared hosting (the cheap plans) don't usually allow ssh login. Even VPS plans usually come with Apache, Mysql and phpMyAdmin installed for you.

[Murayama]

Hello!

Thanks for your reply.
I use a cheap plan (about 10~15 USD a month, and if I don't remember, it's probably because it's cheap).
Anyway, I can use ssh.
I have installed the custom control panel to install the database, and the parameters are as explained above.
All the parameters I have setup above are only for explanation.
Example from above:
New Username: murayama_sql
-> This is not the real name I used for the database, it means only "name I used for my database"
New Password: murayama_sql_pswd
-> This is not my real password, it means only "password I used for the mysql database"
New Password again: murayama_sql_pswd

And so on.

Dreamhost used to have a joomla server, I just want to set it back, I don't want to use wordpress or other
content managers because in this case I would have to learn from scratch. The only solution is to manually
install joomla.

Thanks,

[ceford]

To be honest, trying to manage a web site through the command line is going to be tedious. The price you are paying is not cheap. You could get a shared hosting site with cPanel for half that and be up and running in no time.

Try the Launch button at the top of this site for a free Joomla site. Documented here:

https://docs.joomla.org/How_to_build_yo ... la_Website

If sticking with Dreamhost:

1. Find out how to use phpMyAdmin.
2. The database domain is usually localhost - but you should be provided with a Mysql instance; you just need to create a new database - you can create as many as you like.

[Murayama]

Hello!

Thanks for your reply.
Ok, I will summarize what I did, because apparently the fact that my MySql database
has been successfully installed didn't make it. So, quick summary:

In all the following, I will use the following symbolic names:

Username = murayama
domain of the site I want to install = murayama_domain
password = murayama_pswd

1. With these 2, I can ssh like this:
sudo ssh murayama_domain.com -l murayama
I'm asked for my password, and I key in murayama_pswd

This works.

2. Creation of the database. Not with phpmyadmin, but something similar, probably.
I'm asked for the following parameters, and I have completed the form as follows.

Database Name: MurayamaDB
Use Hostname: mysql.murayama.com
New Hostname: // Ignored this one

New Username: murayama_sql
New Password: murayama_sql_pswd
New Password again: murayama_sql_pswd

The database seems to be correctly created, it is listed in my databases,
as shown by this image: The new database is empty, that's why it says 1k.

SQLDatabases.png

3. Download Joomla 5.0.3, load it onto the domain of the website I want to create,
unzip the package.

4. When I connect to murayama_domain, I get the joomla setup interface. This means:
- That the connection to the site is correct because I can get the installer
in my browser.
- That Joomla's installer is installed at the right place because I can at least
to do the first steps in the installer, see pictures above.

Back to my question. The database exists as said above. I don't understand the
meaning of the above message.
Does this mean that my database file is not found? Is it a matter of some path?

Thanks

[brian]

make sure that you are setting the hstname as localhost on the joomla installation page

[Murayama]

Hello!

Sorry for the delay, I'm busy on other tasks.

make sure that you are setting the hstname as localhost on the joomla installation page

Yes, it's the default and I haven't altered it.

Thanks!

[Per Yngve Berg]

It's not clear wheater you have given the database user all permissions to the database.