Rahul, Firstly, you have to choose a database.
mysql> use neutron; mysql> show tables; mysql> select * from networks; On Fri, Oct 16, 2015 at 3:29 PM, Rahul Arora <[email protected]> wrote: > Hi Nitish, > > When i am trying to see table "networks" in the DB.I am not able to use > "show tables" command to see tables.looks like it this version does not > suppor that. > > List of all MySQL commands: > Note that all text commands must be first on line and end with ';' > ? (\?) Synonym for `help'. > clear (\c) Clear the current input statement. > connect (\r) Reconnect to the server. Optional arguments are db and host. > delimiter (\d) Set statement delimiter. > edit (\e) Edit command with $EDITOR. > ego (\G) Send command to mysql server, display result vertically. > exit (\q) Exit mysql. Same as quit. > go (\g) Send command to mysql server. > help (\h) Display this help. > nopager (\n) Disable pager, print to stdout. > notee (\t) Don't write into outfile. > pager (\P) Set PAGER [to_pager]. Print the query results via PAGER. > print (\p) Print current command. > prompt (\R) Change your mysql prompt. > quit (\q) Quit mysql. > rehash (\#) Rebuild completion hash. > source (\.) Execute an SQL script file. Takes a file name as an > argument. > status (\s) Get status information from the server. > system (\!) Execute a system shell command. > tee (\T) Set outfile [to_outfile]. Append everything into given > outfile. > use (\u) Use another database. Takes database name as argument. > charset (\C) Switch to another charset. Might be needed for processing > binlog with multi-byte charsets. > warnings (\W) Show warnings after every statement. > nowarning (\w) Don't show warnings after every statement. > > For server side help, type 'help contents' > > mysql> > > > Can you please redirect me how i can see this? > > -- > > Regards > > Rahul Arora > > On Fri, Oct 16, 2015 at 3:52 PM, nithish B <[email protected]> > wrote: > >> Hi Rahul, >> Is the table "networks" available in the DB? Looks like it does not exist >> and thus when neutron queries the DB, it returns the error. >> Let me know. >> >> Thanks. >> Nitish B. >> >> Regards, >> Nitish B. >> >> On Fri, Oct 16, 2015 at 3:10 PM, Rahul Arora <[email protected]> >> wrote: >> >>> Hi Team. >>> >>> I am trying to run Openstack KILO release on my Ubuntu 14.04 x86 >>> machine.I am able to run all the services.i.e glance,nova.keystone,neutron >>> etc successfully. >>> >>> But when i am trying to launch VM using below command manually. >>> >>> *nova boot --image 8f6e2973-c048-4445-8c31-38e159c930fc --flavor m1.tiny >>> "rahul"* >>> >>> I am getting below error in *neutron-server *service. >>> ========================================= >>> >>> >>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource >>> self.errorhandler(self, exc, value) >>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource File >>> "/usr/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in >>> defaulterrorhandler >>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource raise >>> errorclass, errorvalue >>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource OperationalError: >>> (OperationalError) (1054, "Unknown column 'networks.mtu' in 'field list'") >>> 'SELECT networks.tenant_id AS networks_tenant_id, networks.id AS >>> networks_id, networks.name AS networks_name, networks.status AS >>> networks_status, networks.admin_state_up AS networks_admin_state_up, >>> networks.shared AS networks_shared, networks.mtu AS networks_mtu, >>> networks.vlan_transparent AS networks_vlan_transparent, >>> ipallocationpools_1.id AS ipallocationpools_1_id, >>> ipallocationpools_1.subnet_id AS ipallocationpools_1_subnet_id, >>> ipallocationpools_1.first_ip AS ipallocationpools_1_first_ip, >>> ipallocationpools_1.last_ip AS ipallocationpools_1_last_ip, >>> dnsnameservers_1.address AS dnsnameservers_1_address, >>> dnsnameservers_1.subnet_id AS dnsnameservers_1_subnet_id, >>> subnetroutes_1.destination AS subnetroutes_1_destination, >>> subnetroutes_1.nexthop AS subnetroutes_1_nexthop, subnetroutes_1.subnet_id >>> AS subnetroutes_1_subnet_id, subnets_1.tenant_id AS subnets_1_tenant_id, >>> subnets_1.id AS subnets_1_id, subnets_1.name AS subnets_1_name, >>> subnets_1.network_id AS subnets_1_network_id, subnets_1.subnetpool_id AS >>> subnets_1_subnetpool_id, subnets_1.ip_version AS subnets_1_ip_version, >>> subnets_1.cidr AS subnets_1_cidr, subnets_1.gateway_ip AS >>> subnets_1_gateway_ip, subnets_1.enable_dhcp AS subnets_1_enable_dhcp, >>> subnets_1.shared AS subnets_1_shared, subnets_1.ipv6_ra_mode AS >>> subnets_1_ipv6_ra_mode, subnets_1.ipv6_address_mode AS >>> subnets_1_ipv6_address_mode, externalnetworks_1.network_id AS >>> externalnetworks_1_network_id \nFROM networks LEFT OUTER JOIN >>> externalnetworks ON networks.id = externalnetworks.network_id LEFT >>> OUTER JOIN subnets AS subnets_1 ON networks.id = subnets_1.network_id >>> LEFT OUTER JOIN ipallocationpools AS ipallocationpools_1 ON subnets_1.id >>> = ipallocationpools_1.subnet_id LEFT OUTER JOIN dnsnameservers AS >>> dnsnameservers_1 ON subnets_1.id = dnsnameservers_1.subnet_id LEFT >>> OUTER JOIN subnetroutes AS subnetroutes_1 ON subnets_1.id = >>> subnetroutes_1.subnet_id LEFT OUTER JOIN externalnetworks AS >>> externalnetworks_1 ON networks.id = externalnetworks_1.network_id >>> \nWHERE networks.tenant_id IN (%s) AND networks.shared IN (%s)' >>> ('75ee0e2b66e04287920904eb40351f57', 0) >>> 2015-10-06 02:29:53.894 8064 TRACE neutron.api.v2.resource >>> >>> NOTE: I am using ml2 plugins to run the neutron-server service. >>> >>> Please help me solving this issue. >>> >>> Thanks for the help. >>> >>> >>> -- >>> >>> Regards >>> >>> >>> Rahul Arora >>> >>> _______________________________________________ >>> Mailing list: >>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack >>> Post to : [email protected] >>> Unsubscribe : >>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack >>> >>> >> > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: [email protected]?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > >
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: [email protected]?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
