Join Log in
Score:0
avatar Server

What can I do about a hanging MyCollab installation?

in flag
Christos Hayward

MyCollab displays an initial setup screen a la Wordpress, but the installer hangs, regardless of how permissive I've set its directory to be.

When I test a database connection, it said that it can't make a connection. I have specified the database name, a user with access to that database, the corresponding password, and the address. If I click "Check connection" it says "Cannot connect to database. Recheck your input."

I am not sure what it's not connecting to. I can use a mysql -ufoo -p, giving the same credentials as I gave MyCollab, and telnetting to localhost on 3306 gets binary data that includes an intelligible MariaDB prompt. I can use the database from the command line.

What else should I be doing?

87
1 + 1
in flag
Christos Hayward
Also, I am not committed to using MariaDB. I will happily use e.g Postgres if that will work.
0
Reply
Score:1
cg_foreau avatar Server
ca flag
cg_foreau

Wanted to comment as this is not a direct answer, but I'm lacking the reputation to do so.

Assuming you are using the proper configuration and considering that you have tested it, the issue might lie elsewhere : Are you using SELinux on your system (type getenforce to check if it is Enforcing) ? If you do, it might be blocking the communication between your services. To know if it does, look in /var/log/audit/audit.conf for lines with status=denied.

If you can afford to temporarily disable some security features, the easiest way to fix the issues you may see in audit.conf is to use setenforce 0, re-attempt to connect your service to your database (it should work at this point), then create a new permission file audit2allow -a -M mycollab and register it in your system semodule -i mycollab.pp before re-enabling selinux setenforce 1.

Note that the files generated by audit2allow contain sensitive configuration and should be audited before being applied to your system if you are in a security-sensitive context.

For some more details on audit2allow's usage: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/security-enhanced_linux/sect-security-enhanced_linux-fixing_problems-allowing_access_audit2allow

0 + 3
in flag
Christos Hayward
Thank you. The server is a Debian server; `getenforce` gets a command not found error.
0
Reply
cg_foreau avatar
ca flag
cg_foreau
I think you do not have selinux installed then, but I'm not very familiar with debian. I believe that MySQL limits user access per source/location. When using `mysql` you might not be identified as connecting from the same source. Try to use ALL the parameters you provided to mycollab when establishing the connection with cmd (set --bind-address and --database https://linux.die.net/man/1/mysql). Similar issue here : https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address . Have you checked the MySQL server logs in case it sees the login attempt ?
0
Reply
in flag
Christos Hayward
Thank you; advice to check the logs is always a helpful reminder. I'm awarding the bonus to you because even though I don't have what I want, you offered the most help.
0
Reply
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.