when installing myql sqldriver plugin if you found following error :-
/usr/bin/ld: cannot find -lssl
/usr/bin/ld: cannot find -lcrypto
collect2: error: ld returned 1 exit status
make: *** [../../../../plugins/sqldrivers/libqsqlmysql.so] Error 1
install following rpms :-
(all will be found in centos75 everything)
audit-libs-2.8.4-4.el7.i686.rpm
bzlib-1.0.6-alt6.i586.rpm
cracklib-2.9.0-11.el7.i686.rpm
crypto-utils-2.4.1-42.el7.x86_64.rpm
cryptsetup-libs-2.0.3-3.el7.x86_64.rpm
cyrus-sasl-2.1.26-23.el7.i686.rpm
cyrus-sasl-2.1.26-23.el7.x86_64.rpm
cyrus-sasl-devel-2.1.26-23.el7.i686.rpm
cyrus-sasl-devel-2.1.26-23.el7.x86_64.rpm
cyrus-sasl-lib-2.1.26-23.el7.i686.rpm
cyrus-sasl-lib-2.1.26-23.el7.x86_64.rpm
daxctl-libs-62-1.el7.x86_64.rpm
device-mapper-1.02.149-8.el7.x86_64.rpm
device-mapper-libs-1.02.149-8.el7.i686.rpm
elfutils-libelf-0.172-2.el7.i686.rpm
elfutils-libs-0.172-2.el7.i686.rpm
gamin-0.1.10-16.el7.x86_64.rpm
glib2-2.56.1-2.el7.x86_64.rpm
glib2-devel-2.56.1-2.el7.x86_64.rpm
glibc-2.17-260.el7.i686.rpm
glibc-common-2.17-260.el7.x86_64.rpm
keyutils-libs-1.5.8-3.el7.i686.rpm
keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm
krb5-devel-1.15.1-18.el7.i686.rpm
krb5-devel-1.15.1-18.el7.x86_64.rpm
krb5-devel-1.15.1-34.el7.x86_64.rpm
krb5-libs-1.15.1-18.el7.i686.rpm
krb5-libs-1.15.1-18.el7.x86_64.rpm
krb5-libs-1.15.1-34.el7.x86_64.rpm
krb5-libs-1.15.1-37.el7_6.x86_64.rpm
libattr-2.4.46-13.el7.i686.rpm
libblkid-2.23.2-59.el7.i686.rpm
libcap-2.22-9.el7.i686.rpm
libcap-ng-0.7.5-4.el7.i686.rpm
libcom_err-1.42.9-11.el7.i686.rpm
libcom_err-1.42.9-11.el7.x86_64.rpm
libcom_err-1.42.9-13.el7.x86_64.rpm
libcom_err-devel-1.42.9-11.el7.i686.rpm
libcom_err-devel-1.42.9-11.el7.x86_64.rpm
libcom_err-devel-1.42.9-13.el7.x86_64.rpm
libdb-5.3.21-24.el7.i686.rpm
libffi-3.0.13-18.el7.i686.rpm
libgcc-4.8.5-36.el7.i686.rpm
libgcrypt-1.5.3-14.el7.i686.rpm
libgpg-error-1.12-3.el7.i686.rpm
libitm-4.8.5-28.el7.i686.rpm
libitm-4.8.5-28.el7.x86_64.rpm
libitm-devel-4.8.5-28.el7.i686.rpm
libitm-devel-4.8.5-28.el7.x86_64.rpm
libitm-static-4.8.5-28.el7.i686.rpm
libitm-static-4.8.5-28.el7.x86_64.rpm
libkadm5-1.15.1-18.el7.i686.rpm
libkadm5-1.15.1-18.el7.x86_64.rpm
libkadm5-1.15.1-34.el7.x86_64.rpm
libkadm5-1.15.1-37.el7_6.x86_64.rpm
libmount-2.23.2-59.el7.i686.rpm
libselinux-2.5-14.1.el7.x86_64.rpm
libselinux-devel-2.5-14.1.el7.x86_64.rpm
libsepol-2.5-10.el7.x86_64.rpm
libsepol-devel-2.5-10.el7.x86_64.rpm
libstdc++-4.8.5-36.el7.i686.rpm
libuuid-2.23.2-59.el7.i686.rpm
libverto-0.2.5-4.el7.i686.rpm
libverto-devel-0.2.5-4.el7.x86_64.rpm
lz4-1.7.5-2.el7.i686.rpm
lz4-1.7.5-2.el7.x86_64.rpm
lz4-devel-1.7.5-2.el7.x86_64.rpm
ncurses-libs-5.9-14.20130511.el7_4.i686.rpm
ndctl-libs-62-1.el7.x86_64.rpm
nspr-4.17.0-1.el7.i686.rpm
nspr-4.17.0-1.el7.x86_64.rpm
nspr-4.19.0-1.el7_5.x86_64.rpm
nspr-devel-4.17.0-1.el7.i686.rpm
nspr-devel-4.17.0-1.el7.x86_64.rpm
nss-3.34.0-4.el7.i686.rpm
nss-3.34.0-4.el7.x86_64.rpm
nss-devel-3.34.0-4.el7.i686.rpm
nss-devel-3.34.0-4.el7.x86_64.rpm
nss-pem-1.0.3-4.el7.i686.rpm
nss-pem-1.0.3-4.el7.x86_64.rpm
nss-softokn-3.34.0-2.el7.i686.rpm
nss-softokn-devel-3.34.0-2.el7.i686.rpm
nss-softokn-devel-3.34.0-2.el7.x86_64.rpm
nss-softokn-freebl-3.34.0-2.el7.i686.rpm
nss-softokn-freebl-3.34.0-2.el7.x86_64.rpm
nss-softokn-freebl-3.36.0-5.el7_5.i686.rpm
nss-softokn-freebl-devel-3.34.0-2.el7.i686.rpm
nss-softokn-freebl-devel-3.34.0-2.el7.x86_64.rpm
nss-tools-3.34.0-4.el7.x86_64.rpm
nss-util-3.34.0-2.el7.i686.rpm
nss-util-3.34.0-2.el7.x86_64.rpm
nss-util-3.36.0-1.el7_5.x86_64.rpm
nss-util-devel-3.34.0-2.el7.i686.rpm
nss-util-devel-3.34.0-2.el7.x86_64.rpm
opencryptoki-3.7.0-1.el7.i686.rpm
opencryptoki-3.7.0-1.el7.x86_64.rpm
opencryptoki-devel-3.7.0-1.el7.i686.rpm
opencryptoki-devel-3.7.0-1.el7.x86_64.rpm
opencryptoki-icsftok-3.7.0-1.el7.i686.rpm
opencryptoki-icsftok-3.7.0-1.el7.x86_64.rpm
opencryptoki-libs-3.7.0-1.el7.i686.rpm
opencryptoki-libs-3.7.0-1.el7.x86_64.rpm
openldap-2.4.44-13.el7.i686.rpm
openldap-2.4.44-13.el7.x86_64.rpm
openldap-clients-2.4.44-13.el7.x86_64.rpm
openldap-devel-2.4.44-13.el7.i686.rpm
openldap-devel-2.4.44-13.el7.x86_64.rpm
openldap-servers-2.4.44-13.el7.x86_64.rpm
openldap-servers-sql-2.4.44-13.el7.x86_64.rpm
openssl-1.0.2k-12.el7.x86_64.rpm
openssl-devel-1.0.2k-12.el7.i686.rpm
openssl-devel-1.0.2k-12.el7.x86_64.rpm
openssl-devel-1.0.2k-16.el7.x86_64.rpm
openssl-libs-1.0.2k-12.el7.i686.rpm
openssl-libs-1.0.2k-12.el7.x86_64.rpm
openssl-libs-1.0.2k-16.el7.x86_64.rpm
openssl-perl-1.0.2k-12.el7.x86_64.rpm
openssl-static-1.0.2k-12.el7.i686.rpm
openssl-static-1.0.2k-12.el7.x86_64.rpm
pam-1.1.8-22.el7.i686.rpm
parted-3.1-29.el7.i686.rpm
pcre-8.32-17.el7.i686.rpm
pcre-devel-8.32-17.el7.x86_64.rpm
perl-Newt-1.08-36.el7.x86_64.rpm
perl-WWW-Curl-4.15-13.el7.x86_64.rpm
readline-6.2-10.el7.i686.rpm
sqlite-3.7.17-8.el7.i686.rpm
sqlite-3.7.17-8.el7.x86_64.rpm
sqlite-devel-3.7.17-8.el7.i686.rpm
sqlite-devel-3.7.17-8.el7.x86_64.rpm
sslscan-1.10.2-3.el7.x86_64.rpm
systemd-libs-219-62.el7.i686.rpm
tlssled-1.3-4.el7.noarch.rpm
xz-libs-5.2.2-1.el7.i686.rpm
zlib-1.2.7-18.el7.x86_64.rpm
zlib-devel-1.2.7-18.el7.x86_64.rpm
then run following command :-
# cd /opt/Qt/5.7/Src/qtbase/src/plugins/sqldrivers/mysql <--|
# /opt/Qt/5.7/gcc_64/bin/qmake "INCLUDEPATH+=/usr/include/mysql" "LIBS+=-L/usr/lib64/mysql -lmysqlclient_r -lrt -ldl" mysql.pro
# make
#make install
then run following program :-
#include <QtWidgets>
#include <QtSql>
int main(int argc,char* argv[])
{
QApplication app(argc,argv);
QTableView table;
table.setWindowTitle("QT-Connect to MySQL Database");
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("collegedata");
db.setUserName("rahul");
db.setPassword("rahul");
if (!db.open())
{
QMessageBox::critical(0, QObject::tr("Database Error"),
db.lastError().text());
}
QSqlQuery query;
query.exec("select * from studentdata");
QSqlQueryModel model;
model.setQuery(query);
table.setModel(&model);
table.resizeColumnsToContents();
table.resize(450,250);
table.show();
return app.exec();
}
if this shows table then you have succesfully installed mysql sql plugin
No comments:
Post a Comment