Weblinks: "The FastCGI process exited unexpectedly"

This forum is for issues with installing Joomla! 2.5 (All 1.6 and 1.7 releases have reached end of life and should be updated to 2.5.) on IIS webservers.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Thu Mar 01, 2012 5:46 pm

Hello,

I am finding there is an error every time I attempt to display a list of Weblinks within a Weblinks category as a module in Joomla 2.5.1 (IIS 7.5 server, MS-SQL).

I can display other module types, and I can display links without a problem when it is displayed as a Menu Item link. This only happens when it comes to displaying it as a module.

Anyone else finding this problem? Any patches available for this?

Thanks in advance.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26050
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by Per Yngve Berg » Thu Mar 01, 2012 6:22 pm

This must be an issue with your web server. Can't say more without more info.
Check the server logs. Use the Forum Post Assistant and post the result.

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Thu Mar 01, 2012 6:36 pm

Thanks!

Here's what the server log displays when visiting that page.

2012-03-01 18:26:58 ::1 GET /megan-s-law.html - 80 - ::1 Mozilla/5.0+(Windows+NT+6.1)+AppleWebKit/535.11+(KHTML,+like+Gecko)+Chrome/17.0.963.56+Safari/535.11 500 0 1 333

I believe it has something to do with displaying weblinks as a module specifically, as it works fine to display weblinks when it comes from a menu item.
Problem Description :: Forum Post Assistant (v1.2.0) : 1st March 2012 wrote:Weblinks as module gives 500 error
Log/Error Message :: Forum Post Assistant (v1.2.0) : 1st March 2012 wrote:HTTP Error 500.0 - Internal Server Error C:\Program Files\PHP\php-cgi.exe - The FastCGI process exited unexpectedly
Forum Post Assistant (v1.2.0) : 1st March 2012 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 2.5.1-Stable (Ember) 2-Feb-2012
Joomla! Platform :: Joomla Platform 11.4.0-Stable (Brian Kernighan) 03-Jan-2012
Joomla! Configured :: Yes | Read-Only (444) | Owner: 0 (uid: /gid: ) | Group: 0 (gid: ) | Valid For: 1.7 and above
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 1 | SEF ReWrite: 1 | .htaccess/web.config: Yes | GZip: 0 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: default | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Windows NT | OS Version: 6.1 | Technology: i586 | Web Server: Microsoft-IIS/7.5 | Encoding: gzip,deflate,sdch | Doc Root: C:/inetpub/wwwroot/joomla | System TMP Writable: No

PHP Configuration :: Version: 5.3.10 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: | Error Reporting: 22527 | Log Errors To: C:\Windows\temp\php-errors.log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 2M | Max. POST Size: 8M | Max. Input Time: 60 | Max. Execution Time: 300 | Memory Limit: 128M

MySQL Configuration :: Connection Error: : Database Credentials Present? in Configuration...
Detailed Environment :: wrote:PHP Extensions :: Core (5.3.10) | bcmath () | calendar () | com_dotnet (0.1) | ctype () | date (5.3.10) | ereg () | filter (0.11.0) | ftp () | hash (1.0) | iconv () | json (1.2.1) | mcrypt () | SPL (0.2) | odbc (1.0) | pcre () | Reflection ($Revision: 321634 $) | session () | standard (5.3.10) | mysqlnd (mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $) | tokenizer (0.1) | zip (1.9.1) | zlib (1.1) | libxml () | dom (20031129) | PDO (1.0.4dev) | bz2 () | SimpleXML (0.1) | wddx () | xml () | xmlreader (0.1) | xmlwriter (0.1) | cgi-fcgi () | sqlsrv (2.0.1802.200) | pdo_sqlsrv (2.0.1802.200) | openssl () | curl () | gd () | gettext () | gmp () | imap () | ldap () | mbstring () | mysql (1.0) | mysqli (0.1) | Phar (2.0.1) | pdo_mysql (1.0.2) | PDO_ODBC (1.0.1) | pdo_sqlite (1.0.1) | pgsql () | soap () | sockets () | sqlite3 (0.7-dev) | tidy (2.0) | xmlrpc (0.51) | exif (1.4 $Id: exif.c 321634 2012-01-01 13:15:04Z felipe $) | mhash () | Zend Engine (2.3.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: No | PHP SU: Yes | Custom SU (Cloud/Grid): No
Potential Ownership Issues: Maybe
Folder Permissions :: wrote:Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (777) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) |
Extensions Discovered :: wrote:Modules :: SITE :: mod_articles_archive (2.5.0) | mod_articles_categories (2.5.0) | mod_articles_category (2.5.0) | mod_articles_latest (2.5.0) | mod_articles_news (2.5.0) | mod_articles_popular (2.5.0) | mod_banners (2.5.0) | mod_breadcrumbs (2.5.0) | mod_custom (2.5.0) | mod_feed (2.5.0) | mod_finder (2.5.0) | mod_footer (2.5.0) | mod_languages (2.5.0) | mod_login (2.5.0) | mod_menu (2.5.0) | mod_random_image (2.5.0) | mod_related_items (2.5.0) | mod_search (2.5.0) | mod_stats (2.5.0) | mod_syndicate (2.5.0) | mod_users_latest (2.5.0) | mod_weblinks (2.5.0) | mod_whosonline (2.5.0) | mod_wrapper (2.5.0) |
Modules :: ADMIN :: mod_custom (2.5.0) | mod_feed (2.5.0) | mod_latest (2.5.0) | mod_logged (2.5.0) | mod_login (2.5.0) | mod_menu (2.5.0) | mod_multilangstatus (1.7.1) | mod_popular (2.5.0) | mod_quickicon (2.5.0) | mod_status (2.5.0) | mod_submenu (2.5.0) | mod_title (2.5.0) | mod_toolbar (2.5.0) | mod_version (2.5.0) |

