Open Stack

Hi Elena,

I am using these commands only.Please see below .

root at t1040rdb:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.39-MariaDB Source distribution

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]> use neutron;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [neutron]> show tables
    ->

show tables command is not giving any output.

..

Regards

Rahul Arora

On Fri, Oct 16, 2015 at 6:25 PM, Elena Ezhova <eezhova at mirantis.com> wrote:

> 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
>>
>>
>
> __________________________________________________________________________
> 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/75ec0c5c/attachment.html>