openstack devstack的pike版本错误:No sql_connection parameter is established 解决办法

在Ubuntu16.04中搭建Devstack(Train版本) 在Ubuntu16.04中搭建Devstack(Train版本)环境搭建搭建过程相关问题创建实例相关问题其他问题 环境搭建 参考: Pike版环境搭建 官方版环境搭建 本人为Openstack萌新,谨以此文作为学习记录,方便以后查看,同时希望文中的解决方法可以帮到你。 反反复复,平台搭了好多次。最开始在VMware虚拟机中进行搭建,由于可以创建快照,遇到错误就退回,虽然方便,但并不是学习的好方... 阅读详情

在 ubuntu16.04.3系统 openstack  devstack的pike版本,一个主控节点,一个计算节点,安装顺利完成,但创建虚拟机时出错,提示错误为:No sql_connection parameter is established 

File "/opt/stack/nova/nova/conductor/manager.py", line 551, in build_instances context, spec_obj, instance_uuids)

File "/opt/stack/nova/nova/conductor/manager.py", line 622, in _schedule_instances scheduler_utils.setup_instance_group(context, request_spec)

File "/opt/stack/nova/nova/scheduler/utils.py", line 443, in setup_instance_group group_info = _get_group_details(context, instance_uuid, group_hosts)

File "/opt/stack/nova/nova/scheduler/utils.py", line 400, in _get_group_details instance_uuid)

File "/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184, in wrapper result = fn(cls, context, *args, **kwargs)

File "/opt/stack/nova/nova/objects/instance_group.py", line 331, in get_by_instance_uuid db_group = cls._get_from_db_by_instance(context, instance_uuid)

File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 978, in wrapper with self._transaction_scope(context): File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__ return self.gen.next()

File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1028, in _transaction_scope context=context) as resource: File "/usr/lib64/python2.7/contextlib.py", line 17, in __enter__ return self.gen.next()

File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 633, in _session bind=self.connection, mode=self.mode)

File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 398, in _create_session self._start() File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 484, in _start engine_args, maker_args)

File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 506, in _setup_for_connection "No sql_connection parameter is established")

应该是数据库连接字符串问题,按网上的方法,检查 /etc/nova/nova.conf

[database]

connection = mysql+pymysql://root:secret@127.0.0.1/nova_cell0?charset=utf8

[api_database]

connection = mysql+pymysql://root:secret@127.0.0.1/nova_api?charset=utf8

正常可用,数据库也正常可访问,

有的说在计算节点的 /etc/nova/nova.conf也要提供连接字符串,但pike版本的已不使用计算节点直接操作数据库的方法,是通过消息机制提交控制节点操作数据库。

折磨几天,最后定位到是须在 /etc/nova/nova_cell1.conf中需提供api_database 连接字符串

 

[api_database]

connection = mysql+pymysql://root:secret@127.0.0.1/nova_api?charset=utf8

问题解决,可以正常创建虚拟机。

另外,在计算节点down机,web界面设置计算节点关闭服务,并没有清楚掉计算节点,创建虚拟机时会出现超时错误,看来控制节点仍然在询问计算节点。

 

 

 

嵌入式定点PID控制器:mrm-pid极简实现与实时控制实践 PID控制器是自动控制领域的基础算法,其核心在于比例、积分、微分三环节的协同调节。在资源受限的嵌入式系统中,传统浮点PID易受时序抖动、内存分配不确定性及FPU依赖影响,难以满足毫秒级确定性响应需求。定点PID通过整数运算替代浮点计算,显著提升执行周期稳定性与跨平台兼容性,成为电机控制、传感器补偿等实时场景的关键技术路径。mrm-pid库以位置式结构、int32_t增益参数、int64_t积分累加器和无动态内存设计,实现了超低开销(12–28 CPU周期)与完全可审计的闭环内核,天然适配Cortex-M系列 阅读详情

相关推荐

51单片机也能玩转信号发生器?手把手教你用DAC0832和LM358输出四种标准波形

本文详细介绍了如何使用51单片机和DAC0832芯片搭配LM358运放,自制低成本信号发生器,实现正弦波、矩形波、三角波和锯齿波四种标准波形的输出。从硬件选型、电路设计到编程实现,手把手教你完成这一实用电子项目,总成本不到50元,适合电子爱好者和学生实践。

weixin_30530939的博客 551

No sql_connection parameter is established

No sql_connection parameter is established

u013614281的专栏 5818

AJ-Report开源数据大屏存在远程命令执行漏洞

该平台可以通过post方式在validationRules参数对应值中进行命令执行,可以获得服务器权限,登陆管理后台接管大屏。如果被攻击者利用,危害后果十分严重。

