Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: About Installation with Oracle Data Base

About Installation with Oracle Data Base 3 years 1 month ago #63661

  • vlad
  • vlad's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Hello to all the community

First, congratulations on LimeSurvey

The situation I have is:

Am trying to install LimeSurvey on Oracle 11g database, but have not succeeded, someone can guide me on this, since I have not found much information on how to solve it.

best regards
The administrator has disabled public write access.

Re: About Installation with Oracle Data Base 3 years 1 month ago #63664

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2643
  • Thank you received: 313
  • Karma: 115
Well, I am not surprised that you were not sucessful. when I look at the requirements it seems like Oracle is not supported.

docs.limesurvey.org/Installation&structu...tions+for+LimeSurvey
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re: About Installation with Oracle Data Base 3 years 1 month ago #63671

  • vlad
  • vlad's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
hi holch thank's for you answer

I read this link where someone speak about how to install limeSurvey with Oracle DB support but not specify how to do that, then is totally imposible in this moment install LimeSurvey with Oracle DB support?

link:

ideas.limesurvey.org/ideatorrent/idea/210/

greetings
The administrator has disabled public write access.

Re: About Installation with Oracle Data Base 3 years 1 month ago #63672

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2643
  • Thank you received: 313
  • Karma: 115
Well, the link that you have sent is the idea generation tool, where users can ask for new features. So this is just a wish of someone.

In the comments NSS mentioned that Oracle DB is not compatible with the other supported databases. Seems like he has hacked limesurvey to work with Oracle, but has lost the possibility to use other databases. And, you probably will have to do the work for each update.

I'd rather use MySQL or any other supported database, but there might be a specific reason why you need Oracle.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re: About Installation with Oracle Data Base 3 years 1 month ago #63673

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2643
  • Thank you received: 313
  • Karma: 115
Maybe you get in touch with NSS, maybe he can send you the modified files...
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re: About Installation with Oracle Data Base 3 years 1 month ago #63674

  • vlad
  • vlad's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
well, the reason to want install LS with Oracle support is simple, my client wanna this posibility because Oracle is the unique database his use. Like a software usage policy

greetings
The administrator has disabled public write access.

Re: About Installation with Oracle Data Base 3 years 1 month ago #63675

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2643
  • Thank you received: 313
  • Karma: 115
I imagined that there is something behind this.

Try to talk to NSS and how he did it.

But don't just look into the effort of implementing it, but also how to maintain it. Because depending on the implementation it can cause quite a lot of work to keep up with the updates. And it is not a good idea to skip updates because of that (security issues).
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re: About Installation with Oracle Data Base 3 years 1 month ago #63676

  • vlad
  • vlad's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
Ok, I'll try contacted with NSS to receive any help.

thank you holch
I'll contact to you soon for anything about this topic
we keep online

greetings
The administrator has disabled public write access.

Aw: About Installation with Oracle Data Base 2 years 9 months ago #68383

  • Steve
  • Steve's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 494
  • Thank you received: 46
  • Karma: 17
Are there any news about the installation with an Oracle Data Base?

Is it possible to create a new auxiliary class/function(s) that creates the sql strings? I think the LimeSurvey project would benefit from such a class because you can use the same function(s) to create sql statements again and don't have to write "SELECT ..." in all necessary php-files again and again. Perhaps it would help customizing the sql strings for the communication with an Oracle database. The syntax seems to be one of the problems. For example I tried using "SELECT ... FROM tableXY as a" and it doesn't work because the correct statement for Oracle would be "SELECT ... FROM tableXY a" (without "as"). By using an auxiliary class these modifications can be done in this class and not in every php page. In the best/good case this methods can be used in new releases and support Oracle without changing every sql statement.
Mit freundlichen Grüßen/Best regards,

Stefan Gohlke
LimeSurvey Team
The administrator has disabled public write access.

Re: Aw: About Installation with Oracle Data Base 2 years 9 months ago #68391

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5324
  • Thank you received: 294
  • Karma: 249
Limesurvey 2.0 will use a PHP framework (probably "CodeIgniter"). Maybe this framework support Oracle (but I doubt so and still lots of queries would have to be rewritten).

Are there many Open Source projects supporting Oracle?

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.168 seconds
Donation Image