Updating user login credentials to sql that requires ssh 
Autor: Matthew K.X5 Pro.
User self registration + authentication.
Shared host provider (namecheap) requires SSH to talk to SQL database. Can't find way to put that information in X5 weibsite upload database information screen. So can't upload website through that route. Export and ftp to host works except X5 access managment screen/tool only downloads current information, cannot upload information to database once I move registrants to permissions buckets.
1. anyone have a workaround to be able to do site update uploads with SSH? I see some discussion about using Putty to create tunnel, but no details on what I put in the X5 upload/ftp fields to go through that tunnel - using the original site login and details does not work for me.
2. are the login credentials exported to a spefic file that is outside the SQL database and therefore something I can upload with ftp? If so, what is the filename?
3. why does the online /admin console not include the ability to move registered users (drag the names) to the appropriate authorization buckets like one can do in the software access management screen?
Hello Matthew
I doubt that for what the website is supposed to do SSH is necessary.
It's likely your hosting provider is not correctly aware of how the software operates, but I'm positive this won't be necessary for you.
Data to the database is never uploaded directly from the software. The software uploads codes inside a file online and then the online file applies the changes. SSH is never required.
If your website isn't storing information correctly in the Database, the reason must be a different one.
What exactly doesn't work? what did you attempt so far? can you give me an example?
Do you plan on allowing users to register online and it isn't working? Perhaps you can provide an URL for me here to test this?
I remain available here
Stefano
Autor
Stefano,
Namecheap host says that for accounts with shared hosting, you have to use SSH for any connections to the SQL database (since apparently the SQL server is shared too). I do NOT need to so SSH for the general website files, it is only to initially establish the table necessary for website X5 user password and ID. In order to do that, I had to export the website to the free website x5 host, export the database .sql file, login to namecheap host, import the .sql file. after that, the user registration/authentication started to work partially. It took me 2 days to intuit that workaround.
1. is it true that in order for the correct files to be created by X5 software for user autoregistration and page permissions, one must fill in the section under "data management" tab? if not (since the SQL table has been already created), then maybe my issues will be resolved.
2. when I do not fill that information in - for another website at the same host that does not require and user login authentication - the uploads work. So I know that authentication for the general files is working (website files go to the same parent directory, different subfolders, for all my websites).
3. when I add the autoregister function to my members site, and add the data management information, it always aborts with a "unable to connect to server" error.
4. I have to then export the website files locally and upload them separately with filezilla.
My main issue is that I have members registering and authenticating all the time. I need to then "move/copy" their names into the appropriate permissions buckets/categories for them to be get access to the pages. The only way I can find to do that is to use the X5 access managment panel in the software. But then what? how do I upload the updates to the website? the "refresh" button appears only to download from the website current authenticated users and users that had previously been moved into their appropriate buckets when I did a full ftp site upload. I just want the user permissions to update. How do I do that?
It would be so much easier if I could do the user managment within the on-line /admin console. The only thing I see in that console is a list of new registrants but no way to move them into their permission buckets. Shouldn't that capability be there? the HELP files talk about the admin console being the place to do that, but it seems this only applies to the software console, not the on-line one.
1. how do I update user permission permissions without having to upload the whole site again?
2. is the on-line admin console supposed to have a feature to manage users or not?
Right now it regenerate all files with "export" and then ftp upload the access.inc.php file in res directory, but it seems like there should be an easier way. and I am not sure that is the only file I should be uploading, since it seems like it is not working all the time.
Thanks,
Matthew
Hello Matthew,
1) Yes, automatic user registration does require a database to be linked to the project, so you will need to add the relevant parameters for the Data Management tab.
2) If a website has no functions that require a databse to function (automatic registration, contact forms that send the data to a database, e-commerce orders sent to the database, etc.), then those parameters are not mandatory.
3) Does this error occur only when the database parameters are added? You mentioned, for point 2, another website. What happens to the current website if you disable automatic registration and try to export it without the Data Management parameters? Does the export work in that case, or does the error still appear?
Regarding the management of automatic registration users, I can confirm that it is not possible to set the users in specific groups from the Admin panel.
Those who register with the automatic registration will be placed in this group, but you will then have to place them in the desired groups in Step 1 in order to provide the correct access permissions depending on the type of user.
Eric