| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 348 online users.
» 0 Member(s) | 346 Guest(s)
Bing, Google
|
| Latest Threads |
UserSpice Alpha Testing a...
Forum: News Center
Last Post: ivinsons
11-08-2024, 06:13 PM
» Replies: 13
» Views: 42,475
|
UserSpice 4.4 Development
Forum: News Center
Last Post: Amelie12
09-21-2024, 12:23 PM
» Replies: 4
» Views: 15,199
|
Welcome to the new UserSp...
Forum: News Center
Last Post: ivinsons
08-25-2024, 07:39 AM
» Replies: 2
» Views: 27,918
|
How to use hasPerm
Forum: UserSpice 4.4
Last Post: mudmin
07-20-2019, 02:45 PM
» Replies: 1
» Views: 13,755
|
Session issue? What I sho...
Forum: UserSpice 4.4
Last Post: Parth
07-17-2019, 05:06 PM
» Replies: 4
» Views: 14,502
|
Email Error
Forum: UserSpice 4.4
Last Post: Brandin
07-17-2019, 04:47 PM
» Replies: 1
» Views: 6,623
|
{ Missing Text } after up...
Forum: UserSpice 4.4
Last Post: Brandin
07-16-2019, 04:23 PM
» Replies: 22
» Views: 53,638
|
Best Practice Info
Forum: New to UserSpice?
Last Post: Brandin
07-16-2019, 11:55 AM
» Replies: 1
» Views: 13,490
|
Force to use 2FA -always-
Forum: UserSpice 4.4
Last Post: Brandin
07-12-2019, 12:43 PM
» Replies: 1
» Views: 6,636
|
e-mail not verifying
Forum: UserSpice 4.4
Last Post: LBC
07-10-2019, 11:34 AM
» Replies: 31
» Views: 76,232
|
|
|
| Database connection unsuccessful! |
|
Posted by: W11B2349 - 04-09-2019, 06:42 PM - Forum: UserSpice 4.4
- Replies (8)
|
 |
Brand new installation of 4.4
I was able to connect to my remote MySQL server when using my own PHP applications, however when I attempt to install userspice it's saying I can't connect.
Currently I'm using a web server and a separate MySQL server, both of which are using Windows Server 2016.
Is there a good way to go about debugging this? Thanks in advance!
|
|
|
|
| Notice: undefined index: |
|
Posted by: artoo80 - 04-09-2019, 03:40 PM - Forum: UserSpice 4.4
- Replies (1)
|
 |
