Next Page: 10000

          

Las mejores ofertas en cursos del Black Friday 2019

 Cache   

Las mejores ofertas en cursos del Black Friday 2019

Black Friday 2019 ya está aquí y con él famoso día llega una avalancha total de ofertas no solo el mismo viernes, sino el los días previos y posteriores. En Genbeta hemos estado recogiendo algunas de las oportunidades más interesantes relacionadas con software y servicios y ahora haremos lo propio con cursos online en español sobre computación, programación, hacking y ciberseguridad.

Si bien hay mucho que se puede aprender online gratis, algunas ofertas educativas más completas, con certificación y demás beneficios suelen ser de pago. Pero las plataformas de educación en linea no pierden la oportunidad durante estos últimos días de noviembre y principios de diciembre para también unirse con sus propias promociones.

Cursos a 9.99 euros en Udemy

Adi Goldstein Mdinbvq1sfg Unsplash

Cursos a 9.90 en Domestika

Kelly Sikkema Yk0hpwwdj1i Unsplash

Cursos con 70% de descuento en Tutellus

Kobu Agency 67l18r4tw W Unsplash

Utiliza el cupón BLACKFRIDAY antes de inscribirte para ahorrar hasta un 70%.

Descuentos de 25% en los cursos online de Securizame

Fabian Grohs Dc6pb2jdaqs Unsplash

Apple Coding Academy

Hasta el 5 de diciembre puedes obtener un 30% de descuento en los cursos de Swift 5.1 y Desarrollo de apps con SwiftUI. Si combinas las ofertas y tomas los dos cursos puedes obtener 35% de descuento. Los cursos de Apple Coding en Udemy tienen un descuento del 52%.

Más ofertas

  • 3 meses de Amazon Kindle Unlimited por 29,97 euros gratis.
  • 4 meses de Amazon Music Unlimited por 0,99 euros.
  • 30 días de Amazon Prime gratis.

Puedes estar al día y en cada momento informado de las principales ofertas y novedades de Xataka Selección en nuestro canal de Telegram o en nuestros perfiles de Twitter , Facebook y la revista Flipboard. Puedes echar un vistazo también a los cazando gangas de Xataka Móvil, Xataka Android, Xataka Foto, Vida Extra, Espinof y Applesfera, así como con nuestros compañeros de Compradicción. Puedes ver todas las gangas que publican en Twitter y Facebook, e incluso suscribirte a sus avisos vía Telegram.

También puedes encontrar aquí las mejores ofertas del Black Friday 2019.

Xataka Selección
ofrece:
Descubre las mejores ofertas en Tecnología del Black Friday que hemos seleccionado para ti en Xataka Selección. ¡No te las pierdas!

Nota: algunos de los enlaces aquí publicados son de afiliados. A pesar de ello, ninguno de los cursos mencionados han sido propuestos por las webs, siendo su introducción una decisión única del equipo de editores.

También te recomendamos

Gracias a esta web puedes verificar si una oferta de Black Friday de verdad vale la pena antes de comprar

Las mejores ofertas en software del Black Friday 2019

Las mejores ofertas en software, VPN y cursos en la semana previa al Black Friday 2019

-
La noticia Las mejores ofertas en cursos del Black Friday 2019 fue publicada originalmente en Genbeta por Gabriela González .


          

IT / Software / Systems: Senior Software Engineer - Salt Lake City, Utah

 Cache   
Company OverviewAt Motorola Solutions, we create technologies our customers refer to as their lifeline. Our technology platforms in communications, software, video and services help our customers work safely and more efficiently. Whether it's helping firefighters see through smoke, enabling police officers to see around street corners, or reliably keeping the lights on in homes and businesses around the world, our work supports those who put their lives on the line to keep us safe. Bring your passion, potential and talents to Motorola Solutions, and help us usher in a new era in public safety and security. Department OverviewBring your talent and skills to Motorola Solutions, as part of the Software Enterprise at the Salt Lake City Design Center. The Records and Evidence team develops software for public safety organizations to manage all forms of records and evidence. We build products to serve large cities that need sophisticated, customized workflows to smaller municipalities that need cost effective, end to end solutions. All of our systems are built scalable and highly reliable. We provide both cloud and on-premises solutions. These efforts are all in support of our hybrid cloud-based Software as a Service (SaaS) solutions for public safety customers. This team is part of the Software Enterprise division, which offers secure, reliable and efficient team communications, workflow and operational intelligence solutions for critical public safety and enterprise markets throughout the world. Our services use cloud computing infrastructure on AWS and Azure to build at scale. Job Description Perform as a contributing member of an advanced software development scrum team using modern software development techniques to produce world-class public safety software solutions in both on-premise and cloud-based environments Participate in formal and informal design and implementation activities producing mission-critical, real-time solutions that will affect the public directly and may save lives Develop requirements, code and create unit and other automated testing solutions for highly available and sophisticated enterprise level systems and services Provide engineering management with accurate effort estimates for projected work and produce documentation including User Stories and Tasks Effectively communicate and collaborate with technical leaders in a multi-team/multinational environment with teams spanning the globe Demonstrate flexibility and resilience in the face of changing technologies, priorities, and requirements Desired Qualifications: Self-starter, able to understand and verbally express software development concepts in a clear manner and through the use of reports and other written artifacts. Strong background in modern software development practices, principles, and tools including JavaScript, ES6, Nodejs, plus a UI framework like Angular or React Experience with RDBMS such as MySQL, MariaDB, SQL Server and any NoSql distributed databases like Cosmos DB/DocumentDB/ DynamoDB In depth knowledge and working experience developing REST based APIs and implementing microservice principles and architectures Experience developing cloud based solutions in Azure or AWS (other similar enterprise level systems may be relevant) Proven ability to evaluate software quality through the use of functional testing, load testing, performance testing and techniques like network tracing, threat analysis, penetration testing, unit and exploratory testing This position is subject to working in high security areas governed by the US Department of Justice's \"Criminal Justice Information Services (CJIS) Security Policy\" and therefore requires successfully passing a more stringent fingerprint background check administered by Motorola Solutions Inc. customers. Basic Requirements Bachelors degree in Computer Science or related field and 3+ years of software development experience or masters degree in Computer Science or related field with 1+ years of experience Must be able to obtain background clearance as required by government customer Travel RequirementsUnder 10% Relocation ProvidedNone Position TypeExperiencedReferral Payment PlanNoEEO Statement Motorola Solutions is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran's status, or, any other protected characteristic. If you are a current Motorola Solutions employee, please click this link to apply through your Workday account. ()
          

How to Transfer Your WordPress Site to New Domain

 Cache   

BlogVault Migration for WordPress

When you’re operating your WordPress site on one host and need to move it to another, it’s not as simple as you might think. Every instance of WordPress has 4 elements… the infrastructure and IP address it’s hosted at, the MySQL database that contains your content, the uploaded files, themes and plugins, and WordPress itself. WordPress has an import and export mechanism, but it’s restricted to actual content. It doesn’t maintain author integrity, and doesn’t

The post How to Transfer Your WordPress Site to New Domain appeared first on Martech Zone.


          

MySQL user does not work after disable/re-enable virtual server in virtualmin

 Cache   

Hello,

When disabling and re-enabling a domain the MySQL user for that domain refuses to work. In order to fix it I have login to MySQL and set a new password with an ALTER statement. This is on a vanilla Ubuntu 18.04 server deployed with virtualmin's install.sh method. I can reproduce this problem on all domains on this server so it's not an isolated case. The MySQL version on the server is 5.7.

I've also made a forum topic about this but I thought a bug report would be more appropriate for this case.

Reporter: 
sputnik0
Created: 
Thu, 11/28/2019 - 18:22
Updated: 
Thu, 11/28/2019 - 18:23

          

LAMP Developer

 Cache   
VA-Chantilly, Job Description Client is looking for a progressive and innovative full stack software engineer to provide technology leadership and hands-on coding skills to their growing development team. Their technology stack includes PHP, MySQL, Elasticsearch, RabbitMQ, Memcached, Redis, Node.js, Jenkins and GitHub among others. Job Duties: Design and architect solutions using modern, progressive XP engineer
          

SQL Database Developer - Flexible Working

 Cache   
Founded in 2010 we are a specialist digital business change consultancy and have worked with household named brands through complex digital and business transformations. We have developed a patent-pending analytics platform and revolutionary SaaS products . Database Developer - SQL - Disruptive Data Analytics SaaS - Digital Transformation London SE1 | 50,000 Pension Flexible Working Established Tech Start-Up Vibe The Database Developer Role: We're looking for a highly passionate and experienced Database Developer to join our team to extend our rich analytics products as we push and grow our products in the market.The successful applicant will be joining a small, highly focused development team based in Central London. They will be involved in leading the technical design of our analytics platform and its future road map on current technologies and our future move to graph-based technologies. The applicant will lead the data domain and will be responsible for the way in which our data analytics are developed, deployed and managed. The development work in the immediate term is based on MySQL, but we are looking for individuals that are also open to developing their skills into graph-based technologies in future. This is the most exciting time as we have developed a rich underlying platform which we intend to expand rapidly to accommodate a large number of new customers. The successful Database Developer will be expected to have: A strong understanding of relational database technologies (modelling, development and DevOps) Strong experience with agile, sprint based development Able to grasp complex concepts and to drive the direction of data analytics development. A keen willingness to learn and to develop themselves. Transparent and collaborative working style Be a key player in a small and highly efficient development team. 5 years of SQL development in a structured development environment. Experience of a start up, high growth environment Willingness to learn and adapt. Strong ability to work to deadlines. Nice to have : Understanding of graph concepts and. Good understanding of devops processes and how they apply to the data domain. Good understanding of cloud based technologies (ideally AWS) Candidates will be evaluated on a mixture of: Technical capability and experience (40%) Personal motivation and drive(30%) Personality and cultural fit (30%) Your Background / Previous Roles May Include: MySQL Datbase Developer, Database Engineer, Database Programmer, Database Software Developer, Data Modeling. Data Architecture Interested? Apply here for a fast-track path to the Hiring Manager Application notice... We take your privacy seriously. When you apply, we shall process your details and pass your application to our client for review for this vacancy only. As you might expect we may contact you by email, text or telephone. Your data is processed on the basis of our legitimate interests in fulfilling the recruitment process. Please refer to our Data Privacy Policy & Notice on our website for further details. If you have any pre-application questions please contact us first quoting the job title & ref. Good luck, Team RR.
          

学习MYSQL的笔记分享(一)——数据的创建与使用

 Cache   
存储在某种介质上能够识别的物理符号。如文字,图像,声音,视频等。 保存在磁盘外存介质上的数据集合,能被各类用户所共享,数据冗余低,按一定的数据模型组织、描述和存储,较高的数据独立性和易扩展性。 用户与
          

学习MYSQL的笔记分享(二)

 Cache   
重点内容 一、SELECT语句 ALL|DISTINCT:默认为ALL,即SELECT后可能存在重复行,DISTINCT则可消除重复行 select_expr:指定需要查询的内容 INTO OU
          

学习MYSQL笔记分享(三)——索引

 Cache   
不能使用CREATE INDEX 创建PRIMARY KEY索引 注意:数据库管理系统对于主键自动生成唯一索引,所以也是一个特殊的索引。 主键和索引的区别: 一个表 有多个唯一性索引,只有一
          

学习MYSQL笔记分享(四)——视图

 Cache   
一、视图的概述 视图是由一个或多个表或者视图导出的虚拟表,包含数据行与列。 视图与表的区别: - 视图是一张虚拟表 - 视图的数据来自定义视图查询引用的真实表,动态生成 - 视图数据存储在引用表中 -
          

学习MYSQL笔记分享(五)——数据完整性与表的维护

 Cache   
定义了完整性约束,MYSQL服务器会随时检测处于更新状态的数据内容是否符合相关的完整性约束,保证数据的一致性与正确性。 实体完整性规则指关系的主属性,即主码的组成不能为空,关系的主属性不能为NULL
          

三网H5游戏【西游H5】御灵新宠手工外网端+后台+文字教程附带视频教程

 Cache   

西游最全面架设教程:

======================================================

要求系统 Centos7.2

配置要求 2核 4G内存 宽带随意 建议5M

1.安装宝塔 

yum install -y wget && wget -O install.sh http://download.bt.cn/install/install.sh && sh install.sh

2.安装MySQL5.6,php5.6,nginx1.14

3.宝塔 - 数据库 - root密码 输入 123456 提交

4.宝塔 - 网站 - 添加站点 输入IP 根目录/www/wwwroot/

5.宝塔 - 安全 - 放行端口 - 添加3306    全开1:65535

6.mysql -u root -p   

隐藏输入123456回车

7.创建数据库

GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '123456' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

FLUSH   PRIVILEGES;

quit

8.上传www.zip到网站根目录 给予权限 并且用宝塔解压 (温馨提示:www.zip根据情况而定,并不是所有的端都叫WWW,有的也叫game啥的,反正看到.zip或者.tar.gz,内存最大的就是)

  cd /www/wwwroot/game

  unzip www.zip

  chmod -R 777 /www/wwwroot/game1   给权限

9.上传s1.zip到 root目录 给予权限 并且用宝塔解压  (root文件也是根据情况来看,有些端叫S1.zip啊啥的,两个文件夹,一个最大的是WWW网站的,一个小很多的就是ROOT啦)

  cd /root

  unzip root.zip

  chmod -R 777 /root    给权限

10.上传动态库目录下的文件到 usr/lib64

cd /usr/lib64

ldconfig

yum install gcc* -y

yum install libtocmalloc* -y

61fb6ea6e7c6454c

11.数据库与IP修改:

★修改服务端 

修改root/server/s1/的三个xml文件  

configure_center.xml

configure.xml

configure_cross.xml

修改\game\pay config.php

里的区名  ip

修改/www/wwwroot/ip/cz/config.php 

                                第5行 数据库密码

cz文件根据你网站的后台文件来看,后台不固定

12.导入web数据库(温馨提示:数据库根据你的版本而定,并不是都叫web)

13.关闭防火墙

   systemctl stop firewalld.service

   systemctl disable firewalld.service

14.开启

cd /root/s1/server/sh

./gamectl.sh start

./gamectl.sh startbg

关闭

cd /root/server/sh1

./gamectl.sh stop

bf8d4e8647e4f8285e3fda3fcc3bf618.png

[NeadPay]
          

传奇手游【战神引擎】1.80复古小极品视频版服务端+安卓端+外网教程

 Cache   

服务端解压到D盘目录下,破解网关已经集成了,数据库就用phpstudy集成的不要另外安装

apache默认80端口

mysql默认密码www.gowlom2.com

center中央账号服务器安装步骤

安装mongodb-win32-x86_64-2008plus-ssl-3.4.9-signed和robomongo-0.9.0-rc10-windows-x86_64-33c89ea

打开mongod安装目录 C:\Program Files\MongoDB\Server\3.4\bin 

按住shift+右键 点击命令窗口 (切记用管理员身份打开CMD)

输入 mongod --config "D:\MongoDB\config\mongo.cfg" --serviceName "MongoDB" --install

安装完成以后继续在cmd命令输入net start mongodb  -(开启)

需要关闭则输入net start mongodb  -(关闭)

windowns里面的内容复制到相应目录下

服务端修改ip教程

D:\mud2.0\DBServer\DBService.ini

D:\mud2.0\GateServer\GameGate\MirGate.ini

D:\mud2.0\GateServer\logingate\LoginGate.ini

D:\mud2.0\logincenter\logincenter_win\application\controllers\serverlist.lua

D:\mud2.0\logincenter\logincenter_win\config\serverlist.json

D:\mud2.0\Mir200\Gs1\!Setup.txt

D:\phpStudy\WWW\project.manifest

D:\phpStudy\WWW\version.manifest

客户端修改 

用压缩包打开客户端找到路径assets\res

一共3个文件 mir2.zip、mir264.zip、project.manifest

其中mir2.zip和mir264.zip拖出来用压缩包找到mir2.def.init两个包里都是一样的,修改一个即可。

用UE编辑器编辑,找到cqsf1.xingdy.com(注意16位)老规矩位数不够,域名来凑。

project.manifest直接notepad++打开,修改最后面的域名改成你的。(这个可以是IP)

然后单机的也说一下,没有域名怎么办。比如192.168.100.111 

你写进mir2.def.init的时候 就改成192.167.100.0111就凑够16位去玩单机

打包里还有个安卓反编译.rar,因为我们是直接压缩包修改的,并没有反编译。

解压这个包,然后选择签名,把安卓包拖进去直接签名一下就可以了。

游戏全部配置修改以后,按顺序启动游戏即可。


[NeadPay]
          

传奇合击手游【幽冥传奇】1113一键即玩服务端+GM工具+外网教程

 Cache   

