Posts by lewashby

@rproffitt what is the microsoft relevance here?

I'm not near good enough to open the source of software and fix, change, or even understand anything. I can write very simple bash, python, php, c & c++ programs. php is the only thing I can realistically develop to any usability, and even then it's pretty minimal.

No ntfs, OS is ext4 and micro sd is fat32.

I fixed it but I still don't understand what was happening. Something really weird was going on with the music file that seems to have been causing this in some way. I had the song 'Tie Me Kangaroo down sport by Rolf Harris, album The Hits of Pop & Doo Wop, Vol. 5' downloaded to my music library, I got the song from Amazon's digital music store. Of my two directories that luckybackup/rsync kept getting mixed up were 'Various Artists & Various artists' the kangaroo song was the only song that was physically in the lowercase directory but showed in uppercase as two identical files on my desktop music player (Banshee). When I would right click on each of the two copies and click 'open in folder' one would be in the uppercase directory (Various Artists) and the other would be in the lowercase directory (Various artists), when when I would right click on the one in the lowercase directory and delete the file it would delete both copies? I have no idea! I re-download the song from amazon and this time I edited the meta data and changed the Artists field …

I reformatted the sd card and ry-synced everything again, same problem. I also manually copied the files from my library to the sd card and it worked fine, go figure. Re-synced again with luckybackup and delete all the files on the destination again :(.

P.S. Why is the post marked 'Featured'?

My system didn't recognise iocharset or the shortname options. I have now ran this command on my system ->
$ rsync -vrc --delete --ignore-existing --exclude ".*/" /home/me/media/music/ /media/me/MEDIA-SD/ && echo "DONE"

Now the tail end of this command looks like this.

irectory (2)
rsync: mkstemp "/media/me/MEDIA-SD/Various Artists/O Brother, Where Art Thou_/.10. Didn't Leave Nobody But The Baby (O Brother, Where Art Thou_ Soundtrack).mp3.3olHWE" failed: No such file or directory (2)
default_perms_for_dir: sys_acl_get_file(Various Artists/One Hit Wonders, ACL_TYPE_DEFAULT): No such file or directory, falling back on umask
rsync: mkstemp "/media/me/MEDIA-SD/Various Artists/One Hit Wonders/.04. Rockin' Little Angel.mp3.u5o7ya" failed: No such file or directory (2)
default_perms_for_dir: sys_acl_get_file(Various Artists/Platinum Christmas, ACL_TYPE_DEFAULT): No such file or directory, falling back on umask
rsync: mkstemp "/media/me/MEDIA-SD/Various Artists/Platinum Christmas/.07 Little Drummer Boy.mp3.BIvwgG" failed: No such file or directory (2)
default_perms_for_dir: sys_acl_get_file(Various Artists/Pop a Paris - Rock N' Roll and Mini Skirts Vol.1, ACL_TYPE_DEFAULT): No such file or directory, falling back on umask
rsync: mkstemp "/media/me/MEDIA-SD/Various Artists/Pop a Paris - Rock N' Roll and Mini Skirts Vol.1/.03. Ces bottes sont faites pour marcher.mp3.Z0ms7b" failed: No such file or directory (2)
default_perms_for_dir: sys_acl_get_file(Various Artists/Rain Man _ Original Motion Picture Sound, ACL_TYPE_DEFAULT): No such file or directory, falling back on umask
rsync: mkstemp "/media/me/MEDIA-SD/Various Artists/Rain Man _ Original Motion Picture Sound/.01 Iko Iko.mp3.sG3n3H" failed: No such file or directory (2)
default_perms_for_dir: sys_acl_get_file(Various Artists/Rain Man _ Original Motion Picture Soundtrack, ACL_TYPE_DEFAULT): No such file or directory, falling back on umask
rsync: mkstemp "/media/me/MEDIA-SD/Various Artists/Rain Man _ Original Motion Picture Soundtrack/.01. Iko Iko.mp3.R5Gc7d" …

Yes it's mounted, otherwise I wouldn't be able to navigate to the SD card and list it's contents and luckBackup wouldn't even let me run the sync if it's wasn't. And everything should be rwx but just to me sure I just ran chmod -R +rwx ~/media/music/*. Check this out, after running that command I seen the following and the end of my luckybackup log.

         13.01M 100%   15.77MB/s    0:00:00 (xfr#1479, to-chk=210/6213)
Various artists/

deleting .audio_data/album_img/52407A71DB71DB0606836602A75A619E
deleting .luckybackup-snaphots/default.profile/snaps/default-music-sync2-20170530202113.changes.log
deleting .luckybackup-snaphots/default.profile/snaps/
deleting .luckybackup-snaphots/default.profile/profiles/default.profile
deleting .luckybackup-snaphots/default.profile/profiles/
deleting .luckybackup-snaphots/default.profile/logs/default-music-sync2-20170530202113.log
deleting .luckybackup-snaphots/default.profile/logs/
deleting .luckybackup-snaphots/default.profile/
deleting Coldplay/A Rush of Blood to the Head/11. Amsterdam.flac
deleting Coldplay/A Rush of Blood to the Head/10. A Rush Of Blood To The Head.flac
deleting Coldplay/A Rush of Blood to the Head/09. A Whisper.flac
deleting Coldplay/A Rush of Blood to the Head/08. Warning Sign.flac
deleting Coldplay/A Rush of Blood to the Head/07. Green Eyes.flac
deleting Coldplay/A Rush of Blood to the Head/06. Daylight.flac
deleting Coldplay/A Rush of Blood to the Head/05. Clocks.flac
deleting Coldplay/A Rush of Blood to the Head/04. The Scientist.flac
deleting Coldplay/A Rush of Blood to the Head/03. God Put A Smile Upon Your Face.flac
deleting Coldplay/A Rush of Blood to the Head/02. In My Place.flac
deleting Coldplay/A Rush of Blood to the Head/01. Politik.flac
deleting Various artists/White Christmas/10. Deck the Halls.flac
deleting Various artists/White Christmas/09. O Little Town of Bethlehem.flac
deleting Various artists/White Christmas/08. It's Beginning to Look a Lot Like Christmas.flac
deleting Various artists/White Christmas/07. Winter Wonderland.flac
deleting Various artists/White Christmas/06. Frosty the Snowman.flac
deleting Various …

I've been using rsync and or luckybackup for a while now to sync my desktop's music library to my micro sd card for my digital music player. Today I noticed that my music player wasn't showing one of my albums so I've started investigating and I've found that it's not the music player but is more likely to be rsync, but I don't understand how or why. After syncing I check the sd card manually and sure enough this album is still not beeing synced.

On my computer all of my music is stored at /home/me/media/music/* inside of this last music directory there are two various artists directories, one is uppercase and one is lower case for the word artists. Variouse Artists & Variouse artists. The weird thing is my sd card is only getting the contents of the 'Various artists' directory that's on my desktop but on my sd card the directory is called 'Various Artists' and there is not 'Various artists' directory listed at all on my sd card. So I'm only getting one of the two copies on my sync and it's filled with the contents that the other one is filled with on my computer. In this case I used luckbackup but it uses rysnc, I'll past the code below. Any ideas? Thanks. Oh, and sd card is fat32.

rsync -h --progress --stats -r -t --modify-window=1 --delete-after --delete-excluded --exclude=**/lost+found*/ --exclude=**/*Trash*/ --exclude=**/*trash*/ /home/me/media/music/ /media/me/MEDIA-SD/

I'm having trouble mounting my android's micro sd card. When I run lsusb I see the entry for the card

lsusb - > Bus 001 Device 006: ID 0bda:0158 Realtek Semiconductor Corp. USB 2.0 multicard reader

I have also validated that the device is sdf.

me@mothership ~ $ sudo mount /dev/sdf /home/me/Desktop/mnt/
mount: wrong fs type, bad option, bad superblock on /dev/sdf,
       missing codepage or helper program, or other error

       In some cases useful info is found in syslog - try
       dmesg | tail or so.

Any ideas? Thanks.

Noted.

I recently built a crypto currency miner and I'm using Linux Mint as my OS for the miner. I manually turn on the miner by navigating to ~/Desktop/claymore and running ./start_only_eth.bash and my miner starts mining. So i palced this line ./home/ethereum/Desktop/claymore/start_only_eth.bash in the /etc/init.d/rc.local file but I don't think it's running. When I type ps or ps -aux | grep /home neither ps command shows that my miner is running. What am I doing wrong with my auto startup stript?

Also, how can I setup my miner so that the computer will always be on? Meaning, if the power goes off and is restored it will turn itself back on as long as there is power without me having to maunally push the button? Thanks all.

In an angry keyboard rant I hit Ctrl Alt Delete, nothing, Ctrl Alt F2, nothing, Ctrl Alt F1 boom, there was my installation screen hiding. Go figure? Thanks.

Just tried a Debian iso image instead of an Xubuntu image and I had a similar problem. I got an erro while while it was creating the partitions. It said something about how that the partition had been created but that the Kernal didn't know about it and that I should reboot before making any changes. The it asked if I wanted to Cancel or Ignore, I chose ignore and the partition creation didn't give me any more errors but it progress bar stopped in one spot and would not move any further.

3rd try
I just tried with another live usb and a whole new SSD and now when I boot up the computer a blue screen that says "Xubuntu" comes up and just when I think it's about to start the installation process the screen goes black and I see the following messages in white on the screen.

[ *** ] A start job is running for Ubuntu live CD installer ($COUNTER MIN SEC / no limit)
[ OK ] Started Network Manager Script Dispatcher Service.

Any ideas, please help. Thanks.

I haven't check the chucksum but I have used several different images so I'M doubting that it's a corrupt iso file. Both images that I'v treid were from the Ubuntu website. Also, there is no dvd or cd drive.

A while back I built a computer with an Asus motherboard, a SSD, and two milk creates for a cheap case, and I had Xubuntu installed on it. I have tried to install Xubuntu on it again several times today but it always fails to create the partitions. I keep getting an error -> 'Creation in partitoin # x (0,0,0) failed' or something like that. Then after this happens the computer will not even boot back into the live USB Ubuntu again or even the BIOS, all I get there after is a black screen with a blinking white cursor at the top left of the screen. If I want to boot the computer back into Xubuntu again I have to write a new usb image, that thumb drive on which the installation fails will not work again. Also I've tried two different Xubuntu images so I doubt that it's a currupt image file. Any ideas? Thanks.

I figured it out, the CD player was alphabetically using the file names, how inefficient for an mp3 CD player! All the meta tag editing for nothing and how I have to rename all the files before buring an mp3 CD.

I have been downloading old kid's readio stories and trying to burn them onto mp3 CDs for my daughter. The problem is that when she plays the CDs on the mp3 CD player in her room the tracks are not in order. I have edited the meta-data and labeld every track with the same artist and album as well as made sure that the CD # of # fields were populated. Any ideas on what could be causing this and or how I might be able to fix the problem?

rproffitt

Sorry it took so long.

https://www.manualslib.com/products/Vizio-E55-D0-4359509.html

One more question, why does my thread have a 'sponsored' logo beside it?

I contacted Vizio and they said that there is not setting to switch back and forth between component and composite. They said that the ports were interchangeable between component and composite wires and everything should work fine. So I guess I'm SOL. I tried a red, white, yellow to hdmi but that didn't work either. :(
Thanks for your help.

I recently purchased a new Vizio 55" LED 1080p tv but I'm having trouble connection my Nintendo 64 to it. The red & white audio cable are working fine and I'm getting all of the audio but there is not yellow port on my new tv for the N64's yellow wire. The tv does have a green and blue port and when I connect the N64's yellow wire into the tv's green port the images shows up but it's black and white and scrolling upward. On my last tv this red, white, & yellow N64 wires into red, white, green tv ports worked fine, it was also a 1080p just not LED. Any ideas? I thought I might try this device out as a solution. Does anyone know if it would work? -> http://a.co/cwOdJ3r

I just followed the exact same steps from the website again only in a new directory and now everything is working fine. Go figure. Thanks Grib.

user@mothership myhellowebapp $ source venv/bin/activate
(venv) user@mothership myhellowebapp $ ls -l venv/bin
total 3508
-rw-r--r-- 1 user user    2125 Dec 20 22:35 activate
-rw-r--r-- 1 user user    1067 Dec 20 22:35 activate.csh
-rw-r--r-- 1 user user    2265 Dec 20 22:35 activate.fish
-rw-r--r-- 1 user user    1137 Dec 20 22:35 activate_this.py
-rwxr-xr-x 1 user user     295 Dec 20 22:35 easy_install
-rwxr-xr-x 1 user user     295 Dec 20 22:35 easy_install-2.7
-rwxr-xr-x 1 user user     267 Dec 20 22:35 pip
-rwxr-xr-x 1 user user     267 Dec 20 22:35 pip2
-rwxr-xr-x 1 user user     267 Dec 20 22:35 pip2.7
lrwxrwxrwx 1 user user       7 Dec 20 22:35 python -> python2
-rwxr-xr-x 1 user user 3546104 Dec 20 22:35 python2
lrwxrwxrwx 1 usr user       7 Dec 20 22:35 python2.7 -> python2
-rwxr-xr-x 1 user user    2384 Dec 20 22:35 python-config
-rwxr-xr-x 1 user user     274 Dec 20 22:35 wheel

No, I just followed the instructions here -> https://hellowebapp.com/setup/
That site is paired with the Django book I'm reading. Should I have done it differently?

I'm not completely sure how a venv works but I'm guessing the which python & which pip shouldn't be returning an absolute path from root the way they are below. I'm assuming that they should be displaying relative paths from the either the project directory or the venv directory but I don't know for sure

   user@mothership myhellowebapp $ source venv/bin/activate
    (venv) user@mothership myhellowebapp $ which python
    /usr/bin/python
    (venv) user@mothership myhellowebapp $ which pip
    /usr/bin/pip
    (venv) user@mothership myhellowebapp $ locate django-admin.py
    /home/user/.local/bin/django-admin.py
    /home/user/.local/bin/django-admin.pyc
    /home/user/.local/lib/python2.7/site-packages/django/bin/django-admin.py
    /home/user/.local/lib/python2.7/site-packages/django/bin/django-admin.pyc
    /home/user/.local/share/Trash/files/NewerFiles/orig/.local/share/Trash/expunged/3117399120/build/lib/django/bin/django-admin.py
    /home/user/.local/share/Trash/files/NewerFiles/orig/.local/share/Trash/expunged/3117399120/build/scripts-3.3/django-admin.py
    /home/user/.local/share/Trash/files/NewerFiles/orig/.local/share/Trash/expunged/3411875491/build/lib.linux-x86_64-2.7/django/bin/django-admin.py
    /home/user/.local/share/Trash/files/NewerFiles/orig/.local/share/Trash/expunged/3411875491/build/scripts-2.7/django-admin.py
    (venv) user@mothership myhellowebapp

I don't think I bothered to try and install python or pip to the virtual environment but thought I would just use my system wide python and pip for that and instead focust on just installing django localy to the venv. But even when I tried to install python and pip localy to the venv to see if that was the problem this is what I got.

(venv) user@mothership myhellowebapp $ sudo apt-get install python
Reading package lists... Done
Building dependency tree       
Reading state information... Done
python is already the newest version (2.7.11-1).
0 upgraded, 0 newly installed, 0 to remove and 40 not upgraded.
(venv) user@mothership myhellowebapp $ sudo apt-get install python-pip
Reading package lists... Done
Building dependency tree       
Reading state information... Done
python-pip is already the newest version (8.1.1-2ubuntu0.4).
0 upgraded, 0 newly installed, 0 to remove and 40 not upgraded.
(venv) user@mothership myhellowebapp $

[Linux Mint]

Linux Mint

I'm following a book on Django and it has this -> https://hellowebapp.com/setup/ accompanying website. Take a look below at what I'm getting when I get to the "Start your Django project" section of the link.

Here's a peak at my terminal input and feedback.

(venv) user@mothership myhellowebapp $ pip install Django==1.9.6
Collecting Django==1.9.6
Downloading Django-1.9.6-py2.py3-none-any.whl (6.6MB)
100% |████████████████████████████████| 6.6MB 138kB/s
Installing collected packages: Django
Successfully installed Django-1.9.6
You are using pip version 8.1.1, however version 9.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
(venv) user@mothership myhellowebapp $ git init
Initialized empty Git repository in /home/user/projects/python/django-projects/myhellowebapp/.git/
(venv) user@mothership myhellowebapp $ django-admin.py startproject hellowebapp .
django-admin.py: command not found
(venv) user@mothership myhellowebapp $ ls
venv
(venv) user@mothership myhellowebapp $ python django-admin.py startproject hellowebapp .
python: can't open file 'django-admin.py': [Errno 2] No such file or directory
(venv) user@mothership myhellowebapp $ ls

Note that I already have python 2.7 & 3.5 installed on my system and when referring to python my system is by default pointing to python 2.7. Any ideas?

Indeed.

I'm trying to reset my mariadb password following this site -> https://www.rosehosting.com/blog/how-to-reset-your-mariadb-root-password/
but when I enter mysql -u root I get the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

Any ideas? Thanks.

grep -v "#EXTINF:" All.m3u | sed 's#../##'g

I'm using the line above to try and make the playlists that I export from Banshee compatible with my digital music player. When I run the sed portion of this script I'm trying to remove the portion of the path up to where the music directories actually start. I jus want the .m3u file to be a list of lines containing Artists/Album/Title.flac

But when I run this script it's removing all of the forward slashes /, not just the beginning ../
Can anyone tell me why it's removing all of the forward slashes and what I might be able to do about it? Thanks.

I haven't seen this problem before in vim, and since I'm use to being able to backspace in vim it's hard for me not to see it as bug or problem that needs to be fixed.

I recent created a .vimrc file in my home directory because in addition to syntax highlighting and auto indention I also wanted my tabs to be four columns wide and to be tabs and not spaces but now that I have my file setup I am unable to use backspace to remove a newline. When I start backspacing a line the cursor stops at the beginning of the line and will not delete the line move to the end of the line above. Any ideas?

" All system-wide defaults are set in $VIMRUNTIME/debian.vim and sourced by
" the call to :runtime you can find below.  If you wish to change any of those
" settings, you should do it in this file (/etc/vim/vimrc), since debian.vim
" will be overwritten everytime an upgrade of the vim packages is performed.
" It is recommended to make changes after sourcing debian.vim since it alters
" the value of the 'compatible' option. 
" This line should not be removed as it ensures that various options are
" properly set to work with the Vim-related packages available in Debian.
runtime! debian.vim 
" Uncomment the next line to make Vim more Vi-compatible
" NOTE: debian.vim sets 'nocompatible'.  Setting 'compatible' changes numerous
" options, so any other options should be set AFTER setting 'compatible'.
"set compatible 
" Vim5 and later versions support syntax highlighting. Uncommenting the next
" line enables syntax highlighting by default.
if has("syntax")
 syntax on
endif 
" If using a dark background within the …

Thanks, I'm also trying gnome-disks but it's taking forever to format my extern so I'm sure it's even working. I'll check that out. Thanks again.

Linux Mint (Ubuntu).

I'm looking for a way to encrypt some of my external HDDs. I was looking this option over -> https://www.howtoforge.com/tutorial/encrypt-your-data-with-encfs-on-ubuntu/ but I'm not sure how well this would work. I read this on the top portion of the site -> "It is a pass-through filesystem, not an encrypted block device, which means it is created on top of an existing filesystem." What exactly does that mean. I also noticed that the encfs program (encfs) mounts to the encrypted/decrypted directories and since I will be having to mount an external HDD it looks to me like I would have a standard mount to the external HDD to my encrypted direcotry and then another mount from encfs to the same directory. Will that even work? Or, does anyone of any other suugestions or recomendations? Thanks.

Thanks.

I just purchased an 240 GB SSD for my older Toshiba Satellite. I would rather not go through trying to save the files from the HDD and install the Linux Mint Debian Edition and then move all the files back, I would like to just be able to clone the HDD to the SSD. Can anyone give me any direction on that? Thanks.

ALso, I'd like to maybe get some new memory for the laptop and if possible maybe a CPU as well but I know that's less likely. Here's my laptop -> https://www.cnet.com/products/toshiba-satellite-l355d/specs/ After looking over the specs it looks like it only has 3 GB of RAM and it can only have a max of 4 GB. I found this product on amazon, can anyone tell me if this would work? "KOMPUTERBAY 2GB (2x1GB) DDR SODIMM (200 pin) 333Mhz DDR333 PC2700 LAPTOP MEMORY" or maybe two of these "Crucial 2GB Single DDR2 800MHz (PC2-6400) CL6 SODIMM 200-Pin Notebook Memory Module CT25664AC800". Also, is the CPU replaceable and if so what would be a little better and compatible? Thanks.

Thanks for your help.

I havent putchased a lot of hardware for a laptop and I just want to make sure that I get RAM that is compatible with this computer. I figured if I pasted the resutls of inxi it would tell knowledgable observer what kind to get. So will it suffice to just go to amazon or crucial and enter laptop ddr RAM?

Noted. What about the RAM, if I wanted to go ahead and put some new ram in it? What do I need to look for?

I have an older Toshiba Satellite laptop with Linux Mint OS installed. It pretty old and it's starting to show as it's getting slower. It's got a bigger screen and it's even got the num pad on the right of the keyboard in addetion to the numbers at the top. I thought about getting a new one but this has been a good computer and it's built very sturdy, I worked at Best Buy for about 6 months and I didn't see many built this sturdy. So I thought I might just put a few new parts in it to start with, maybe start with a processor and RAM and then maybe later an SSD and a new battery. Anyway here's the specs after running inxi, can someone please tell me what I need to be looking for concerning hardware, I'd like to get what's compatible with this computer and Linux but I'd like to up the specs a little with both the CPU and the RAM. Thanks.

developer@mint-laptop ~ $ inxi
CPU~Dual core AMD Turion X2 Mobile RM-72 (-MCP-) clocked at Min:1050.000Mhz Max:2100.000Mhz Kernel~3.16.0-4-amd64 x86_64 Up~25 min Mem~1108.3/2764.4MB HDD~250.1GB(4.8% used) Procs~167 Client~Shell inxi~2.1.28 

You take it I'm not going to read from the past. Did you notice that I did post a url where I was trying to get help via web search before coming here. I wasn't having any luck. Thanks you so much for your help!

My daughter has a Samsun Android tablet that has ran out of space so I purchased an sd card. The card is mounting and I reformatted it from the Android device but the device is still claiming to be full when she tries to install new apps. I tried this site http://www.howtogeek.com/242937/how-to-set-up-a-new-sd-card-in-android-for-extra-storage/ but that app never popped up when I inserted the sd card into the Samsung's slot. Any ideas on how I can give her extra app storate space for her tablet? Thanks.

Yes, many band names, artits, album names and song names have spaces in them.

The sd card is formatted to FAT32 and it has an exact copy of my music foler. So it looks like this.

artist1/album1/musicFile1.flac
artist1/album1/musicFile.2flat
artist1/album2/musicFile1.flac
artist2/album1/musicFile1.flac
etc...

I don't think it's read only. My music library is syncing from my computer to the sd card fine except that I always get these two errors.

After running rsync with the -a --delete source dest arguments on my music library to my sd card I am getting the following errors.

default_perms_for_dir: sys_acl_get_file(Tears For Fears/Donnie Darko, ACL_TYPE_DEFAULT): No such file or directory, falling back on umask
rsync: mkstemp "/media/garrett/MUSIC-SD/Tears For Fears/Donnie Darko/.Mad World.mp3.yr2Xyc" failed: No such file or directory (2)
rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1183) [sender=3.1.0]

I don't really understand either one of these two erros. It's syncing from source to destination so how can it say 'No such file or directory'? If it's not there wouldn't it just copy it? And that's a very odd file '.Mad World.mp3.yr2xrc' that I can't even find when I look in the source directory myself. And I have no idea what 'ACL_TYPE_DEFAULT' is all about. Any ideas? Thanks.

File

drop database if exists contacts

create database contacts;

use contacts;

create table names
(
    ID mediumint not null auto_increment primary key,
    firstName varchar(20),
    lastName varchar(20)
);

create table addresses
(
    ID mediumint not null auto_increment primary key,
    nameID mediumint not null,
    addr1 varchar(30),
    addr2 varchar(30),
    city varchar(30),
    state varchar(10),
    postal_code varchar(10)
);

insert into names (firstName, lastName)
values ('John', 'Doe'), ('Mary', 'Smith'), ('Bill', 'Jones'), ('Dave', 'White'), ('Jane', 'Tate');

insert into addresses (nameID, addr1, addr2, city, state, postal_code)
select ID, '123 4th Street', '', 'Anytown', 'OH', '12345' from names where firstName='John' and lastName='Doe';

insert into addresses (nameID, addr1, addr2, city, state, postal_code)
select ID, '16 7th Avenue', 'Apt. 9', 'Big City', 'AZ', '23456' from names where firstName='Mary' and lastName='Smith';

insert into addresses (nameID, addr1, addr2, city, state, postal_code)
select ID, '5432 Rose Ct.', 'Number 3', 'Townburg', 'VT', '34567' from names where firstName='Bill' and lastName='Jones';

insert into addresses (nameID, addr1, addr2, city, state, postal_code)
select ID, '456 7th Street', '', 'Hilltop', 'FL', '98756' from names where firstName='Dave' and lastName='White';

insert into addresses (nameID, addr1, addr2, city, state, postal_code)
select ID, '98 Long Road', '', 'Noplaceville', 'AK', '74839' from names where firstName='Jane' and lastName='Tate';

I used this line, source /home/user/db.sql

and I got these errors.

ERROR 1064 (42000) at line 1 in file: '/home/user/db.sql': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'create database contacts' at line 3
ERROR 1049 (42000) at line 5 in …

Well, it's a bunch of independant instructors. Some do and some don't respond. I'm trying there too. Thanks.

Im using a digitaloceans account because I'm following along with a coure on Udemy.com and that was part of the course. So I'm not punching localhost into my browser I'm using IPADDRESS:5000. I agree with you about the virtual environment, I wish the course hadn't used that but maybe had a brief video on it towards the end just to show what it is and how it works. Do you see any possible glues in the error messages as to what might be going on?

Here's my script.

#!/usr/bin/env python3

from flask import Flask

app = Flask(__name__)

@app.route('/')

def homepage():
    return "Hell World"

if __name__ == "__main__":
    app.run()

When I try and run it outside of my venv I get this error.

Traceback (most recent call last):
  File "./__init__.py", line 3, in <module>
    from flask import Flask
ImportError: No module named 'flask'

But if I run source venv/source/activate first I get this

• Running on http://127.0.0.1:5000/ (Press CTRL+C to quit)
  Not that it's actually on a remote serve I setup on DigitalOceans. When I put that in my URL with the real DHCP IP address /var/log/apache/error.log gives me back all of this.

  mod_wsgi: Compiled for Python/2.7.11.
  mod_wsgi: Runtime using Python/2.7.12.
  AH00489: Apache/2.4.18 (Ubuntu) mod_wsgi/4.3.0 Python/2.7.12 configured -- resuming normal operations
  AH00094: Command line: '/usr/sbin/apache2'
  mod_wsgi (pid=31942): Target WSGI script '/var/www/html/FlaskApp/flaskapp.wsgi' cannot be loaded as Python module.
  mod_wsgi (pid=31942): Exception occurred processing WSGI script '/var/www/html/FlaskApp/flaskapp.wsgi'.
  Traceback (most recent call last):
  File "/var/www/html/FlaskApp/flaskapp.wsgi", line 9, in <module>
  from FlaskApp import app as application
  File "/var/www/html/FlaskApp/FlaskApp/init.py", line 3, in <module>
  from flask import Flask
  ImportError: No module named flask
  mod_wsgi (pid=31941): Target WSGI script '/var/www/html/FlaskApp/flaskapp.wsgi' cannot be loaded as Python module., referer: http://ipaddress
  mod_wsgi (pid=31941): Exception occurred processing WSGI script '/var/www/html/FlaskApp/flaskapp.wsgi'., referer: http://ipaddress
  Traceback (most recent call last):, referer: http://ipaddress
  File "/var/www/html/FlaskApp/flaskapp.wsgi", line 9, in <module>, referer: http://IPADDRESS
  from FlaskApp import app as application, referer: …

Thanks Gribouillis, I'll check that out. snippsat, I actually like the LAMP stack and I wanted to use Python instead of PHP in my LAMP stack. I was open to trying Flask or Django but I've had such a terrible time setting them up. I might give it another try. By the way, your site looks gorgeous!

Yea that's what I'm going to do. I like python and I wanted to give it a try at web programming but the setup and management is too difficult. I'll just go back to php.

I have always heard a LAMP stack refered to as Linux, Apache, MySQL (or MariaDB) and PHP. Since Python also starts with a p the term LAMP would still work but that isn't what is usually meant, but is what I'm wanting to try. Just watched another 15 minute video on starting a django project and now I am even more discouraged about using python in my LAMP stack instead of PHP.