Hi Elena, I am using these commands only.Please see below .
root@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 <eezh...@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.ar...@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 <bestofnith...@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.ar...@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 : openst...@lists.openstack.org >>>> Unsubscribe : >>>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack >>>> >>>> >>> >> >> __________________________________________________________________________ >> OpenStack Development Mailing List (not for usage questions) >> Unsubscribe: >> openstack-dev-requ...@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-requ...@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-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev