3.4 .conf problem (Upgrade Process)

[Oscar Tark]

Hi to all! so I am upgrading our server from 3.0.0 to 3.4.3 the main thing I see is a difference to the .config file. I am using the template furnished by Sharoon Thomas at https://gist.github.com/sharoonthomas/0b425318b47b3dc999e1. For some reason it says it is using the file but is not using the parameters i gave it. most probably the keywords are wrong for the parser?

[Sharoon Thomas]

Hi Oscar

On Tue, Apr 28, 2015 at 5:34 AM, Oscar Tark <oscar...@gmail.com> wrote:

Hi to all! so I am upgrading our server from 3.0.0 to 3.4.3 the main thing I see is a difference to the .config file. I am using the template furnished by Sharoon Thomas at https://gist.github.com/sharoonthomas/0b425318b47b3dc999e1. For some reason it says it is using the file but is not using the parameters i gave it. most probably the keywords are wrong for the parser?

Can you upload a copy of your config (removing sensitive info) ? This would help take a look at it faster.

Also running the server with -v and --dev shows more info.

Thanks

--

--

Sharoon Thomas
Openlabs Technologies & Consulting (P) Limited

w: http://www.openlabs.co.in
m: +1 813.793.6736 (OPEN) Extn. 200 (Request a call)

t: @sharoonthomas

- We Win When our Customers Win

[Oscar Tark]

Hello Sharoon,

Here is a copy of the config without the sensitive info:

---------------------------------------------------------------------------------------

[database]
# Database related settings
 
# The URI to connect to the SQL database (following RFC-3986)

uri = db://user:pwd@localhost:port/
#uri = postgresql://tryton:tryton@/
#uri = postgresql://tryton:tryton@localhost:5432/
path = path
list = True
retry = 8
language = en_US
 
[ssl]
#FOR LATER, PEOPLE
# The path to the private key
#privatekey = key
 
# The path to the certificate
#certificate = key
 
[jsonrpc]
listen = ip:port
 
# The hostname for this interface
hostname = hostname
 
# The root path to retrieve data for GET requests
data = jsondata
 
[xmlrpc]
# Settings for the XML-RPC network interface
 
# The IP/host and port number of the interface
listen = ip:port
 
[webdav]
# Settings for the WebDAV network interface
listen = ip:port
 
[session]
timeout = 8000
super_pwd = pwd
 
[email]
# Mail settings
# Available protocols are:
# - smtp: simple SMTP
# - smtp+tls: SMTP with STARTTLS
# - smtps: SMTP with SSL
uri = smtp://localhost:25
 
# The From address used by the Tryton Server to send emails.
#from = none@localhost
 
[report]
#unoconv = pipe,name=trytond;urp;StarOffice.ComponentContext

[James Norman]

This looks like an obsolete configuration file - look under configuration in the documentation. IMHO the configuration file being used is inaccurate. I’ve given it a file I know not to exist, and it happily starts and says it’s using that non-existent file.

[Sergi Almacellas Abellana]

El 28/04/15 a les 14:47, Oscar Tark ha escrit:

>
> # The URI to connect to the SQL database (following RFC-3986)
>
> uri = db://user:pwd@localhost:port/

It looks like this uri is wrong:

format is the following:

dbtype://username:password@host:port/database_name

so in your case it will be:

postgresql://user:pwd@localhost:port/db

Hope it helps.

See:
http://doc.tryton.org/3.6/trytond/doc/topics/configuration.html#topics-configuration

--
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

[Oscar Tark]

Wierd, well anyways it\s not working and I want to figure out how to fix it. I did see the documentation but unfortunately I still don\t understand what is going wrong. I was till now using the 3.0.0 config format. Clearly the keywords are wrong as the parser is ignoring the text...

As per you said Jim, mine does the same. says its using that config file and goes to defaults without saying it\s going onto defaults though i did try -v and --dev

[Oscar Tark]

Tried changing the format, still nothing...

[Sharoon Thomas]

On Tue, Apr 28, 2015 at 6:32 AM, Oscar Tark <oscar...@gmail.com> wrote:

Tried changing the format, still nothing...

The most critical piece of info to start with that Tryton needs is the database URI.

Can you check with that alone in your config file ?

Alternatively, you can test without a config file if your DB settings are correct.

Try:

`TRYTOND_DATABASE_URI=postgresql://tryton:tryton@localhost:5432/ trytond -v --dev`

[Oscar Tark]

@Sharoon,

So I executed the command output:

[Tue Apr 28 13:44:16 2015] INFO:trytond.server:using default configuration
[Tue Apr 28 13:44:16 2015] INFO:trytond.server:initialising distributed objects services
[Tue Apr 28 13:44:16 2015] INFO:trytond.server:starting JSON-RPC protocol on localhost:8000

it has lapsed to default which is ok. now I trz to connect to the server at localhost:8000 and it sazs no connection to server when trying to create a db.

[Sharoon Thomas]

Oscar, I presumed that is probably the issue.

Tryton is notoriously silent about database connection issues. 

My guess is, that is where the problem is. To figure the error, you can make tryton connect to a database at load time by passing `-d <dbname>` as argument and this should make tryton instantly connect to the database. Any errors in your connection would be apparent then.

Thanks

[Oscar Tark]

Found the problem!, Thanks Sharoon!

Cheers!