Author Topic: [0.9 RC] MSSQL Issue RoundCube install  (Read 6848 times)

Offline ryanarvixe

  • Newbie
  • *
  • Posts: 2
[0.9 RC] MSSQL Issue RoundCube install
« on: March 19, 2013, 03:01:57 PM »
I'm struggling with something that should be as basic as getting this installed :(

Check DB config

DSN (write):  OK
DB Schema:  NOT OK(Error creating database schema: [102] [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'GO'.)
Please try to inizialize the database manually as described in the INSTALL guide. Make sure that the configured database extists and that the user as write privileges

This is what my db.inc.php looks like relating to the sqlsrv

$rcmail_config['db_dsnw'] = 'sqlsrv://roundcube:XXX@localhost/roundcube';     

Obviously replacing XXX with the actual password and database name and and MSSQL username are both roundcube.

We use MSSQL 2012 Standard (thus no need to add \SQLEXPRESS or any other instance name and when I do, the installer starts throwing errors (no longer says DSN (write) OK but when it is configured as above, it shows fine, but clicking initialize generates the error above on the scheme)

I loaded the .sql file into the database manually, attempted to complete the install and disabled the installer but at http://mail.rosebloom.arvixe.com/roundcubemail-0.9-rc/ I was still left with

"DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator."'

Our environment appears to meet all of the requirements for RoundCube based on the feedback the installer provided.

Offline ryanarvixe

  • Newbie
  • *
  • Posts: 2
Re: [0.9 RC] MSSQL Issue RoundCube install
« Reply #1 on: March 19, 2013, 03:02:40 PM »
Finally the only entries in the log folder are

"[19-Mar-2013 13:32:53 -0500]: DB Error: [208] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'session'. in E:\HostingSpaces\Internal\mail.rosebloom.arvixe.com\wwwroot\roundcubemail-0.9-rc\program\lib\Roundcube\rcube_db.php on line 416 (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 13:32:53 -0500]: DB Error: [208] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'session'. (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 13:32:53 -0500]: DB Error: [208] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'session'. in E:\HostingSpaces\Internal\mail.rosebloom.arvixe.com\wwwroot\roundcubemail-0.9-rc\program\lib\Roundcube\rcube_db.php on line 416 (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 13:35:31 -0500]: DB Error: [208] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'session'. in E:\HostingSpaces\Internal\mail.rosebloom.arvixe.com\wwwroot\roundcubemail-0.9-rc\program\lib\Roundcube\rcube_db.php on line 416 (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 13:35:31 -0500]: DB Error: [208] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'session'. (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 13:35:31 -0500]: DB Error: [208] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'session'. in E:\HostingSpaces\Internal\mail.rosebloom.arvixe.com\wwwroot\roundcubemail-0.9-rc\program\lib\Roundcube\rcube_db.php on line 416 (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 12:01:11 -0700]: DB Error: [208] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'session'. in E:\HostingSpaces\Internal\mail.rosebloom.arvixe.com\wwwroot\roundcubemail-0.9-rc\program\lib\Roundcube\rcube_db.php on line 416 (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 12:01:11 -0700]: DB Error: [208] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'session'. (GET /roundcubemail-0.9-rc/)
[19-Mar-2013 12:01:11 -0700]: DB Error: [208] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'session'. in E:\HostingSpaces\Internal\mail.rosebloom.arvixe.com\wwwroot\roundcubemail-0.9-rc\program\lib\Roundcube\rcube_db.php on line 416 (GET /roundcubemail-0.9-rc/)
"