-------------------------------------------------------------------------------------------------------

服务端解压缩到D盘:D:\Longgame-BL20166.Com 【解压完后检查路径是否正确】    服务端与客户端默认IP:192.168.1.111

-------------------------------------------------------------------------------------------------------

启动游戏首先需要安装虚拟网卡并设置IP为192.168.1.111

游戏启动教程:

第一步:第一次运行游戏必须先安装【JAVA环境】,运行【[99]首次运行JAVA环境】一次。注意:是第一次,以后不需要了。WIN10用户不能使用,请自行手工安装环境文件夹里面的【jdk-8u91-windows-x64】。

第二步:打开【[0]安装虚拟网卡(运行二次即可).vbs】,这里注意的是腾讯管家等会拦截,需要点击【允许】。WIN10用户不能使用,需要手工修改虚拟网卡IP为192.168.1.111.

第三步:打开【[01]phpstudy_pro】打开之后,启动第一个【Apache2.4.39】和第三个【MySQL5.7.26】启动这2个,其他的别动。

第四步:打开【[02]start】  打开之后会出现10个弹窗。游戏就启动完成了。

这里要说一下,游戏启动大约3-5分钟。需要等待一下。没有启动完成会卡在选区界面。

最后一步:把【幽冥传奇.apk】安装到安卓模拟器,就可以开始游戏了。

-------------------------------------------------------------------------------------------------------

游戏GM工具:

http://192.168.1.111/gm/

使用GM工具首先需要把【人物下线】,

然后名字输入S1.*** 这里***的意思就是你的人物名字。比如游戏名:有分享,那么输入S1.有分享

修改完成后,上线即可。

发送邮件物品工具:

http://192.168.1.111/cqpay.php?uid=16777221&type=item&num=8&item=88

上面网址里面的【16777221】改成自己的角色ID,网址里面的【8】是数量,网址里面的【88】是物品ID。

http://192.168.1.111/cqpay.php?uid=【角色ID】&type=item&num=【数量】&item=【物品ID】

角色ID查看:

使用N11打开数据库【cq_actor1】找到【actors表】,里面的【actorid】就是你的角色ID了。

-------------------------------------------------------------------------------------------------------

游戏外网修改:

服务端修改:

D:\Longgame-BL20166.Com\WWW\args.php                       【推荐使用Notepad++修改,修改32行的IP为你的外网IP】

客户端修改:

路径\assets\data\scripts\platform\platform_adapter.lua     【推荐使用Notepad++修改,修改22行的IP为你的外网IP】


[NeadPay]
          

大富豪多雷扫雷完整源码完美运营带搭建文字教程

 Cache   

源码介绍:

又是一个牛逼的扫雷源码

最近很多人都想要的一套

这套相当于士兵扫雷的升级版

调整了ui,增加了多雷玩法模式

后台带控,功能强大

不多说,看图吧

搭建教程:

inux centos 7.2 

ng1.16 或者阿帕奇2.4    php7.0  mysql 5.5

伪静态默认thinkphp 

php安装一下扩展 fileinfo

修改地方

公众号:\app\index\controller

WeixinController.php 修改公众号

数据库:\data\conf

database.php  修改数据库

机器人:

vendor\GatewayWorker\Applications\YourApp\Config

Db.php  修改数据库 

vendor\GatewayWorker\Applications\YourApp\

start_businessworker.php 

74行改你自己目录

密码admin    26212155

服务器启动打开ssh

执行cd /www/wwwroot/你的网站目录/vendor/GatewayWorker

php start.php start -d

源码截图:


[NeadPay]
          

MySQL reset root password

 Cache   

Hello,

This time I share with you the faster and more secure method to reset the root password of MySQL.

This method is faster because the downtime is between 1 or 2 seconds (MySQL restart time) and it is more secure because the mysqld is not started without grants on the tables.

The steps are:

  1. Create text file /var/lib/mysql/mysql-init with the sintaxis to reset the password for user root:

    vim /var/lib/mysql/mysql-init
    
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
    
  2. Add under the [mysqld] stanza on the file /etc/my.cnf:

    init-file=/var/lib/mysql/mysql-init
    
  3. Restart the mysqld service:

    service mysqld restart
    
  4. Remove the init-file line from /etc/my.cnf

  5. Remove /var/lib/mysql/mysql-init

    rm /var/lib/mysql/mysql-init
    
And after that, you can access again to your mysql instance.

:)


          

MySQL without password

 Cache   



The common form to log in to MySQL server, is running a mysql command with your login credentials and server’s IP address as arguments. For example:

mysql -u $MYSQL_ROOT -p$MYSQL_PASS

However, besides the inconvenience of typing extra arguments, using plain-text login credentials in a command line like above is really not a secure way to access a MySQL server.

MySQL offers a way for you to log in to MySQL server without password, by using an external MySQL configuration file. In Linux, there are two different kinds of MySQL configuration files:

  1. /etc/my.cnf and
  2. ~/.my.conf

While any system-wide MySQL configuration is defined in /etc/my.cnf, any user-specific MySQL configuration is stored in ~/.my.cnf. You can leverage ~/.my.cnf, to define your MySQL login credential in the file.

vim ~/.my.cnf

We put our MySQL user in the configuration file:

[client]
user=root
password=$PASSWORD_ROOT

Make sure to have the configuration file readable to you only.

chmod 0600 ~/.my.cnf

Once ~/.my.cnf is created, simply typing mysql command will let you log in to the MySQL server as root, and you no longer need to provide login password separately.

mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14787
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

          

Mojo-mysql-1.18 : Tekki

 Cache   
Tekki uploaded T/TE/TEKKI/Mojo-mysql-1.18.tar.gz (40k) on 01 Dec 2019
          

Web Entwickler (m/w/d) Informatik / JavaScript / MySQL / IT

 Cache   
Deine Aufgaben als Web-Entwickler (m/w/d) Als Web Entwickler – Frontend/Backend (m/w/d) bist du sowohl für die Pflege und Weiterentwicklung existierender Web Anwendungen, als auch für den Entwurf und die Entwicklung von neuen Web Apps verantwortlich. Unsere Anforderungen: Erfolgreich abgeschlossenes Informatik-Studium oder eine vergleichbare Ausbildung Praktische Erfahrung in der Web-Entwicklung PHP7, MySQL, Javascript, HTML5, CSS3 und [...]
          

Shinguz: Migration from MySQL 5.7 to MariaDB 10.4

 Cache   

Up to version 5.5 MariaDB and MySQL can be considered as "the same" databases. The official wording at those times was "drop-in-replacement". But now we are a few years later and times and features changed. Also the official wording has slightly changed to just "compatible".
FromDual recommends that you consider MariaDB 10.3 and MySQL 8.0 as completely different database products (with some common roots) nowadays. Thus you should work and act accordingly.

Because more and more FromDual customers consider a migration from MySQL to MariaDB we were testing some migration paths to find the pitfalls. One upgrade of some test schemas led to the following warnings:

# mysql_upgrade --user=root
MariaDB upgrade detected
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.columns_priv                                 OK
...
mysql.user                                         OK
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views from mysql
sys.host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
status   : Operation failed
sys.host_summary_by_file_io
Error    : Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50723, now running 100407. Please use mysql_upgrade to fix this error
error    : Corrupt
...
sys.x$host_summary
Error    : Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist
Error    : View 'sys.x$host_summary' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
error    : Corrupt
...
sys.x$waits_global_by_latency                      OK
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
staging
staging.sales                                      OK
staging.sugarcrm_contact_export
Warning  : Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
status   : OK
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

If you run the mysql_upgrade utility a 2nd time all issues are gone...

# mysql_upgrade --user=root --force

Some hints for upgrading

  • Make a backup first before you start!
  • Dropping MySQL sys Schema before the upgrade and installing MariaDB sys Schema again afterwards reduces noise a bit and lets you having a working sys Schema again.
    The MariaDB sys Schema you can find at GitHub: FromDual / mariadb-sys .
  • It makes sense to read this document before you begin with the upgrade: MariaDB versus MySQL: Compatibility.

Literature



          

Mysql Rodolphe

 Cache   
Mysql Rodolphe
          

PHP codeigniter Developer

 Cache   
Category: AJAX, Codeigniter, HTML, MySQL, PHP
Budget: ₹100 - ₹400 INR

Technical Skills Experience in PHP, MySQL, JAVASCRIPT, AJAX, JQuery, HTML/ CSS, Knowledge in any of PHP framework like Codeigniter,Symfony, Cake PHP, Ability to communicate project status, issues, and...
          

I want to Learn PHP and SQL

 Cache   
Category: HTML, Javascript, Laravel, MySQL, PHP
Budget: ₹1500 - ₹12500 INR

i want to learn Front end: HTML5 CSS3 Javascript Jquery Back End PHP laravel Database SQL
          

Looking for phyton coder for scraping via RSS

 Cache   
Category: Scripts & Utilities, Data Scraping, Web Scraping, Python, JavaScript, RSS, PHP, MySQL Administration

Hi There,

I would like to build something like this:
http://www.stock-spy.com/

I think it's phyton and RSS feeds.

If you have experience with that kind of thing I would love to see some other jobs that you did on similar projects.

Also, it will be great if you can send me a quote regarding the reference above.

Thank you
Or Keynan


Posted On: November 28, 2019 15:10 UTC
Category: Web, Mobile & Software Dev > Scripts & Utilities
Skills: Data Scraping, Web Scraping, Python, JavaScript, RSS, PHP, MySQL Administration
Country: Israel
click to apply
          

Responsive website

 Cache   
Category: CSS, HTML, Javascript, MySQL, PHP
Budget: $30 - $250 USD

We need a user interface and responsive website and looking for expert coder who can code for a customized framework. Competencies required: JavaScript, PHP; MySQL, JQuery, HTML, CSS Knowledge about...
          

php javascript: fix bugs, secure poorly coded script -- ongoing

 Cache   
Category: Codeigniter, Javascript, MySQL, PHP, Web Security
Budget: $30 - $250 USD

No automatic or fake bids. Main Issue: Bots or visitors can delete post, delete comment, post, like without login just by query string on url. made possible by this genius team: https://www.freelancer.com/u/infowider11...
          

Editing MySQL Data Using PHP and the MySQLi Libraries

 Cache   
This tutorial is going to show you how to retrieve results from a database using PHP, then edit the row and save it back to the database. If you haven’t followed our other tutorials you might want to check out: Reading from a MySQL Database Using PHP and MySQLi Inserting Data Into a MySQL Database ... Read more Editing MySQL Data Using PHP and the MySQLi Libraries
          

Inserting Data Into a MySQL Database Using PHP and MySQLi

 Cache   
This tutorial will show you how to insert data into a MySQL database using the latest MySQLi PHP libraries. This tutorial will replace our older tutorial on MySQL libraries and that post will redirect here in the future. Assumptions First, we will assume you have PHP, MySQL, and Apache running. I use MAMP for my ... Read more Inserting Data Into a MySQL Database Using PHP and MySQLi
          

Reading from a MySQL Database Using PHP and MySQLi

 Cache   
I had some old tutorials out there that use outdated PHP libraries to access a MySQL database. I wanted to update these to use the latest PHP library called MySQLi. MySQLi is the improved database driver for use in the PHP scripting language to provide an interface to MySQL databases. It replaces both PHP’s MySQL ... Read more Reading from a MySQL Database Using PHP and MySQLi
          

Summary of trailing spaces handling in MySQL, with version 8.0 upgrade considerations (no replies)

 Cache   
https://saveriomiroddi.github.io/Summary-of-trailing-spaces-handling-in-MySQL-with-version-8.0-upgrade-considerations/
          

An in depth DBA's guide to migrating a MySQL database from the `utf8` to the `utf8mb4` charset (no replies)

 Cache   
https://saveriomiroddi.github.io/An-in-depth-dbas-guide-to-migrating-a-mysql-database-from-the-utf8-to-the-utf8mb4-charset/
          

Mysql wont update when i run ./build mysql

 Cache   
none
          

IT / Software / Systems: Full Stack Developer - Node/React - Partial Remote - Grapevine, Texas

 Cache   
Full Stack Developer - Node/React - Partial Remote We are a cutting edge SAAS logistics company specializing in large orders. Due to recent funding and growth on team, we are seeking an experienced and motivated Node/React Developer to help them build out and improve their existing technology. What You Will Be Doing You will champion development of best in class web applications, consistently ensuring UI consistency and quality. You will create and deploy software building blocks that support the client's product suite, and work cross functionally with product and leadership teams to workshop and implement the best solutions. You will lead the standardization and improvement of development processes including technology selection, deployment steps and code review. What You Need for this Position 3+ years of experience as a software engineer and preferably experience helping to lead development teams- Node.js Guru- Strong experience with React workflows- Fluent in server technologies, specifically AWS- Database skills - MySQL as well non-relational database experience- Experienced working with API's/Integrations- Enterprise application experience What's In It for You - Excellent benefits package- 2 REMOTE days/week- Profit sharing- Gym reimbursement - Strong 401k Feel free to email me resumes directly alfredo.rivera@cybercoders.com - Applicants must be authorized to work in the U.S. CyberCoders, Inc is proud to be an Equal Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, or any other characteristic protected by law. Your Right to Work In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. ()
          

I've lost admin permissions and I'm locked out of Deskpro On-Premise

 Cache   

Question:

When I try to log into my admin account, I get a message that I don't have admin permissions. I think the account was changed to a normal agent by mistake. There's no other admin account I can use, so I'm locked out of Deskpro. Is there some way I can make a new admin account?

Answer:

From the command line, run:

php bin/console dp:agents make-admin

You will then be prompted to enter the email address of a user you want to promote to admin.

 

You can use

php /path_to_deskpro/bin/console dp:agents

to see a list of agent accounts.

 

If this method doesn't work, you could edit the MySQL database directly.

In the people table, find your account and set is_agent=1 and can_admin=1.


          

Can Deskpro integrate with other software?

 Cache   

Yes, you can install apps to integrate with a wide variety of other software.

Head to our Apps & Integrations section on our website for a full list of what is available.

The list includes:

  • Google Analytics
  • Gravatar
  • Highrise
  • HipChat
  • Slack
  • JIRA
  • Trello
  • Zapier
  • MailChimp
  • Magento
  • Microsoft Translator
  • Salesforce
  • Twilio SMS
  • Clickatell SMS

You can install authentication apps so users/agents can log in with credentials from:

  • Magento
  • Active Directory
  • Your own database (MySQL, PostgreSQL, SQLite, MsSQL, Oracle, or any database that supports ODBC connections)
  • SAML identity providers
  • Web software using the easy-to-implement JSON Web Token standard
  • eZ Publish
  • Okta
  • OneLogin
  • Facebook
  • Google+
  • Joomla
  • LDAP
  • phpBB
  • Twitter
  • vBulletin
  • XenForo

If you have your own developers, Deskpro has a full REST API for integration with other systems and a PHP SDK, as well as a widgets and apps framework. See the article Getting started with Deskpro development for more details.

We can also develop custom integrations for you at reasonable prices.

 

 

 


          

“Existing tables were detected in your database” error

 Cache   

 

Question

I'm getting an error from the install wizard saying “Existing tables were detected in your database”. How do I resolve this?

 

Answer

The Deskpro installer creates a ‘deskpro’ database within MySQL. If this is not empty (for example, you partly installed Deskpro before, or you are trying to install a production version over your old test helpdesk), the installation cannot proceed.

The easiest solution is to connect to MySQL and create a new empty database, e.g.

 

mysql> CREATE DATABASE deskpro-live;

 

Then in config.php, edit this line:

 

define('DP_DATABASE_NAME', 'deskpro');

 

replacing 'deskpro' with the new database name e.g. 'deskpro-live'.

Deskpro will now use the new, blank database for installation, but you will still have the old database for reference until you choose to delete it.


          

Cómo configurar Servidores Virtuales (Virtual Hosts) en Apache y Debian 10 Buster

 Cache   
