#sources.list

Em alguns casos, ao instalar o Linux 16.04 LTS, ao atualizar o sistema por meio do terminal (sudo apt-get update ou sudo apt-get upgrade), o mesmo pode retornar alguns erros, como “Failed to fetch“. Estas situações ocorrem, pois o arquivo que contém os links de atualização pode conter links quebrados e impossibilitam seu sistema de realizar instalações e atualizações em muitos casos. Para solucionar o problema é preciso substituir o arquivo sources.list do seu sistema pelas informações encontradas abaixo, que referem-se a links atualizados e comentários. Segue um pequeno tutorial para a auxiliar a atualização:

Com este comando, garante permissão de modificação para a pasta /etc/apt que contém o arquivo sources.list (que será modificado). 

$ sudo nano /etc/apt/sources.list

Substitua as informações do seu arquivo pelas informações encontradas abaixo com Ctrl + V no terminal. Salve com Ctrl + O e feche o arquivo com Ctrl + X.

Se preferir, utilize o Gedit:

$ sudo gedit /etc/apt/sources.list

#------------------------------------------------------------------------------# #                            OFFICIAL UBUNTU 15.04 REPOS               # #------------------------------------------------------------------------------#

###### Ubuntu Main Repos deb http://us.archive.ubuntu.com/ubuntu/ vivid main restricted universe multiverse

###### Ubuntu Update Repos deb http://us.archive.ubuntu.com/ubuntu/ vivid-security main restricted universe multiverse deb http://us.archive.ubuntu.com/ubuntu/ vivid-updates main restricted universe multiverse deb http://us.archive.ubuntu.com/ubuntu/ vivid-proposed main restricted universe multiverse deb http://us.archive.ubuntu.com/ubuntu/ vivid-backports main restricted universe multiverse

###### Ubuntu Partner Repo deb http://archive.canonical.com/ubuntu vivid partner

#------------------------------------------------------------------------------# #                           UNOFFICIAL UBUNTU 15.04 REPOS           # #------------------------------------------------------------------------------#

#### Dropbox PPA - http://dropbox.com

#### Gimp PPA - https://launchpad.net/~otto-kesselgulasch/+archive/gimp

#### GNOME3 Extra Apps PPA - https://launchpad.net/~gnome3-team/+archive/gnome3

#### Google Chrome Browser - http://www.google.com/linuxrepositories/-

#### Google Earth - http://www.google.com/linuxrepositories/

#### Kubuntu Backports PPA - https://edge.launchpad.net/~kubuntu-ppa/+archive/backports

#### LibreOffice PPA - http://www.documentfoundation.org/download/

#### MultiSystem - http://liveusb.info/dotclear/

#### Opera - http://www.opera.com/

#### Oracle Java (JDK) Installer PPA - http://www.webupd8.org/2012/01/install-oracle-java-jdk-7-in-ubuntu-via.html

#### Plex Media Center - http://www.plexapp.com

#### SimpleScreenRecorder PPA - http://www.maartenbaert.be/simplescreenrecorder/

#### Steam for Linux - http://store.steampowered.com/about/

#### Tor: anonymity online - https://www.torproject.org

#### Unsettings PPA - http://www.florian-diesch.de/software/unsettings/

#### WebUpd8 PPA - http://www.webupd8.org/

#### Xorg Edgers PPA - https://launchpad.net/~xorg-edgers

#------------------------------------------------------------------------------# #                           INSTALAÇÃO DAS CHAVES GPG                          # #------------------------------------------------------------------------------#

# Rode os comandos abaixo via terminal

# sudo apt-get update && sudo apt-get install wget curl

# Dropbox -- sudo apt-key adv --keyserver pgp.mit.edu --recv-keys 5044912E # Gimp -- sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 614C4B38 # Gnome3 Extra -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 3B1510FD # Google Chrome Stable -- wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -O- | sudo apt-key add - # Google Earth -- wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -O- | sudo apt-key add - # Kubuntu Backports -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8AC93F7A # LibreOffice -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 1378B444 # MultiSystem -- wget -q http://liveusb.info/multisystem/depot/multisystem.asc -O- | sudo apt-key add - # Opera -- sudo wget -O - http://deb.opera.com/archive.key | sudo apt-key add - # Oracle Java (JDK) -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys EEA14886 # Plex Media Center -- wget -c http://plex.r.worldssl.net/PlexMediaServer/ubuntu-repo/pool/main/p/plex-archive-keyring/plex-archive-keyring_2.0.0_all.deb && sudo dpkg -i plex-archive-keyring_2.0.0_all.deb # SimpleScreenRecorder -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 283EC8CD # Steam For Linux -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys F24AEA9FB05498B7 # Tor Navegador anonimo -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 886DDD89 # Unsettings -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 0FEB6DD9 # WebUpd8 -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 4C9D234C # Xorg Edgers -- sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8844C542

