Language support

[dk seelro]

Hello Everyone,

This is Dodo Khan from Pakistan. We have just started using openXdata for our survey purpose. I am trying to create questionnaire local language say in Urdu. If this is possible then I would like to know how? It would be great help. 

i tried it , i crated a form in urdu and when i save it it shows a error. 

technical error, please try again lator 500 the call failed on the server ; see server log for details,

i also Google it. find the openxdata manual , that manual is saying we need to change a line, and then it will works. 

The OPENXDATA_SETTINGS.properties file, found under your webapp directory, can be changed like this. 

n  hibernate.connection.url=jdbc:mysql://localhost:3306/openxdata?autoReconnect=true&useUnicode=true&characterEncoding=UTF8

n  hibernate.connection.createdb.url=jdbc:mysql://localhost:3306/?autoReconnect=true&useUnicode=true&characterEncoding=UT8

waiting for the response. 

Thanks and Regards 

Dodo Khan

[Shashank Garg]

Hi Dodo Khan,

A "500" error normally occurs when the server is not able to connect to the database. In your second line "hibernate.connection.createdb.url=jdbc:mysql://localhost:3306/?autoReconnect=true&useUnicode=true&characterEncoding=UT8"  the database name is missing. The correct setting should have been:

hibernate.connection.createdb.url=jdbc:mysql://localhost:3306/openxdata?autoReconnect=true&useUnicode=true&characterEncoding=UT8

In any case, are you working with the latest OXD Server? 

It should have 2 settings, one for defining access to OXD System Tables, and another for Exported Tables. So, technically, you can have the system and exported tables located in different databases, even on different physical servers.

In the latest server your OPENXDATA_SETTINGS.properties file should look something like this:

##############################

# Mysql Settings

##############################

# Connection Properties

hibernate.connection.username=myusername

hibernate.connection.password=mydbpwd

hibernate.connection.driver_class=com.mysql.jdbc.Driver

hibernate.connection.url=jdbc:mysql://localhost:3306/openxdata?autoReconnect=true&useUnicode=true&characterEncoding=UTF8

#Exporter connection properties

exporter.driver_class=com.mysql.jdbc.Driver

exporter.url=jdbc:mysql://localhost:3306/openxdata?autoReconnect=true&useUnicode=true&characterEncoding=UTF8

exporter.username=myusername

exporter.password=mydbpwd

exporter.size_of_varchar=100

In the example shown above, I have placed both tables in the same database "openxdata", but they could be different databases. The choice is yours.

Please check it out.

Shashank@Handsrel

--
You received this message because you are subscribed to the Google Groups "openXdata Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openxdata-use...@googlegroups.com.
To post to this group, send email to openxda...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openxdata-users/786ff00b-8b8d-4103-a883-a39599675e36%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[dk seelro]

Thanks for the response, 

i am using the latest version. 

i have attached my file OPENXDATA_SETTINGS.properties , with this file oxd is working fine with English and when i update this file as per your mention lines, it shows a error

"HTTP Status 404 - " i have also attached my log file. 

with this i have changed my data base type and make it (data base charator set : utf8 and database collection: utf_unicode-ci)

can you help, where i am making a mistake. 

i will be waiting for your response, 

Thanks and Regards 

Dodo Khan

[dk seelro]

friends i am still waiting for the response 

[Dagmar Timler]

Hi

I think we are missing some of the evidence (i.e. the log files you sent us do not contain very much information). 

The only information in the log file indicates that you aren't using the attached OPENXDATA_SETTINGS.properties file. Two things lead me to believe that:

 1) The logs you sent say that there was no OPENXDATA_SETTINGS environment variable set. As a result, the default OPENXDATA_SETTINGS.properties is used.

 2) The properties file contains the setting "openxdata.database_type" and the log file has an exception saying that the property is missing.

Please read more about the properties file here: https://trac.openxdata.org/wiki/OPENXDATA_SETTINGS.properties

I would recommend using an environment variable to point to your settings file, and not just replacing the file in the webapp folder. The latter can be overwritten quite easily and seemingly randomly.

Onto your Urdu "500" error. The log files you sent have no 500 error log. Without the associated stack trace we can't unfortunately help. Depending on your OS, there could also be error stack traces in a log file called "localhost". Please take a look in all the relevant Tomcat log files for the stack trace caused when you see the "500" error in the Form Designer.

What is also confusing is that the error you sent us is a startup error. This means after seeing the error, the web application would not start up. This means you are unable to login and create a form. If this is the latest error you see, you first need to fix the properties file problem.

Thanks

Dagmar

--

You received this message because you are subscribed to the Google Groups "openXdata Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openxdata-use...@googlegroups.com.
To post to this group, send email to openxda...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/openxdata-users/942c72fd-35a0-4ecf-9436-e49fe620b3e4%40googlegroups.com.

[dk seelro]

Thanks for the response, 

i am attaching a snapshot with of the error and getting after creating any object in urdu and i save it shows this error and does not save the form with this i am also attaching log files of the for your reference, 

i hope this will help you to sort out the issue and you will help me to sort out the problem. because i need to start survey by wednesday. 

Thanks and Regards 

Dodo Khan

[Dagmar Timler]

Hi 

Thanks for the additional information.

It still seems to me as if the OPENXDATA_SETTINGS.properties you sent me is not being picked up by the application when it starts.

2014-07-14 11:16:22,154 [Thread-1] INFO  org.openxdata.server.OpenXDataPropertyPlaceholderConfigurer - Attempting to load properties from servlet context path: OPENXDATA_SETTINGS.properties

2014-07-14 11:16:22,154 [Thread-1] INFO  org.openxdata.server.OpenXDataPropertyPlaceholderConfigurer - Loading properties file from ServletContext resource [/OPENXDATA_SETTINGS.properties]

2014-07-14 11:16:22,154 [Thread-1] WARN  org.openxdata.server.OpenXDataPropertyPlaceholderConfigurer - Unable to find environment or system variable: OPENXDATA_SETTINGS

I would recommend following the steps on the wiki in order to set-up the environment variable in order to be sure that your property file is being used - the one where the unicode indicator and characterset is specified in the database URL.

To view this discussion on the web visit https://groups.google.com/d/msgid/openxdata-users/78b58915-1b66-4c58-ae9d-de0c3b4c60a7%40googlegroups.com.

[Dagmar Timler]

The URL for the documentation on the settings file can be found here: https://trac.openxdata.org/wiki/OPENXDATA_SETTINGS.properties