Open Stack

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 <rahul1991.arora at gmail.com>
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 <bestofnithish at gmail.com>
> 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 <rahul1991.arora at gmail.com>
>> 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     : openstack at lists.openstack.org
>>> Unsubscribe :
>>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>>>
>>>
>>
>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20151016/4caa8b27/attachment.html>