Hi all,

Thanks for your responses and sorry about the late reply.
The problem is that on my COS box at home, I have to reboot several times before it boots up normally. With the COS box at work the problem only happened once.
By default the latest / first kernel is selected, but as you can see in the pictures it initially boots up in emergency mode.

There is not much that I was able to troubleshoot. Before the last big update I was able to boot up with the rescue kernel.

I have checked the disk space and I did not find any problems:

Please assist,

John

Hi all,

Since the latest reboot I discovered that the problem has partially returned on two separate COS boxes. Our web & mail server was temporarily off-line because of it.
I was unable to reproduce the problem, but to be sure that it does not happen again, I changed the default kernel to the rescue kernel.

Can anyone help me to prevent this problem from returning and to use the latest kernel instead of the rescue one by default ... ?!?

Please assist,

John

Thanks B.

The "yum upgrade" did the trick.
I used to have some problem with an older kernel so I had disabled automatic updates and ran the rescue kernel, but in the mean time these problems have been solved.

I also successfully installed OpenVPN from the marketplace.

Greetings & thanks,

John

Hi B.

Thanks for your response.
Here are the results you asked for:
This error message was in my browser after enabling debugging:

/var/log/webconfig/debug.log:


Please assist,

John

Webconfig UI no longer working after installing OpenVPN

Hi all,

Yesterday I installed OpenVPN from the marketplace and since then I am unable to access the web interface on my gateway box from a client.
Also on the box itself I do not see the web interface after a successful login (just a white screen and a mouse pointer).
I am able to login with PuTTy & WinSCP from a client and my clients have Internet access.
I attempted to solve the problem with the following, but slapd was running and restarting the web interface did not solve the problem:


Uninstalling openvpn also did not solve the problem:

Please assist,

John

bump

Sry for bumping this thread, but I believe that something is wrong with my setup.
We are unable to access any of the Windows File Shares with our own accounts. Only with the WinAdmin account it is possible to access the Flexshares.
I could use some help, so please assist.

John

Hi all,

Thanks for responding.
The only thing I was able to test was to comment out "syslog = 0" in /etc/samba/smb.conf, but this did not solve the problem.

I discovered the following (tested from a Windows client):
When I attempt to browse to the Flexshares, I am asked for a uid & pw.
When I enter my own account, I am only able to view the Flexshare folders available, but I am not allowed to enter them. I do not see my home directory.
When I login with the winadmin account I am able to view and enter the Flexshares.
I am asked for a uid & pw twice ... once when connecting to the cos box and once when I attempt to enter the Flexshares.

Please advice,

John

Unable to access Flexshares thrue Samba

Hi All,