swordheart的博客 387

Openstack部署 queens版本问题总结

Openstack部署 queens版本问题总结 参考官网:https://docs.openstack.org/install-guide/openstack-services.html https://blog.youkuaiyun.com/networken/article/details/80682437 安装openstack yum源 yum install centos-release-openstack-queens 为了能使用yum方式快速安装openstack 各组件 也可以自己配置repo 利

青山绿水 1039

Android开发者必看:5分钟搞定MQTT客户端连接EMQX服务器(附完整代码)

本文为Android开发者提供了一份快速实现MQTT客户端连接EMQX服务器的实战指南。通过引入Eclipse Paho SDK,详细讲解了从项目配置、权限申请到核心连接、主题订阅与消息发布的完整流程,并附有即拿即用的Kotlin代码,帮助开发者在物联网应用中高效集成轻量级实时通信功能。

weixin_29228781的博客 271

安卓手机必备:Auto.js快手极速版自动刷视频避坑指南(含最新3.0脚本)

本文是一份安卓自动化工具Auto.js的全面实践指南,重点解析了如何搭建稳定运行环境、配置关键权限以及管理脚本。针对快手极速版等应用的自动化需求,文章详细介绍了设备选择、Auto.js版本对比、各品牌手机后台保活设置,并强调了脚本安全与调试技巧,帮助用户有效避坑,实现自动化任务的稳定执行。

i7j8k9l的博客 782

neutron启动失败报错:ERROR neutron CantStartEngineError: No sql_connection parameter is established

neutron启动失败报错:ERROR neutron CantStartEngineError: No sql_connection parameter is established。

代码讲故事 1185

高通平台N4单路输入的720P相机预览

N4的一路720P Camera作为MIPI摄像头使用

llw21680的专栏 165

neutron启动失败报错:ERROR neutron CantStartEngineError: No sql_connection parameter is established...

neutron启动失败报错:ERROR neutron CantStartEngineError: No sql_connection parameter is established。登录后复制 [root@nova neutron]# systemctl status neutron-server.service ●...

weixin_37053933的博客 1136

(14-3)值分布式算法:QR-DQN (Quantile Regression DQN)算法

QR-DQN(Quantile Regression DQN)是一种强化学习算法,它是深度 Q-网络(Deep Q-Network,DQN)的一个变种,旨在更好地处理值函数的不确定性。QR-DQN的实现步骤与传统的DQN类似,但在目标分布计算和损失函数方面有一些不同之处,这使得它能够更好地处理值函数的不确定性。QR-DQN(Quantile Regression DQN)算法的核心思想是将值函数表示为一个分布,而不是传统的单一值估计。在下面的内容中,将讲解一个使用QR-DQN算法的例子。

码农三叔 2052

lwip-2.0.3

lwip是瑞典计算机科学院(SICS)的Adam Dunkels 开发的一个小型开源的TCP/IP协议栈。实现的重点是在保持TCP协议主要功能的基础上减少对RAM 的占用。

openstack 安装stein版本的体验(测试)

keystone概念 分享一篇csdn上已经总结的文章:https://blog.youkuaiyun.com/dylloveyou/article/details/80329732 openstack版本更新 每六个月更新一次大版本(一年2个版本) YUM仓库:我系统为centos7.6,支持4个版本(只能选择其一,或者第三方源安装其他版本) 安装操作需要参考openstack官网文档,版本之前有...

杨仕虎的博客 526

深度学习工具包 DeepLearningToolbox

