Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: SolidSonicTH on December 16, 2018, 12:14:28 PM

Title: SOLVED: Having trouble connecting to SQL Server 2017...
Post by: SolidSonicTH on December 16, 2018, 12:14:28 PM
I can't seem to get Roundcube to pass the username and password successfully during setup.

Is there something that needs to be configured on the SQL Server first before attempting this (like needing to open a port or something along those lines)?

I'll provide screenshots if needed.
Title: Re: Having trouble connecting to SQL Server 2017...
Post by: rm13 on December 18, 2018, 06:08:59 PM
If this SQL server is on a separate box then yes, you may need to open a port. You could check with a sql command line client from where you are installing Roundcube.
Title: Re: Having trouble connecting to SQL Server 2017...
Post by: SolidSonicTH on December 18, 2018, 07:24:03 PM
No, it’s in the same server as the database, that’s what’s perplexing me.
Title: Re: Having trouble connecting to SQL Server 2017...
Post by: rm13 on December 21, 2018, 10:02:44 AM
So are you able to create the initial database?
https://github.com/roundcube/roundcubemail/wiki/Installation#database-configuration

Any other database functional? For Linux something like this
Code: [Select]
sudo lsof -i :mysql to be sure mariadb is listening.
Title: Re: Having trouble connecting to SQL Server 2017...
Post by: SolidSonicTH on December 26, 2018, 10:56:54 AM
I manually built the database instead of letting Roundcube do it.

Here's the specific errors I'm seeing (the top one is the most pressing but any advice on the other two would be helpful as well).

(https://i.imgtc.com/2jX97OJ.png)

I might have set up my database user improperly so I'll go elsewhere for advice if that is the case.
Title: Re: Having trouble connecting to SQL Server 2017...
Post by: JohnDoh on December 27, 2018, 07:49:48 AM
I see you database server reports "login failed" are you use you typed the creds correctly in the config file?
Title: Re: Having trouble connecting to SQL Server 2017...
Post by: SolidSonicTH on December 27, 2018, 08:16:26 AM
I gave it the credentials I thought I had set up for that purpose.

I created the account both in Windows and then later in SQL Server itself and neither version seems to take it.

Does it need some kind of domain identifier to make it a valid login from Roundcube?
Title: Re: Having trouble connecting to SQL Server 2017...
Post by: rm13 on December 27, 2018, 03:47:10 PM
I'm not very familiar with MS SQL, but I think the Windows login vs SQL login will depend on how you configured your MS SQL. It could be the same or different... You should probably make it a SQL only account that has no rights on the OS for better security.

Make sure the Roundcube login works as expected from the SQL Server Management first.
Title: Re: SOLVED: Having trouble connecting to SQL Server 2017...
Post by: SolidSonicTH on January 29, 2019, 10:19:35 PM
I just wanted to let everyone know who helped that we are good to go.

The trick was in fact just having an SQL-only name. After that things started falling into place (I also had to delegate it the owner of the Roundcube database).

So it's running. Need to figure out how to secure it (right now it's using HTTP port 80) but otherwise it's good to go.

The only other issue I'm having is missing MIME files.