Receiving error with postgres

Discussions about using SIP Sorcery on your own computer/server
Post Reply
dig12345
Posts: 17
Joined: Thu Aug 05, 2010 8:01 pm

Receiving error with postgres

Post by dig12345 » Fri Dec 10, 2010 2:44 pm

I've followed the install doc included with v1.2 to set up sipsorcery with postgres. I'm getting the following error when logging in or creating a new account from the webgui:

2010-12-10 09:29:15,796 [8] ERROR sipsorcery [(null)] - Exception SQLAssetPersistor Add (for CustomerSession). Can't cast DateTimeOffset into any valid DbType.
2010-12-10 09:29:15,796 [8] ERROR sipsorcery [(null)] - Exception Authenticate CustomerSessionManager. Can't cast DateTimeOffset into any valid DbType.


Here is my connect string settings:
<add key="PersistenceStorageType" value="SQLLinqPostgresql" />
<add key="PersistenceConnStr" value="Database=sipsorcery;Host=localhost;User Id=postgres;Password=XXCHANGEDXX" />

I checked in pgAdmin and I can see 11 tables in the sipsorcery database. I added a row to sipdomains as directed. Not sure what else?

Any advise would be appreciated. Thanks.

Aaron
Site Admin
Posts: 4652
Joined: Thu Jul 12, 2007 12:13 am

Re: Receiving error with postgres

Post by Aaron » Sun Dec 12, 2010 9:57 pm

Are you using both the database schema and libraries from the 1.2 install?

If you try and use either the latest code or db schema with the 1.2 version it won't work.

dig12345
Posts: 17
Joined: Thu Aug 05, 2010 8:01 pm

Re: Receiving error with postgres

Post by dig12345 » Mon Dec 13, 2010 1:00 am

I'm using the precompiled v1.2 package. No modifications. (not sure which library's you're referring to)

Which DB schema should I be using? The doc file refers to the schema from the lastest source, I believe that's the one I used.

Aaron
Site Admin
Posts: 4652
Joined: Thu Jul 12, 2007 12:13 am

Re: Receiving error with postgres

Post by Aaron » Mon Dec 13, 2010 8:56 am

That's my fault. I should have included the database schema in the zip.

You should be able to get it working if you take a look at this thread.

Post Reply