Working group discussing best practices for Drupal development and deployment on Microsoft Windows.
Since there are so many combinations of web server and database server be sure to clarify in your posts whether you are talking about IIS, Apache, SQL Server, or MySQL.
Topics of interest are:
- Microsoft Internet Information Server (IIS)
- Microsoft Windows
- Microsoft SQL Server
- WAMP tools (WampServer, XAMPP, etc)
- Development environments (Visual Studio, Komodo, Eclipse, NetBeans, etc)
- PHP
- Integration with enterprise servers
Running Drupal on Windows 2012 and SQL Server 2012
Hi All,
We are getting ready to receive new servers for our website. I am currently running Drupal 7 on IIS 7.5 and SQL Server 2008R2. The OS on both servers is Windows 2008R2. Is anyone running Windows and SQLServer 2012? I'd like the newest versions on the incoming servers but not sure if it is compatible or not.
Any insight is appreciated.
terri
Drupal/PHP Developer | worldwide technical services
Require experienced Drupal developer to work alongside our online production
team, which includes designers, information architects, and content developers. Responsibilities for this position include custom programming and web
application development, troubleshooting of existing client sites, contributing ideas and efforts
toward internal projects and working as part of a team to find solutions to various problems (i.e.
development platforms, documentation etc.). The ideal candidate should enjoy working in a
creative, challenging, and fast-paced team environment.
How work's Drupal developments using SQLSrv driver?
I have some questions about this scenario:
1 - If I distribute a development in drupal using MSSQL as Database Server (http://drupal.org/projects/sqlsrv) that is not under GPL licence, the functions and/or procedures stored in that database can be encrypted? Notice that in this case I didn't encrypt the drupal code.
2 - If I use Drupal to interact with data generated and managed from a propietary software (which can't be redistributed), can I via contract or other negate the possibility of a redistribution.
Anti Virus setup
Hello.
We are running Drupal 6 on IIS7 on Windows Server 2008 in Production.
There is some concern that our McAfee Enterprise AV setup is causing problems, though I cannot find hard evidence of this.
Was wondering what others used as their AV setup -- general tips or specific to McAfee.
Right now it does full scans at 3 AM locally (we're not a particularly global site).
This causes near 100% CPU usage during that time, but it's a low traffic period for us.
Our bigger concern is that On-Access scanning causes the site to choke periodically.
Read more
clean url problem with Korean/Chinese Characters (Unicodes)
For SEO and multilingual site, I want to use Korean or non-alphabetical characters in the url strings.
But I get crash/errors on the url with Korean characters in it.
Other rewrite is working fine-clean url.
Is there a way to configure web.config or something to make this work?
People always tell me to stop using IIS and change to linux, apache...etc.
Thank you for your advice and help!!
SQLSrv Driver + Organic Subgroup Creation = Rollback to Savepoint error
I just tried to create a sub-group using the Organic Groups module, and I received the same error that I received several months ago when I replied to an issue report on drupal.org. I found another related issue report referencing a possible fix, but the patch didn't work for me.
Read moredb_select - WITH (NOLOCK)
Hello:
Somebody know how to get a db_select() "WITH (NOLOCK)", otherwise how do I make a Tablesort with a pager from a db_query()?
Thanks for your answers.
How do Modules work with Windows? Are there as many?
We are preparing to implement Drupal 7 for our content management, and are considering both WAMP and full Windows (I don't know what that is called). Are there as many extra modules if you use the full windows with SQL Server modules? Do you just use the same modules and change them somehow to work with SQL? Any insite is appreciated.
thanks
terri
How to Set Up "sites/default/files" Permissions Properly on Windows
Thanks for any help. I thought this would be the perfect place to ask my question.
My setup: Drupal 7.15 / IIS 7.5 / PHP5.3 / SQL Server 2008
I started receiving these crazy "Permission denied in drupal_unlink()" errors after an update from 7.13 to 7.14 (and then 7.15). At first, I focused on the permissions for the tmp directory. But after getting some assistance from Drupal's issue queue, I was able to pinpoint the problem as being related to the "sites/default/files" directory.
Read moreImport legacy MSSQL data to Drupal on MSSQL
Hi,
I have Drupal 7 running on Server 2008 R2 with IIS 7.5 and MSSQL 2008.
I am wanting to use drupal to replace a legacy application that runs on an Oracle Database.
I have copied over a specific table from Oracle to another database on the same MSSQL server as Drupal is connected to.
I now want/need to move circa 320,000 articles from that table and create them as nodes within Drupal.
Read moreWhy is Drupal 7 driver for SQL Server issue being ignored?
I'm not trying to stir the pot so-to-speak; I'm just trying to figure out why nothing's happening with what many see as an important issue with the SQL Server driver for Drupal 7. This driver is maintained by the Commerce Guys.
There has been a major issue with the update from Drupal 7.12 to 7.14 and 7.15 for several months that was noted on these two reported issues:
http://drupal.org/node/1526404 (created on April 10, 2012 at 5:22pm)
http://drupal.org/node/1561396 (created on May 4, 2012 at 11:11am)
http://drupal.org/node/1567380 (created on May 8, 2012 at 10:05am)
tutor or freelancer | Personal tutoring or online support
I've been trying to figure out Migrate module to import event content type from D7 installation to other D7 on the same windows server which I own.
It's been almost a week without success and I would rather get this project done by getting direct help/support to learn faster way...
Event content type have like 100 nodes only...so not a grand project.
I have taxonomy terms to migrate, term references, date fields, featured image, categories and tags. Plus path, statistics(total count).
Read morehook_query_alter???
Anybody knows how did I can change the target database via hook_query_alter or other hook launched before the execution of a query?
Baseline Drupal performance expectations
UPDATE: Make sure that your Drupal settings.php connection string uses the IP address of your MySQL server (e.g. 127.0.0.1 for your local Windows machine), not 'localhost'. This change brought the execution time of a barebones Drupal install down from ~800-900ms to ~60-90ms.
Original post follows -----------------------
Fairly new to Drupal, trying to determine what kind of performance we should expect from a stock Drupal install, with the optional modules (not the barebones option).
Read more
Mail Not Sending from Windows Server 2008
I cannot get my server to send emails with PHP. This is true within my Drupal install as well as with a simple PHP mail script. I am new to server management, so any assistance would be greatly appreciated. I am running IIS 7.5 on a Windows Server 2008 R2. The mail function in my PHP.ini is as follows:
[mail function]
; For Win32 only.
; http://php.net/smtp
SMTP = localhost
; http://php.net/smtp-port
smtp_port = 25Thanks.
MSSQL 2005???
Is there a possibility to connect a Drupal 7 site in MSSQL 2005, using SQLSRV?
High-profile sites running Drupal on Windows
Can anyone provide a list of high-profile sites that run Drupal on Windows in production? I have not seen a good list, despite searching http://groups.drupal.org/drupal-windows and http://groups.drupal.org/microsoft-servers
drupal not working.
Hi
I am installing drupal at http://drupal.des-us.com. It gives me the error that PDO is not enabled. I inquired with my web host, and it is enabled, which can be checked at http://web.des-us.com/test.php. They told me to contact the vendor. So why is drupal not installing here? I had installed it successfully some days before on the 26th of may.
I also have access to php.ini file, and I have checked that mbstring and pdo both are enabled.
Thanks
install multisite drupal on 3rd party webhost
Hello all
I am trying to install drupal on my shared hosting plan. I have already successfully installed drupal 7.14 on my desktop windows server 2008 with IIS7. I plan to recreate the same site on the 3rd party webhost.
The hosting plan has the following:
1. Windows server 2008
2. IIS6
3. PHP 5.2.5
4. MySQL 5.0.91
I have setup my core drupal install at a subdomain http://dessites.des-us.com. It was working quite correctly, until suddenly, I get this error on browsing to the site:
Fatal error: Class 'PDO' not found in ........includes\database\database.inc on line 184
Drupal Performance on IIS7 vs Apache
I've been doing a bunch of performance testing for one of my Drupal sites Trailforks.com and decided to compare IIS7 vs Apache 2.4. I host several Drupal websites on Windows Web Server 2008 with IIS7 and love it. I've read more and more articles that show IIS outperforms Apache and other web servers in many situations. But I wanted to make sure I wasn't loosing possible performance by hosting my site with IIS compared to Apache.
Read more