Cannot build with maven

[ArthurMagnier]

Hello,

I have tried for some time to run the classroom-demo, quite unsuccessfully for now.

I am running a fresh install of Ubuntu 16.04 LTS, and I ran an "insecure" example without problem. So I tried with the classroom...

My problem appears at the maven build stage ("sudo mvn clean package exec:java), which is returning me an error about a denied access to mysql server.

Failed to execute goal org.codehaus.mojo:exec-maven-plugin:1.5.0:java (default-cli) on project classroom-demo: An exception occured while executing the Java class. null: InvocationTargetException: Failed to execute CommandLineRunner: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection: Access denied for user 'foo'@'localhost' (using password: YES)

If you have any idea of where my problem could be located, I would be relieved...

Thank you in advance,
Arthur

[pabloFuente]

That error shows up when the Spring app cannot connect to the MySQL database. As explained here, classroom-demo is an application with a database, and you need to have up and running mysql with the proper database created (all the necessary steps are explained in that link). The steps reproduced there should properly work on Ubuntu 16.04 (I have just tested them).

Cheers!

[ArthurMagnier]

I followed every step carefully...
"service mysql status" is telling me that the service is running without any problem.
Today i re tried from scratch, deleting files from the classroom-demo and reinstalling mysql, with the same error at the end. Can it be a permission problem with the group mysql or http?

Cheers,

[pabloFuente]

Here in the application.properties file are all the configuration parameters for connecting the app with the database. Be sure the user and password are the same in the file and in your MySQL service. You can also try different values for the first property spring.datasource.url, which should be jdbc:mysql://{HOST_MYSQL}:{PORT_MYSQL}/{DATABASE_NAME}. For example: jdbc:mysql://127.0.0.1:3306/openvidu_sample_app. Maybe your mysql is not runnig in the default port (3306), or it doesn't accept "localhost" as a valid host for some reason, or maybe the database name is misspelled. Try out different options in that property.

As for the permission problems... Not sure about that. MySQL installation process makes you establish a 'root' user and password, and those must then be the ones included in the application.properties file.
If in your specific setup there is a permission issue with mysql service, I'm afraid I cannot really help you. But the Internet is full of tutorials on how to connect a Spring app with JDBC to a properly configured MySQL database.

Cheers.

[ArthurMagnier]

Thank you, it did the trick!
My next step will be to be able to stream from another computer, I will hunt the configuration file... As right now I am always redirected to localhost!

Cheers,

[ArthurMagnier]

Hello,
So I searched for that magic line of code telling Openvidu where to serve the root server, and I didn't find it... My wss is still redirected to localhost, do you know what do I have to change to serve from a static server? It would be helpful for me!

Cheers,

[pabloFuente]

To set the URL that should be used in the browser to connect to OpenVidu Server you just need to use property openvidu.publicurl when launching your OpenVidu Server. That is the URL that will be passed to clients.

In this table you got more information about all the properties that can be customized in your OpenVidu Server.

Regards.

[AlexPrietoBlanco]

Hello,

I am trying to finish the OpenVidu-classroom demo and I have the same problem in the 7th step. I changed my password in the application.properties file but every time I use this command: mvn clean package exec:java the password is reset to "pass".

Any idea about what could I do?

Thank you in advance.
Alex.