DevHeads.net

Postings by bill

reverting to PHP 5.x

I remember seeing a thread go by that said how to revert a 16.04
LTS to use PHP 5.x rather than 7.x

Can anybody give me a link?
bill

setting the network interface

I do remember that some time ago Ubuntu stopped using a static
resolv.conf but I just can't figure out how to set it up now.
I read the manual and it suggests using pre-up and ethtool but I
remember that there is a way of defining the interface by editing
a file, just can't figure out which one.

bill

HPE ProLiant ML10 Gen9 Server

My development server motherboard died. So this time, instead of
getting an old windows machine out and making it a server I
decided to buy new.
I bought a HPE ProLiant ML10 Gen9 Server without disks or OS.
When I started to install 14.04* LTS I got as far as configuring
the NIC and the install said that no NIC was installed.
OK, thinks I, driver problem. To the HPE website.

seeing errors

While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.

when it finished I used the command "show warnings," but only one
warning showed (the last one).

How can I see the warnings earlier in the load ?

-bill

gzip failing to unzip

To find a low frequency failure in a production system I have
been taking periodic dumps (using phymyadmin-export) specifying
that the file be gzipped. It appears to have worked just fine.

Today I went to unzip one of the files to use it as a mysql
source on the development system so I could dig into the problem
and..

gunzip reported:
gzip: IS-2016-12-31.sql.gz: decompression OK, trailing garbage
ignored

The "trailing garbage" is the last 3/4 of the file.

upgrading from 14.04 LTS to 16.04 LTS - mysql problems

I am not in a hurry, but eventually I will have to make this
upgrade. I have a large application written in PHP (php 5.5)
which will not run on php 7.x until I do a LOT of work on the mysql.

Q1: does 16.04 upgrade php to 7, and
Q2: can I prevent that or downgrade back to php 5.x

bill

phpMyAdmin - apache configuration issue

I updated/upgraded my 14.04LTS server and the url:
<a href="http://192.168.0.200/phpmyadmin" title="http://192.168.0.200/phpmyadmin">http://192.168.0.200/phpmyadmin</a>
no longer works. Error message is 404.

I know that invoking phpmyadmin is done in a weird way, i.e:
there is no folder named phpmyadmin in the document root.

This is on my backup system that is a replication slave and afaik
everything else is working just fine: can access other, "normal"
pages.

I asked for help in the php ng, no joy, so I am asking here.
Having been contaminated by using WinBlows computers I did a
apt-get remove phpmyadmin, a apt-get autoremove, a apt-get
install.

after reboot and slave resync phpMyAdmin is not accessible

I know this looks like a mysql question, but I suspect it is a
Ubuntu configuration problem.

When I try to access phpmyadmin I get a 404
The requested URL /phpmyadmin/index.php was not found on this server.
Apache/2.4.7 (Ubuntu) Server at 192.168.0.200 Port 80
any suggestions ?

shutdown by regular user

How can a non-privileged user initiate a shutdown.

There is one person with an administrative account and sudo
privleges. There are 3 others with no account. Frequently, in
case of emergency shutdown the admin user is not available.

I would like to set up a regular user but make it possible for
that user to run shutdown. In Unix I would use asroot, but Ubuntu
14.4 LTS does not have that.

How can I do this.

-bill

which user is Apache2

I want to set up an include file (php) outside the directory tree
- done
I want to limit access to the file to the php module under Apache2.

Who should I set the user/group to ?

I have played with it and can give you a list of users to NOT set
it to :-)

-bill

key management - 1404 encrypted filesystem

I have read the man pages for eCryptFS and the ubuntu.com pages,
but I can't find anything on removing a key from the kernel
keyring. ecryptfs-utils can add a key (via
ecryptfs-add-passphrase or ecryptfs-manager).

Can a passphrase be removed ?
-bill

new install 14.04 LTS

All went well. But when I try to log in with putty or FileZilla
I get:
Error: Network error: Connection refused
Error: Could not connect to server

Ideas ? Suggestions ?

-bill

not replicating one table

Ubuntu 14.04 LTS, MySQL 5.5.38
I have a setup with multiple tables in one database. One is a
memory table. I have replication running to a remote computer
for a hot backup.

I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the in memory table.

Suggestions, hints, and links appreciated.

-bill

upgrading to 14.04 - again - no libphp5.so

Apache complains that it can not load libphp5.so for the very
good reason that it is not present in /usr/lib/apache2/modules.

I tried upgrading php, but no joy.

suggestions ?

after 12.04 LTS upgrade

The upgrade apparently went fine.
But I can no longer use FileZilla:

Status: Connecting to 192.168.0.101:21...
Status: Connection established, waiting for welcome message...
Response: 220 (vsFTPd 3.0.2)
Command: USER william
Response: 331 Please specify the password.
Command: PASS ******
Response: no talloc stackframe at
../source3/param/loadparm.c:4864, leaking memory
Error: Could not connect to server

I haven't a clue what this means or how to fix it.
Suggestions please.

-bill

dist-upgrade

I am doing an in-place upgrade from 12.04 to 14.04 and all is
going well, except...
I have a bunch of files in /boot, some abi-..., some config-...,
some initred.img-..., some System.map-... some vmlinuz-..., and
some others.
The upgrader is doing something to those files and it is taking
roughly forever. I thought it was a loop until I noticed that
the kernel numbers were changing.

here is what it keeps repeating:
Updating /boot/grub/menu.lst ...

Replication problem

Replication novice