Code: Notice: Undefined index: kUserSessionID in /var/TFH/users/views/_admin_sessions.php on line 100
upgraded from 404: it is visible in the session administrator - I have not traced it back yet but wander whether anyone else has seen it
|
|
|
|
| [Howto] Connect Microsoft Azure MySQL with SSL |
|
Posted by: stonez56 - 04-09-2019, 08:27 AM - Forum: UserSpice 4.4
- Replies (2)
|
|
Hi all,
This is my first post! 
Thanks for this great PHP user management framework.
It saved me a lot of time to management users in my PHP application!
For about a week, I tried to figure out how to connect MS Azure MySQL with SSL.
Finally, I got it worked. And I am very happy to share this with you!
Software versions: - UserSpice V4.4
- Azure MySQL 5.7.24-log (MySQL Community Server (GPL)
- OS: Win64
1) In /users/init.php, update correct Azure Mysql User name, password, db name, and password:
Code: // Set config
$GLOBALS['config'] = array(
'mysql' => array(
'host' => 'yoursystem.mysql.database.azure.com',
'username' => 'mysqladm@yoursystem',
'password' => 'your_password',
'db' => 'your_db',
),
'remember' => array(
'cookie_name' => 'ejiasdf93asdfj',
'cookie_expiry' => 604800 //One week, feel free to make it longer
),
'session' => array(
'session_name' => 'user',
'token_name' => 'token',
)
);
2) Download CA certifications here (BaltimoreCyberTrustRoot.crt.pem) from here and save it in your website.
In my case, I saved this file at d:\home\site\wwwroot\
3) Then, in /users/classes/DB.php,
add two lines, in PDO connects as options around LINE 31:
PDO::MYSQL_ATTR_SSL_CA => "d:\home\site\wwwroot\BaltimoreCyberTrustRoot.crt.pem",
PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false
Code: class DB {
private static $_instance = null;
private $_pdo, $_query, $_error = false, $_errorInfo, $_results=[], $_resultsArray=[], $_count = 0, $_lastId, $_queryCount=0;
private function __construct($config = []){
if (!$opts = Config::get('mysql/options'))
$opts = array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET SESSION sql_mode = ''",
PDO::MYSQL_ATTR_SSL_CA => "d:\home\site\wwwroot\BaltimoreCyberTrustRoot.crt.pem",
PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false
);
try{
if($config == []){
$this->_pdo = new PDO('mysql:host=' .
Config::get('mysql/host') .';dbname='.
Config::get('mysql/db') . ';charset=utf8',
Config::get('mysql/username'),
Config::get('mysql/password'),
$opts);
}......more codes.... below
Then, you should be able to connect to Microsoft Azure MySQL with SSL enabled!
Hope this is helpful to you!
Stonez
|
|
|
|
| Hello Everybody! |
|
Posted by: paktrad - 04-06-2019, 09:44 AM - Forum: New to UserSpice?
- Replies (1)
|
|
I am Muhammd Khan and I am new to userspice and this site. I am 57 and trying to learn web development so I can stay focused, active and productive as I grow old. I have fair level of skills in php/mysql and tried learning Laravel before landing here.
I must say I am finding learning userspice way more easier and productive than my previous endeavors. I do have few questions but I will spend some more time trying to figure out answers for myself before posting here.
Thanks for letting me in and regards
Muhammad Khan
|
|
|
|
| pagination |
|
Posted by: tmith - 04-05-2019, 05:19 PM - Forum: UserSpice 4.4
- Replies (1)
|
|
Hi.
One more question (for now)!
I'm looking to integrate some/all of the UserSpice logic to handle user processes within a 3rd party app.
Part of the process will be the user viewing the results of the userspice queries. Does userspice have the ability to display "test" data for queries in a pagination format?? Or will I have to roll my own?
I'm thinking of something like the following...
page first 2,3,4...last
+------------------------------------------------------------------------------+
+ field1 + field2 + field3 + field4 + field5 + field6 +
+ + + + + + +
+ + + + + + +
+ + + + + + +
+ + + + + + +
+------------------------------------------------------------------------------+
thoughts/comments???
thanks
|
|
|
|
| User Access Control Loevel/Logic -- page access |
|
Posted by: tmith - 04-05-2019, 02:21 PM - Forum: UserSpice 4.4
- Replies (1)
|
|
Hi.
Another post!
I've only skimmed google/docs -- didn't yet see what I'm looking for.
Does UserSpice have any sort of built in user access control level/logic process built into it. I'm thinking of a parocess where users can be assigned a given access/permissions role, which then grants the user certain function/access.
If this isn't available, is it on the roadmap? Is there anything which could serve this function/purpose?
thanks!!
|
|
|
|
| user profile fields |
|
Posted by: tmith - 04-05-2019, 01:42 PM - Forum: UserSpice 4.4
- Replies (1)
|
|
Hi
I'm considering using UserSpice as the user logic in a project. My UseCase is targeted towards college students.
The project is to be a directory/profile kind of app where users signup/join, and modify the profile data. The user profile will have multiple fields. Since the target users are college students, the fields will look like the following:
-fname
-lname
-email
-zipcode
-State
-College
-Major/Dept
-Year (1st/2nd/3rd)
-ReferrerID
-JoinStatus
-dateJoin
-userID
-Etc...
Setting up the tables/schema would be trivial.
My issues/question, is how I might set up the logic to allow a user to be able to query the underlying db/tbls to then generate/display a list of users based on the different fields.
Should the app/logic have hardcoded query/sql where the input columns are defined?
The app would/might have a select page where each of the above fields maps to a select/input field in a "form". The user would be prompted to select any/all of the fields. A "default" value would be assigned to any field not selected by the user.
The app would then use ajax/async calls to then process the backend logic..
This approach would/should work with a single well defined/well checked/qualified query statement.
The resulting rows would then drive a paged set of rows for the user to view in the clientside app.
Does this make sense? Have I missed anything?
If anyone has any thoughts on this, feel free to post.
Thanks
|
|
|
|
Validation malfunction with update 4.4.07 |
|
Posted by: MatthiasM - 04-05-2019, 11:51 AM - Forum: UserSpice 4.4
- Replies (4)
|
|
Fellow Userspicers,
the Validation.php class is missing some curly brackets at some if/else functions, starting at line 172 ( checking for >= ).
without them, the validation process failes on you.
I'm in love with the new language options <3
Keep on rocking,
Matthias
|
|
|
|
|