Templates Discovered :: wrote:Templates :: SITE :: atomic (2.5.0) | beez5 (2.5.0) | beez_20 (2.5.0) |
Templates :: ADMIN :: bluestork (2.5.0) | hathor (2.5.0) |

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26050
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by Per Yngve Berg » Thu Mar 01, 2012 6:45 pm

I can only see two misconfigurations:

System TMP Writable: No
Session Path Writable: No

Set a proper writeable temp and session folder in php.

Finaly, don't flag anything 777. That is a direct invitation to hackers and everyone have write access to the files. Files shall be 644 and folders 755.

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Thu Mar 01, 2012 7:30 pm

Thank you for your reply and all the help so far. I have altered php.ini in order to point to the joomla tmp folder, and the log folder. I reset the IIS server and checked the FPA again... and it still says that these folders are not system writable. Can you help me understand what specifically to change for this? It should be noted that I'm accessing the Web site through "http://localhost/" and the joomla folder is set as the web root.

Thanks again.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26050
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by Per Yngve Berg » Thu Mar 01, 2012 8:00 pm

I have no experience in setting up IIS. There is also a webconfig.ini file.

Try to do a search at Microsoft or post at a IIS forum.

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Thu Mar 01, 2012 9:23 pm

Thank you, I will do that. I'll report back if I discover anything that might be helpful for others.

Incidentally: Do you believe fixing this misconfiguration will solve the problem? The site works correctly for all other pages, including Weblinks as a component menu item... just not when displayed as a module. I can unpublish the module and that page will work again.

Thanks again.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26050
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by Per Yngve Berg » Thu Mar 01, 2012 9:29 pm

You can try to re-upload the files in the mod_weblinks folder in case of corrupt files.
Never seen before that the web server crashes like that. It usually generates a php error.

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Fri Mar 02, 2012 12:38 am

Just an FYI -- this problem was added in early February in the Joomla Bug Tracker here: http://joomlacode.org/gf/project/joomla ... m_id=28005 If you can assist in solving this one on this forum topic, I will carry that over into the official tracker. Thank you.

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Thu Mar 22, 2012 4:06 pm

I'm experiencing the same issue, I checked out the bug tracking page, is there any way to get an estimate of the amount of time it will take to fix something like this?

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Thu May 10, 2012 6:08 pm

plastersan, here's what I have updated on the joomla bug tracker page. Not an official solution but this got it working for me.
OK, I've figured out the problem and have a solution, although I'm pretty sure
you will want to create a proper patch for this. It all comes down to this line
in "modules\mod_weblinks\helper.php":

'DATE_FORMAT(a.date, "%Y-%m-%d") AS created');

Which is a MySQL statement. Also, "created" is being called twice
(once in the query and also as a column with the reference "SELECT
a.*"). So, I've replaced that line with this:

'convert(char(10), a.date, 120) AS created_date');

And it now works -- no errors, no fastcgi crash, and displays properly. Not
sure whether the code logic requires "created" to be called, and
also, I'm sure this update would not work under mysql, so somebody here will
need to take it the rest of the way from here. Thanks!!

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Thu May 10, 2012 6:23 pm