We have a problem trying to access our Windows file share Flexshare from Windows10 & Ubuntu clients. When we connect to \\<cos>.lan (or smb://<cos> on Linux) we see all the available Flexshares.
The group owner of the Flexshare is "allusers". We confirmed that the user has rights for the "users" group.
When we attempt to access the same Flexshare in a web browser, we are able to log on to it and browse thrue it's content (http://<cos>/flexshare/<flexshare>.
The samba service is up and running and rebooting the COS box did not solve the problem.
This is what is mentioned in the samba log files after several unsuccessful attempts from my workstation:

Please assist,

John

Hi Rich,

We encountered the same problems with our web Flexshares. Even Flexshares that contain only html contents require a third party access (read only) since last week.
I would like to add another issue, because the web Flexshares with "Require Authentication" enabled are inaccessible. At the same time it is possible to access the ClearOS webconfig page to change the password of the same account.

Please assist,

John.

PHPMyAdmin Joomla value 0

Hi all,

Recently we encountered the problem that we are unable to add new users to a site made with Joomla with the following error message:

Save failed with the following error: 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 ' 3)' at line 3 SQL=INSERT INTO `#__user_usergroup_map` (`user_id`,`group_id`) VALUES (, 3)

ClearOS version 7.3, Joomla version 3.6.5, PHP version 5.4.16
We where able to fix this by manually editing the PHPMyAdmin table "<prefix>_users" and changing the id entry from 0 to the currently highest number + 1.

Manually patching the "<prefix>_contact_details" table is required as well, when creating a contact (highest number + 1).
But ... when we attempt to add/edit a Joomla contact, we encounter a similar issuewith the following error message:

Save failed with the following error: Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__ucm_history` (`ucm_item_id`,`ucm_type_id`,`version_note`,`save_date`,`editor_user_id`,`character_count`,`sha1_hash`,`version_data`) VALUES ('30','3','','2017-04-18 12:10:42','475','1796','0a77a4e1d9bf7a121d06526a55049454314f7a3c','{\"id\":30,\"name\":\"Daniel W.\",\"alias\":\"daniel-w\",\"con_position\":\"Programmeur \\/ Designer\",\"address\":\"Koningin Wilhelminalaan 6\",\"suburb\":\"Utrecht\",\"state\":\"\",\"country\":\"\",\"postcode\":\"3734 AC\",\"telephone\":\"030 - 760 2 760\",\"fax\":\"\",\"misc\":\"\",\"image\":\"\",\"email_to\":\"danielw@ict-stadsbrug.nl\",\"default_con\":0,\"published\":\"1\",\"checked_out\":\"475\",\"checked_out_time\":\"2017-04-18 12:10:29\",\"ordering\":\"20\",\"params\":\"{\\\"show_contact_category\\\":\\\"\\\",\\\"show_contact_list\\\":\\\"\\\",\\\"presentation_style\\\":\\\"\\\",\\\"show_tags\\\":\\\"\\\",\\\"show_name\\\":\\\"\\\",\\\"show_position\\\":\\\"\\\",\\\"show_email\\\":\\\"\\\",\\\"show_street_address\\\":\\\"\\\",\\\"show_suburb\\\":\\\"\\\",\\\"show_state\\\":\\\"\\\",\\\"show_postcode\\\":\\\"\\\",\\\"show_country\\\":\\\"\\\",\\\"show_telephone\\\":\\\"\\\",\\\"show_mobile\\\":\\\"\\\",\\\"show_fax\\\":\\\"\\\",\\\"show_webpage\\\":\\\"\\\",\\\"show_misc\\\":\\\"\\\",\\\"show_image\\\":\\\"\\\",\\\"allow_vcard\\\":\\\"\\\",\\\"show_articles\\\":\\\"\\\",\\\"articles_display_num\\\":\\\"\\\",\\\"show_profile\\\":\\\"\\\",\\\"show_links\\\":\\\"\\\",\\\"linka_name\\\":\\\"\\\",\\\"linka\\\":false,\\\"linkb_name\\\":\\\"\\\",\\\"linkb\\\":false,\\\"linkc_name\\\":\\\"\\\",\\\"linkc\\\":false,\\\"linkd_name\\\":\\\"\\\",\\\"linkd\\\":false,\\\"linke_name\\\":\\\"\\\",\\\"linke\\\":false,\\\"contact_layout\\\":\\\"\\\",\\\"show_email_form\\\":\\\"\\\",\\\"show_email_copy\\\":\\\"\\\",\\\"banned_email\\\":\\\"\\\",\\\"banned_subject\\\":\\\"\\\",\\\"banned_text\\\":\\\"\\\",\\\"validate_session\\\":\\\"\\\",\\\"custom_reply\\\":\\\"\\\",\\\"redirect\\\":\\\"\\\"}\",\"user_id\":\"486\",\"catid\":\"4\",\"access\":\"1\",\"mobile\":\"\",\"webpage\":\"http:\\/\\/ict-stadsbrug.nl\",\"sortname1\":\"\",\"sortname2\":\"\",\"sortname3\":\"\",\"language\":\"*\",\"created\":\"2017-04-18 11:29:21\",\"created_by\":\"475\",\"created_by_alias\":\"\",\"modified\":\"2017-04-18 12:10:42\",\"modified_by\":\"475\",\"metakey\":\"\",\"metadesc\":\"\",\"metadata\":\"{\\\"robots\\\":\\\"\\\",\\\"rights\\\":\\\"\\\"}\",\"featured\":\"0\",\"xreference\":\"\",\"publish_up\":\"0000-00-00 00:00:00\",\"publish_down\":\"0000-00-00 00:00:00\",\"version\":4,\"hits\":\"0\"}')

AFAIK it is not table <prefix>_ucm_history.
Please assist,

John