kla587 / Internet-System-Dev

0 stars 0 forks source link

Installed SQLite to test database connection #32

Open kla587 opened 8 years ago

kla587 commented 8 years ago

Uninstalled MySQL and followed tutorial for installing and configuring SQLite on http://www.tutorialspoint.com/sqlite/sqlite_perl.htm.

Ran command line: wget http://search.cpan.org/CPAN/authors/id/T/TI/TIMB/DBI-1.625.tar.gz tar xvfz DBI-1.625.tar.gz cd DBI-1.625 perl Makefile.PL make sudo make install

SQLite driver was missing for DBI, then ran

wget http://search.cpan.org/CPAN/authors/id/M/MS/MSERGEANT/DBD-SQLite-1.11.tar.gz tar xvfz DBD-SQLite-1.11.tar.gz cd DBD-SQLite-1.11 perl Makefile.PL make make install

Created a test program to set up a connection to the SQLite database.

kla587 commented 8 years ago

Upon testing connection received the following error: access denied for user ''@'localhost'

kla587 commented 8 years ago

Found suggestion that the database wasn't fully installed, http://stackoverflow.com/questions/17144583/dbd-mysql-installed-but-still-error-install-drivermysql-failed-cant-locate.

Uninstalled SQLite and ran the following commands:

sudo apt-get install sqlite3 libsqlite3-dev

perl Makefile.PL make make test make install

kla587 commented 8 years ago

Currently receiving another error:

install_driver(SQLite) failed: Can't locate DBD/SQLite.pm in @INC (you may need to install the DBD::SQLite module) (@INC contains: /etc/perl /usr/local/lib/perl/5.18.2 /usr/local/share/perl/5.18.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.18 /usr/share/perl/5.18 /usr/local/lib/site_perl .) at (eval 6) line 3. Perhaps the DBD::SQLite perl module hasn't been fully installed, or perhaps the capitalisation of 'SQLite' isn't right. Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge. at test.pl line 53.

Faisal2016 commented 8 years ago

I get error when I try to run it in the command line.