← Back to team overview

openstack team mailing list archive

Re: IMPORTANT: Grizzly compute node error with nova sqlalchemy

 

Hi,

You don't have permissions on your MySQL server for those clients to connect
to.

You can validate that by doing:
$ telnet 192.168.22.42 3306

You need to grant privileges for all OpenStack service users:
> grant all on nova.* for 'nova'@'%' identified by 'nova_password';
> flush privileges

Cheers,
nm

From:  <raghavendra.lad@xxxxxxxxxxxxx>
Date:  Friday, July 26, 2013 11:17 AM
To:  <veeraready@xxxxxxxxx>, <openstack@xxxxxxxxxxxxxxxxxxx>
Subject:  Re: [Openstack] IMPORTANT: Grizzly compute node error with nova
sqlalchemy

HI Veera Reddy,
 
Now I have turned on Compute, Controller and Network and get the below error
with compute
 
 
 
My nova.conf
 
[DEFAULT]
logdir=/var/log/nova
state_path=/var/lib/nova
lock_path=/run/lock/nova
verbose=True
api_paste_config=/etc/nova/api-paste.ini
compute_scheduler_driver=nova.scheduler.simple.SimpleScheduler
rabbit_host=192.168.22.42
nova_url=http://192.168.22.42:8774/v1.1/
sql_connection=mysql://novaUser:novaPass@192.168.22.42/nova
root_helper=sudo nova-rootwrap /etc/nova/rootwrap.conf
 
# Auth
use_deprecated_auth=false
auth_strategy=keystone
 
# Imaging service
glance_api_servers=192.168.22.42:9292
image_service=nova.image.glance.GlanceImageService
 
# Vnc configuration
novnc_enabled=true
novncproxy_base_url=http://10.1.168.42:6080/vnc_auto.html
novncproxy_port=6080
vncserver_proxyclient_address=192.168.22.44
vncserver_listen=0.0.0.0
 
# Network settings
network_api_class=nova.network.quantumv2.api.API
quantum_url=http://192.168.22.42:9696
quantum_auth_strategy=keystone
quantum_admin_tenant_name=service
quantum_admin_username=quantum
quantum_admin_password=service_pass
quantum_admin_auth_url=http://192.168.22.42:35357/v2.0
libvirt_vif_driver=nova.virt.libvirt.vif.LibvirtHybridOVSBridgeDriver
linuxnet_interface_driver=nova.network.linux_net.LinuxOVSInterfaceDriver
#If you want Quantum + Nova Security groups
firewall_driver=nova.virt.firewall.NoopFirewallDriver
security_group_api=quantum
#If you want Nova Security groups only, comment the two lines above and
uncomment line -1-.
#-1-firewall_driver=nova.virt.libvirt.firewall.IptablesFirewallDriver
 
#Metadata
service_quantum_metadata_proxy = True
quantum_metadata_proxy_shared_secret = helloOpenStack
metadata_host = 192.168.22.42
metadata_listen = 127.0.0.1
metadata_listen_port = 8775
 
# Compute #
compute_driver=libvirt.LibvirtDriver
 
# Cinder #
volume_api_class=nova.volume.cinder.API
osapi_volume_listen_port=5900
 
Regards
Raghavendra Lad
 

From: Veera Reddy [mailto:veeraready@xxxxxxxxx]
Sent: Friday, July 26, 2013 1:38 PM
To: Lad, Raghavendra
Subject: Re: [Openstack] IMPORTANT: Grizzly compute node error with nova
sqlalchemy
 

Hi ,

 

One reason may be Openstack Controller may be not reachable from Compute
node

(or)

Grant privileges to nova database.

GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' IDENTIFIED BY 'password';

 

-- 
Regards,
Veera

 

 

 

On Fri, Jul 26, 2013 at 1:30 PM, <raghavendra.lad@xxxxxxxxxxxxx> wrote:

 

 

Hi Team,

 

I get a error in Compute node when I run the

 

nova-manage service list

Error message

warning nova.openstack.common.db.sqlalchemy.session

 

I am trying the Grizzly

 

 

https://github.com/mseknibilel/OpenStack-Grizzly-Install-Guide/blob/OVS_Mult
iNode/OpenStack_Grizzly_Install_Guide.rst
<https://github.com/mseknibilel/OpenStack-Grizzly-Install-Guide/blob/OVS_Mul
tiNode/OpenStack_Grizzly_Install_Guide.rst>

 

 

 

 
 
 
 
 
 
 
 

Regards,

Raghavendra Lad

 
 


This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise confidential information. If you have
received it in error, please notify the sender immediately and delete the
original. Any other use of the e-mail by you is prohibited.

Where allowed by local law, electronic communications with Accenture and its
affiliates, including e-mail and instant messaging (including content), may
be scanned by our systems for the purposes of information security and
assessment of internal compliance with Accenture policy.

____________________________________________________________________________
__________

www.accenture.com <http://www.accenture.com>

_______________________________________________
Mailing list: https://launchpad.net/~openstack
Post to     : openstack@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openstack
More help   : https://help.launchpad.net/ListHelp


 
 
_______________________________________________ Mailing list:
https://launchpad.net/~openstack Post to     : openstack@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openstack More help   :
https://help.launchpad.net/ListHelp

PNG image


References