I have a master server at the office and a replication server at
home. This setup has been working for a couple of years.
Occasionally the replication server gets out of sync (usually
following a internet problem and the vpn going down.)
I just stop the slave, make sure there is nothing going to the
master (when the office is closed),
copy the database,
transfer the file,
load the backup, and
start the slave and all is well.

This time there was not a communications problem of which I am
aware.

dns-nameservers

When I installed 12.04 lts it appears I inadvertently listed a
bad address for 1 of the 2 nameservers. I have googled and
looked in the manual, but I can't find out where the nameservers
are listed. I did add one nameserver to /etc/network/interfaces
and that one does show up on resolve.conf, but another (good)
nameserver also is in resolve.conf as is the bad address.

Can anyone give me a clue where the "default" (ie: not in
/etc/network/interfaces) might be residing

--bill

Help with cleaning up data

I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.

CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL,
`icd10` char(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `icd9` (`icd9`,`id`),
UNIQUE KEY `icd10` (`icd10`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=ascii

id icd9 icd10
25 29182 F10182
26 29182 F10282
27 29182 F10982

I just can't think of a way to write a querey to delete the
duplicates.

help -networking

The server I use for development blew its motherboard. I
switched the (only) hard disk to another system and it boots
fine. But, when I try to ping to or from the new system it
reports "Destination unreachable"

/etc/network/interfaces has one eth entry for eth2.
It is the same as it was before the motherboard switch.

I sure could use some help in getting this system back on line.

bill

upgrading 12.4 LTS PHP

The 12.04 LTS php is 5.3. I would like to upgrade to the most
current stable version in the repositories.

I did a sudo upgrade but did not see php on the list.

what is the proper way:
to find out what the php release in the repository is?
upgrade that package.

bill

Query help -

I have a table, schedule:
CREATE TABLE `schedule` (
`schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`provider` varchar(15) NOT NULL,
`apptTime` datetime NOT NULL,
`location` varchar(10) NOT NULL,
`duration` smallint(5) unsigned NOT NULL,
`standing_script` mediumint(9) DEFAULT NULL,
`appt_status` char(1) NOT NULL,
`patient_number` mediumint(9) NOT NULL,
`notify` smallint(6) DEFAULT NULL,
`comment` varchar(80) DEFAULT NULL,
`history` varchar(200) DEFAULT NULL,
`posted` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`schedule_id`),
UNIQUE KEY `patient`

select and update in the same statement

I am finding I need to retrieve data from a row and also update
the 'lastAccess' field in that row. I am using PHP and now do it
in two calls to MySQL.
Can one of the wizards suggest a way that I can do both in one call ?

Not a big deal, just interesting.

bill

unable to enumerate USB device: APCUSBD

I have a APC 750 with the usb port connected to a 12.04 Unbutu
system.

After about a day of operation I start getting the following error:

Aug 31 23:13:57 ubuntu3 kernel: [128564.632031] hub 2-0:1.0:
unable to enumerate USB device on port 3

Checking the syslog I find the following repeated over and over,
with the device number going up by one each time:

Aug 31 23:13:25 ubuntu3 kernel: [128532.951308] hub 2-0:1.0: port
3 disabled by hub (EMI?), re-enabling...
Aug 31 23:13:25 ubuntu3 kernel: [128532.952063] usb 2-3: USB
disconnect, device number 110
Aug 31 23:13:25 ubuntu3 kernel: [1285

APC UPS losing comm with 12.04

When I start up my recently updated ubuntu unix (now at 12.04)
all works just fine and apcupsd and multimon.cgi and apcaccess
report good data. After about 30 min (rough guess) the system
console reports:

Aug 28 14:33:13 ubuntu3 kernel: [98814.108038] hub 2-0:1.0:
unable to enumerate USB device on port 3

and apaccess says status: COMMLOST

The usb plugs are tight.
I did have this problem before I updated from 10.04LTS

Anyone have any suggestions on how to debug/fix this ?

bill

small problem with 10.04 -> 12.04 upgrade

I upgraded our main server without problem.
At the end of the upgrade of the backup server I answered the
question about rebooting with a blank rather than a Y.

I was presented with a choice that didn't make a lot of sense and
Ican't remember which I selected.

The system started the upgrade again and at the first opportunity
I quit and rebooted.

It seems to run 12.04 just fine, but instead of the 12.04
splash/progress screen I get a grub (I presume) menu asking which
version I want to boot.

update doesn't

I have a table ("tasks") with:
task_id mediumint(9)
status char(1)
priority char(1)
and more fields

when I do the following (using phpMyAdmin):
update tasks
set status='H'
where task_id='1'

I get 1 row affected, but the status does not change when I look
at the row.

If I set it to 'X' it does change.

To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the row (using the pencil icon=Edit) it changes back to 'W'.

Either there is something really strange or my mysql is possessed.

I am using Server ve

update problem

when I try to update one of my 10.04 LTS systems I am getting:

Err <a href="http://security.ubuntu.com" title="http://security.ubuntu.com">http://security.ubuntu.com</a> lucid-security Release.gpg
Could not resolve 'security.ubuntu.com'

and each additional package fails in the same way.

another system at a different location updates fine.

Suggestions ?

bill

do-release-upgrade

I am at 10.04.1 LTS
when I type:
sudo do-release-upgrade
I get:
Checking for a new ubuntu release
No new release found

I want to go to 12.04 LTS

bill

conditional updating

I want to update a date field in a record. if the date in the
field is 0000-00-00 I want to change it to the current date. I
would appreciate suggestions or links on how to do this.

Yup, tried reading the manual, but need a bit of help.
I will be updating another field at the same time.

bill