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.
Receiving error with postgres
Re: Receiving error with postgres
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.
If you try and use either the latest code or db schema with the 1.2 version it won't work.
Re: Receiving error with postgres
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.
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.
Re: Receiving error with postgres
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.
You should be able to get it working if you take a look at this thread.