深度学习工具包Deprecation notice.-----This toolbox is outdated and no longer maintained.There are much better tools available for deep learning than this toolbox, e.g. [Theano](http://deeplearning.net/software/theano/), [torch](http://torch.ch/) or [tensorflow](http://www.tensorflow.org/)I would suggest you use one of the tools mentioned above rather than use this toolbox.Best, Rasmus.DeepLearnToolbox================A Matlab toolbox for Deep Learning.Deep Learning is a new subfield of machine learning that focuses on learning deep hierarchical models of data.It is inspired by the human brain's apparent deep (layered, hierarchical) architecture.A good overview of the theory of Deep Learning theory is[Learning Deep Architectures for AI](http://www.iro.umontreal.ca/~bengioy/papers/ftml_book.pdf)For a more informal introduction, see the following videos by Geoffrey Hinton and Andrew Ng.* [The Next Generation of Neural Networks](http://www.youtube.com/watch?v=AyzOUbkUf3M) (Hinton, 2007)* [Recent Developments in Deep Learning](http://www.youtube.com/watch?v=VdIURAu1-aU) (Hinton, 2010)* [Unsupervised Feature Learning and Deep Learning](http://www.youtube.com/watch?v=ZmNOAtZIgIk) (Ng, 2011)If you use this toolbox in your research please cite [Prediction as a candidate for learning deep hierarchical models of data](http://www2.imm.dtu.dk/pubdb/views/publication_details.php?id=6284)```@MASTERSTHESIS\{IMM2012-06284, author = "R. B. Palm", title = "Prediction as a candidate for learning deep hierarchical models of data", year = "2012",}```Contact: rasmusbergpalm at gmail dot comDirectories included in the toolbox-----------------------------------`NN/` - A library for Feedforward Backpropagation Neural Networks`CNN/` - A library for Convolutional Neural Networks`DBN/` - A library for Deep Belief Networks`SAE/` - A library for Stacked Auto-Encoders`CAE/` - A library for Convolutional Auto-Encoders`util/` - Utility functions used by the libraries`data/` - Data used by the examples`tests/` - unit tests to verify toolbox is workingFor references on each library check REFS.mdSetup-----1. Download.2. addpath(genpath('DeepLearnToolbox'));Example: Deep Belief Network---------------------```matlabfunction test_example_DBNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit RBM and visualize its weightsrand('state',0)dbn.sizes = [100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);figure; visualize(dbn.rbm{1}.W'); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand('state',0)%train dbndbn.sizes = [100 100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);%unfold dbn to nnnn = dbnunfoldtonn(dbn, 10);nn.activation_function = 'sigm';%train nnopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.10, 'Too big error');```Example: Stacked Auto-Encoders---------------------```matlabfunction test_example_SAEload mnist_uint8;train_x = double(train_x)/255;test_x = double(test_x)/255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit SDAE and use it to initialize a FFNN% Setup and train a stacked denoising autoencoder (SDAE)rand('state',0)sae = saesetup([784 100]);sae.ae{1}.activation_function = 'sigm';sae.ae{1}.learningRate = 1;sae.ae{1}.inputZeroMaskedFraction = 0.5;opts.numepochs = 1;opts.batchsize = 100;sae = saetrain(sae, train_x, opts);visualize(sae.ae{1}.W{1}(:,2:end)')% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = 'sigm';nn.learningRate = 1;nn.W{1} = sae.ae{1}.W{1};% Train the FFNNopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.16, 'Too big error');```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x',28,28,60000))/255;test_x = double(reshape(test_x',28,28,10000))/255;train_y = double(train_y');test_y = double(test_y');%% ex1 Train a 6c-2s-12c-2s Convolutional neural network %will run 1 epoch in about 200 second and get around 11% error. %With 100 epochs you'll get around 1.2% errorrand('state',0)cnn.layers = { struct('type', 'i') %input layer struct('type', 'c', 'outputmaps', 6, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %sub sampling layer struct('type', 'c', 'outputmaps', 12, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %subsampling layer};cnn = cnnsetup(cnn, train_x, train_y);opts.alpha = 1;opts.batchsize = 50;opts.numepochs = 1;cnn = cnntrain(cnn, train_x, train_y, opts);[er, bad] = cnntest(cnn, test_x, test_y);%plot mean squared errorfigure; plot(cnn.rL);assert(er<0.12, 'Too big error');```Example: Neural Networks---------------------```matlabfunction test_example_NNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);% normalize[train_x, mu, sigma] = zscore(train_x);test_x = normalize(test_x, mu, sigma);%% ex1 vanilla neural netrand('state',0)nn = nnsetup([784 100 10]);opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samples[nn, L] = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.08, 'Too big error');%% ex2 neural net with L2 weight decayrand('state',0)nn = nnsetup([784 100 10]);nn.weightPenaltyL2 = 1e-4; % L2 weight decayopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex3 neural net with dropoutrand('state',0)nn = nnsetup([784 100 10]);nn.dropoutFraction = 0.5; % Dropout fraction opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex4 neural net with sigmoid activation functionrand('state',0)nn = nnsetup([784 100 10]);nn.activation_function = 'sigm'; % Sigmoid activation functionnn.learningRate = 1; % Sigm require a lower learning rateopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex5 plotting functionalityrand('state',0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = 'softmax'; % use softmax outputopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex6 neural net with sigmoid activation and plotting of validation and training error% split training data into training and validation datavx = train_x(1:10000,:);tx = train_x(10001:end,:);vy = train_y(1:10000,:);ty = train_y(10001:end,:);rand('state',0)nn = nnsetup([784 20 10]); nn.output = 'softmax'; % use softmax outputopts.numepochs = 5; % Number of full sweeps through dataopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, tx, ty, opts, vx, vy); % nntrain takes validation set as last two arguments (optionally)[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

glance创建数据数据表报错/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py:1336: OsloDBDepre

查看配置文件看看有没有错误,检查后未发现错误 [root@controller ~]# vim /etc/glance/glance-api.conf [database] connection = mysql+pymysql://glance:000000@controller/glance [root@controller ~]# vim /etc/glance/glance-registry.conf [database] connection = mysql+pymysql://glance:

qq_52122458的博客 3764

最新的sdio 4.0 spec 协议标准 带书签 高清完整PDF版

Part-E1-SDIO-Specification-Ver4.00-Final-120220.pdf:最新的sdio 4.0 spec 协议标准 带书签 高清完整PDF版,包括SDIO 接口的外设,SDIO 接口官方协议等。

假人有限元模型

假人模型,车辆碰撞假人有限元模型,适合做乘员安全的研究者利用

Openstack Q版安装(all in one )

openstack Q版 all in one 手动安装 基础信息 准备 RabbitMQ集群 Memcached集群 Keystone Glance集群 Nova控制节点集群 Nova计算服务 Horizon集群 部署使用openstack是因为之前kvm虚拟机起的比较多和管理成本,以及对未来考量.这里记录一下openstack的部署安装过程 基础信息 Mysql数据库 ip: 192.168.1.1 User:user Pwd:Passwd Openstack集群可用

lijianhua的博客 653

openstack同步数据库报错!!

openstack同步数据库操作su -s /bin/sh -c "keystone-manage db_sync" keystone

qq_47902942的博客 1159

Glance安装过程出现的问题及解决方法

安装环境: 操作系统:CentOS Linux release 7.7.1908 (Core) openstack版本:openstack 3.14.3Queens版 中间件:apache+mariadb+rabbitmq+memcache 安装文档:https://docs.openstack.org/install-guide/ 问题1.yum失败 现象: # yum ...

运维狗的备忘录 8178

MySQL报错no connection established

今天登数据库突然发现无法连接数据库了,很奇怪导致项目跑不起来,查阅得知是因为没有开启MySQL本地服务。

TYJ1017的博客 4079

安装openstack时碰到的错误

目录 安装keystone identity时遇到的错误信息 glance验证操作错误信息 计算节点安装openstack-nova-compute找不到包 openstack-nova-compute安装后服务起不来 openstack-nova-compute安装后验证没有输出 dashboard安装后打不开 OpenStack云平台涉及到的相关服务进程的日志记录的默认存放地址 总结

gsl371的专栏 2万+

openstack-M版,学习笔记四

笔记为根据老男孩视频+官方文档学习,并记录,如有错漏,心情好的可以指出一下。 视频地址:https://www.bilibili.com/video/BV1LJ411Y7og?p=12 镜像服务(glance) 镜像服务 (glance) 允许用户发现、注册和获取虚拟机镜像。它提供了一个 REST API,允许您查询虚拟机镜像的 metadata 并获取一个现存的镜像。您可以将虚拟机镜像存储到各种位置,从简单的文件系统到对象存储系统—-例如 OpenStack 对象存储, 并通过镜像服务使用。 .

nova12315的博客 2144

python库sqlalchemy使用教程

SQLAlchemy是一个功能强大的Python ORM工具包。提供全功能的SQL和ORM操作,不再需要编写 SQL 语句,使得操作数据库表就像在操作对象。

专注于Python编程技术的分享与交流,致力于帮助开发者提升编程技能,解决实际问题,探索Python的无限可能。 5814

数据库突然不能运行了,出现 no connection established这么办!

一般出现这种情况都是因为数据库服务突然停止了,只需要在cmd命令提示框中输入services.msc后回车,打开后台应用列表找到mysql80点右键启动即可。

L520134_051029的博客 3427

OpenStack部署(三)

Image Service 图像服务glance 一、先决条件 在安装和配置映像服务之前,必须创建数据库、服务凭据和API端点。 1.创建数据库root访问数据库 [root@localhost /]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. 创建glance数据库 MariaDB [(none)]> CREATE DATABASE glance; Query OK, 1 row affected (0.0

weixin_44099173的博客 807

mysql进阶(二十五)解决数据库NO CONNECTION问题

解决数据库NO CONNECTION问题前言 数据库版本类型:Mysql5.5 在应用程序连接数据库时,提示数据库连接失败。打开数据库查看,显示如下。 究其原因,是因为mysql服务出现了问题,重启mysql服务,数据库成功连接。参考文献 1.http://jingyan.baidu.com/album/0a52e3f4158211bf62ed72e6.ht

IT全栈 华强工作室 5万+
上一篇: 学习笔记:openstack 实验环境安装
下一篇: openstack 填坑笔记1:pike版本,外网连接配置
领尚
博客等级 码龄14年 1143粉丝 271原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值