GSN configuration error

[AndreaLCN]

Hi all,

I'm trying to build GSN project but something get wrong.
I do not Know if I'm making some mistake building it. The procedure that produce the errors is:

I use SBT. First step a build it with sbt command. (obviously in the correct directory - gsn directory).
Second step, I type project webui and then StartDjango.
Third step I typeproject core and then re-start. Here the first error. Attached file: project_core_error.

Forth step. I type project servicer and then run. Here an other error. attached files --> project_services_error_1, project_services_error_2, project_services_error_3.


.

Last step i try localhost:9000, and here a configuration error, maybe due to the others error. Attached file: configuration_error.

I would like to know if these errors are due to a wrong procedure that i'm doing to build the project or to something else.
Can somebody help me to fix them?

thanks,
Andrea.

[ebiiii]

Hi Andrea,

The first error, which could be actually a warning, is just because some configuration files are missing in the gsn-core project, and it is using the default parameters, which are just fine.

The second error is because of this configuration line: https://github.com/LSIR/gsn/blob/master/gsn-services/conf/application.conf#L15 . It is meant for when the application is packaged and installed, but for running it from the sources, you will have to change it to point to the gsn-core folder.

I'll keep this issue open to remind me to change that next time I have some time to update it. :)

[AndreaLCN]

Hi Julien,

I did what you suggested but it doesn't work! I mean, I hope that I have correctly understood what you mean. So I change in tha applicantion.conf file the line:
gsn.location="/usr/share/gsn-core/" with --> gsn.location="/home/ubuntu/Desktop/gsn-master/gsn-core/"
Is it correct?

[ebiiii]

oh, my bad. The "conf" folder is at the root in the repository. the path should be then: gsn.location="/home/ubuntu/Desktop/gsn-master/"

[AndreaLCN]

Well, you was right. Tha correct path was the last you wrote, but now an other problem occurs. I'm so sorry.

Have you ever seen an error like that? How can I fix it? I saw that an error like that was just post in an other issues tab but without any answer. I'd really appreciate if you can still help me.

[ebiiii]

This looks like an error of the gsn-services. The default database is an H2 file in /tmp/GsnAuthDb. It should be initialized and all tables created with the evolution scripts. Maybe deleting this file and restarting the services could work ?

[AndreaLCN]

Yes, it looks like an error due to that file, but if I delete it the problem is not fixed!
Have a look! it's a kind of problem due to play and to this database. And there is still this internal server error.

[ebiiii]

I remember I already had this issue. The evolution scripts in gsn-services/conf/evolutions/default/
were automatically re-generated according to the database driver that was selected in the application.conf . But at some point they stopped being updated and the current version looks like the postgresql one. According to https://stackoverflow.com/questions/9964266/how-to-enable-ddl-generation-in-playframework-2-0 this is when I added the second file there. A quick hack could be to remove the 2.sql file, run the service, and add it back and restart the service. Let me know if it works...

[AndreaLCN]

I tried but it does not work! But I was reading the error, is it a syntax error in SQL statement, right?

[ebiiii]

Yes, the syntax is slightly different between the DB systems. In this case, you can also manually edit the file 1.sql to fix it. (I remember postgres had issue with names longer than 31 char, but I don't remember the issue with H2). Actually the file you have now in gsn-services/conf/evolutions/default/ is different from the one here https://github.com/LSIR/gsn/blob/master/gsn-services/conf/evolutions/default/1.sql
If you can figure out what is wrong, I'd be happy to update the repository or add it in the documentation ;-)

[AndreaLCN]

Ok, I checked my 1.sql file and it is different from which one you linked. I tried to modify it but when I re-run the program the file 1.sql return the same as before it was modified. How can I effectively modify it? Do you want that I point you out the differences?

[ebiiii]

I think if you remove the comments at the beginning of the file it would stop rewriting it. To be tested

[AndreaLCN]

ok, I tried to fix these errors, I mean those in 1.sql file. Now it gives me an error in the 2.sql file. It is an error due to security_role. Maybe because security_role has 2 arguments instead of 3!?
Have a look

[ebiiii]

well the security_role table should be correct with 2 columns: https://github.com/LSIR/gsn/blob/master/gsn-services/conf/evolutions/default/1.sql#L75. I'm not really sure that the 1.sql really created everything then.

[AndreaLCN]

Ok, it should be correct. But the error now is that this security_role is not found! How is it possible? Does it depend on the 1.sql file? Saluti, A.Serra 2017-08-11 15:50 GMT+02:00 Julien Eberle <notifications@github.com>:

…

well the security_role table should be correct with 2 columns: https://github.com/LSIR/gsn/blob/master/gsn-services/conf/ evolutions/default/1.sql#L75. I'm not really sure that the 1.sql really created everything then. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#83 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AcBagP8xsqBS1phamWphFSY6nBfS77g5ks5sXFw2gaJpZM4Omnyp> .

[AndreaLCN]

Have a look.