Defect #30285
closed
Microsoft SQL server support is broken
Added by Go MAEDA almost 6 years ago. Updated over 4 years ago.
0%
Description
Redmine 4.0.0 does not work with Microsoft SQL Server.
One of the causes is that a dependent library activerecord-sqlserver-adapter does not support Rails 5.2 yet.
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues/636
Files
| sqlserver.patch (4.55 KB) sqlserver.patch | Pavel Rosický, 2019-06-11 21:34 | ||
| patchCygwin.jpg (399 KB) patchCygwin.jpg | Hiep Le, 2019-07-16 10:56 | ||
| Gemfile.patch (786 Bytes) Gemfile.patch | update gems for sql server support | Pavel Rosický, 2020-03-31 16:37 |
Related issues
Updated by Go MAEDA almost 6 years ago
- Related to Defect #30284: Internal Server Error When Deleting a User added
Updated by Go MAEDA almost 6 years ago
- Related to Defect #30211: Crash with the message "undefined method `alias_method_chain'" when connecting to Microsoft SQL Server added
Updated by Go MAEDA almost 6 years ago
- Related to Defect #30210: Application crash when deleting an issue from issue list with SQLServer added
Updated by Go MAEDA almost 6 years ago
- Related to Feature #23630: Migrate to Rails 5.2 added
Updated by Go MAEDA almost 6 years ago
- Subject changed from Microsoft SQL server is broken to Microsoft SQL server support is broken
Updated by Jean-Philippe Lang almost 6 years ago
- Target version changed from 4.0.1 to 4.0.2
Updated by Go MAEDA almost 6 years ago
activerecord-sqlserver-adapter 5.2.0.rc1 has been released on February 12.
Updated by Jean-Philippe Lang almost 6 years ago
- Target version changed from 4.0.2 to Candidate for next minor release
Waiting for final release of activerecord-sqlserver-adapter 5.2.0
Updated by Marius BĂLTEANU almost 6 years ago
- Related to Defect #28506: Error Setup Redmine with Win10 added
Updated by Marius BĂLTEANU almost 6 years ago
- Related to deleted (Defect #28506: Error Setup Redmine with Win10)
Updated by Marius BĂLTEANU almost 6 years ago
- Related to Defect #28506: Error Setup Redmine with Win10 added
Updated by Go MAEDA almost 6 years ago
activerecord-sqlserver-adapter 5.2.0 has been released on March 19.
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/blob/master/CHANGELOG.md#v520
Can anyone test if Redmine 4.0 works with MS SQL Server? Please note that you have to run bundle update to install the latest activerecord-sqlserver-adapter gem.
Updated by sebastián scarano almost 6 years ago
yeap, here's the release, it would be great if redmine latest version could be confirmed to work ok with sql server...
and update the note at http://www.redmine.org/projects/redmine/wiki/RedmineInstall#Supported-database-back-ends
Redmine 4.0 does not support SQL Server as of December 2018 because a dependent library activerecord-sqlserver-adapter does not support Rails 5.2 yet.
Updated by Pavel Rosický almost 6 years ago
I tested it on SQL Server 2017 with these gems
activerecord-sqlserver-adapter (5.2.0)
tiny_tds (2.1.2-x64-mingw32)
it passes all tests, but unfortunatelly there's a problem with migrations due to this bug
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/pull/691
TinyTds::Error: The object 'DF_projects_description' is dependent on column 'description'. 087_change_projects_description_to_text.rb:5:in `up'
there might be an option to add a workaround in redmine, but it won't be pretty, so I would prefer to fix the problem in activerecord-sqlserver-adapter.
Updated by John Bolthouse over 5 years ago
Is there any progress on this? I would definitely like to upvote this as I have clients on Sql Server. I would also be happy to test potential solutions in our dev environments.
Updated by Pavel Rosický over 5 years ago
sorry, no feedback from activerecord-sqlserver-adapter's maintainers yet
but you can test my (unofficial) patch by changing the Gemfile
when /sqlserver/
gem "tiny_tds", "2.1.2", :platforms => [:mri, :mingw, :x64_mingw]
gem "activerecord-sqlserver-adapter", :git => 'https://github.com/ahorek/activerecord-sqlserver-adapter.git', :branch => 'constrains_bug', :platforms => [:mri, :mingw, :x64_mingw]
on my environment it passes all activerecord-sqlserver-adapter's tests and redmine's tests. Let us know if it works for you.
Updated by Pavel Rosický over 5 years ago
- File sqlserver.patch sqlserver.patch added
if you're still interested, here's a patch for redmine
Updated by Ricidleiv Tondatto over 5 years ago
Pavel Rosický wrote:
if you're still interested, here's a patch for redmine
For those who like me had to search how to apply this patch, here the official Redmine's way.
http://www.redmine.org/projects/redmine/wiki/patch
Updated by Alexander Ryabinovskiy over 5 years ago
Pavel Rosický wrote:
sorry, no feedback from activerecord-sqlserver-adapter's maintainers yet
but you can test my (unofficial) patch by changing the Gemfile
[...]on my environment it passes all activerecord-sqlserver-adapter's tests and redmine's tests. Let us know if it works for you.
Hello. They have megred your issue, as I can see?
https://github.com/ahorek/activerecord-sqlserver-adapter.git
Is this problem solved?
Updated by Hiep Le over 5 years ago
- File patchCygwin.jpg patchCygwin.jpg added
Hi Pavel,
Thanks for the update. Probably the problem not yet solved.
Could you please help clarify clearer with the patch file?
In Cygwin, I tried using both $ patch -p0 -i sqlserver.patch and $ patch -p0 < sqlserver.patch and none of them work.
Before using patch command, I converted the file using unix2dos but no luck. It kept failing with the LF and CRLF issue for ending line between linux and windows during file conversion.
Do I need to convert the file and what is the proper way to do? Please see the attached image.
Thank you very much!
Hiep
Updated by Pavel Rosický over 5 years ago
Hiep Le
ok, try to change the Gemfile instead.
when /sqlserver/
gem "tiny_tds", "2.1.2", :platforms => [:mri, :mingw, :x64_mingw]
gem "activerecord-sqlserver-adapter", :git => 'https://github.com/ahorek/activerecord-sqlserver-adapter.git', :branch => 'constrains_bug', :platforms => [:mri, :mingw, :x64_mingw]
CR/LF issues is off-topic, please ask on forums if you need help
there're better alternatives than cygwin
https://rubyinstaller.org/downloads/ or https://en.wikipedia.org/wiki/Windows_Subsystem_for_Linux
Alexander Ryabinovskiy
Hello. They have megred your issue, as I can see? https://github.com/ahorek/activerecord-sqlserver-adapter.git Is this problem solved?
yes, it's merged, but there's no release yet. https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/releases
until that happens www.redmine.org/attachments/download/23286/sqlserver.patch might be a temporarly solution. cc Go MAEDA, your opinion?
Updated by Bob Binary almost 5 years ago
Go MAEDA wrote:
Redmine 4.0.0 does not work with Microsoft SQL Server.
One of the causes is that a dependent library activerecord-sqlserver-adapter does not support Rails 5.2 yet.
Hi,
any news about this? I would like to use the latest version of redmine with mssql on windows. As far as I understand the answers in this thread do not solve the problem and currently there is no way to get the latest version of redmine running on mssql?
BR,
Bob
Updated by Pavel Rosický almost 5 years ago
As far as I understand the answers in this thread do not solve the problem and currently there is no way to get the latest version of redmine running on mssql?
officially no, by using an unofficial patch yes. (https://www.redmine.org/issues/30285#note-16)
I'm not the maintainer of the https://github.com/rails-sqlserver/activerecord-sqlserver-adapter gem, so there's nothing more I can do. The current state of development seems to be pretty dead.
Updated by Pavel Rosický over 4 years ago
- File Gemfile.patch Gemfile.patch added
activerecord-sqlserver-adapter 5.2.1 has been released on 31.3.2020. We should update the Gemfile.
Updated by Marius BĂLTEANU over 4 years ago
- Target version changed from Candidate for next minor release to 4.1.1
Updated by Yuichi HARADA over 4 years ago
Pavel Rosický wrote:
activerecord-sqlserver-adapter 5.2.1 has been released on 31.3.2020. We should update the Gemfile.
+1
I think it's good. I confirmed using the Docker image "mcr.microsoft.com/mssql/server:2017-latest-ubuntu".
Updated by Go MAEDA over 4 years ago
- Status changed from New to Resolved
- Assignee set to Go MAEDA
- Resolution set to Fixed
Pavel Rosický wrote:
activerecord-sqlserver-adapter 5.2.1 has been released on 31.3.2020. We should update the Gemfile.
Committed the patch. Thank you for working hard on fixing activerecord-sqlserver-adapter.
Marius, I think we can apply the patch to 4.0-stable as well as 4.1-stable, what do you think? SQL Server support is broken in Redmine 4.0 and later.
Updated by Marius BĂLTEANU over 4 years ago
- Target version changed from 4.1.1 to 4.0.7
Go MAEDA wrote:
Pavel Rosický wrote:
activerecord-sqlserver-adapter 5.2.1 has been released on 31.3.2020. We should update the Gemfile.
Committed the patch. Thank you for working hard on fixing activerecord-sqlserver-adapter.
Marius, I think we can apply the patch to 4.0-stable as well as 4.1-stable, what do you think? SQL Server support is broken in Redmine 4.0 and later.
Sure, good idea. I don't know why I thought that only 4.1 is affected.
Updated by Go MAEDA over 4 years ago
- Status changed from Resolved to Closed
Merged r19628 to stable branches.
Updated by Go MAEDA over 4 years ago
- Related to Patch #31230: Fix: migration fails in MS SQL-Server added