Hi Ralf,

Did you get any error while installing CPBM? Or installation went fine but getting errors when you are starting CPBM for the first time?
Also, can you please let us know what errors you are getting?

Thanks,
Manish

Hi Manish,

Installation seems to run fine with no errors. (Both CP 1.3.4.1 & 1.3.5.1)
However I have not been able to display the logon page of the web portal. Just a blank broweser page.

I have been trying to install onto CentOS 6.2 and am now in the process of building a CentOS 5.8 instance.

Have been following the installation instructions from the Citrix edocs website.

Are you able to login to CP even without a CS environment or does the CS need to be up and running?

The catalina log files displayed errors in relation to access permissions into cloud@mynamespace.local,
During DB installation I just used "cloud" as username and password.

Ralf

Hi Ralph,
Are you able to login to CP even without a CS environment or does the CS need to be up and running?
Yes. We can login to CP even if you dont have CS but it is practically not useful. You will not see resource stats on dashboard and will not be able to navigate to many tabs.

The catalina log files displayed errors in relation to access permissions into cloud@mynamespace.local,
During DB installation I just used "cloud" as username and password.
This looks like the problem. Are you able to login to CP database from the CP server ? And did you install MySQL server using the install.sh packaged with CP rpm?

Thanks,
Manish

Hi Manish,

I have installed CP 1.3.4.1 in both CentOS 5.8 & 6.2 following the install guidelines in the edocs.
MySQL is installed through the install.sh package and on the server all looks fine and installs fine

However when I try browsing to the URL http://<IP Address CP Server>:8080/portal

I get nothing...no login page whatsoever.
This happens even without configuring CS in the cloud.properties file.
no web page at all...

So I have got a feeling am doing something wrong or missing a step.
Since this is happening over and over again...as I have installed CP at least a dozen times now
CS no probs all working fine and CS portal up just fine.

Its the CP I have trouble with.

Any help appreciated...

Cheers,
Ralf

HI Ralf,

We recently noticed a similar problem with another user who was trying to install. Could you please try using the same username and password for both CS and CP databases when you do your installation of CloudPortal?

Fatima

Hi Fatima,

I have been using the defaults.
For CP cloud/cloud.
The installation of CS doesn't asks me to provide user details, but If I'm correct this defaults to cloud/cloud ???.

However also without CS configured the login page for CP doesn't even show, this is without logging in to anything.

Cheers,
Ralf

Hi Ralph,

It looks like the issue is with permissions to access MySQL db for user cloud@mynamespace.local.
Can you please run below queries on mysql DB to add permissions for user cloud.

create user cloud identified by '<password>'; (+if user cloud is not already created+)
grant all on cloud_portal.* to cloud;
grant all on cloud_reports.* to cloud;
grant all on cloud_portalmq.* to cloud;

*Note: I am assuming that you have the cloud_portal, cloud_reports and cloud_portalmq schemas already created.

Once you run above statements restart the portal server.
If this does not resolve your issue then please provide the complete stack trace of the error from catalina.out.

Thanks,
Manish

Hi Manesh,

I run the SQL queries but to no avail :-(

Even tried dropping and recreating the user...

Just not getting any CloudPortal logon page to display.

attached the catalina.out

Cheers,
Ralf

Hi Ralf,

I looked into the catalina.out file and below are my findings:
1. On 8 June when you started CloudPortal application , you got connected to CP database and populated all the schema and base data.
2. But, CloudPortal application is not able to connect to CS database. It was throwing exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure, Caused by: java.net.NoRouteToHostException: No route to host
(At this point, CP database credentials are correct but may be the CS database host is not correct)
3. Then, you changed the CS database credentials and restarted CloudPortal application.
4. CP application got connected to CP database, but again failed to connect to CS database with exception: java.sql.SQLException: Access denied for user 'cloud'@'cpbm.tdm.local' (using password: YES)
(At this point CP database credentials are correct, and CS database host is fine but username and password are incorrect.)
5. On 17 June, you started the CP application server again and got same exception as in step 4. i.e java.sql.SQLException: Access denied for user 'cloud'@'cpbm.tdm.local' (using password: YES)
6. Then, again you changed the CP database credentians and restarted the CP application server.
7. This time you got different error: java.sql.SQLException: Access denied for user 'cloud@localhost'@'192.168.10.13' (using password: YES)
8. Final observation is , CloudPortal application is NOT able to connect to MQ database.

So, my suggestion are as follows:
a. Revert the CP database credentials to what you had on 8 June. This will ensure that you have correct CloudPortal database credentials.
b. Keep the CS host same as you had when you got access denied exception. This will ensure that CS host is correct.
Grant all permissions to user cloud on CS database. Now try to connect to CS database from instance where CloudPortal application is running. This will verify that CS database credentials are correct.

c. And, add CP database credentials for MQ database also, you can update these values in cloud.properties file:
# JDBC URL for the MQ database
vmops.mq.jdbc.url=jdbc:mysql://<CP database host>/cloud_portalmq?relaxAutoCommit=true
vmops.mq.jdbc.username=<CP database user>
vmops.mq.jdbc.password=<CP database user's password>

Please let me know if you need more information.

Thanks,
Manish

Edited by: Manish Agarwal on Jun 18, 2012 10:20 AM

Hi Manesh,

Did as you suggested, but still think I have a DB permission issue.

Attached a fresh catalina.out and the cloud.properties file.

My setup is
csman.tdm.local (192.168.10.15) CloudStack
cpbm.tdm.local (192.168.10.13) CloudPortal

I am starting to think that the CP user cloud@cpbm.tdm.local is trying to access the cloud DB on the CS server and is being denied..

Help...

Thanks,
Ralf

Ralf,

This has been called out as a known issue in our latest release documentation. As I mentioned in my earlier post, you could try to get this to work if the two databases have the same credentials.

As part of the cloudStack install process, you would have provided a db username, password. Please provide the same credentials in CloudPortal.

Thanks,
Fatima

Hi Fatima,

The CloudStack install didn't ask for DB User and password credentials oppose to the CloudPortal Installation.

I used the following command:

cloud-setup-databases cloud --deploy-as=root

Reading through the CS Install documentation it states :
"the following command, it is assumed the root user is deploying the database and creating the cloud user."

Now I assume the CS install wizard is creating a user cloud with password cloud.
This is the same as i enter manually during the CP installation.
However the catalina.out log file in CP states a FATAL error based on permission errors for cloud@cpbm.tdm.local

hence my suspicion around DB permission issues...

I am not doing anything out of the ordinary, just trying to install CS & CP following the available documentation.

Any help appreciated.

Cheers,
Ralf

You would have to provide a db password for cloudStack as well. If not, the user would be set up wit no password. I believe you can use the below command:

cloud-setup-databases cloud:<dbpassword>@localhost --deploy-as=root:<password>

If you have already provided CP DB credentials un:cloud and pw:cloud, please run the above and provide cloud in place of dbpassword.

Edited by: fatimag on Jun 18, 2012 8:56 PM