Espero que este breve artigo tenha ajudado nesse árduo caminho que você escolheu. No caso de qualquer erro ou dúvida que tenha surgido ao longo deste breve tutorial, sinta-se totalmente livre para entrar em contato.

New Post has been published on http://websetnet.com/owncloud-7-installation-and-configuration-on-debian-7-wheezy/

OwnCloud 7 installation and configuration on Debian 7 (Wheezy)

Installation and configuration of ownCloud 7 on Debian 7 (Wheezy)

Version 1.0 Author: Srijan Kishore Last edited 08/Sep/2014

This document describes how to install and configure ownCloud 7 on Debian 7. I will also describe how to connect to the ownCloud Server's data with Ubuntu 14.04 desktop and windows 7 machine. ownCloud provides access to your data through a web interface or WebDAV while providing a platform to easily view, sync and share across devices—all under your control. ownCloud’s open architecture is extensible via a simple but powerful API for applications and plugins and works with any storage.

1 Preliminary Note

This tutorial is based on Debian 7 server, so you should set up a basic Debian 7 server installation before you continue with this tutorial. The system should have a static IP address. I use 192.168.0.100 as my [...] in this tutorial and server1.example.com as the hostname. Again I have  192.168.0.101 as IP address of Ubuntu 14.04 Desktop and server2.example.com as the hostname. I will be using the user=srijan for the installation and configuration. I will also show the ownCloud sharing options with windows machine, so I have working Windows 7 machine too.

  2 Installation of ownCloud 7

ownCloud is a web application that can store and serve content from a centralized location, much like Dropbox. The difference is that ownCloud 7 allows you to host the serving software on your own machines, taking the trust issues out of putting your personal data someone else's server.

We will first download the release key associated with the ownCloud software:

cd /tmp wget http://download.opensuse.org/repositories/isv:ownCloud:community/Debian_7.0/Release.key apt-key add - < Release.key

Then we can add the ownCloud 7 repository as follows:

echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/Debian_7.0/ /' >> /etc/apt/sources.list.d/owncloud.list

Finally, update the package database and install ownCloud:

apt-get update apt-get install owncloud

3 ownCloud 7 configuration on Debian Wheezy

Further we need to install Mysql to get the configurations as follows:

apt-get install mysql-server

It will ask for password input, just enter your desired password there.

New password for the MySQL "root" user: <--mysqlpassword Repeat password for the MySQL "root" user: <--mysqlpassword

We will be configuring our ownCloud server to take advantage of the more robust MySQL database instead of the SQLite default implementation. To do so, we must configure MySQL first as:

mysql -u root -p

Put the Mysql password which you selected before, & create a database for ownCloud in Mysql prompt:

CREATE DATABASE owncloud;

Assign privileges to a new MySQL user to handle database operations for ownCloud:

GRANT ALL ON owncloud.* to 'owncloud'@'localhost' IDENTIFIED BY 'database_password';

exit

Now, if you go to your IP address or domain name followed by "/owncloud" in your browser, you will see a page that looks like this:

[...]

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

Click on Storage & database:

[...]

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

Now select MySQL/MariaDB and create an admin account as in my case I have choosen owncloud as my admin account and a desired password for that user:

[...]

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

In the lower tab below the MySQL/MariaDB give the entry of the username=owncloud password=database_password databasename=owncloud.

Then press Finish setup.

[...]

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

[...]

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

4 Mounting the ownCloud 7 share with Ubuntu 14.04

We can mount the shared point with the other machines, here I will show you the way to process to moint it through WebDAV tools in another Ubuntu Desktop machine. There are two methods to use ownCloud 7 as a client in Ubuntu Desktop.

Manual mount by giving entries installing davfs2

By installing ownCloud 7 client

I will explain both of them, you can use any of them to mount.

4.1 Manual mount through davfs2

I am running the command on my second machine server2.example.com:

sudo apt-get update

sudo apt-get install davfs2

We will allow non-root users to mount and unmount the WebDAV shares by typing:

sudo dpkg-reconfigure davfs2

Should unprivileged users be allowed to mount WebDAV resources? <--Yes

Moving ahead I will be adding my username=srijan to WebDAV group:

 sudo usermod -aG davfs2 srijan

We want to make the permanent mount point in server2.example.com, so I will give the following entries in the /etc/fstab:

sudo vi /etc/fstab

[...] 192.168.0.100/owncloud/remote.php/webdav /home/srijan/owncloud davfs user,rw,noauto 0 0

Now in user=srijan's home drive I will create directories, one to mount the share point and another to hold the configurations details:

mkdir ~/owncloud

 mkdir ~/.davfs2

Further create a file as:

vi ~/.davfs2/secrets

192.168.0.100/owncloud/remote.php/webdav owncloud database_password