adrianfso, thank you!

MSSQL DB has been an adventure so far, are you also using MSSQL DB?

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Thu May 10, 2012 6:33 pm

Yep, and I'm far from an expert. Got some help though. Trying to get phocagallery to work. Can't figure it out.

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Thu May 10, 2012 6:39 pm

We have 4 add-ons working: JCE Editor, Ninja Icons, Fox Contacts, and Sliders.
I was thinking about starting a list of joomla extensions that work with MSSQL, if you have any to add, let me know :)

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Thu May 10, 2012 6:45 pm

XMAP works fine but I think I had to do a couple tweaks to the files to get it working. Mostly, I can't figure out how to deal with "GROUP BY" clauses. In phocagallery, "GROUP BY" is used a lot and mssql treats it differently. Not even sure if that's the only issue. Are you finding that all of the incompatibility issues boil down to SQL statements? I'm also using IIS so I'm worried that it has something to do with that, but I don't think so... PHP is running just fine on it. If it's SQL statements, then it probably comes down to GROUP BY and how to replace that.

Phocagallery has taken a lot of work to get working, so far. Not recommended for the faint of heart!

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Fri May 11, 2012 3:08 pm

I believe extensions have to be re-written to use jdatabase query instead of mysql/mssql calls to the database.
The install process is also different, the vendor will need to support different queries to write the tables to specific DBs. I will post an example of what this looks like from JCE Editor to demonstrate what this looks like.

Our setup looks like this:
Windows 2008 server
IIS 7
Joomla 2.5.4
PHP 5.3
Database is out on an SQL Cluster.

Is that pretty much the same setup you have?

I've been thinking about creating a guide for this kind of setup and maybe eventually gathering information on how to re-written applications to support MSSQL (and eventually other DBs like Oracle), but I think a step by step guild on how to setup Joomla 2.5 in Windows/IIS/MSSQL is a good place to start.

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by humvee » Fri May 11, 2012 3:13 pm

First and foremost you need to update to J 2.5.4, if you have not already done so, this eliminates any known issues that may have been fixed.

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Fri May 11, 2012 3:18 pm

This is from another thread, but an example of the differences between MSSQL and MySQL when using extensions:

Before you change the database type, make sure that all the extensions you would like to use support MSSQL. The release of Joomla 2.5 makes all the core Joomla MSSQL compatible, however there are currently very few extensions that have had MSSQL support added. If you look at the com_myextension.xml file, you can see which databases they current support, eg. (in this case mySQL and MS SQL)

Code:
<install>
<sql>
<file driver="mysql" charset="utf8">sql/install.mysql.utf8.sql</file>
<file driver="sqlsrv" charset="utf8">sql/install.sqlsrv.utf8.sql</file>

</sql>
</install>


The syntax for MSSQL (sqlsrv) is very different to mySQL, for example:
Example of JCE Editor -
MySQL:

Code: Select all

CREATE TABLE IF NOT EXISTS `#__wf_profiles` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(255) NOT NULL,
	`description` varchar(255) NOT NULL,
	`users` text NOT NULL,
	`types` varchar(255) NOT NULL,
	`components` text NOT NULL,
	`area` tinyint(3) NOT NULL,
	`rows` text NOT NULL,
	`plugins` text NOT NULL,
	`published` tinyint(3) NOT NULL,
	`ordering` int(11) NOT NULL,
	`checked_out` tinyint(3) NOT NULL,
	`checked_out_time` datetime NOT NULL,
	`params` text NOT NULL,
	PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
Compared to MSSQL:

Code: Select all

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[#__wf_profiles]') AND type in (N'U'))
BEGIN
CREATE TABLE [#__wf_profiles](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](250) NOT NULL,
	[description] [nvarchar](250) NOT NULL,
	[users] [text] NOT NULL,
	[types] [nvarchar](250) NOT NULL,
	[components] [nvarchar](max) NOT NULL,
	[area] [smallint] NOT NULL,
	[rows] [nvarchar](max) NOT NULL,
	[plugins] [nvarchar](max) NOT NULL,
	[published] [smallint] NOT NULL,
	[ordering] [int] NOT NULL,
	[checked_out] [smallint] NOT NULL,
	[checked_out_time] [datetime] NOT NULL,
	[params] [nvarchar](max) NOT NULL,
 CONSTRAINT [PK_#__wf_profiles_id] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
END;
And the extension needs to be using the database query format
Code:

Code: Select all

$db      = JFactory::getDbo();
$query   = $db->getQuery(true);

$query->from('#__myextension AS a');
$query->select('a.*,  c.title AS category_name');
$query->join('LEFT', '#__categories AS c ON c.id = a.catid');
$query->where('(a.state IN (0, 1))');
$query->order('a.catid, a.ordering');

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Fri May 11, 2012 3:57 pm

humvee wrote:First and foremost you need to update to J 2.5.4, if you have not already done so, this eliminates any known issues that may have been fixed.
Thank you for the post humvee, I can verify its still an issue in 2.5.4, we ended up switching to ninja icons and liked them better so its no longer an issue for us, but I can help with testing any changes if that is useful.

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by humvee » Fri May 11, 2012 4:37 pm

Yep I was referring to AdrianFSO who showed 251.
I have also added your comment regarding extensions to the introductory post on the forum (with accreditation)

adrianfso
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Mar 01, 2012 5:09 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by adrianfso » Mon May 14, 2012 4:43 pm

Thank you for all the help so far, everyone. I am on 2.5.4, and had updated to it within days of its release. Sorry for the delay in my response.

I'm still experiencing other issues and I believe they are related to the sqlsrv set up. But I think another thread would be in order for those. plastersan, if you are developing any sort of guide for this setup (you are correct about my current set up from your previous post), then just let me know how I can help. It would be great to give this type of advice to anyone else coming along the same path that we've been traveling. Thanks!

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by humvee » Tue May 15, 2012 7:44 am

adrianfso wrote: plastersan, if you are developing any sort of guide for this setup (you are correct about my current set up from your previous post), then just let me know how I can help. It would be great to give this type of advice to anyone else coming along the same path that we've been traveling. Thanks!
If any of you are developing notes and want to help the most people then joining the http://docs.joomla.org wiki and adding the information there would be the greatest thing you could do.

It also give all of us not currently on IIS/MSSQL somewhere to point everyone to.

I have a copy of WinServer 2008 standing by, but I have been busy working with Apache on Linux, Windows, and Mac and there are only so many hours in the day! :eek:

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Tue May 15, 2012 12:55 pm

Sounds good, I will do that, I need to gather screeen shots and step by step directions from my network engineer for some parts of the process.

Here is the complete setup we use just in case this would be useful to anyone:

We have 4 servers:
Joomla01
Joomla02
Joomla03
Joomla04
(not real names obviously)
All are Windows Server 2008 R2 SP1
The database is seperate from the servers on an SQL Cluster.
Joomla01/02 access is setup through an F5 load balancer.
The file structure is replicated from 01 to 02 using richcopy.
Joomla 03 is a test server that connects to a test database also on the sql cluster.
We have batch file/sql query we can fire off to copy over the live structure to test when we need to.

Joomla04 is on the DMZ to provide external access using merge replication to the internal network.

This structure supports our 10,000+ users well so far.

We had several failed intranet projects before Joomla that we spent a lot of money on, we were able to reuse that hardware with joomla for no additional costs besides the labor involved in converting which was relatively small. From a business standpoint, Joomla has been a slam dunk for us.

The one thing we wish Joomla had was ACL integration with Active Directory groups. There is one extension that does it, but its fairly limited and still in beta. If that functionality could be added to the core, or by a vendor extension, it would be worth a lot to us. Everything else is exactly what we were looking for out of CMS.

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by humvee » Tue May 15, 2012 4:00 pm

Plastersan wrote:Sounds good, I will do that, I need to gather screeen shots and step by step directions from my network engineer for some parts of the process.
Great thank you. You could always get the engineer to write it directly - but if engineer == developer they like doing it not writing about it !!

plastersan
Joomla! Apprentice
Joomla! Apprentice
Posts: 28
Joined: Wed Jan 04, 2012 1:20 pm

Re: Weblinks: "The FastCGI process exited unexpectedly"

Post by plastersan » Tue May 15, 2012 4:12 pm

humvee wrote:
Plastersan wrote:Sounds good, I will do that, I need to gather screeen shots and step by step directions from my network engineer for some parts of the process.
Great thank you. You could always get the engineer to write it directly - but if engineer == developer they like doing it not writing about it !!
You are correct :D
I enjoy doing it, like you, it will just be a matter of setting aside time, but I will do it because I think its the least I can do for everything Joomla did for me.

[Mod Note: that's what makes it a great community to belong to :) :) :) :) ]
Last edited by humvee on Tue May 15, 2012 4:21 pm, edited 1 time in total.
Reason: added footnote


Locked

Return to “Joomla! 2.5 on IIS webserver”