software | Ibrahim Shafi

Error installing Sql Server 2008 (Solved)

Jul 122011

When installing SQL Server 2008, if the privilege, Debug Programs, is not enabled for the user doing the install, the install fails un-gracefully. You may also get a message that says ‘Access Denied’. To set the privilege, do the following:

Click: [Start] >> [Administrative Tools] >> [Local Security Policy]
Navigate to: Security Settings>>Local Policies>>User Right Assignment>>Debug Programs
Add the user doing the install to the list.
Once you have made this change, cold boot your computer and check that the change was successful.

If you already loaded SQL Server Express or any other version of SQL Server 2008, and this check reveals that ADMIN is the only entry with the permission, you must completely un-install SQL Server Express 2008 and any other related SQL services installed along with it from control panel, by using the Add/Remove Programs, then cold boot your computer and make sure no services are left in place.

You may then re-install SQL Server with the correct permissions.

Undefined index: SSL_CLIENT_CERT

software 1 Response »

Oct 072009

While working with a PHP application running on Apache that uses client certificates, I ran into the following error:

Undefined index: SSL_CLIENT_CERT

The fix was simple. Make sure you have the following in your apache ssl configuration file:

<VirtualHost _default_:443>
...

SSLOptions +FakeBasicAuth +ExportCertData +StrictRequire

...
</VirtualHost>

It might be commented out.

Arabic Typing in Windows

software, windows 2 Responses »

Aug 062009

I just discovered an addon to Microsoft Windows to make it really easy to type in Arabic. Install Microsoft Maren and you can type Arabic using roman characters. So for example, the words “Saba7 el 7’eir” will map to “الخير صباح” meaning good morning in Arabic. There are other alternatives such as Yamli and Google ta3reeb, but they only work in web based applications. Maren works in a number of applications, including Word.

Quickbooks Pro 2009 online banking import problem

software No Responses »

Jul 152009

Today I was updating my Quickbooks file with my downloaded statement from Bank of America. In the past this has worked fine, but today I got the following error:

There are no new transactions available.  Please check again tomorrow.

I looked at the stmt.qbo file from the bank and I could see the new transactions in there, so I knew they were there. After looking online for an answer, I finally looked at the settings for the affected account. To solve the problem,

go to Lists -> Chart of Accounts, then right click on the affected account and select edit account.
Select the “Online Services” tab and select the option to “Deactivate All Online Services”.
Once you do this, then import the stmt.qbo file by going to File -> Utilities -> Import -> Web Connect Files…
You may need to associate the file with an existing account. After doing this, you should see new transactions.

push_with_attributes and acts_as_taggable gem

software No Responses »

Jul 012009

I have a Ruby on Rails application in which I used the acts_as_taggable gem. The problem is that this gem does not work with Rails 2 because the method push_with_attributes has been deprecated. After searching around for a while, I just changed the following line in taggable.rb:

tag_collection.push_with_attributes(tag_record, attributes) unless tagged_with?(name)

to:

tag_collection << tag_record unless tagged_with?(name)

Since I am not using attributes, it seems to work. I am not sure if it breaks anything else.

Caught exception: A database error has occurred Query: INSERT INTO `user`

software No Responses »

Mar 182009

I am using SSL certificate authentication to log into Mediawiki. One of the users would get an error when he used his valid certificate. The error:

Caught exception: A database error has occurred Query:
INSERT INTO `user`
(user_id,user_name,user_password,user_newpassword,user_newpass_time,user_email,user_email_authenticated,user_real_name,user_options,user_token,user_registration,user_editcount)
VALUES
(NULL,'john.smith','','','20090310212536','',NULL,'','quickbar=1\nunderline=2\ncols=80\nrows=25\nsearchlimit=20\ncontextlines=5\ncontextchars=50\ndisablesuggest=0\nskin=\nmath=1\nusenewrc=0\nrcdays=7\nrclimit=50\nwllimit=250\nhideminor=0\nhighlightbroken=1\nstubthreshold=0\npreviewontop=1\npreviewonfirst=0\neditsection=1\neditsectiononrightclick=0\neditondblclick=0\neditwidth=0\nshowtoc=1\nshowtoolbar=1\nminordefault=0\ndate=default\nimagesize=2\nthumbsize=2\nrememberpassword=0\nnocache=0\ndiffonly=0\nshowhiddencats=0\nnorollbackdiff=0\nenotifwatchlistpages=0\nenotifusertalkpages=1\nenotifminoredits=0\nenotifrevealaddr=0\nshownumberswatching=1\nfancysig=0\nexternaleditor=0\nexternaldiff=0\nforceeditsummary=0\nshowjumplinks=1\njustify=0\nnumberheadings=0\nuselivepreview=0\nwatchlistdays=3\nextendwatchlist=0\nwatchlisthideminor=0\nwatchlisthidebots=0\nwatchlisthideown=0\nwatchlisthideanons=0\nwatchlisthideliu=0\nwatchcreations=0\nwatchdefault=0\nwatchmoves=0\nwatchdeletion=0\nnoconvertlink=0\nvariant=en\nlanguage=en\nsearchNs0=1','8f168c4d8ed2afa12c3b223d001e1cd7','20090310212536','0')
Function: User::addToDatabase Error: 1062 Duplicate entry
'john.smith' for key 2 (localhost)

Mediawiki is set up to create a user using the information in the certificate if the user does not exist. It turns out that if the field from the certificate used to create the username starts with a lowercase letter, then Mediawiki will think the user does not exist, but MySQL complains that the user already exists. Mediawiki is looking for a username that starts with a capital letter. The issue was solved by issuing another certificate to the user with the first letter of the username capitalized.

no such file to load — htree (MissingSourceFile)

software No Responses »

Mar 052009

I moved a ruby on rails app to another machine and set it up to use Phusion Passenger. When I went to my app, I got the following error:

no such file to load -- htree (MissingSourceFile)

The problem was resolved by installing htree.

The application failed to initialize properly (0XC0000005)

software, windows 1 Response »

Dec 292008

I was working with a program which worked perfectly fine in Windows XP, but when I tried to run it in Windows 2003 Server, I got the following error:

The application failed to initialize properly (0XC0000005). Click OK to terminate the application.
This problem is generated by Microsoft’s Data execution prevention (DEP) . For more information, reference Microsoft Technet
Any application that is not registered with DEP will receive an exception with status code STATUS_ACCESS_VIOLATION (0xC0000005).

To get around the problem, follow this procedure:

The following procedure describes how to manually configure DEP on the computer:

Click Start, click Control Panel, and then double-click System.
Click the Advanced tab. Then, under Performance, click Settings.
Click the Data Execution Prevention tab.
Click Turn on DEP for essential Windows programs and services only to select the OptIn policy.
Click Turn on DEP for all programs and services except those I select to select the OptOut policy.
If you selected the OptOut policy, click Add and add the applications that you do not want to use DEP with.

After adding my application to the list that do not use DEP, it started working.

Liferay Installation Error

software 2 Responses »

Oct 202008

I ran into the following error when I tried to install and run the Liferay+Tomcat 6 bundle on Fedora 9:

java.lang.ArrayIndexOutOfBoundsException: 0
	com.liferay.portal.util.PortalInstances._getDefaultCompanyId(PortalInstances.java:233)
	com.liferay.portal.util.PortalInstances._getCompanyId(PortalInstances.java:189)
	com.liferay.portal.util.PortalInstances.getCompanyId(PortalInstances.java:71)
	com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.doFilter(VirtualHostFilter.java:110)
	com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
	com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:74)
	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)

Suffusion theme by Sayontan Sinha