Ensure that the file is writable by only you by using the file manager or by issuing the following command:

chmod 600 ~/.davfs2/secrets

Now we will mount it as follows:

mount owncloud/

srijan@server2:~$ sudo mount owncloud/ Please enter the username to authenticate with server 192.168.0.100/owncloud/remote.php/webdav/ or hit enter for none. Username: owncloud Please enter the password to authenticate user owncloud with server 192.168.0.100/owncloud/remote.php/webdav/ or hit enter for none. Password:  database_password srijan@server2:~$

Note: The given credentials will be used further, so please take a note of it:

Username: owncloud Password: database_password

Further if you find any permissions error in the folder then change the folder permission as owner of the user:

chown -R srijan:srijan owncloud/

To automatically mount the folder on login at server2.example.com, add the mount ~/owncloud command to the ~/.bashrc file.

vi ~/.bashrc

[...] mount ~/owncloud

After mounting successfully you can get some error Resource temporarily unavailable and Certificate warnings then it can be removed as follows:

For Resource temporarily unavailable:

vi /etc/davfs2/davfs2.conf

[...] use_locks 0

For Certificate warnings:

If you use a self-signed certificate, you will get a warning. If you are willing to take the risk of a man in the middle attack, run this command instead:

echo "y" | mount ~/owncloud > /dev/null 2>&1

4.2 ownCloud 7 client installation by ownCloud

Open [...] and select the distribution Ubuntu 14.04, further in your Ubuntu Desktop put the commands:

cd /tmp wget http://download.opensuse.org/repositories/isv:ownCloud:desktop/xUbuntu_14.04/Release.key sudo apt-key add - < Release.key

sudo sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/desktop/xUbuntu_14.04/ /' >> /etc/apt/sources.list.d/owncloud-client.list" sudo apt-get update sudo apt-get install owncloud-client

It will install ownCloud-client in the Ubuntu 14.04 Desktop. Thats it open ownCloud-client

[...]

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

Put the server path as 192.168.0.100/owncloud and then put your credentials of username=owncloud  and password=database_password

[...]

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

Further if you are using it without https theen you can ignore the error and move ahead:

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

Again:

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

Then it will map the ownCloud with your dekstop:

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

And then finally all data will get synced:

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

5 Mounting the ownCloud 7 share with Windows 7

We can access the data from ownCloud 7 server on a window machine also. There are many methods to this, you can check this link for them. I will explain two of them.

I will be using the ownCloud clients for that. Open link and download the windows client from here

Simply install the client and it will work for you.

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

Enter the details http://192.168.0.100/owncloud:

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

Again give your credentials(  user=owncloud and password=database_password) which we have settup while installing the ownCloud 7 and the window will appear:

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

You can open the local folder to access the files locally.

Cyberduck ver 4.5.

There is another method to access the ownCloud 7 server. I will be using Cyberduck for that. For this you need to install it from this URL.

Download the installer and install it simply by doing next --next.

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

Cyberduck has a very nice user interface.

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

Enter the credentials & connect 192.168.0.100/owncloud/remote.php/webdav with user=owncloud and password=database_password:

  (JavaScript must be enabled in your browser to view the large image as an image overlay.)

安裝 PostgreSQL & phpPgAdmin

增加Source list

$sudo vi /etc/apt/sources.list

$deb http://ppa.launchpad.net/pitti/postgresql/ubuntu lucid main

$deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu lucid main

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8683D8A2

更新Source

$sudo apt-get update

安裝9.0 & phppgadmin

$sudo apt-get install postgresql-9.0

$sudo apt-get install phppgadmin ※自己抓回來裝也可以!

設定 PostgreSQL  

$sudo vi /etc/postgresql/9.0/main/pg_hba.conf

將method的部分視情況設定! 預設是md5。另有trust(不用密碼)、password(密碼登入)選項! 選擇登入方式。

然後存檔，重新啟動!

$sudo /etc/init.d/postgresql restart

以postgres身份登入預設資料庫template1

$psql - U postgres -d template1

 建立帳號密碼為pg_root的管理員

create user pg_root with password 'pg_root' createdb createuser;

修改 postgres 的密碼為 postgres 

alter user postgres with password 'postgres';

phpPgAdmin 基本上複製到網頁目錄下就安裝完成，要注意 conf 資料夾裡是否存在 config.inc.php 檔案，如果沒有就把 config.inc.php-dist 改名成 config.inc.php 即可!

備份資料庫

pg_dump -U [使用者] -f [輸出檔名] [資料庫名]

還原資料庫

psql -U [使用者] -d [資料庫名] < [SQL Script File]

參考資料

如何在 Ubuntu 下安裝 PostgreSQL 9.0 和 pgAdmin III 1.12.0

PostgreSql的建立和管理

在RHEL/CENTOS 上使用 PostgreSQL資料庫