En éste tutorial o guía paso a paso se describe como configurar servidores virtuales (virtual hosts) en Apache sobre Debian 10 Buster. Los servidores virtuales también son llamados sitios web o páginas web, y permiten servir más de uno usando el mismo servidor web, en éste caso, Apache. Cuando recién instalamos LAMP (“Linux, Apache, MySQL, […]
          

Bayesian Machine Learning in Python: A/B Testing for $24

 Cache   
Expires November 23, 2022 23:59 PST
Buy now and get 80% off

KEY FEATURES

A/B testing is used everywhere, from marketing, retail, news feeds, online advertising, and much more. If you're a data scientist, and you want to tell the rest of the company, "logo A is better than logo B," you're going to need numbers and stats to prove it. That's where A/B testing comes in. In this course, you'll do traditional A/B testing in order to appreciate its complexity as you elevate towards the Bayesian machine learning way of doing things.

  • Access 40 lectures & 3.5 hours of content 24/7
  • Improve on traditional A/B testing w/ adaptive methods
  • Learn about epsilon-greedy algorithm & improve upon it w/ a similar algorithm called UCB1
  • Understand how to use a fully Bayesian approach to A/B testing

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels, but knowledge of calculus, probability, Python, Numpy, Scipy, and Matplotlib is expected
  • All code for this course is available for download here, in the directory ab_testing

Compatibility

  • Internet required

THE EXPERT

The Lazy Programmer is a data scientist, big data engineer, and full stack software engineer. For his master's thesis he worked on brain-computer interfaces using machine learning. These assist non-verbal and non-mobile persons to communicate with their family and caregivers.

He has worked in online advertising and digital media as both a data scientist and big data engineer, and built various high-throughput web services around said data. He has created new big data pipelines using Hadoop/Pig/MapReduce, and created machine learning models to predict click-through rate, news feed recommender systems using linear regression, Bayesian Bandits, and collaborative filtering and validated the results using A/B testing.

He has taught undergraduate and graduate students in data science, statistics, machine learning, algorithms, calculus, computer graphics, and physics for students attending universities such as Columbia University, NYU, Humber College, and The New School.

Multiple businesses have benefitted from his web programming expertise. He does all the backend (server), frontend (HTML/JS/CSS), and operations/deployment work. Some of the technologies he has used are: Python, Ruby/Rails, PHP, Bootstrap, jQuery (Javascript), Backbone, and Angular. For storage/databases he has used MySQL, Postgres, Redis, MongoDB, and more.

          

Deep Learning: GANs and Variational Autoencoders for $25

 Cache   
Expires November 23, 2022 23:59 PST
Buy now and get 86% off

KEY FEATURES

Variational autoencoders and GANs have been two of the most interesting recent developments in deep learning and machine learning. GAN stands for generative adversarial network, where two neural networks compete with each other. Unsupervised learning means you're not trying to map input data to targets, you're just trying to learn the structure of that input data. In this course, you'll learn the structure of data in order to produce more stuff that resembles the original data.

  • Access 41 lectures & 5.5 hours of content 24/7
  • Incorporate ideas from Bayesian Machine Learning, Reinforcement Learning, & Game Theory
  • Discuss variational autoencoder architecture
  • Discover GAN basics

PRODUCT SPECS

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels, but knowledge of calculus, probability, object-oriented programming, Python, Numpy, linear regression, gradient descent, and how to build a feedforward and convolutional neural network in Theano and TensorFlow is expected
  • All code for this course is available for download here, in the directory unsupervised_class3

Compatibility

  • Internet required

THE EXPERT

The Lazy Programmer is a data scientist, big data engineer, and full stack software engineer. For his master's thesis he worked on brain-computer interfaces using machine learning. These assist non-verbal and non-mobile persons to communicate with their family and caregivers.

He has worked in online advertising and digital media as both a data scientist and big data engineer, and built various high-throughput web services around said data. He has created new big data pipelines using Hadoop/Pig/MapReduce, and created machine learning models to predict click-through rate, news feed recommender systems using linear regression, Bayesian Bandits, and collaborative filtering and validated the results using A/B testing.

He has taught undergraduate and graduate students in data science, statistics, machine learning, algorithms, calculus, computer graphics, and physics for students attending universities such as Columbia University, NYU, Humber College, and The New School.

Multiple businesses have benefitted from his web programming expertise. He does all the backend (server), frontend (HTML/JS/CSS), and operations/deployment work. Some of the technologies he has used are: Python, Ruby/Rails, PHP, Bootstrap, jQuery (Javascript), Backbone, and Angular. For storage/databases he has used MySQL, Postgres, Redis, MongoDB, and more.

          

Technical Architect (Salesforce experience required) Casper - SilverlineCRM - Casper, WY

 Cache   
Competency with Microsoft SQL Server, MYSQL, postgreSQL or Oracle. BA/BS in Computer Science, Mathematics, Engineering, or similar technical degree or…
From SilverlineCRM - Wed, 13 Nov 2019 18:32:15 GMT - View all Casper, WY jobs
          

Technical Architect (Salesforce experience required) Cheyenne - SilverlineCRM - Cheyenne, WY

 Cache   
Competency with Microsoft SQL Server, MYSQL, postgreSQL or Oracle. BA/BS in Computer Science, Mathematics, Engineering, or similar technical degree or…
From SilverlineCRM - Wed, 13 Nov 2019 18:32:15 GMT - View all Cheyenne, WY jobs
          

Fixing mini issues on Laravel

 Cache   
I am finding Laravel developer who can work need to sort it out soon It will be long term ... (Budget: $10 - $30 CAD, Jobs: HTML, Laravel, MySQL, PHP, Website Design)
          

Web application

 Cache   
Need build application, which will have login system and complete form of 25 pages (Budget: ₹600 - ₹1500 INR, Jobs: ASP.NET, HTML, MySQL, PHP, Website Design)
          

Recommended update for apr-util 3110

 Cache   
Abstract:

Recommended update for apr-util


Patch: SUSE-SLE-Module-Server-Applications-15-2019-3110
Bugs: 1149792

Applies to:

Package(s): libapr-util1-dbd-mysql libapr-util1-dbd-pgsql libapr-util1-dbd-sqlite3
Product(s):
SUSE Linux Enterprise Server 15


Downloads:


          

Mysql Er Diagram From Database

 Cache   
Mysql Er Diagram From Database
          

IT / Software / Systems: Sr Software Engineer - Boca Raton, Florida

 Cache   
Overview:The Senior Java Developer will be part of a high performance team of professionals responsible for delivering Java and AWS web applications to our internal and external customers. Qualified candidates will enjoy working in a fast paced team environment that is passionate about their work and contributing to our exciting digital transformation and growth agenda for the entire organization. Responsibilities: Work as part of the technical team that designs, develops, implements, and maintains scalable web and mobile applications Work closely with graphic designers and other development teams to ensure successful implementation and integration of dashboards and interactive web applications Converts specifications and requirements into functional application code and works with front-end designers to create functional web pages and applications Coordinate analytical business functions, discovering business rules and ensuring that they are handled appropriately by the business applications Understand and adhere to industry best practices for delivering high quality code Is an active participant in an Agile/SCRUM environment Interact with the business and user community to gather and validate business requirements and business rules Work according to defined scope and time lines and track work in progress Break down projects into tasks with time estimation Proactively identify and communicate issues Work in a team environment with other developers, architects, designers, product managers, business analysts Demonstrated focus on quality (unit testing, system testing, user acceptance testing) Experience: Minimum 5-7 years experience using Java/J2EE and object-oriented design principles and design patterns Experience with frameworks like Spring, Javascript, Mybatis/iBatis Experience with AWS technologies including Serverless and Lambda Experience building and maintaining scalable web applications in AWS Demonstrated proficiency with developing web services and API's including Microservices Experience with front-end technologies like Angular, HTML, CSS, JQuery, Ajax Experience working with relational databases, including Oracle, SQL Server, and MySQL Experience with Eclipse, Netbeans, or equivalent IDEs Unit testing tools JUnit or equivalent Experience working with and implementing third party e-commerce services including, but not limited to: Credit card processing, Customer product reviews, Site analytics (Google Analytics), SEO/SEM, and and on-site searches (Google) Experience with Oracle E-Business Suite a plus Experience with mobile applications and SDKs (jQuery mobile, Sencha, iPhone/Xcode, Android) a plus Knowledge of CI/CD and DevOps practices is plus Education Bachelor's degree in computer science preferred. ()
          

Other: Senior Node.js Engineer - Boca Raton, Florida

 Cache   
Senior Node.js Engineer If you are a Senior Node.js Engineer with experience, please read on! Top Reasons to Work with Us - HUGE Room for Growth- Great Work/Life Balance/Autonomy- Competitive Pay What You Will Be Doing As a Senior Node.js Developer, you'll be working with us in all aspects of the product, from its core infrastructure to the various micro-services. As a part of the development team, you'll wear multiple hats, turn ambiguity into details, take the lead on building complex features and continuously find opportunities to improve performance and increase reliability. What You Need for this Position At Least 3 Years of experience and knowledge of:- JavaScript- Node.js- GIT- SQL- MySQLNice to have:- AWS So, if you are a Senior Node.js Engineer with experience, please apply today! - Applicants must be authorized to work in the U.S. CyberCoders, Inc is proud to be an Equal Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, or any other characteristic protected by law. Your Right to Work In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. ()
          

IT / Software / Systems: Senior Security Software Engineer - Miami, Florida

 Cache   
This role requires expertise in modern software components for scalable systems including messaging queues, schedulers, multi-threaded software, databases and modern cloud (AWS) technologies. Requirements: 8 years software engineering experience Experience designing and implementing python in a production environment Comfort with serialization formats (e.g., JSON, XML, YAML, and Google Protobuf) Familiarity with NoSQL databases (e.g., Redis) Experience leveraging code pipelines (e.g., Gitlab CI/CD using Docker) Experience with relational (e.g., MySQL, Postgres) and non-relational (e.g., MongoDB) databases DevOps expertise (e.g., Docker / Kubernetes) Familiarity with message queuing solutions (e.g., RabbitMQ) Experience building and deploying applications in AWS Experience designing and leveraging interfaces (APIs) Excellent communication skills both in-person and remote Passion for problem solving Ability to work independently and with a diverse team Act on a high performing Agile team supporting a variety of projects Desires: Prior working experience with data analytics tools like JupyterLab, NumPy, Pandas Experience applying cybersecurity principles and concepts in code Familiarity with interacting programmatically with PE structures Experience writing code that leverages any of the following Python modules: distorm, unicorn, capstone, pefile, keystone. Bachelor s Degrees in CS, EE, or equivalent experience. - provided by Dice ()
          

IT / Software / Systems: PHP Web Developer - Miami, Florida

 Cache   
PLEASE DO NOT APPLY BEFORE READ THE COMPLETE POST!!If you are a Experienced PHP Developer BASED in South Florida read on! We are looking for new talent for our offices in Miami. We are Miami based company, branch of a French company specialized on SIMcards and Telecom platforms.--- We are constantly growing and in need to of a strong web developer to join our growing team immediately.--- What you need - Bachelor of Science in Computer Science or related degree- Experience with MVC framework, ( Symfony is a MUST)- Experience with PHP (must)- Experience with relational databases such as MySQL, Oracle.- Experience with linux- Experience with HTML, CSS, Javascript (AJAX/---DOM), Java- Experience with Webservices, SOAP, RESTAPI What You'll be doing -Creating web applications -Create front, and back-end applications.----Build on commercial, open-source, and custom frameworks.----Work with various programming languages and protocols.--- What's in it for you- Possibility to work in a high-tech environment- Multidisciplinary team based in Miami/Argentine/Middle East. We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to sponsor visasThis is a full time onsite job in Miami, if you are not able to work under this premise please do not apply. ()
          

Build me a Codeigniter Website

 Cache   
We are looking for a Php + Codeigniter Developer who possesses a passion for pushing web technologies to the limits and will work with our team to design & develop and build the next generation of our web applications and Softwares... (Budget: ₹100 - ₹400 INR, Jobs: Codeigniter, HTML, MySQL, PHP, Website Design)
          

Magento 2.2.3 Database Alignment

 Cache   
Hi I am looking for someone to help take a database from an exciting Marhgento site, and merge it into another Magento site. We need to set up Varriables and Criterias for this to happen (Budget: $30 - $250 AUD, Jobs: eCommerce, HTML, Magento, MySQL, PHP)
          

database on my server not picked up by google .

 Cache   
My site is on one server and database is on another server. I cant see any file picked up by google though its been 1 yr (Budget: ₹600 - ₹1500 INR, Jobs: Database Administration, HTML, MySQL, PHP, SQL)
          

Ccavenue Payment gateway integration for ecommerce website

 Cache   
How to integrate payment gateway for my website (Budget: ₹100 - ₹400 INR, Jobs: eCommerce, HTML, MySQL, PHP, Website Design)
          

Aurora Global Database is Now Supported on Amazon Aurora MySQL 5.7

 Cache   

An Amazon Aurora Global Database is a single database that spans multiple AWS regions, enabling low latency global reads and disaster recovery from region-wide outages. With today’s launch, the feature is supported on the MySQL 5.7-compatible edition of Aurora. You can create a new Global Database cluster by adding a region to an existing MySQL 5.7 cluster.


          

Amazon Aurora with MySQL and PostgreSQL Compatibility are now FedRAMP-High Compliant in AWS GovCloud (US)

 Cache   

Amazon Aurora with MySQL compatibility and Amazon Aurora with PostgreSQL compatibility in AWS GovCloud (US) Regions are now compliant with the Federal Risk and Authorization Management Program (FedRAMP) High baseline, which includes over 400 security controls. 


          

Amazon Aurora MySQL 5.7 Now Supports Zero-Downtime Patching

 Cache   

Amazon Aurora zero-downtime patching (ZDP), which attempts to preserve client connections through an engine patch, is now supported on Aurora MySQL engine release 2.07 and above. When ZDP executes successfully, application sessions are preserved and the database engine restarts while patching. Read the Aurora documentation to learn more. 


          

AWS Glue now enables you to bring your own JDBC drivers to your Glue Spark ETL jobs

 Cache   

Starting today, you can now bring your own JDBC drivers to your Glue Spark ETL jobs. AWS Glue is a fully managed extract, transform, and load (ETL) service that makes it easier to prepare and load your data for analytics. AWS Glue has native connectors to connect to supported data sources either on AWS or elsewhere using JDBC drivers. This feature enables you to connect to data sources with custom drivers that were not natively supported in AWS Glue such as MySQL 8 and Oracle 18. You can also use multiple JDBC driver versions in the same Glue job enabling you to migrate data between source and target databases with different versions. To learn more, please visit our documentation.


          

SQL Crash Course for beginners – Learn SQL with MySQL

 Cache   

SQL Crash Course for beginners – Learn SQL with MySQL, Master the SQL statements that every software developer or data analyst needs for designing and developing databases. Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases – to name just a few. So, to be a successful developer or data scientist […]

The post SQL Crash Course for beginners – Learn SQL with MySQL appeared first on Online Tutorials.


          

Dedicated MySQL Service Provisioning Failures

 Cache   

Nov 28, 07:34 PST
Resolved - This incident has been resolved. The provisioning failures were caused by a renewed CA certificate that should have been distributed to the Dedicated MySQL service broker but was not. When we regenerated the associated server certificates the service broker lost connectivity to a component it depends on for provisioning. Installing the new CA certificate on the Dedicated MySQL service broker resolved the issue.

Nov 27, 15:38 PST
Update - We are continuing to monitor for any further issues.

Nov 27, 15:36 PST
Monitoring - We have identified the cause of the issue and applied a fix. We are monitoring to ensure the fix has resolved the issue.

Nov 27, 14:49 PST
Investigating - We are currently investigating an issue affecting new service instance provisioning for the Dedicated MySQL service.


          

Er Diagram Mysql Company

 Cache   
Er Diagram Mysql Company
          

 Cache   
Nice SQL cribsheet.
          

2019-10451 - Stagiaire – Data Analyst Performance Opérationnelle Air France Cargo H/F

 Cache   
Métier : Stratégie et développement/Etudes et Performance
Type de contrat : Convention de stage
Description du poste :
Rattaché(e) à l'entité des Indicateurs et sous la responsabilité de votre maître de stage, votre principale mission consistera à : Contribuer à améliorer le suivi de la performance, un volet prioritaire de l’entreprise, en construisant les indicateurs de mesures de nos opérations Fret. Votre mission sera globale, depuis la conception fonctionnelle jusqu’à la réalisation technique informatique et s’articulera comme ci-dessous : 1/ Apporter assistance à la  maîtrise d’ouvrage fonctionnelle (~20%) Définir, spécifier et formaliser avec les équipes métier les indicateurs de suivi de la performance (KPI) S’approprier le fonctionnement des processus et procédures métiers afin de pouvoir concevoir et modéliser des indicateurs informatiques Présenter les réalisations aux clients finaux et réaliser les formations nécessaires   2/ Data science / data mining (~30%) Identifier, extraire et agréger les données des différentes sources (bases de données MySQL, datawarehouse) Proposer de nouveaux outils ou méthodes pour améliorer le traitement et l’analyse des données   3/ Ingénierie et développement de la solution (~50%) Apporter une maintenance technique et fonctionnelle des outils existants  Développer ces indicateurs en utilisant plusieurs technologies: Web (Serveurs/Front) ou reporting via Business Object / Datawarehouse / Spotfire

Vous êtes étudiant(e) en dernière année d’école d’ingénieur ou MIAGE et vous rechercher un stage de fin d'étude pour une durée de 6 mois. Vous possédez les compétences techniques suivantes : Data analyst, ETL, business object, data visualisation La maitrise de Spotfire serait un plus et/ou technologies serveurs (SQL/PhP / framework symphony) Compétences fonctionnelles : Recueil de besoins utilisateurs - Vous aimez l’autonomie dans la gestion de vos projets, travailler avec les ‘end-users’, manipuler les data et coder… - Vous avez démontré dans vos précédentes expériences une réelle capacité à vous adapter, vous organiser et à délivrer. Conformément aux engagements pris par Air France dans son accord 2018-2020 en faveur de l’emploi des personnes en situation de handicap, nos contrats sont ouverts à tous.
Site : 45 rue de Paris 95747 ROISSY CHARLES DE GAULLE CEDEX
Niveau d'études min. requis : Bac + 4 / 2ème année grande école
Langue / Niveau :
Anglais : 3 - Confirmé

          

Spécialiste, développement - Fairstone - Montréal, QC

 Cache   
Java, JEE, Gitlab (CI), Spring MVC, Stash/BitBucket, Javascript (React JS, Node JS, Angular), Redux, Maven, Jenkins, REST, SOAP, Tomcat, Websphere, MySQL, Api…
From Fairstone - Fri, 22 Nov 2019 16:55:10 GMT - View all Montréal, QC jobs
          

Specialist, Development - Fairstone - Montréal, QC

 Cache   
Java, JEE, Gitlab (CI), Spring MVC, Stash/BitBucket, Javascript (React JS, Node, Angular), Redux, Maven, Jenkins, REST, SOAP, Tomcat, Websphere, MySQL, Api…
From Fairstone - Fri, 22 Nov 2019 16:54:47 GMT - View all Montréal, QC jobs
          

Las mejores ofertas en cursos del Black Friday 2019

 Cache   

Las mejores ofertas en cursos del Black Friday 2019

Black Friday 2019 ya está aquí y con él famoso día llega una avalancha total de ofertas no solo el mismo viernes, sino el los días previos y posteriores. En Genbeta hemos estado recogiendo algunas de las oportunidades más interesantes relacionadas con software y servicios y ahora haremos lo propio con cursos online en español sobre computación, programación, hacking y ciberseguridad.

Si bien hay mucho que se puede aprender online gratis, algunas ofertas educativas más completas, con certificación y demás beneficios suelen ser de pago. Pero las plataformas de educación en linea no pierden la oportunidad durante estos últimos días de noviembre y principios de diciembre para también unirse con sus propias promociones.

Cursos a 9.99 euros en Udemy

Adi Goldstein Mdinbvq1sfg Unsplash

Cursos a 9.90 en Domestika

Kelly Sikkema Yk0hpwwdj1i Unsplash

Cursos con 70% de descuento en Tutellus

Kobu Agency 67l18r4tw W Unsplash

Utiliza el cupón BLACKFRIDAY antes de inscribirte para ahorrar hasta un 70%.

Descuentos de 25% en los cursos online de Securizame

Fabian Grohs Dc6pb2jdaqs Unsplash

Apple Coding Academy

Hasta el 5 de diciembre puedes obtener un 30% de descuento en los cursos de Swift 5.1 y Desarrollo de apps con SwiftUI. Si combinas las ofertas y tomas los dos cursos puedes obtener 35% de descuento. Los cursos de Apple Coding en Udemy tienen un descuento del 52%.

Más ofertas

  • 3 meses de Amazon Kindle Unlimited por 29,97 euros gratis.
  • 4 meses de Amazon Music Unlimited por 0,99 euros.
  • 30 días de Amazon Prime gratis.

Puedes estar al día y en cada momento informado de las principales ofertas y novedades de Xataka Selección en nuestro canal de Telegram o en nuestros perfiles de Twitter , Facebook y la revista Flipboard. Puedes echar un vistazo también a los cazando gangas de Xataka Móvil, Xataka Android, Xataka Foto, Vida Extra, Espinof y Applesfera, así como con nuestros compañeros de Compradicción. Puedes ver todas las gangas que publican en Twitter y Facebook, e incluso suscribirte a sus avisos vía Telegram.

También puedes encontrar aquí las mejores ofertas del Black Friday 2019.

Xataka Selección
ofrece:
Descubre las mejores ofertas en Tecnología del Black Friday que hemos seleccionado para ti en Xataka Selección. ¡No te las pierdas!

Nota: algunos de los enlaces aquí publicados son de afiliados. A pesar de ello, ninguno de los cursos mencionados han sido propuestos por las webs, siendo su introducción una decisión única del equipo de editores.

          

Database Administrator 3 (2nd Shift Database Administrator) - Salient CRGT - Martinsburg, WV

 Cache   
Seeking an intermediate to advanced MSSQL and MySQL Database Administrator for second shift (3:30 PM – midnight), full time work at the VA’s Network Operations…
From Salient CRGT - Wed, 13 Nov 2019 21:06:17 GMT - View all Martinsburg, WV jobs
          

Comment on Disaster Recovery Jackpot: Active/Active WAN-based Replication in GemFire vs Oracle and MySQL by Pinoy Lambingan

 Cache   
Thanks For Sharing,, Keep It Up.
          

FS#61443: [php] Unbuffered queries memory leak in mysqlnd

 Cache   
There should already be a fix for that (since 14 January 2019).

Would you please read here:

https://bugs.php.net/bug.php?id=77308

and here (for my older bugreport):

https://bugs.archlinux.org/task/61139?project=5&order=dateopened&sort=desc

Thank you in advance!
          

Client Management System using PHP & MySQL

 Cache   
none
          

SQLPro Studio 2019.63

 Cache   
SQLPro Studio 2019.63

A simple, powerful database manager for macOS - SQLPro Studio is the premium database management tool for Postgres, MySQL, Microsoft Management Studio and Oracle databases.
          

Install WordPress with LEMP on Ubuntu 18.04

 Cache   

What is LEMP? LEMP is a combination of Linux, Nginx, MySQL/MariaDB and PHP 7.2 which is used to deploy WordPress. This guide is only intend for single WordPress per... Read More ›

The post Install WordPress with LEMP on Ubuntu 18.04 appeared first on Gulshan Kumar.


          

MySQL 连接时尽量使用 127.0.0.1 而不是 localhost

 Cache   

原因

Whenever you specify “localhost” or “localhost:port” as server, the MySQL client library will override this and try to connect to a local socket (named pipe on Windows). If you want to use TCP/IP, use “127.0.0.1” instead of “localhost”. If the MySQL client library tries to connect to the wrong local socket, you should set the correct path as in your PHP configuration and leave the server field blank.

localhost 使用的 Linux socket,127.0.0.1 使用的是 tcp/ip

为什么我使用 localhost 一直没出问题

因为你的本机中只有一个 mysql 进程, 如果你有一个 node1 运行在 3306, 有一个 node2 运行在 3307

mysql -u root -h localhost -P 3306
mysql -u root -h localhost -P 3307

都会连接到同一个 mysql 进程, 因为 localhost 使用 Linux socket, 所以 -P 字段直接被忽略了, 等价于

mysql -u root -h localhost 
mysql -u root -h localhost 

而 -h 默认是 localhost, 又等价于

mysql -u root 
mysql -u root 

为了避免这种情况(比如你在本地开发只有一个 mysql 进程,线上或者 qa 环境有多个 mysql 进程)最好的方式就是使用 IP

mysql -u root -h 127.0.0.1 -P 3307

使用localhost地址的strace

strace mysql -h localhost -P 3306 -u root &> /tmp/strace_mysql.txt

结果:

execve("/opt/app/mysql/bin/mysql", ["mysql", "-h", "localhost", "-P", "3306", "-u", "root"], [/* 25 vars */]) = 0

......

socket(AF_LOCAL, SOCK_STREAM, 0)        = 3
connect(3, {sa_family=AF_LOCAL, sun_path="/tmp/mysql.sock"}, 110) = 0 // 这里
setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = -1 EOPNOTSUPP (Operation not supported)
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0

使用ip地址的strace

strace mysql -h 127.0.0.1 -P 3306 -u root &> /tmp/strace_mysql_use_ip.txt
execve("/opt/app/mysql/bin/mysql", ["mysql", "-h", "127.0.0.1", "-P", "3306", "-u", "root"], [/* 25 vars */]) = 0

....

socket(AF_INET, SOCK_STREAM, IPPROTO_TCP) = 3
connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0

之前遇到过这个问题,但是没有找到原因,今天看到网友分享了经验,记录下

转自: https://www.v2ex.com/t/623596


          

IT / Software / Systems: Full Stack Software Developer III - San Diego, California

 Cache   
RESPONSIBILITIES:Kforce has a client in search of a Full Stack Software Developer III in San Diego, California. (CA) Essential Duties: Work closely with product and development teams to create an amazing user experience. Build integration and unit tests along with code. Work in agile development environment with shirt sprints and standups. Implement proof of concept, prototypes and production-grade software. Maintain and support existing software and hardware systems, infrastructure and production. Assist support staff and team members in trouble-shooting software issues and implementing bug fixes. Takes ownership of the code base. Work to continually improve code quality, and get bugs fixed and deployed rapidly REQUIREMENTS: Experience in or knowledge of Python, Celery, Go, Elasticsearch, PostgreSQL, SaltStack, Flask, Git, React, Elixir Deep understanding and knowledge of virtualization (libvirt, KVM, Xenserver) Excellent communication and interpersonal skills Strong programming skills including software engineering methodologies and best practices REST/API development Strong experience with Python or other scripting languages Experience working in a Linux development environment Strong experience with relational databases, and specifically MySQL, Elasticsearch, Redis Excellent HTML, CSS and JavaScript skills Experience in consuming RESTful APIs Skills: API CSS DATABASES ELASTICSEARCH FLASK Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. ()
          

IT / Software / Systems: Staff Software Engineer - Particle Counting - Loveland, Colorado

 Cache   
Staff Software Engineer - Particle Counting North America-North America-United States-CO-Loveland Beckman Coulter s Particle Counting and Characterization business is growing and needs intelligent, hardworking skilled software engineers to work as part of our team to develop and deliver new products. You will apply modern development methodologies and new software technologies to create world class products. Work with cross-functional project teams to develop new products and sustain existing product lines. Are you an expert in building scalable systems, leading technical discussions, participating in code reviews and guiding the team in engineering best practices? Are you a highly technical, hands-on coder who will also provide technical guidance and thought leadership to team members? * Architect, design, implement and maintain software systems in a collaborative team environment to deliver products that change the world. * Ability to architect and build software from scratch as well as improve existing code * Provide strong technical leadership to the team. Lead architecture efforts to develop the technical road map of projects. * Work closely with less experienced software staff to design new software components. * Ensure design and code reviews, analysis of code components and code coverage of unit test cases. * Drive end-to-end quality with effective automation of unit level, component level and system level testing * Use user-centered design to deliver products that delight our customers. * Cultivate innovation. * Challenge status quo whilst supporting a world class product development life cycle. * Mentor and be mentored by your team members in development techniques and technologies. * Participate in the testing process through test review and analysis, test witnessing, and certification of software. Understand and apply automated test strategies to the entire development life cycle. * Gain experience with a broad range of software technologies and the ability to make technical choices objectively. * Participate in global development efforts. * Build relationships with peers across the business and uses these relationships to drive innovation. * Actively track developments in the software community and incorporate them where appropriate. * Provide input to the organization for strategic planning and technology. * Become savvy in new technologies by taking courses, learning from peers, or self-driven education * BS with 9+ years experience or MS with 7+ years experience in Computer Science, Computer Engineering or a related field * Familiarity with developing production software for desktop computing or embedded devices * Exceptional problem solving, critical thinking and communication skills * Relentless focus on optimizing time to market while increasing quality * Ability to find and share tools that optimize your work * We are agile, we inspire and embrace change, we expect that from you too Your experience includes a good set of these crucial skills * Experience architecting and building software from scratch * Experience in designing and developing complex framework and platform solutions with practical use of design patterns * Experience mentoring others * Ability to communicate software and system design * Automated testing * Automated software delivery pipelines * Continuous Integration * Ability to work with customers to understand their needs and translate them into successful solutions * User Experience (UX) / User Interface design and implementation * Excellent Communication and Presentation Skills * Modern software development methodologies including Agile and Scrum * 5+ years of experience with at least two of: C++, C#, Python or Typescript * Experience with the following is a plus: Ruby, Python, MVVM, WPF, MVC, Golang * Experience with technologies used on: Linux OS, Windows IoT and Desktop OS * Understanding of Localization and Internationalization Tools we use * Container services (Docker, Kubernetes, etc) * Maven, Jenkins, Git, Jira, Confluence * C#, C++, Typescript, Ruby, Python, CSS, HTML5 * Windows, Linux, AWS, .Net, Mono, QT * Frameworks such as Angular, React, NodeJS or GraphQL * Relational DB - MySQL, SQL Server, PostgreSQL * Machine learning * Numerical analysis Diversity & Inclusion At Danaher, we are dedicated to building and sustaining a truly diverse and inclusive culture. These are not just words on a page Diversity and Inclusion is a top priority for the company, and it ties deeply to each of our core values. Danaher Corporation and all Danaher Companies are equal opportunity employers that evaluate applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity, or other characteristics protected by law. #LI-SM1 Full-time ()
          

Dr.Web Enterprise Security Suite 12.0の Serverをアップデート

 Cache   

2019年11月28日

株式会社Doctor Web Pacific


Doctor Webは、Dr.Web Enterprise Security Suite 12.0の Server(REL-1200 201911180)をアップデートしました。今回のアップデートでは、発見されたエラーが修正されました。

次の変更が加えられました。

  • 複数のデバイスクラスあるいは複数のバスが同時に指定された場合、デバイスをブロックできない問題が解決されました。
  • MySQLまたはMariaDB データベース管理システムが利用されている場合、Dr.Web 11のServerをバージョン12へアップデートできない問題が解決されました。
  • Control Centerにて、端末またはグループを比較する時に発生する内部サーバーエラーが修正されました。
  • "var-root" および "home-root" フォルダがディスク上の異なる領域にある場合、Dr.Web Serverがアップデートできない問題が解決されました。
  • Office Controlクラスリストからブロック対象となる項目が正常に削除できないエラーが修正されました。
  • 保護される端末にて、製品のアップデートを不可能にしたエラーが修正されました。

アップデートはDr.Web Global Update System (Dr.Web GUS)経由で実行されます。


          

SENIOR Database Administrator - Remote Full time Position. ORACLE CERTIFICATION REQUIRED

 Cache   
Category: Database Administration, Database Programming, MySQL, Oracle, SQL
Budget: $750 - $1500 USD

The ideal candidate will have the ability to work independently or under only general direction in a fast-paced and flexible environment with tight deadlines and changing priorities. The candidate must...
          

import a mysql dump file to SQL SERVER DB from management studio

 Cache   
Category: Database Administration, Microsoft SQL Server, MySQL, SQL
Budget: $10 - $30 USD

It is just a 3.2M small file, and you need have a tool to covert mysql dump file to SQL SERVER DUMP format, you need know both mysql and SQL SERVER well
          

The Premium 2020 Learn to Code Certification Bundle

 Cache   

Taught by a professional boot camp instructors, this eLearning bundle is covering up-to-date and relevant topics to today's developer industry. Learn Python, Java, Web Developent, Django, JavaScript, MySQL and more.

The post The Premium 2020 Learn to Code Certification Bundle appeared first on Indie Game Bundles.


          

Discussion: MySQL DBA required in Minneapolis

 Cache   
We are currently hiring for the below mentioned role in our organization.

If interested, please send your resume to jobs at systemsinmotion.com

Position: MySQL DBA
Location: Minneapolis, MN
Duration: Long term (1+ year)

Mentioned below is the...

Join this discussion.


          

DBeaver 6.3.0

 Cache   
Versie 6.3.0 van DBeaver is uitgekomen. Met dit programma kunnen databases worden beheerd. Het kan onder andere queries uitvoeren, en data tonen, filteren en bewerken. Ondersteuning voor de bekende databases, zoals MySQL, Oracle, DB2, SQL Server, PostgreSQL, Firebird en SQLite, is aanwezig. Het is verkrijgbaar in een CE- en EE-smaak, waarbij de eerste zonder kosten als open source te gebruiken is. De enterprisesmaak voegt ondersteuning van verschillende nosql-databases toe, zoals MongoDB, Apache Cassandra en Apache Hive, en bevat verder extra plug-ins en jdbc-drivers. In deze uitgave zijn de volgende veranderingen en verbeteringen doorgevoerd: Changes in DBeaver 6.3.0:
          

Webbased Introduction To Programming Essential Algorithms Syntax And Control Structures Using Php Html And Mysql Third Edition By Mike Okane 20140107

 Cache   
Webbased Introduction To Programming Essential Algorithms Syntax And Control Structures Using Php Html And Mysql Third Edition By Mike Okane 20140107
          

【教程】杰奇2.4仿有度小说整站源码,大气模板自适应手机端,最新关关采集器3.5+采集

 Cache   
php5.6+Mysql(环境配置为锦尚中国版主调试时的配置 请严格按照配置环境要求运行 注意:关关采集器采集的时候需要在win服务器下执行,或者本地执行要远程链接到你服务器的数据库,所以如果有条件直接使用win系统服务器来装此套程序! 第1步.先用软件edi ...
          

【教程】精仿糗事百科笑话网站源码+6套PC端模板+WAP手机端 ThinkPHP内核

 Cache   
php5.6+Mysql(环境配置为锦尚中国版主调试时的配置 请严格按照配置环境要求运行 注意:不要删除根目录下的bbs.52jscn.com快捷方式,以免报错,文件只存在网站目录下不会被别人看到更不会包含代码和后门,请放心!!!! 第1步.先用软件editplus或者note ...
          

DBA MySQL et Oracle - Technologies ExPretio - Montréal, QC

 Cache   
Mettre en place et contrôler les autorisations d'accès et les privilèges des différents utilisateurs BD. Collaborer avec les autres équipes (QA, DEV ET R&D)…
From Indeed - Thu, 28 Nov 2019 18:29:00 GMT - View all Montréal, QC jobs
          

Web Developer

 Cache   
OH-CINCINNATI, Graphet is seeking an experienced Web Developer with PHP development experience. The successful candidate will plan, design, create, manage, and test business applications using PHP, MySQL, and other Java servlet and stand-alone applications. Established in 2001, our company is growing due to increasing demand for our energy data mining services. We are looking for someone who is a self-starter an
          

Connection Timeout on remote DB connection (no replies)

 Cache   
I am trying to use the c++ connector to connect to a remote db I am running on a virtual linux box. I keep getting this error:

CDK Error: Connection attempt to the server was aborted. Timeout of 10000 milliseconds was exceeded

This is my code:

#include <mysqlx/xdevapi.h>
#include <iostream>

int main()
{
try {
Session sess("db", 33060, "<user>", "<password>");
}
catch (const Error & err)
{
std::cout << "ERROR: " << err << std::endl;
}
catch (std::exception & ex)
{
std::cout << "STD EXCEPTION: " << ex.what() << std::endl;
}
catch (const char* ex)
{
std::cout << "EXCEPTION: " << ex << std::endl;
}


It works perfectly fine when I connect to localhost instance of mysql so I am not sure what the problem is. I can also connect to the remote db with mysql workbench so..?
          

get_driver_instance is unresolved (2 replies)

 Cache   
I'm building a small MySQL app with VS 2019. I'm linking against the X64 debug binaries and explicitly including mysqlcppconn8-static.lib. The app makes many calls to connector api's, but get_driver_instance is the only one that turns up as unresolved.

I've noted that this problem has recurred with many connector releases over the years. Could someone at Oracle PLEASE figure out why and fix it permanently? In the meantime, I'd like a workaround (if there is one) so I can continue development?
          

Post is not appearing in topic list (no replies)

 Cache   
The topic title is: Static build of connector fails with C2079 mysqlx_row_struct not defined

I can see the post in my Follow Topics list but it has the date 12/31/1969. How do I get this to show in the topic list?
          

read access violation in xdevapi 8.0.17 (2 replies)

 Cache   
I keep seeing an access violation in the MySQL dll. It appears to be random, not 100% of the time, but happens frequently. Originally I thought that I was allowing the session to be destroyed before the results, but I created a small wrapper to ensure that results are always destroyed before the session.

Here's the snippet of my most relevant code. I'm not sure that this is the function that's failing (unfortunately putting breakpoints in changes the timing enough that it significantly reduces the chances of this happening.) You can see that I create move-construct the session into a shared_ptr, construct the Statement for later execution, pass the shared_ptr to query which executes the statement on a thread in my thread pool, and pack the results into a shared pointer (since results don't seem to be copyable but are movable) and a copy of the shared_ptr to the session into a simple result wrapper. The wrapper exists to be copyable and to ensure that the last shared_ptr to the results is released before the last shared_ptr to the session, ensuring that the session's lifespan is longer than the results. I'm not sure all this should strictly speaking be necessary, but I've been chasing this null pointer exception for a while and since the null pointer being dereferenced is the session, I sort of assumed that I was allowing the session to be destroyed before the results. Maybe there's a bug in this code, but it ought to guarantee that the session is not destroyed before the results, and indeed when I look at it in my debugger my session shared pointer is valid.

template< typename Result >
class result_ptr
{
public:
using result_t = Result;

private:
std::shared_ptr< result_t > Result_;
std::shared_ptr< msx::Session > Session_;

public:
result_ptr( ) { }

result_ptr( result_t && result, decltype( Session_ ) session ) :
Result_( std::make_shared< result_t >( std::move( result ) ) ),
Session_( session )
{ }

~result_ptr( )
{
Result_.reset( );
Session_.reset( );
}

result_ptr( result_ptr && ) = default;
result_ptr( result_ptr const & ) = default;

result_ptr & operator=( result_ptr && ) = default;
result_ptr & operator=( result_ptr const & ) = default;

auto & operator*( ) const noexcept
{
return *Result_;
}

auto operator->( ) const noexcept
{
return Result_.get( );
}
};

template< typename Exec >
inline auto query( ContextId const &, std::shared_ptr< msx::Session > session, Exec statement ) -> ppl::task< result_ptr< decltype( statement.execute( ) ) > >
{
return ppl::create_task(
[session, s = std::make_shared< Exec >( std::move( statement ) )]( )
{
try
{
return result_ptr< decltype( s->execute( ) ) >( s->execute( ), session );
}
catch( std::exception const & ex )
{
so::cout << ex.what( ) << "\n";
throw;
}
} );
};

ppl::task< std::vector< TaskId > > MySQLQueue::getReadyTasks(
ContextId const & contextId,
unsigned int const limit )
{
using result_type = decltype( u::query( contextId, std::shared_ptr< msx::Session >( ), Client_.getSession( ).getSchema( "" ).getTable( "" ).select( ) ) )::result_type;

auto session = std::make_shared< msx::Session >( Client_.getSession( ) );

return u::query(
contextId,
session,
session->getSchema( SchemaName_ ).getTable( TableName_
).select(
info::column::select[info::column::_id]
).where(
"state = :state AND processAfter < :processAfter"
).limit(
limit
).bind( std::map< std::string, std::string >{
{ "state", Info::State::String[Info::State::Created] },
{ "processAfter", utility::time_point_to_string( clock::now( ) ) } }
)
).then(
[]( result_type const & res )
{
std::vector< TaskId > rv;
rv.reserve( res->count( ) );

std::transform(
res->begin( ),
res->end( ),
std::back_inserter( rv ),
[]( msx::Row && row ) -> TaskId
{
return std::to_string( row[0].get< uint64_t >( ) );
} );

return rv;
} );
}

I cannot figure out why this is resulting in an access violation. The AV error message when the exception is trapped is:

Exception thrown: read access violation.
this->m_session was nullptr.

You can see from the call stack that the AV is actually buried pretty deep in the MySQL dll:

mysqlcppconn8-2-vs14.dll!cdk::mysqlx::Reply::has_results() Line 132 C++
mysqlcppconn8-2-vs14.dll!cdk::mysqlx::Reply::discard() Line 102 C++
mysqlcppconn8-2-vs14.dll!cdk::mysqlx::Reply::~Reply() Line 59 C++
mysqlcppconn8-2-vs14.dll!cdk::Reply::~Reply() C++
mysqlcppconn8-2-vs14.dll!cdk::Reply::`scalar deleting destructor'(unsigned int) C++
mysqlcppconn8-2-vs14.dll!mysqlx::abi2::r0::common::Result_impl::~Result_impl() Line 181 C++
mysqlcppconn8-2-vs14.dll!mysqlx::abi2::r0::common::Result_impl::`scalar deleting destructor'(unsigned int) C++
mysqlcppconn8-2-vs14.dll!mysqlx::abi2::r0::internal::Result_detail::~Result_detail() Line 493 C++
cgrmerge.exe!mysqlx::abi2::r0::internal::Result_common<mysqlx::abi2::r0::internal::Result_detail>::~Result_common<mysqlx::abi2::r0::internal::Result_detail>() C++
cgrmerge.exe!mysqlx::abi2::r0::Result::~Result() C++
cgrmerge.exe!mysqlx::abi2::r0::Result::`scalar deleting destructor'(unsigned int) C++
cgrmerge.exe!std::_Destroy_in_place<mysqlx::abi2::r0::Result>(mysqlx::abi2::r0::Result & _Obj) Line 322 C++
cgrmerge.exe!std::_Ref_count_obj2<mysqlx::abi2::r0::Result>::_Destroy() Line 1506 C++
cgrmerge.exe!std::_Ref_count_base::_Decref() Line 652 C++
cgrmerge.exe!std::_Ptr_base<mysqlx::abi2::r0::Result>::_Decref() Line 883 C++
> cgrmerge.exe!std::shared_ptr<mysqlx::abi2::r0::Result>::~shared_ptr<mysqlx::abi2::r0::Result>() Line 1133 C++
cgrmerge.exe!std::shared_ptr<mysqlx::abi2::r0::Result>::reset() Line 1178 C++
cgrmerge.exe!utility::result_ptr<mysqlx::abi2::r0::Result>::~result_ptr<mysqlx::abi2::r0::Result>() Line 60 C++
cgrmerge.exe!pplx::details::_ResultHolder<utility::result_ptr<mysqlx::abi2::r0::Result>>::~_ResultHolder<utility::result_ptr<mysqlx::abi2::r0::Result>>() C++
cgrmerge.exe!pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>::~_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>() Line 2432 C++
cgrmerge.exe!pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>::`scalar deleting destructor'(unsigned int) C++
cgrmerge.exe!std::_Destroy_in_place<pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>>(pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>> & _Obj) Line 322 C++
cgrmerge.exe!std::_Ref_count_obj2<pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>>::_Destroy() Line 1506 C++
cgrmerge.exe!std::_Ref_count_base::_Decref() Line 652 C++
cgrmerge.exe!std::_Ptr_base<pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>>::_Decref() Line 883 C++
cgrmerge.exe!std::shared_ptr<pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>>::~shared_ptr<pplx::details::_Task_impl<utility::result_ptr<mysqlx::abi2::r0::Result>>>() Line 1133 C++
cgrmerge.exe!pplx::task<utility::result_ptr<mysqlx::abi2::r0::Result>>::_ContinuationTaskHandle<utility::result_ptr<mysqlx::abi2::r0::Result>,utility::result_ptr<mysqlx::abi2::r0::Result>,`ScheduledTask::MySQLQueue::recover'::`2'::<lambda_1>,std::integral_constant<bool,0>,pplx::details::_TypeSelectorAsyncTask>::~_ContinuationTaskHandle<utility::result_ptr<mysqlx::abi2::r0::Result>,utility::result_ptr<mysqlx::abi2::r0::Result>,`ScheduledTask::MySQLQueue::recover'::`2'::<lambda_1>,std::integral_constant<bool,0>,pplx::details::_TypeSelectorAsyncTask>() Line 3871 C++
cgrmerge.exe!pplx::task<utility::result_ptr<mysqlx::abi2::r0::Result>>::_ContinuationTaskHandle<utility::result_ptr<mysqlx::abi2::r0::Result>,utility::result_ptr<mysqlx::abi2::r0::Result>,`ScheduledTask::MySQLQueue::recover'::`2'::<lambda_1>,std::integral_constant<bool,0>,pplx::details::_TypeSelectorAsyncTask>::`scalar deleting destructor'(unsigned int) C++
cgrmerge.exe!pplx::details::_AutoDeleter<pplx::details::_TaskProcHandle>::~_AutoDeleter<pplx::details::_TaskProcHandle>() Line 99 C++
cgrmerge.exe!pplx::details::_TaskProcHandle::_RunChoreBridge(void * _Parameter) Line 117 C++
cpprest141d_2_10.dll!pplx::details::_Scheduler_Param::DefaultWorkCallback(struct _TP_CALLBACK_INSTANCE *,void *,struct _TP_WORK *) Unknown
ntdll.dll!TppWorkpExecuteCallback() Unknown
ntdll.dll!TppWorkerThread() Unknown
kernel32.dll!BaseThreadInitThunk?() Unknown
ntdll.dll!RtlUserThreadStart?() Unknown

Any help would be greatly appreciated.
          

Microsoft C++ Exception std::out_of_range mysql-connector-c++-8.0.18-winx64 (5 replies)

 Cache   
Visual Studio 2019 Pro
mysqld.exe 8.0.17 x64
I am using mysqlcppconn8-static.lib, downloaded from MySQL site.

This is not a fatal exception, the query result is correct. The exception appears to be thrown every time that the code reads the database. I have not seen the exception occur when writing to the database.

Code to reproduce the error:
MySQLTest()
{
mysqlx::Session session( DATABASE_URL );
mysqlx::RowResult result;
mysqlx::Row row;
mysqlx::Value value;
std::wstring path;
int id;

result = session.getSchema( DATABASE_SCHEMA_CONFIGURATION ) // Expands to L"schema_name"
.getTable( L"resource_paths" )
.select( L"id", L"path" )
.execute();
if( row_count > 0 )
{
row = result.fetchOne();
while( !row.isNull() )
{
size_t col_count = row.colCount();
value = row[0]; // throws std::out_of_range, value contains correct data
id = GetResourceIdFromDBString( static_cast<std::wstring>( value ) ); // Convert string id to numeric id
value = row[1]; // throws std::out_of_range, value contains correct data
path = static_cast<std::wstring>( value );
// Do some interesting stuff with the path
row = result.fetchOne();
}
}
}

It appears that the exception originates with mysqlx::Value& Row_detail::get_val(mysqlx::col_count_t pos) in result.cc but I do not have the pdb files to be able to trace it all the way. I have traced it to Value& get(col_count_t pos) in include\mysqlx\devapi\row.h

Thank you.
          

MYSQL : ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

 Cache   
none
          

MYSQL ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

 Cache   
none
          

MYSQL: [Warning] Using a password on the command line interface can be insecure.

 Cache   
none
          

MYSQL:mysqldump: Error: Binlogging on server not active

 Cache   
none
          

MYSQL : [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead.

 Cache   
none
          

MySQL核心参数优化

 Cache   
back_log参数的作用 指定MySQL可能的TCP/IP的连接数量(一个TCP/IP连接占256k),默认…
          

0026389: Steps to reproduce - Error 403 forbidden - When fill in the words user add & select in steps to reproduce.

 Cache   
We are using Mantis in our company for testing an application.<br /> When registering a bug we disocover a bug in MANTISBT. It is not possible to save these steps to reproduce:<br /> 1. Select any territory 2. Click on Add User 3. Click on Show Me More<br /> <br /> Always there will be an error 403 at Google Chrome & Firefox...<br /> <br /> MantisBT Version 2.22.1<br /> Schema Version 209<br /> PHP Version 7.2.24<br /> Database Driver mysqli<br /> Database Version, Description 10.3.17, 10.3.17-MariaDB
          

Application Architect - Dow Technologies and Systems - Casper, WY

 Cache   
Used Java Persistence API entities and Mybatis to interact with MySQL databases. Built Java entities representing database tables and worked on systems managing… $7,000 - $7,500 a month
From Indeed - Fri, 18 Oct 2019 06:09:57 GMT - View all Casper, WY jobs
          

Administration - Installation - Core: Re: Ilias on IIS and MSSQL

 Cache   
Hallo Andreas,

ja, du kannst ILIAS mit IIS und MSSQL zum laufen bringen.

Halte dich einfach an die offizielle Linux Installationsanleitung hier auf ilias.de und münze das ganze dann auf die Windows Welt um.

Wir haben 2 Windows Server 2012 R2 mit IIS, MySQL Community und SMTP am laufen.
Ebenfalls PHP 7.1, Java 9, PhantomJS, ImageMagick mit ffmpeg, zip, unzip und node.

Damit bist du dann auch in der Lage die Lucence Suche und den chat laufen zu lassen die du als Services einbinden kannst.


          

Software Programmierer als Frontend-Entwickler HTML / CSS / Javascript (no replies)

 Cache   
BIEDERMANN UND BRANDSTIFT GmbH ist eine auf den Fashion- und Lifestyle-Bereich spezialisierte Kreativagentur für digitale Markenvisualisierung. Zu unseren Projekten gehören Webseiten, E-Commerce, E-Learning sowie weitere digitale Tools. Unser Qualitätsverständnis teilen wir unter anderem mit Kunden wie: TOMMY HILFIGER, HUGO BOSS AG, GEORGE GINA & LUCY, WORMLAND, GERRY WEBER etc.

Für unseren Firmensitz in Frankfurt suchen wir zur Verstärkung unseres Teams ab sofort

Software Programmierer als Frontend-Entwickler HTML / CSS / Javascript

Entwickler sind bei uns integraler Bestandteil des Prozesses und werden bereits früh in ein Projekt eingebunden. Unser hochmotiviertes und interdisziplinäres Team ermöglicht es Dir, Deine Fähigkeiten und Talente voll einzubringen. Unsere unterschiedlichen Projekte und Ansätze garantieren einen abwechslungsreichen Job und viel gegenseitiges Lernen.

Wir erwarten sehr gute Kenntnisse in:
HTML5 / CSS
Javascript
jQuery

Optimalerweise bringst Du auch Kenntnisse in PHP 5.x, MySQL und SVN mit.

contactsoftcore@biedermannundbrandstift.com
http://meridiasprzedam.plom.pl/
          

Contractor - Mphasis - Bengaluru, Karnataka

 Cache   
Java Technologies - JAVA-JAVA J2EE /SPRING/RESTFUL/ SOAP/ANGULARJS/NODEJS/RDBMS/NOSQL (MONGODB/CASSANDRA/MYSQL).
From Mphasis - Wed, 06 Nov 2019 12:29:21 GMT - View all Bengaluru, Karnataka jobs
          

Front-End Engineer

 Cache   
Job DescriptionJoin Hired and find your dream job as a Front-End Engineer at one of 10,000+ companies looking for candidates just like you. Companies on Hired apply to you, not the other way around. You''ll receive salary and compensation details upfront? - before the interview - and be able to choose from a variety of industries you''re interested in, to find a job You''ll love in less than 2 weeks. As a Front-End Engineer, you''ll be responsible for implementing the interactive and visual elements of web and mobile applications. You''ll collaborate with the team of UX designers and back-end engineers in delivering intuitive layouts. You''ll also be responsible for translating the needs of our company and clients into appealing applications. If you enjoy writing code and creating user-friendly layouts, this job is a good fit for you. We value a diversity of perspectives and encourage healthy discussion and debate, but unite behind our decisions. Responsibilities Creating clean code Ensuring cross-browser compatibility Building a library for future use Optimizing applications for scalability and speed Acting as a mentor to junior developers, through code reviews and design document critiques Creating prototypes and quality mockups What Skills 2+ years experience in front-end development 2+ years of recent experience building pages in Javascript (ES6), HTML, and CSS Experience working with a javascript framework such as React.js or equivalent Solid understanding of JavaScript frameworks Exemplary communication skills; able to map problem-solution space and explain possible solutions to non-technical team members Good skill with Adobe suite, including Illustrator and Photoshop Familiarity with content management systems, including WordPress, Drupal and Joomla Understand of layout aesthetics Solid understanding of SEO principles Passion for learning new technologies fast B.S. degree in Computer science, Software Engineering or a related field, or equivalent experience These Would Also Be Nice Experience with backend development Experience with analytics tools like Google Analytics or Mixpanel Experience with various database systems, both in production and warehousing capacities, such as MySQL, PostgreSQL, and Redshift Experience with server-side languages such as Ruby on Railsby Jobble
          

MongoDBであるメリットが無くなってしまったのでMySQLに移行したはなし – KAYAC engineers’ blog

 Cache   
SREチームの長田です。 この記事はTech Kayac Advent Calendar Migration Track 1日目の記事です。 今回はLobiで使用していたMongoDBをMySQLに移行したはなしです。 MongoDBを何に使っていたか DAUなどのKPIレポートや、サービスの状況を把握するための各種集計結果を保存するために使っていました。 サービス開始直後は......
          

Create class for checking id on group migration

 Cache   

Hi,
I need to migrate d7 organic group to d8 group.
But I need to check if the d7 group was public or private for adding into different d8 group type.
Here is my yml file in my migration module
 

langcode: fr
status: true
dependencies: {  }
id: upgrade_upgrade_d7_node_groupe
class: Drupal\migrate\Plugin\Migration
field_plugin_method: null
cck_plugin_method: null
migration_tags:
  - 'Drupal 7'
  - Content
migration_group: migration_intranet
label: 'Migration des groupes'
source:
  key: drupal_7
  database:
    driver: mysql
    username: almedest_admin
    password: *****
    host: localhost
    port: ''
    database: almedest_digitalgreta_intranet_drupal7
    prefix: null
  plugin: d7_node
  node_type: groupe
process:
  id:
    -
      plugin: get
      source: tnid
  label:
    -
      plugin: get
      source: title
  status:
    -
      plugin: get
      source: status
  created:
    -
      plugin: get
      source: created
  changed:
    -
      plugin: get
      source: changed
  field_groupe_descriptif:
    -
      plugin: get
      source: field_groupe_descriptif
  field_groupe_image:
    -
      plugin: sub_process
      source: field_groupe_image
      process:
        target_id: fid
        alt: alt
        title: title
        width: width
        height: height
  field_group_archiver:
    -
      plugin: get
      source: field_group_archiver
  type:
    plugin: default_value
    default_value: prive
destination:
  plugin: 'entity:group'

      

the D8 group type is "public" or "prive".
So I need to create class which can access the d7 database (define in the yml) on the field_data_group_access table, check the group_access_value value.
If the value is 1 the d8 group will be prive type , 0  it will be public type.
Can you explain how can I achieve this?

Drupal version: 

          

为团队寻找后端开发工程师(招聘)

 Cache   

写在前面

程序员是“活到老学到老”的践行者,无论是前端开发者还是后端开发者,都是如此。希望你也是这样的程序员。

再加入当前的公司(上海·桂林路)后,随着公司业务逐渐展开,发现团队里的事情也多起来了,因此开贴找一起共事一起学习的同事。

后端开发工程师

职位描述:

  • 参与完成项目的系统分析、设计,并负责业务功能与底层基础功能的功能设计、代码实现。

希望你:

  • 有 2 年以上的后端开发经验;
  • 熟练使用 Java/Go/Python 中的一种或多种编程语言;
  • 了解并能熟练使用常见的数据库(Mysql、ElasticSearch、MongoDB、Redis 等);
  • 掌握计算机基本理论知识,包括基础网络、存储、算法等;
  • 如果自我感觉良好,可以不受上面条款的限制。

欢迎邮件(zhjw43@163.com)骚扰。


          

Check In System

 Cache   
Hi! I have a PHP 7.3 application that I would like developed. I have use cases modeled in UML and I will need all source code. You will be given a PHP Cpanel development environment with a domain name upon contract start that will be used as the hub for development... (Budget: $30 - $250 USD, Jobs: HTML, Javascript, Laravel, MySQL, PHP)
          

IT / Software / Systems: Full Stack Developer - Troy, Michigan

 Cache   
Full Stack Developer (Mid) - Permanent - Detroit, US Position Purpose Do you want to be part of building out next generation SaaS products that power the automotive industry? JATO is currently looking to hire Full Stack Developers (.NET) to join agile teams at our office in Downtown Detroit. As a Full Stack Developer, you will work in the product delivery team using your C# .NET skills to deliver platform increments, contributing to our value stream. Besides great salary and benefits, JATO offers a casual work environment, flexible work/life balance, and a creative work space with optional weekly events like happy hours, hackathons, and panel discussions. Main Responsibilities Learning and growing professionally while collaborating closely with experienced business/design/technology teammates.Having ownership in our products and our customers experiences, building features that can be implemented and deployed.Provide development support to QA, Business Analysis, and Product Management.Contribute toward the development of our next generation SaaS products Knowledge, Skills and Experience Required Technical Skills You know the fundamentals of .NET (C#) extremely wellYou have worked with consuming/calling REST API'sYou have experience with JavaScript/HTML/CSSYou have developed and deployed one or more Angular projects. (experience with AngularJS is a plus)You have worked with Source Control such as Team Foundation Server and GitYou have experience with relational databases such as SQL Server, MySQL, etcYou have knowledge of non-relational databases such as Mongo DB and Cosmos DBYou have knowledge of node JS and microservices architectureYou are familiar with agile programming methodologies Soft Skills Strong communication skillsStrong problem solving skillsContribute to our continuous efforts to improve our development infrastructure and processesPassionate about software engineering and constant learningDesire to help others improve through mentoringA good grounding in technical theory and practiceExperience in creating detailed support and technical materialAttention to detailRespond to tight deadlinesBeing a team player Please note all CVs must be submitted in English in order to be considered for the role. You must have the right to work and live in the US. PandoLogic. Keywords: Web Developer, Location: Troy, MI - 48099 ()
          

Middle Java Developer (Fin-Tech) в Levi9 Ukraine, Киев

 Cache   

Необходимые навыки

— Java 8.
— Spring: Core, MVC, Security, Data, Boot, Cloud.
— Microservices architecture understanding.
— Restful services (REST).
— Persistence frameworks: Hibernate, JPA.
— Application servers: Tomcat.
— RDBS: MySQL, Oracle
— Unit testing with JUnit and Mockito.
— Miscellaneous: Maven, Git.
— Docker.

Будет плюсом

— Messaging: ActiveMQ / JMS
— RAML
— Understanding of Event Sourcing, CQRS and DDD
— RDBS: MSSQL, Oracle.
— Apache Camel, EIP
— Application servers: Weblogic.
— Test-Driven-Development (TDD)
— AWS

Предлагаем

9 reasons to join us:

1. Frequent business trips to European countries;
2. Ability to create added value for yourself — We have specially equipped Levi9 laboratories (with 3D printers and other high-tech features) when you can work on you own startups or test any other crazy ideas;
3. Possibility to share knowledge on techtalks, meetups and conferences in different Levi locations and outside the company;
4. Your health support via compensation of sport activities, vacation policy and private medical insurance;
5. Financial and vacation support of your important life events (wedding, child birth etc.);
6. Democratic banking policy — you can cooperate with us through any legal Ukrainian bank you choose;
7. Work for industry leaders such as TomTom, Xerox, Swarco and others;
8. “Save time” principles. We promote Automation testing and innovation technologies to save the most precious resource — your time.
9. No micromanagement. We are free birds with clear understanding what the high performance is!

Обязанности

As a Middle Java Developer, you will be working on a product that’s used by millions of people around the world, improving existing elements and trying new technologies.

О проекте

Client: is an international Dutch company delivering an omni channel banking services

Backbase is a creator of Omni-Channel Banking Platform, a state-of-the-art digital banking software solution that unifies data and functionality from traditional core systems and new fintech players into a seamless, digital customer experience.

Project: Widget written on a different frameworks to work on sole portal.

A distributed scrum team with developers in the Netherlands and Ukraine.


          

IT / Software / Systems: sr full stack developer - Lehi, Utah

 Cache   
Sr. Full Stack Dvlpr Xactware Lehi UT 84043 Perform full-stack devlpmt, lead feature defntn process in collabrtn product teams. Create qlty code to implemnt desgns & fix bugs. Perfrm UI coding w TypeScript, JavaScript, CSS SCSS, Angular or similar. Perfrm servr devlpmt to implemnt features w C# (Java, Python, PHP equivalents), ASP.NET Core or ASP.NET Core equivss in other languages (Spring for Java; Django, Flask for Python; Zend, Laravel, CakePHP, Fat-free for PHP), MongoDB (CouchDB, Cassandra, other NoSQL database equivalents) PostgreSQL (MySQL, SQL Server, SQLite, Microsoft SQL equivalents), and Powershell (cmd, bash equivalents). Req. Bach degree or for eqvlnt in CompSci, Info Sys or reltd & 4 yrs exp devlpg w HTML5, CSS, JavaScript. 3 yrs w Angular or equiv. 1 yrs w following back-end techn: C# or equiv; ASP.NET Core or equiv; MongoDB or other NoSQL DB equiv; PostgreSQL or equiv. 1 yr w deploy infrastrct & pipeln & prod deploy. 1 yr dev mobile-optmz web apps. 1 yr with cross-browsr compatblty. Dem knowl of design API's; Consum RESTfl svc; Agile/Scrum methd; writg effctv unit tests. Resumes: Xactware attn: R. Rupp, Ref #X9, 1100 W Traverse Pkwy Lehi UT 84043 recblid 8zbu19cs3nnt8eqzc6aqcu8hjux4w1 ()
          

LNMP与LAMP有什么区别?到底安装哪一个好?

 Cache   

很多小白对服务器的网站环境,不知道是装apache好,还是装nginx好,下面为大家科普相关知识。

LAMP 的全称是linux + apache + mysql +php

LNMP 的全称是linux + nginx + mysql + php (国外喜欢简称为LEMP,搜英文资料需要搜LEMP)

LAMP:使用的是Apache,Apache是世界是用排名第一的Web服务器软件,其几乎可以在所有广泛使用的计算机平台上运营,由于其跨平台和安全性被广泛使用,是最流行的Web服务端软件之一。

LNMP:使用的是Nginx,Nginx是一款高性能额Http和反向代理服务器,也是一个AMAP/POP3/SMTP服务器,Nginx是由Igor Sysoev为俄罗斯访问量第二的Rambler.ru站点开发的,第一个公开版本0.1.0发布于2004年10月4日,2011年6月1日,nginx 1.0.4发布。

扩展资料:

1、LNMP方式的优点:占用VPS资源较少,Nginx配置起来也比较简单,利用fast-cgi的方式动态解析PHP脚本。缺点:php-fpm组件的负载能力有限,在访问量巨大的时候,php-fpm进程容易僵死,容易发生502 bad gateway错误。

2、基于 LAMP 架构设计具有成本低廉、部署灵活、快速开发、安全稳定等特点,是 Web 网络应用和环境的优秀组合。若是服务器配置比较低的个人网站,当然首选 LNMP 架构。当然,在大流量的时候。把Apache和Nginx结合起来使用,也不失为一个不错选择。

Nginx 特性

Nginx 性能稳定、功能丰富、运维简单、处理静态文件速度快且消耗系统资源极少。

1、相比 Apache,用 Nginx 作为 Web 服务器:使用资源更少,支持更多并发连接,效率更高。

2、作为负载均衡服务器:Nginx 既可在内部直接支持 Rails 和 PHP,也可支持作为 HTTP 代理服务器对外进行服务。Nginx 用 C 编写而成, 不论是系统资源开销还是 CPU 使用效率都比 Perlbal 要好的多。

3、作为邮件代理服务器:Nginx 同时也是一款非常优秀的邮件代理服务器(最早开发这个产品的目的之一,是作为邮件代理服务器)。

4、反向代理可以根据url将请求转向于不同用途的集群,比如图片请求,转向图片服务器集群;视频请求,转身视频服务器集群。nginx是一款轻量级的web服务器/反向代理服务器/电子邮件代理服务器,安装非常简单,配置文件也很简洁(还支持 perl 语法)。Nginx 支持平滑加载新配置,还能够在不间断服务的情况下进行软件版本升级。

Apache 特性

1、Apache 是 LAMP 架构最核心的 Web Server,开源、稳定、模块丰富是 Apache 的优势。但 Apache 的缺点是有些臃肿,内存和 CPU 开销大,性能上有损耗,不如一些轻量级的 Web 服务器(譬如:Nginx、Tengine等)高效,轻量级的 Web 服务器对于静态文件的响应能力来说远高于 Apache 服务器。

2、Apache 做为 Web Server 是负载 PHP 的最佳选择,如果流量很大的话,可以采用 Nginx 来负载非 PHP 的 Web 请求。Nginx 是一个高性能的 HTTP 和反向代理服务器,Nginx 以其稳定、丰富功能集、示例配置文件和低系统资源的消耗而闻名。Nginx 现能支持 PHP 和 FastCGI,也支持负载均衡和容错,可和 Apache 配合使用,是轻量级的 HTTP 服务器的首选。

3、Web 服务器缓存也有多种方案,Apache 提供了自己的缓存模块,也可以使用外加的 Squid 模块进行缓存,这两种方式均可有效提高 Apache 的访问响应能力。Squid Cache 是一个 Web 缓存服务器,支持高效缓存,可作为网页服务器的前置 cache 服务器缓存相关请求以提高 Web 服务器速度。把 Squid 放在 Apache 的前端来缓存 Web 服务器生成动态内容,而 Web 应用程序只需要适当地设置页面实效时间即可。如访问量巨大,则可考虑使用 memcache 作为分布式缓存。

4、PHP 的加速可使用 eAccelerator 加速器,eAccelerator 是一个自由开放源码的 PHP 加速器。它会优化动态内容缓存,提高 PHP 脚本缓存性能,使 PHP 脚本在编译状态下,对服务器的开销几乎完全消除。它还可对脚本起优化作用,以加快其执行效率。 使 PHP 程序代码执效率可提高 1-10 倍。

至于安装哪个好呢?

1、要省内存的话LNMP是最好的选择,但似乎不太稳定,有时会比较常出现50状态。

2、静态内容比较多用的话,可以使用LNMP还是不错的。

3、动态内容多的话,推荐使用LAMP还是最稳定的。


          

Web Developer

 Cache   
OH-CINCINNATI, Graphet is seeking an experienced Web Developer with PHP development experience. The successful candidate will plan, design, create, manage, and test business applications using PHP, MySQL, and other Java servlet and stand-alone applications. Established in 2001, our company is growing due to increasing demand for our energy data mining services. We are looking for someone who is a self-starter an
          

[原]Beats:Beats在Kibana中的集中管理

 Cache   

我们可以通过在命令行中对我们的Beats进行管理,比如我们可以启动metric几个模块,我们可以通过如下的命令来执行:

./metricbeat modules enable apache mysql

上面的命令启动apache mysql模块。我们也许觉得这个这样做很方便。但是如果我相对许多的机器(比如几千部机器)来做这样的管理,可能也很麻烦,这是因为我们需要到每一台机器上重复做同样的动作。如果我们需要有改动的话,那么需要对每一台机器再次执行同样的操作。那么有什么办法可以帮助我们减少这个工作量呢?

Elastic在Kibana中做进去一个新的功能:集中管理。Beats中央管理使用一种称为配置标签的机制来对相关配置进行分组。 注册第一个Beat后,您可以在Kibana的中央管理UI中定义配置标签。

Beats集中管理是6.5版带来的功能。 出于安全考虑,此功能在Elastic Gold许可证或使用我们的Elastic Cloud服务的Standard许可证下可用,以确保正确保护部署。 它包含Kibana中新的Beats中央管理UI,并利用Elasticsearch作为集中式配置存储。 在不久的将来,我们还计划公开一个API,以便更轻松地与外部工具和系统集成。

下面我来展示如何使用Beats的集中管理。

 

准备工作

就像我上面提到的,我们必须购买Elastic Gold才可以拥有这样的功能。为了测试这个功能,我们可以接受30天尝试,这样我们就可以开始我们的测试了。

我们首先点击Kibana中的Management,让后选择30天尝试。当我们接受完条件后,我们可以看到:

大家一定可以看到左边的列表会多了一个叫做Beats的种类,并在其下面有一个叫做Central Management的项。我们点击Central Management:

它显示我们的安全没有打开,也就是说,这个功能必须配合安全功能才能启用。我们参照我之前的文章“Elasticsearch:设置Elastic账户安全”来启动安全功能。我们使用elastic账号进行登录:

我们可以看到一个对话框想,提示我们Enroll Beat。点击这个按钮。

目前我们看到有两个Beats:Filebeat及Metricbeat可以供我们来选择。我们来选择Metricbeat来做一些实验。同时在Platform中选择自己喜欢的平台:

争夺我们的情况,我选择MacOS。

由于需要使用到Metricbeat。我们需要参照我之前的文章“Elastic Beats介绍”来安装我们的Metribeat。同时在我们的Terminal中打入从Copy Command处拷贝来的命令:

这个时候在我们的Kibana中会显示:

在上面显示了我的hostname以及metricbeat的版本信息。我们接下来选择Continue按钮:

我们可以选一个我们喜欢的Tag Name和自己喜欢的颜色。在上面我选择了Local表明我的这个Metricbeat是在本地运行的。这样以后我们能很容易地找到我们的这个机器的配置。我们点击Add configuration block按钮:

我们可以选择我们的模块,并选择喜欢额module。最后选择Save按钮。再接着选择Save & Continue按钮:

最终我们完成了:

在上面的画面中选择Done

我们可以看出来我们已经成功地配置好我们的Metricbeat模块了。上面显示Config Status是Offline状态。我们可以在我们的Terminal中打入如下的命令(在Metricbeat的安装目录中):

./metricbeat run

 

我们再重新刷新我们的Kibana界面:

从上面我们可以看出来我们的metricbeat已经在成功运行了。当然我们也可以找到相应的index。按照同样的方法,我们可以对其它的模块来进行配置。

 

参考:

【1】https://www.elastic.co/guide/en/beats/filebeat/current/how-central-managment-works.html

【2】https://www.elastic.co/blog/introducing-beats-central-management-in-the-elastic-stack

作者:UbuntuTouch 发表于 2019/11/30 12:36:38 原文链接 https://blog.csdn.net/UbuntuTouch/article/details/103322686
阅读:18

          

CKEditor - WYSIWYG HTML editor: Errors after update from 7.x-1.16 to 7.x-1.17

 Cache   

I use standalone ckeditor-7.x-1.17 and video_filter-7.x-3.3, and read README.txt in video_filter/editors/ckeditor:

3. Go to "Plugins" on the same page. Enable the video filter plugin.

I made that:
1. Copy video_filter/editors/ckeditor to ckeditor/plugins (for looking "Plugin for inserting video tags with video_filter" in "Plugins" ckeditor setting). This working for video_filter 3.1
2. On page /admin/config/content/ckeditor/edit/Full I have errors:

Warning: strpos() expects parameter 1 to be string, array given в функции ckeditor_load_plugins() (строка 342 в файле /sites/all/modules/contrib/ckeditor/includes/ckeditor.lib.inc).
Warning: preg_match() expects parameter 2 to be string, array given в функции ckeditor_load_plugins() (строка 342 в файле /sites/all/modules/contrib/ckeditor/includes/ckeditor.lib.inc).
Notice: Array to string conversion в функции ckeditor_load_plugins() (строка 343 в файле /sites/all/modules/contrib/ckeditor/includes/ckeditor.lib.inc).
Notice: Array to string conversion в функции ckeditor_toolbar_buttons_all() (строка 1765 в файле /sites/all/modules/contrib/ckeditor/includes/ckeditor.admin.inc).
Warning: Illegal offset type in isset or empty в функции locale() (строка 713 в файле /modules/locale/locale.module).
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'Video filter' AND s.context = '' AND s.textgroup = 'default'' at line 1: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source_0, :source_1 AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => ru [:context] => [:source_0] => video_filter [:source_1] => Video filter ) в функции locale() (строка 720 в файле /modules/locale/locale.module).

          

IT / Software / Systems: Senior Software Engineer (PHP) - El Segundo, California

 Cache   
OceanX is the only all-in-one membership platform partnering with brands to launch, grow and scale recurring revenue programs. Our suite of services helps great brands and passionate entrepreneurs sell physical goods direct-to-consumer, own 100% of their customer data and have access to real-time deep customer insights. Located in Silicon Beach, we look for the best and brightest to add to our highly motivated team of technologists. -Position Summary:We are looking for an experienced backend engineer to join our team! The Sr. Software Engineer will lead the development and transformation of our order processing applications, as part of our larger technology platform. We are looking for a highly skilled PHP Engineer in order to maintain our existing systems and build new enterprise applications. This individual should be a team player, enthusiastic, fun, ready to work hard, and a problem-solver. -This position will work directly in one of our cross-functional teams to create a dynamic and scalable platform for the future. -Primary Responsibilities:Design and build next generation, cloud-based enterprise applications for OceanX by utilizing modern software architecture such as microservicesLead the development and maintenance of PHP & JEE web applications, REST web services, and enterprise integrationsAdhere to excellence in software engineering best practices, and instill the same discipline and experience to other team membersWork closely with product owners and cross-functional team members to define and implement technology-based business solutionsSupport DevOps with release management, continuous integration, continuous deployment, and automation -Lead and facilitate R&D efforts in cutting-edge technologies or third-party products to enhance development capabilities in the department -About you:You have 5+ years of experience in designing and building high volume services preferably written in PHP or Python.You are a skilled communicator and are comfortable articulating complex ideas and talking abstract concepts.You have a deep understanding of SDLC, system design, data structure, algorithms and are comfortable working with highly scalable transactions-based applications.You have 3+ years of experience designing and implementing enterprise integrations using REST web services and messaging Familiarity with modern PHP frameworks (Zend, Laravel, and/or Symfony) and design patterns (MVC)You care about code quality and you thrive in a test-driven environment -You have experience with the following:Cloud-based architectures and common Internet technologies, e.g. Linux, MySQL, JQuery, JSON, AWS.Agile testing methodologies including ATDD and TDD -Development using tools like Jira, GIT, Wiki -Bonus Points:Proficiency in specific AWS products and services such as Cloudformation, S3, SNS, SQS, ELB, RDS, DynamoDB, etc.Experience integrating DevOps, or working closely with DevOps teamsSupported external APIs and/or developer communities.Working knowledge of Docker containersFamiliarity and/or working experience in other programming languages like Java and/or Python or frameworks such as Node.js is a plusFamiliarity with Spring framework using Spring annotations is a plus ()
          

CVE-2011-1939

 Cache   

Severity Not Scored

Description

SQL injection vulnerability in Zend Framework 1.10.x before 1.10.9 and 1.11.x before 1.11.6 when using non-ASCII-compatible encodings in conjunction PDO_MySql in PHP before 5.3.6.

Read more at https://www.tenable.com/cve/CVE-2011-1939


          

0004889: sql-update-3.0.0-to-combined-mysql.sh - possibly incorrect/missing table used

 Cache   
Most of the time sql-update-3.0.0-to-combined-mysql.sh correctly uses table name defined in OCSFolderInfoURL to fetch or update data, but in one place this name is hardcoded to sogo_folder_info:<br /> <br /> echo "UPDATE sogo_folder_info SET c_location = NULL, c_quick_location = NULL, c_acl_location = NULL WHERE c_folder_id = $FOLDERID;" >> $SQLFILE<br /> <br /> This line should read:<br /> <br /> echo "UPDATE $TABLE SET c_location = NULL, c_quick_location = NULL, c_acl_location = NULL WHERE c_folder_id = $FOLDERID;" >> $SQLFILE<br /> <br /> Same goes for PostgreSQL version of the script.
          

Junior Software Engineer

 Cache   

Job Title: Junior Software Engineer

Salary: £25,000 - £29,187

Location: Manchester

  • Would you thrive in a dynamic and creative start-up environment, but also enjoy the security, resources and influence of an established and successful organisation?
  • Would you excel within a world-class and passionate team that loves what they do?
  • Are you a recent graduate, in a Junior/grad role currently or a graduate of a coding bootcamp and looking for an exciting new role?

What to expect:

You will form part of a collaborative, iterative and agile process within a multi-disciplined team helping deliver best in class digital solutions. This role provides a unique opportunity to help support and grow an entirely new software development capability.

Reporting to the Principal Software Engineer and working closely with other multi-disciplined engineers, you will be a valued member of the Digital Delivery Centre team. You will work on real projects alongside experienced engineers and will be provided with opportunities to learn and build your new software development career.

We have long pushed the boundaries of technology. Now digital innovation lies at the heart of our business – because it is central to our future strategy. We are focused on the development of electric, connected and driverless cars that will reshape the whole industry. Joining us is your chance to help redefine who we are and where we’re going. Your talents in software development could take your career in many directions. Get ready to dream for tomorrow.

What you’ll need

  • Some experience with Java, Spring Boot, C#, .Net or another OO language
  • OR ... some experience with JavaScript (ES6/7/8) and common front-end libraries such as React
  • OR ... some experience building mobile apps, especially in React Native
  • OR ... some experience in a QA role working with automated testing using tools like Robot, Cypress, Selenium or Puppeteer

We are keen to speak to people who also have the following skills:

  • Some experience with relational database technologies such as MySQL or similar
  • Some experience with practices such as Test Driven Development and Pair Programming
  • Some experience with modern web technologies such as HTML5 and CSS
  • Some experience with source code management and version control (Git/GitHub/GitLab)
  • Some experience or knowledge of modern CI/CD tools and techniques
  • Knowledge of key stages of the software delivery lifecycle

The following skills and experience are nice to have:

  • Experience or knowledge of Object Oriented Programming
  • Experience or knowledge of API integration and development practices (REST, GraphQL)
  • Experience with Kubernetes or other cloud infrastructure (Google Cloud Platform, AWS, Azure)
  • Familiarity with polyglot persistence and experience with a NoSQL database engine (Mongo, Neo4j, etc)

So why us?

This role is based in our brand new hi-tech Digital Delivery Centre in the heart of Manchester, where you will be working alongside some of the best Engineers in the world. We have the top two floors in the Neo Building which has undergone a £8m refurbishment, neighbours in the building amongst others including Microsoft. We have a roof terrace with weatherproof desk pods as well as showers, bike racks and a discounted gym next door. We run a regular events/social program and the building is dog friendly!

Benefits:

  • Bonus (Individual Performance Payment) as well as a separate annual pay review
  • Flexible Working arrangements (Possible remote working also)
  • Pluralsight account - unlimited online courses
  • 26 days holiday + 8 days statutory
  • 50% off local gym memberships
  • Employee Learning Scheme - £250 per year towards any self-development activity of your choice
  • Childcare Vouchers
  • Occupational Health services
  • Discounts i.e. 5% at Sainsbury’s, 10% at Boots and 20% at EE
  • Privilege Discount Purchase/Lease Vehicle Scheme for yourself and family

Location: Manchester
Salary: Competitive
Hours: Full-time
Type: Permanent
Starting: Starting 01/02/2020
Duration: Permanent


          

Senior Software Engineer

 Cache   

What to expect:

You will form part of a collaborative, iterative and agile process in a multi-disciplined team helping deliver best in class digital solutions. This role provides a unique opportunity to help support and grow an entirely new software development capability.

Reporting to the Principal Software Engineer and working closely with other multi-disciplined Engineers, you will be a valued member of the Digital Delivery Centre team, consistently delivering to challenging business objectives, with a focus on testability, robustness, and performance for exciting new projects. You will work on real projects alongside experienced engineers and will be expected to take on some mentoring and coaching of less experienced engineers.

We have long pushed the boundaries of technology. Now digital innovation lies at the heart of our business – because it is central to our future strategy. We are focused on the development of electric, connected and driverless cars that will reshape the whole industry. Joining us is your chance to help redefine who we are and where we’re going. Your talents in software development could take your career in many directions. Get ready to dream for tomorrow.

What you’ll need

Java experience or similar past or present is the first and foremost requirement, we are looking for great engineers who have a passion for innovative problem solving and quality-first coding. We are keen to speak to people who have experience developing bespoke built enterprise scale cloud-native applications and have strong experience with relational database technologies such as MySQL or similar. You should have a good knowledge of Service Oriented Architectures as well as experience of practices such as Test Driven Development and Pair Programming.

We are looking for those who have experience with Service Oriented Architectures: ReSTful APIs and Microservices as well as experience with modern web technologies such as HTML5 and CSS. Strong Object Oriented programming skills are valued as is experience with source code management and version control (Git/GitHub/GitLab). Experience with modern CI/CD tools and techniques are advantageous as is previous involvement in all stages of the software delivery lifecycle

It’s desirable for you to have experience with Kubernetes or other cloud infrastructures (Google Cloud Platform, AWS, Azure) as well as experience building mobile apps using frameworks such as React Native. Familiarity with polyglot persistence and experience with a NoSQL database engine (Mongo, Neo4j, etc) is also desirable. The successful candidate will thrive in our exciting and dynamic environment and will have excellent mentoring skills to develop others around them.

So why us?

This role is based in our brand new hi-tech Digital Delivery Centre in the heart of Manchester, where you will be working alongside the best engineers in the world. We have the top two floors in the Neo Building which has undergone a £8m refurbishment, neighbours in the building amongst others including Microsoft.

You'll benefit from an annual salary review & bonus scheme performance dependent on performance. Additionally to the below, you will receive flexible working hours and case by case remote working.

  • Bonus (Individual Performance Payment) & annual pay review
  • Privilege Discount Hire Scheme – For a limited time benefit from up to 35% discount on some vehicles
  • 26 days holiday + 8 days statutory
  • Discounts i.e. 5% at Sainsbury’s, 10% at Boots and 20% at EE
  • Employee Learning Scheme - £250 per year towards any self-development activity of your choice
  • Pluralsight account - unlimited online courses
  • 50% gym discount
  • Occupational Health services

Location: Manchester
Salary: Competitive
Hours: Full-time
Type: Permanent
Starting: Starting 01/01/2020
Duration: Permanent


          

代码审计入门之Jeeplus代码审计

 Cache   
0×00 前言 JeePlus是一款基于代码生成器的javaEE快速开发平台,可以帮助解决java项目中绝大部分的的重复工作,让开发者更多关注业务逻辑。Jeeplus支持单表,主附表,一对一,一对多,多对多,左树右表的直接生成,只需简单配置,就可以生成数千行高质量代码。开发者声称该平台使用目前流行的多种web技术,包括Spring mvc4.0+, MyBatis, Apache Shiro, J2cache,qutarz,spring websocket, Jquery ,BootStrap 等等,支持多种数据库MySQL, Oracle等。 分层设计:使用分层设计,分为dao,service,Controller,view层,层次清楚,低耦合,高内聚。 严格遵循了web安全的规范,前后台双重验证,参数编码传输,密码md5加密存储,shiro权限验证,从根本上避免了SQL注入,XSS攻击,CSRF攻击等常见的web攻击手段。既然这么安全,那么我们从网上下载一份源码来看一看。 通过IDEA导入该源码,我们可以发现其为典型的Maven结构 src/main/java:是java的代码目录 src/main/resources:是资源目录,放一些配置文件,如properties、spring-mvc.xml等 src/main/webapp:是传统项目的WebContent目录 0×01:SQL注入 首先该系统要求登录之后才能使用大部分功能。所以我们先来看看那些功能是不需要登录就可以访问的。通过官网的技术手册我们可以知道该系统采用Apache Shiro来控制权限。于是我们查看Apache Shiro的配置文件,寻找过滤器定义的列表。如图所示。 anon 没有参数,表示可以匿名访问。 authc表示需要认证(登录)才能使用,没有参数 通过以上代码我们可以获取到一批不用登陆就可以访问到的URL。我们抽出一个来看看 此处以resetPassword为例 没有任何处理,跟进findUniqueByProperty接口 上述SQL语句并没有采用JDBC的预编译模式。而是采用了${}这样的写法。这种写法就产生了SQL语句的动态拼接。因为”${xxx}”这样格式的参数会直接参与SQL语句的编译,从而不能避免SQL注入攻击。这是造成mybatis注入的标准写法。 我们构造语句注入即可 同理发现多处存在注入。 Payload: GET: /a/sys/user/resetPassword?mobile=13588888888′and (updatexml(1,concat(0x7e,(select user()),0x7e),1))%23 /a/sys/user/validateMobileExist?mobile=13588888888′and (updatexml(1,concat(0x7e,(select user()),0x7e),1))%23 /a/sys/user/validateMobile?mobile=13588888888′and (updatexml(1,concat(0x7e,(select user()),0x7e),1))# POST: /a/sys/register/registerUser roleName=wangba&mobile=13300990099′and (updatexml(1,concat(0x7e,(select user()),0x7e),1))%23&randomCode=2131&loginName=test1&password=123123&confirmNewPassword=123123&ck1=on 通过全局搜索发现系统还有很多地方采用了${}这种写法。这里就不一一标注出来了。 0×02:第三方组件导致的敏感信息泄露 前面我们虽然挖掘到了SQL注入,但是该系统采用魔改的算法进行加密,通过注入查出来的密码无法直接在MD5等平台直接进行解密、而且加密不可逆。相关实现方法如下: 那么怎么办呢?根据网上众多案例,我们可以总结发现,由java开发的项目大部分都存在由第三方组件所导致的漏洞。我们来看看这套程序引用了那些第三方组件呢。通过IDEA我们可以快速的列出我们当前工程所引入的第三方组件包。 我们看到了两个熟悉的组件,druid和fastjson。druid是阿里巴巴开源平台上一个数据库连接池实现,它结合了C3P0、DBCP、PROXOOL等DB池的优点,同时加入了日志监控,可以很好的监控DB池连接和SQL的执行情况。而fastjson则不需要介绍了。大家都很熟悉了,主要用来处理json数据。 根据个人了解,Druid目前是不存在相关漏洞的。但是如果开发者配置不当就可以造成未授权访问,从而导致相关敏感信息泄露。我们来看看web.xml文件 url-pattern 标签中的值是要在浏览器地址栏中输入的 url,可以自己命名,这个 url 访问名为 servlet-name 中值的 servlet 开发者直接配置了映射关系。直接访问url+/druid/ 就可以访问到durid的控制台,在控制台可以直接获取到当前的一些session信息,还可以看到一些JDBC连接信息以及其他的敏感信息。 这一堆session并不是所有都是有效的,具体大家可以抓个包。然后用burp爆破一下。 Payload: http://127.0.0.1/druid/websession.html 0×03:任意文件上传 系统本身提供了一个文件管理的功能,地址为:http://127.0.0.1/a/sys/file。通过该功能可以对上传文件夹内部的文件进行管理,包括移动,复制,上传,删除,重命名等。 我们找到相关代码,看看功能是如何实现的,是否存在安全问题 从代码逻辑我们可以看到上传过程中完全没有限制上传文件类型以及文件后缀,没有任何安全过滤措施。那么我们直接上传webshell文件即可。而且文件名可控,就连我们的写入路径也是可控的。 根据相关参数信息,我们直接构造上传即可,或者登录后直接在文件管理处上传文件也可以。 前面我们挖掘到session信息泄露。在这里我们没有拿到管理员密码的前提下可以替换session来上传我们的shell。达到getshell的目的 0×04:任意文件下载 文件管理功能还提供了文件下载功能,根据以往经验来看此处很有可能存在任意文件下载,我们继续往下看代码。 这里先定义返回数据类型,在实例化对象,最后读取文件 逻辑上并没有做任何安全限制,例如过滤…等,导致我们可以跨目录读任意文件。直接构造参数读就完事了。 0×05:总结 整体来看这套系统存在的安全问题很多,并没有官网所描述的那样安全,还有很多问题。有很多漏洞都是由于业务功能考虑不全所导致的,可能开发者也没有想到这些功能所带来的危害,所以才会出现这些问题。 在日常渗透过程中,所遇到的由SSM框架开发的系统还是有很多的。大家如果拿到源码不妨试着看一下,说不定会有意外的收货及突破。这篇文章有很多不足,写的也很浅显。只做抛砖引玉。欢迎各位大佬多多指正。 *本文原创作者:Freedom,本文属于FreeBuf原创奖励计划,未经许可禁止转载
          

Dr.Web Enterprise Security Suite 12.0の Serverをアップデート

 Cache   

2019年11月28日

株式会社Doctor Web Pacific


Doctor Webは、Dr.Web Enterprise Security Suite 12.0の Server(REL-1200 201911180)をアップデートしました。今回のアップデートでは、発見されたエラーが修正されました。

次の変更が加えられました。

  • 複数のデバイスクラスあるいは複数のバスが同時に指定された場合、デバイスをブロックできない問題が解決されました。
  • MySQLまたはMariaDB データベース管理システムが利用されている場合、Dr.Web 11のServerをバージョン12へアップデートできない問題が解決されました。
  • Control Centerにて、端末またはグループを比較する時に発生する内部サーバーエラーが修正されました。
  • "var-root" および "home-root" フォルダがディスク上の異なる領域にある場合、Dr.Web Serverがアップデートできない問題が解決されました。
  • Office Controlクラスリストからブロック対象となる項目が正常に削除できないエラーが修正されました。
  • 保護される端末にて、製品のアップデートを不可能にしたエラーが修正されました。

アップデートはDr.Web Global Update System (Dr.Web GUS)経由で実行されます。


          

Repair MySQL, PostgreSQL, Ubuntu Databas

 Cache   
Category: Programming & Development

Description: We currently have a Linux Server running Ubuntu, 16.04.6 LTS version it is hosting MySql, PostgreSQ...

          

MySQL Data Recovery Expert Needed

 Cache   
Category: Programming & Development

Description: While migrating data from one server to the other, I get a "table does not exist" error.I had copie...

          

PHP Developer

 Cache   
Category: Programming & Development

Description: Job DescriptionExperienced PHP programmer developer having good experience in OOPs ,MVC, MySQL, PHP...

          

We have a mySql Database with Cars and its bookings, We want some one to create wordpress front end using the database

 Cache   
Category: CSS, Javascript, MySQL, Web Design, WordPress
Budget: ₹1500 - ₹12500 INR

We need a wordpress developer who can work on custom tables, to integrate Cars and its bookings to a existing wordpress theme. The database is mysql and we need the ui to be a calendar ui on wordpress...
          

PHP based Website / Control Panel with 15-20 dynamic pages

 Cache   
Category: HTML, Javascript, MySQL, PHP, Web Design
Budget: ₹12500 - ₹37500 INR

I need an admin/control panel to view/edit data from my existing MySQL Database (data grids, data edit forms, view/edit images etc.). There will be 15-20 dynamic pages and out of which 8-10 pages will be reports and I would like to display them in pie/bar charts and a few in bubbles if possible...
          

Create MYSQL queries that can be echoed to PHP website.

 Cache   
Category: MySQL, PHP, Software Architecture, SQL, XML
Budget: $10 - $30 USD

I run a report with powershell and it produces a CSV file. I take that file and import it into MYSQL. I'm trying to run Select\Count statements and have the results on a PHP page. 1) I would like to automate the whole thing...
          

Java Spring boot API developer

 Cache   
Category: J2EE, Java, Javascript, MySQL, PHP
Budget: $8 - $15 USD

We are a new startup that are building a web application for ordering. We need an extra developer that can work remotely ideally full but also possible part time to develop APIs. We use MySQL, Maven,...
          

Contact management system

 Cache   
Category: Database Programming, HTML, MySQL, PHP, SQL
Budget: $30 - $250 USD

General information for the website: Must be built in PHP Database management system (DBMS): MySQL Kind of development: New website from scratch Description of requirements/features: We need a simple contact management system built that will allow our employees to track whom they've contacted...
          

Develope an ecommerce website

 Cache   
Category: Programming & Development

Description: we need a developer to build an e commerce website using codeigniter php and mysqlwe need a develop...

          

Import excel to cpanel on MySQL Database -- Urgent

 Cache   
Category: Database Administration, Database Programming, MySQL, PHP, Software Architecture
Budget: $10 - $30 USD

I want to import records on three different tables from Excel to MySQL. Data and PHP expert would be highly appreciated.
          

Aplicatie mobila flutter

 Cache   
Category: HTML, MySQL, PHP, Software Architecture, Web Design
Budget: €250 - €750 EUR

Am nevoie de o allicatie in flutter. Va lucra prin api cu website deja functional mysql php.
          

WebRTC with Turnserver to power live streaming

 Cache   
Category: Javascript, MySQL, Node.js, PHP, Software Architecture
Budget: $10 - $30 USD

uses WebRTC with Turnserver to power live streaming, Nodejs for real time chat with Socket.io and Stable PHP Laravel framework with MySQL. Can also use WebRTC Kurento.
          

Move website WIX to simple web

 Cache   
Category: Apache, Linux, MySQL, Nginx, PHP
Budget: $30 - $250 USD

We have a portal in WIX and we have a server with Ubuntu 18.04 Server PHP 7.2 MySQL NGINX We want to move this portal to this server look and feed should be the same or similar. https://www.kbscorp.com/
          

MapleStory private Server

 Cache   
Category: Java, Linux, MySQL, PHP, Software Architecture
Budget: $30 - $250 USD

Maplestory Private server base on java and MySQL , like www.mapleroyals.com I am need only someone that know the game and done project like this before. the server working on windows vps.
          

Fix flash files not loading

 Cache   
Category: Programming & Development

Description: Find problem and fix flash files not loading on pages after updated php and MySQL.Php get call to M...

          

Need Delphi developer to fix some bugs on Windows desktop application

 Cache   
Category: Delphi, Software Architecture, Windows Desktop
Budget: $30 - $250 USD

I need an experienced Delphi developer to fix some bugs on a desktop mailer application. Details of the bugs and some demonstration over Teamviewer will be provided over chat. Please note that this application is heavily multi-threaded and uses a external MYSQL database...
          

eact + redux developer (full time)

 Cache   
Category: Angular.js, Express JS, Javascript, Node.js, NoSQL Couch & Mongo
Budget: $30 - $250 USD

Hi, I am looking for a React and Node.js expert (full time) for couple of projects I have. Skillset: Expert in DB like Mongo, MySQL Webapis using Node.js React experience Docker experience Experience...
          

Fetch data from Mysql Database and show it in a PHP Page

 Cache   
Category: HTML, Javascript, MySQL, PHP, Software Architecture
Budget: $5 - $6 USD

I need to fetch data from a mysql database and show it in a template attached to this project. At the same time I need that each result has a link to see in another page the details of each record that the user wants to select...
          

MYSQL Data Architect

 Cache   
Category: Database Administration, Database Programming, MySQL, SQL
Budget: $30 - $250 USD

Looking for experienced person who can design DB where it can handle Big Data.
          

Implement AMP [ Accelerated Mobile Project ] for Website

 Cache   
Category: HTML, MySQL, PHP, Software Architecture, Web Design
Budget: ₹1500 - ₹12500 INR

We would like to Implement AMP for our website. The website has around 15 Pages and it is built in PHP, MYSQL. Please note that we will give you FTP access using which you will need to work directly in our server, we won't be able to give you CPanel access...
          

MYSQL 5.7 8.0 database restore NO_AUTO_CREATE_USER

 Cache   
Category: Database Administration, Database Development, MySQL, Relational Databases, SQL
Budget: $10 - $30 USD

I just need to restore a 5.7 database (rather small) to 8.0 I am on a windows server. here's the error that I ran into echo "reloading thedatabase " "reloading thedatabase " "C:\Program Files\MySQL\MySQL...
          

Implement AMP for a Website

 Cache   
Category: Programming & Development

Description: We need to implement AMP for a webspage built using PHP and MYSQL. Aprox, there will be 15 pages ar...

          

i need a web developer & designer

 Cache   
Category: Graphic Design, HTML, MySQL, PHP, Web Design
Budget: $250 - $750 USD

Dear. I have a plan for built website and i look for a freelancer who can do it. In my opinion, you can do backend first because database design is more important. I use database MYSQL and you have to design database first...
          

Create a website custom input form

 Cache   
Category: Programming & Development

Description: We have a website with a MySQL database and need to collect data using the web and the database. Th...

          

website for eCommerce

 Cache   
Category: Apache, Django, MySQL, Python
Budget: ₹100 - ₹400 INR

E commerce site Project work on python3 ,django, mysql, apache2
          

PhpAdmin, Mysql- Transactions site

 Cache   
Category: Programming & Development

Description: Client is looking to move from one platform to another and looking for a simple solution. Client wi...

          

Load JSON data into MySQL table -- 2

 Cache   
Category: JSON, MySQL, PHP, Python, XML
Budget: $10 - $30 USD

Need to load large JSON file into MySQL table. Only need a few of the fields within JSON data. Table fields needed: id, label, searchTerms, svg_regular (raw), svg_duotone(raw), height, width Sample...
          

MySQL - Normalize comma separated Serial Number data in View

 Cache   
Category: Database Administration, MySQL, SQL
Budget: $30 - $250 USD

I need a MySQL View created that will take the attached table and display each item and serial number separately. Right now, each row can have multiple serial numbers listed as a comma separated value...
          

Matomo Optimization MySQL Scaling(PolarDB)

 Cache   
Category: Cloud Computing, Development Operations, Linux, MySQL, PHP
Budget: $25 - $50 USD

I have a Matomo analytics site in China running on PolarDB which is similar to MySQL. The performance is too slow and I need an expert in scaling MySQL to help with it.
          

TEAM WANTED: WP, MySQL, Woocommerce, PHP & GitHub skills

 Cache   
Category: Graphic Design, PHP, Web Design
Budget: $10 - $30 USD

Your TEAM will be hired for $10 just to review and completely understand the project before you bid on it. All of your TEAM members will help prepare your text file about the job requirements, functionality expected and time line until completion...
          

Node js development

 Cache   
Category: Javascript, Node.js, NoSQL Couch & Mongo, React.js
Budget: $15 - $25 USD

Looking for a developer to work on an existing nodejs project. Involves mongodb, redis, MySQL, with both front-end (UI) and backend (API) work. React, Redux, docker, are also used.
          

Google Map listings not loading

 Cache   
Category: Google Maps API, Javascript, MySQL, PHP, Software Architecture
Budget: $10 - $30 AUD

I have a php mysql listings component that uses google maps, the map and component stoped working for some reason. Please fix. Mention hg in comments so I know you read this brief, also mention you looked at the map...
          

Knockout.JS, PDOs, PHP, MySQL, LongTerm

 Cache   
Category: Programming & Development

Description: Please note:1) We are hiring individuals not teams.2) Before being hired you must sign a Non-Disclo...

          

Tomcat JDBC ext plugin and Dynatrace

 Cache   

We are trying to get the JDBC-pool information out with the JDBC-plugin but seems that the plugin doesn't pick any information on Apache Tomcat (8.5.14.0) .

https://github.com/Dynatrace/JMX-Extensions/blob/master/Tomcat%20JDBC%20ext/plugin.json

Our application is using Mysql so therefore I doubt that I need to change the data sources but not sure where to start since we don't have access to jmx monitor currently and not sure if we could use the JMX editor to pick the correct measures?





Next Page: 10000

© Googlier LLC, 2019